Hi,
While importing a csv file into timetrex, I am getting below errors:-
Please go through it & help me to resolve it.
php import_users.php -n -u user_name user_column_map.txt data.csv
Column Mappings...
TimeTrex Column: company_id => company_id Default:
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 => user_name Default:
TimeTrex Column: password => password 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 => employee_number 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 => first_name Default:
TimeTrex Column: middle_name => middle_name Default:
TimeTrex Column: last_name => last_name Default:
TimeTrex Column: sex => sex Default:
TimeTrex Column: address1 => address1 Default:
TimeTrex Column: address2 => address2 Default:
TimeTrex Column: city => city Default:
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:
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: 10
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:
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_deduction_id Default: Federal Income Tax
TimeTrex Column: federal_income_tax_user_value1 => federal_income_tax_user_value1 Default:
TimeTrex Column: federal_income_tax_user_value2 => federal_income_tax_user_value2 Default:
TimeTrex Column: federal_income_tax_user_value3 => federal_income_tax_user_value3 Default:
TimeTrex Column: federal_income_tax_user_value4 => federal_income_tax_user_value4 Default:
TimeTrex Column: federal_income_tax_user_value5 => federal_income_tax_user_value5 Default:
TimeTrex Column: province_income_tax_deduction_id => province_income_tax_deduction_id Default: State Income Tax
TimeTrex Column: province_income_tax_user_value1 => province_income_tax_user_value1 Default:
TimeTrex Column: province_income_tax_user_value2 => province_income_tax_user_value2 Default:
TimeTrex Column: province_income_tax_user_value3 => province_income_tax_user_value3 Default:
TimeTrex Column: province_income_tax_user_value4 => province_income_tax_user_value4 Default:
TimeTrex Column: province_income_tax_user_value5 => province_income_tax_user_value5 Default:
Sample Users...
Sample User: 1
wage_type_id: 10
wage_weekly_time: 40:00
federal_income_tax_deduction_id: Federal Income Tax
province_income_tax_deduction_id: State Income Tax
Importing Users...
Update Column Not Found In CSV File!
Importing User: 1. ................................ Failed!
ERROR: Company is invalid
Total Errors: 1
Rolling back transaction!
WARNING: Clear TimeTrex cache after running this.