Trouble importing new targets with custom fields

[tawaki]

I have created custom fields and added them to the 'detail' and 'edit' views of Targets. I have mapped the cvs file fields to the Sugar fields -- some standard and some custom -- following the import process. The problem is that the standard fields import as expected, but the custom fields do not import at all. Looking at the 'prospects' and 'prospects_cstm' tables in MySQL I can see that the 'prospects_cstm' is empty.

What am I missing in Sugar's import process??

[andydreisch]

Hi tawaki, I've forwarded this on to QA for a quick test on our systems.

What Sugar version are you using?

Andy

[tawaki]

Hello Andy,

I am using the latest open source version "d" on a Mandriva box with Apache 2.2.4, PHP 5.2.1, and MySQL 5.0.37.

I created 8 additional custom fields. I kept the csv file small, under 1 MB with 500 records. The import finished okay with all 500 records importing to the 'prospects' table -- it did not hang -- so I doubt that I am having a file size issue.

Thanks for the help.

[franklin_sugar]

Hi Tawaki,

This is Franklin from Sugar QA team. When you importing, did you map your custom fields to the database fields at step3? What are the data types of your custom fields?

FYI: I repeated what you did, but with fewer custom fields and records. It imports correctly into the "prospects_cstm" table.

Thanks,
Franklin

[tawaki]

Hello Franklin,

Yes I did map them. Data types are 3 dates, 3 texts and 2 integers. I just tried importing 10 records with only one text type custom field and it worked. I am going to experiment with the date and integer types.

Do I need to format the date or maybe the number fields in some particular way in the csv file? Any hints to save me time would be appreciated greatly.

[mkenigson]

I'm having a similar problem. I can't seem to use the Accounts importer to import custom date fields. What format do the dates need to be in? I've tried standard datetime formats, yyyy-mm-dd, and mm/dd/yyyy. No dice so far. Everything that has a value gets imported as 2000-01-01.

Incidentally, I also discovered that if you use the "Undo Last Import" button, it won't get rid of anything it's put into accounts_cstm. Don't know if it's got that issue with opportunities or any other imports.

[tawaki]

Hello Franklin,

Yes I did map them. Data types are 3 dates, 3 texts and 2 integers. I just tried importing 10 records with only one text type custom field and it worked. I am going to experiment with the date and integer types.

Do I need to format the date or maybe the number fields in some particular way in the csv file? Any hints to save me time would be appreciated greatly.

Okay, I am now getting all custom fields to import, but like mkenigson noted, the date field is messed up. What is the necessary date format?

[franklin_sugar]

Hi,

The date format is specified in "My Account". The default is yyyy-mm-dd hh:mm. The date in the csv file has to match the format in "My Account".

Thanks,
Franklin

[tawaki]

Okay, yyyy-mm-dd works, but it brings up another question. During the installation process, one of the pages asked for preferred formating. For example, I chose a date format of mm-dd-yyyy. I just checked the config.php file and it is that. However, the format displayed in all date fields in my Sugar app is yyyy-mm-dd. Do I have a problem with my config.php file?

The associated question is should the date format used in the imported date fields match the configured date format or should it always be yyyy-mm-dd...or can it be any of the date formats listed in the array in config.php?

[tawaki]

Hi,

The date format is specified in "My Account". The default is yyyy-mm-dd hh:mm. The date in the csv file has to match the format in "My Account".

Thanks,
Franklin

Got it! It all makes sense now.

Thanks for the help.