Can't import .csv contacts, please help

[Extomas]

Hello everybody,

I'm quite new in SugarCRM and I have one problem.

I ca'n import contact to sugar, no matter what data source i select.
My steps are these:

Data source - microsoft Outlook
Import Action - Create Records

normaly exports contacts from outlook to .csv, everything goes fine till I trying to import, when systems come with window where choose which fields import, i nothing change, pressing "Import", and get error that field "Title" already exits, look through there and i saw that field "Job Title" is mixing everything. Then i select "do not map this field"
Pressing "Import" one more time and saw how sytems trying to import (showing 1 of 161), but fast goes to another page, and result are 3 imported contacts, 158 not imported.

I download error codes and saw similar page:

"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,1
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,2
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,3
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,4
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,5
"Required value missing","LBL_LAST_NAME (last_name)",NULL,6
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,6
"Required value missing","LBL_LAST_NAME (last_name)",NULL,7
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,7
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,8
"Required value missing","LBL_LAST_NAME (last_name)",NULL,9
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,9
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,10
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,11
"Required value missing","LBL_LAST_NAME (last_name)",NULL,12
"Required value missing","LBL_LAST_NAME (last_name)",NULL,13
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,13
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,14
"Required value missing","LBL_LAST_NAME (last_name)",NULL,15
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,15
"Required value missing","LBL_LAST_NAME (last_name)",NULL,16
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,16
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,17
"Required value missing","LBL_LAST_NAME (last_name)",NULL,18
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,18
"Required value missing","LBL_LAST_NAME (last_name)",NULL,19
"Invalid date dtring","LBL_BIRTHDATE (birthdate)",00.0.0,19

And much more similar lines.....

What I'm doing wrong ? Please help me

[malcolmh]

Hi,

From the error messages the format of the birthdate is incoorect.

You also have several records where you don't have a last name which is mandatory