Hello,
I'm trying to import 400 users into the system but somehow i must be doing something wrong.
This is the ouput:
C:\Documents and Settings\managerl03>php C:\WWW\TimeTrex\tools\import\import_use
rs.php -n C:\WWW\TimeTrex\tools\import\user_column_map.txt C:\WWW\TimeTrex\tools
\import\import_users.csv
PHP Notice: Undefined index: first_name in C:\WWW\TimeTrex\tools\import\import
_users.php on line 519
PHP Notice: Undefined index: last_name in C:\WWW\TimeTrex\tools\import\import_
users.php on line 519Column Mappings...
TimeTrex Column: company_id => company_id Default: 1
TimeTrex Column: status_id => status_id Default:
TimeTrex Column: currency_id => currency_id Default:
TimeTrex Column: pay_period_schedule_id => pay_period_schedule_id Default:
TimeTrex Column: policy_group_id => policy_group_id Default:
TimeTrex Column: user_name => 1 Default:
TimeTrex Column: password => 2 Default:
TimeTrex Column: phone_id => phone_id Default:
TimeTrex Column: phone_password => phone_password Default:
TimeTrex Column: ibutton_id => ibutton_id Default:
TimeTrex Column: employee_number => 3 Default:
TimeTrex Column: title_id => title_id Default:
TimeTrex Column: default_branch_id => default_branch_id Default:
TimeTrex Column: default_department_id => default_department_id Default:
TimeTrex Column: group_id => group_id Default:
TimeTrex Column: first_name => 4 Default:
TimeTrex Column: middle_name => 5 Default:
TimeTrex Column: last_name => 6 Default:
TimeTrex Column: sex => 7 Default:
TimeTrex Column: address1 => address1 Default:
TimeTrex Column: address2 => address2 Default:
TimeTrex Column: city => city Default: Shenzhen
TimeTrex Column: country => country Default:
TimeTrex Column: province => province Default:
TimeTrex Column: postal_code => postal_code Default:
TimeTrex Column: work_phone => work_phone Default:
TimeTrex Column: work_phone_ext => work_phone_ext Default:
TimeTrex Column: home_phone => home_phone Default:
TimeTrex Column: mobile_phone => mobile_phone Default:
TimeTrex Column: fax_phone => fax_phone Default:
TimeTrex Column: home_email => home_email Default:
TimeTrex Column: work_email => work_email Default:
TimeTrex Column: birth_date => birth_date Default:
TimeTrex Column: hire_date => hire_date Default: 1/1/2007
TimeTrex Column: termination_date => termination_date Default:
TimeTrex Column: sin => sin Default:
TimeTrex Column: other_id1 => other_id1 Default:
TimeTrex Column: other_id2 => other_id2 Default:
TimeTrex Column: other_id3 => other_id3 Default:
TimeTrex Column: other_id4 => other_id4 Default:
TimeTrex Column: other_id5 => other_id5 Default:
TimeTrex Column: note => note Default:
TimeTrex Column: wage_type_id => wage_type_id Default: monthly
TimeTrex Column: wage => wage Default:
TimeTrex Column: wage_weekly_time => wage_weekly_time Default: 40:00
TimeTrex Column: wage_effective_date => wage_effective_date Default: 1/1/2007
TimeTrex Column: bank_institution => bank_institution Default:
TimeTrex Column: bank_transit => bank_transit Default:
TimeTrex Column: bank_account => bank_account Default:
TimeTrex Column: labor_burden_percent => labor_burden_percent Default:
TimeTrex Column: federal_income_tax_deduction_id => federal_income_tax_deducti
on_id Default:
TimeTrex Column: federal_income_tax_user_value1 => federal_income_tax_user_val
ue1 Default:
TimeTrex Column: federal_income_tax_user_value2 => federal_income_tax_user_val
ue2 Default:
TimeTrex Column: federal_income_tax_user_value3 => federal_income_tax_user_val
ue3 Default:
TimeTrex Column: federal_income_tax_user_value4 => federal_income_tax_user_val
ue4 Default:
TimeTrex Column: federal_income_tax_user_value5 => federal_income_tax_user_val
ue5 Default:
TimeTrex Column: province_income_tax_deduction_id => province_income_tax_deduc
tion_id Default:
TimeTrex Column: province_income_tax_user_value1 => province_income_tax_user_v
alue1 Default:
TimeTrex Column: province_income_tax_user_value2 => province_income_tax_user_v
alue2 Default:
TimeTrex Column: province_income_tax_user_value3 => province_income_tax_user_v
alue3 Default:
TimeTrex Column: province_income_tax_user_value4 => province_income_tax_user_v
alue4 Default:
TimeTrex Column: province_income_tax_user_value5 => province_income_tax_user_v
alue5 Default:
Sample Users...
Sample User: 1
company_id: 1
city: Shenzhen
hire_date: 1/1/2007
wage_type_id: monthly
wage_weekly_time: 40:00
wage_effective_date: 1/1/2007
Sample User: 2
company_id: 1
city: Shenzhen
hire_date: 1/1/2007
wage_type_id: monthly
wage_weekly_time: 40:00
wage_effective_date: 1/1/2007
Importing Users...
Importing User: 1. ................................
Success!
PHP Notice: Undefined index: first_name in C:\WWW\TimeTrex\tools\import\import
_users.php on line 519
PHP Notice: Undefined index: last_name in C:\WWW\TimeTrex\tools\import\import_
users.php on line 519
Importing User: 2. ................................
Success!
Rolling back transaction!
WARNING: Clear TimeTrex cache after running this.
This is my CSV file:
user_name,password,employee_number,first_name,middle_name,last_name,sex
40,2009040,40,ALICE-ling,,zhang,Female
41,2009041,41,LILYX-lihua,,xu,Female
Any idea where the Undefined index comes from?
Thanks.