Working on two threads now instantenously on this issue (other one is http://expressionengine.com/forums/viewthread/76223/). I now try to detail my approach:
1) import CSV with standard fields using the standard import member utility
2) export created memberId’s
3) update full CSV file with created member_id’s
4) convert my field ‘join_date’ into a Unix time stamp correlated to GMT time
5) start the EE SQL manager
6) use SQL LOAD DATA statement to create a temporary table with custom fields import the CSV
7) run several update queries on exp_member_data: UPDATE SET m.field_id_24 = temp.field_id_24 where m.member_id = temp.member_id
join_date - Unix time stamp correlated to GMT time
8) run update query on exp_member changing the join date
9) run insert sql statement for each new member on exp_member_homepage
The latter database table is totally new for me. Should I run a SQL statement like:
INSERT INTO exp_member_homepage (member_id, field_2, field_3 )
SELECT member_id
FROM temp_table
What do you think of this approach? Will it work? As I’m quite new in this constructions which might have a desastrous results, it’s my preference first to make a little plan.
Just a SQL question: should I specify all columns or will they be created as a default when I insert a row into exp_member_homepage?
