Cannot import CSV file

[oblue]

I am trying to import the CSV file with employee data (2 records: empId, first name, last name, gender, birthday) into the HRM but it always failed. From Firefox 3.6, it show Upload Successful. Continuing with Data Import but under the final result, it said "Some rows failed to import" and only the empId, firstname, lastname is imported (note: 2 records shown in orangeHRM with id, firstname, lastname only).

From IE8, orangeHRM just hangs there with and "error on page". This time, it only import 1 records with empId, firstname, last name imported.

I have defined the custom import as : empId, firstName, lastName, gender, birthday
I have defined the sample csv as
1,"test","test","M", 1970-01-01
2,"test1","test1","F", 1970-01-02

Any help is greatly apprecipate!!

Many Thanks

[oblue]

anyone can help??? plz

[khaye]

orange_hrm csv import error.jpg (24.36 KiB) Viewed 1466 times

I'm having the same issue.
I try to import and i get the following error:

So i have exported CSV. use the format import CSV.
At first I use to be able to only import 4 records now i get this error constantly.

Assistance will be greatly appreciated.

[zawmn]

Any solution for this? I got Same isse. I use
OS Windows 2003 and Windows XP with IIS 5 and IIS6
Mysql 5.0.22
PHP Version 5.2.10
OrangeHRM orangehrm-2.6.0.2
I create only required fields (empId,lastName,firstName,middleName) in Custom import type
When I try import, the screen "Upload Successful, Continuing with Data Import and Final Result Some Rows Failed to Import" like above post appear

My CSV file include
empId,lastName,firstName,middleName
TWM1,U TIN,U TIN WIN MAUNG,U TIN WIN MAUNG
T W1,U WIN,U TIN WIN,U TIN WIN,HHL

I found the error message in \lib\logs\logDB.txt
Fri, 14 Jan 2011 04:03:42 +0000 : Error :\nMySQL Query Error : UPDATE hs_hr_employee SET EMP_SMOKER=\'0\', ETHNIC_RACE_CODE=null, NATION_CODE=null, EMP_GENDER=null, EMP_MARITAL_STATUS=\'\', EMP_SSN_NUM=\'\', EMP_SIN_NUM=\'\', EMP_OTHER_ID=\'\', EMP_DRI_LICE_NUM=\'\', EMP_DRI_LICE_EXP_DATE=\'\', EMP_MILITARY_SERVICE= \'\' WHERE EMP_NUMBER=\'37\'\nTech Info\n------------\nIncorrect date value: \'\' for column \'emp_dri_lice_exp_date\' at row 1

[sujee]

26) What is the mapping of data when importing data to OrangeHRM?
From OrangeHRM
Jump to: navigation, search

1. Gender - M for Male, F For female

2. DD1Amount and DD2Amount - (Can't be zero)

2. DD1Checking and DD2Checking ( Y for Cheque or Keep the field empty for Saving)

3. DD1AmountCode and DD2AmountCode (Blank, %, Flat, Flat- are the allowed values for this field. Please note that fields are case sensitive)

See following Sample data with headers,

"lastName","firstName","street1","city","state","zip","gender","birthDate","joinedDate", "OtherEmail","DriveLic"

"Blumkin","Teresa","1585 Broadway","New York","NY",10019,"F",02/4/1978, 02/11/2000,"Smith@Orange1.com","7134998608MANUEL"

[zawmn]

Hi

Thanks for your reply
I just try to import four fields that are
empId,lastName,firstName,middleName

You can see my sample csv file content in my previous post.
Do you think the mapping is wrong?

And do you note that error message from log file ?
"Incorrect date value: for column 'emp_dri_lice_exp_date'"
Why these fields (I didn't selected in import type) are trying to update?

[zawmn]

I also tested with Apache 2.2.8 instead of IIS, the same problem occur when import.

But When I try to install the same version of orange hrm in my linux server
OS : CentOS 5
MySQL server: 5.0.58

The same Import is working well without error.

I note that mysql handle the blank date value differently in linux and windows

In Linux: just warning occur and data is inserted
Warning: #1265 Data truncated for column


In Windows: Error occur and data not allow to inserted
Error: #1292 - Incorrect date value: '' for column

Any suggestion ?

[zawmn]

I found the source of issue at
http://orangehrm.com/forum/viewtopic.ph ... ional+mode

OrangeHRM is not supports for the traditional mode of MySQL.

This should mention in installation guide of orangehrm.