Greetings...
I am having difficulty importing employee information using the import_users.php program. The error is:
ERROR: Invalid Province/State
ERROR: Postal/ZIP Code contains invalid characters, invalid format, or does not match Province/State
The context for the error is:
-----------------------------------------------------------------------------------------
(mysqlt):
select *
from system_setting
where name = 'license'
-----<hr>
Failed!
ERROR: Invalid Province/State
ERROR: Postal/ZIP Code contains invalid characters, invalid format, or does not match Province/State
-----------------------------------------------------------------------------------
The system is Slackware Linux 12.2 (2.6.24-5), TimeTrex 2.2.19, Apache 2.2.8, MySQL 5.0.51b, and PHP 5.2.5.
-----------------------------------------------------------------------------------
Here is the user_column_map.txt file;
timetrex_column, csv_column, default_value, parse_hint
"company_id","","1",""
"status_id","","active",""
"currency_id","","",""
"pay_period_schedule_id","","",""
"policy_group_id","","",""
"user_name","user_name","",""
"password","","drowssap",""
"phone_id","","",""
"phone_password","","",""
"ibutton_id","","",""
"employee_number","VolunteerID","",""
"title_id","","",""
"default_branch_id","","1",""
"default_department_id","","10",""
"group_id","","",""
"first_name","FirstName","",""
"middle_name","","",""
"last_name","LastName","",""
"sex","","",""
"address1","Address","",""
"address2","","",""
"city","City","",""
"country","","",""
"province","province","",""
"postal_code","postal_code","",""
"work_phone","","",""
"work_phone_ext","","",""
"home_phone","HomePhone","",""
"mobile_phone","OtherPhone","",""
"fax_phone","","",""
"home_email","EMail","",""
"work_email","","",""
"birth_date","Birthday","","m/d/y"
"hire_date","BeginningServiceDate","","m/d/y"
"termination_date","","",""
"sin","","",""
"other_id1","NextTBDue","",""
"other_id2","PetVetRecordsDue","",""
"other_id3","DateDrivingInfoExpires","",""
"other_id4","","",""
"other_id5","","",""
"note","comments","",""
"wage_type_id","","10",""
"wage","","",""
"wage_weekly_time","","40:00","10"
"wage_effective_date","","","m/d/y"
"bank_institution","","",""
"bank_transit","","",""
"bank_account","","",""
"labor_burden_percent","","",""
"federal_income_tax_deduction_id","","Federal Income Tax",""
"federal_income_tax_user_value1","","",""
"federal_income_tax_user_value2","","",""
"federal_income_tax_user_value3","","",""
"federal_income_tax_user_value4","","",""
"federal_income_tax_user_value5","","",""
"province_income_tax_deduction_id","","State Income Tax",""
"province_income_tax_user_value1","","",""
"province_income_tax_user_value2","","",""
"province_income_tax_user_value3","","",""
"province_income_tax_user_value4","","",""
"province_income_tax_user_value5","","",""
------------------------------------------------------------------------------------------------
The first couple of lines of the user CSV file:
VolunteerID,FirstName,LastName,Address,City,province,postal_code,HomePhone,OtherPhone,Birthday,BeginningServiceDate,DateDrivingInfoExpires,St
atus,Comments,EMail,NextTBDue,PetVetRecordsDue,user_name
11,Arlene,Schneider,1476 S. Brentwood,Lakewood,Colorado,80232,3099866427,,0000-00-00,0000-00-00,0000-00-00,active,,,0000-00-00,0000-00-00,ASc
hneider
14,Barbara,Steeves,14022 W. Alaska Dr.,Lakewood,Colorado,80228,303-986-1944,,0000-00-00,0000-00-00,0000-00-00,active,active 4/7/2003,,0000-00
-00,0000-00-00,BSteeves
------------------------------------------------------------------------------------------------
And finally, the command line:
php import_users.php -n -u user_name user_column_map.txt vol_out_mod.csv
------------------------------------------------------------------------------------------------
I saw no entries in the various log files that seemed relevant, meaning the time stamps were not within the range of times during which I ran the program.
------------------------------------------------------------------------------------------------
I'm dealing with volunteers, so I have entered no salary or tax data on the web site. We are looking to use this package for scheduling and time tracking only.
I'm not sure what else you will need for this.
Many thanks.
Jeff Williams - jwilliams@hospiceofsaintjohn.org