Results 1 to 4 of 4

Thread: Issue with Importing

  1. #1
    KenBeanNet is offline Junior Member
    Join Date
    Mar 2011
    Posts
    4

    Default Issue with Importing

    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

  2. #2
    KenBeanNet is offline Junior Member
    Join Date
    Mar 2011
    Posts
    4

    Default Re: Issue with Importing

    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?

  3. #3
    KenBeanNet is offline Junior Member
    Join Date
    Mar 2011
    Posts
    4

    Default Re: Issue with Importing

    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

  4. #4
    KenBeanNet is offline Junior Member
    Join Date
    Mar 2011
    Posts
    4

    Default Re: Issue with Importing

    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?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Importing data issue
    By adamguerin in forum Installation and Upgrade Help
    Replies: 5
    Last Post: 2010-06-10, 01:17 AM
  2. Issue in importing to SugarCRM 5.10b
    By odirneto in forum Help
    Replies: 5
    Last Post: 2008-12-30, 05:55 PM
  3. Importing issue
    By jmcalderond in forum General Discussion
    Replies: 3
    Last Post: 2008-09-02, 05:59 PM
  4. Issue importing to custom fields
    By jsaraco in forum Help
    Replies: 3
    Last Post: 2007-12-11, 07:17 PM
  5. Importing Contacts Issue
    By rtroth in forum Installation and Upgrade Help
    Replies: 3
    Last Post: 2007-09-13, 02:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •