Issue with Importing

[KenBeanNet]

Hey all,

First of all great app. I am having issue importing dates as such : "03-Sep-1998 12:00:00 AM"

I went into the config file and added into the Array :

'h:i:s A' => '11:00:00 PM',

and

'd-M-Y' => '23-Dec-2010',


Yet, I still am getting a parse error. Is there something wrong maybe with there being a space between 00 and AM?

Thanks,

Ken

[KenBeanNet]

Still having this issue. I am using the latest version of SugarCRM. I cannot seem to import anything with a date from my old format. Any suggestions?

[KenBeanNet]

Now I am having another issue with importing. Under "Management" I have the field "Id" as they all Moduels do. But now I created "Management Contacts" and trying to link to "Management" but its not linking.

When I import "Management" I am selecting Id as my Ids, which could be something as simple as "ASJ". Then made a One-To-Many relationship with Management > Management Contacts. When I import Management Contacts, it is creating new Management. The IDs do match in MySQL to the CSV but its not finding the pre-entered "Management". Any suggestions?

Ken

[KenBeanNet]

Solution to first problem :

If you want to read in this format d-M-Y which is 23-Jan-2010 than do the following :

Config.php add into date_format array > 'd-M-Y' => '23-Dec-2010',


then in TimeData.php (In the include folder) add the following to supported_strings array > 'M' => '[a-zA-Z]{3}' and this to the time_token_map > 'M' => 'M', // month : Jan-Dec

Once you do that, you can parse Jan-Dec in Regex. Still having a issue linking Ids though.

Anyone?