Results 1 to 2 of 2

Thread: Lead Import CSV

  1. #1
    sacramentojoe is offline Sugar Community Member
    Join Date
    Nov 2005
    Posts
    447

    Default Lead Import CSV

    I'm trying to import a CSV file that is 30 megs in size which I'll map to a lead record(s).
    I've changed my php.ini file to allow uploads of this size and I realize that it'll take longer to execute so I've upped the amount of time a script may execute to 5 minutes and I've upped the ram to 1 gig.
    Even after 5 minutes, I get index.php, which means that it fails.

    Has anybody figured out how to handle these large imports?
    Breaking the file into multiple imports is not an option unfortunately.

  2. #2
    Angel's Avatar
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: Lead Import CSV

    One thing I've done in the past is to import the CSV into MSSQL and use a custom .NET utiltiy to move the data into MySQL. An additional benefit of putting it into MSSQL is that the data to be imported can more easily be manipulated for things such as assigning users, etc. prior to inserting it into Sugar.

    Not sure if this helps, but it might give you some ideas...
    Regards,

    Angel Magaņa
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. CSV File Import of Leads
    By blkr00t in forum Installation and Upgrade Help
    Replies: 2
    Last Post: 2007-09-14, 12:56 PM
  2. Replies: 0
    Last Post: 2007-06-21, 10:45 AM
  3. From lead to order
    By george_bbch in forum Feature Requests
    Replies: 0
    Last Post: 2006-09-26, 02:02 PM
  4. Import CSV Lead Fatal Error
    By ziplizard in forum Developer Help
    Replies: 0
    Last Post: 2006-03-22, 05:24 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
  •