Leads Import

[nsilva]

I just started using Sugar CRM. Im having problems importing my leads from a tab delimited file.
When go into the import tool, it reads the file and lets me pick what information I want to map in which
column of the table, then when I click Import.

I get a screen saying

Import Step 3: Confirm Fields and Import
Print Print Help Help
Import Started:
Sun Mar 25 2007 21:12:01 GMT-0500 (Eastern Standard Time)..................

At the beguinning the dots move, showing some kind of activity, then after a while they stop moving and nothing
else happens. I have try doing it multiple times with no luck.

Im importing around 30,000 records; I thought that maybe the amount of records was causing the problem, and tried only with a few, no luck! In addition, I tried a comma delimeted file, nothing either..
This is a sample of how the contacts look like:
Contacts


Operating system type and version: Ubuntu Server 6.06
Sugar Suite version 4.5.1b
Webserver Apache 2.0.55
» PHP version 5.1.2
» MySQL server version 5.0.22

[ruchida]

Hi,
There will be lots of causes to make the import process stop.

1. Increare the max. memory in php.ini. The Import function consumes lots of memory.
2. Increate the max. execution time in php.ini. It might have timed out.
3. Change the database type from InnoDB to MyISAM if you don't mind. InnoDB runs 10 times slower than MyISAM in Import.
4. Split the csv file into smaller chunks and run Import several times.

[nsilva]

Do you see a problem if I just do it directly in SQL. I know some of the fields will not get populated such as owner of the record, date....

But is there a potential problem with this approach?

[ruchida]

Do you see a problem if I just do it directly in SQL. I know some of the fields will not get populated such as owner of the record, date....

But is there a potential problem with this approach?

The only concern I have is that the "id" field is not populated if you use SQL directly. The "id" is used to identify each record, and should be unique throughout a SugarCRM instance. If you are able to populate the id field in advance, the SQL approach would not be a problem.

[efgroup]

I just got through setting up an import module in Visual FoxPro that hits the leads table plus an additional leads add on table that we added in to Sugar.

When we import leads, we wanted them auto assigned to our telemarketers and a particular campaign.

We use VFP tables and databases as the master repository of leads, then load leads per 'production job' into Sugar CRM.

I did this with odbc from VFP over the internet into a mySql instance in a shared services server.

some things you have to prep for:

1. leads id value - thats no problem on our side, as we can generate the id's before the sql insert
2. campaigns id - if for a new campaign, create it first in Sugar, grab the ID, use it on the leads import
3. assigned_to_id - this is the id in the users table - so if you are adding in new users for a particular campaign, do that FIRST before you import leads - then grab that ID value, put into the vfp table.

In speedtests today, was able to import about 40K records in about 55 minutes.

I hate tab delimited with a passion.

Wintel Box running VFP import -> odbc ->internet ->odbc->mysql db

Warmest Regards [Bill]