Import 500 Accounts successfully but no show

[sogua]

Hi there,

I'm running SugarCRM 5.2.0d on my dev machine (Mac) with PHP 5 and MySQL 5.
I've few customize fields in my Account module and i run an import operation from a CSV file and map everything nicely.

After i run the import, the result shows 500 records successfully created, but when i go to Account module i didnt see any record in my 'Account' module.

I do a quick check at my MySQL db, i see there is 500 records in the 'accounts' table but there is no record for 'accounts_cstm'

Anyone can help?

TQ

[SergeiLo]

Hi TQ,

What is the data type of the field 'accounts_cstm'?

I had the same problem with my custom field of dropdown data type. When I added values to it I added them with additional/extra space after the name. My CSV file was without additional/extra space after the name. After the import I could see my imported records in database but could not see them in SugarCRM UI. I deleted these extra spaces via Admin - Studio - Account module - Fields and then all my records appeared in SugarCRM.

Hope it will help.

Regards,
Sergei

[sogua]

Hi,

In my 'account_cstm' table, i only have varchar and tinyint field. and there is NO RECORD in this table even i map those field during my import process.

If i manually add an account then everything will be inserted successfully (custom field will have record now) and show like wat it does.

All my name in my 'accounts_cstm' doesnt end with space. here's my field name:-
- id_c char(36)
- account_status_c varchar(255)
- cis_id_c varchar(25)

just simple custom field but not really sure why it make so much problem...

anyone can help?