New Import Module

[kbrill]

I am releasing the beta version of my new import module. Right now it is for 4.5.1 only. I am working on the 5.0 release for mid December.

The version available on SugarForge is only for the Open Source version of SugarCRM.

It is available here.

What does it do?

1. I Fixed about 16 bugs and errors, big and small
2. It adds an "Update Import" that will allow you to update records instead of creating new ones
3. It allows you to set default and override values for all columns. For example if in your CSV file all the teams are wrong, you can tell the import module to just import them all to the global team, that would be an override, a default value would replace all blank cells with the global team.
4. I added an update screen so you can tell how many records have been processed and how many were rejected. in real time.
5. It tells you exactly what each field is looking for in it's data. What the correct date format is, if it accepts decimal places ect..
6. It fixes most bad dates, if it's close it will get it right, for example 7/2/07 works now where it used to have to be 07/02/2007.
7. If fixes numbers. $4,000.45 works now, as does €4.342,04 or whatever format your country uses.
8. At the end you get an actual error report showing each error and what line of the CSV it was on. it also seperates out the lines that errored out so you can just fix those and reimport again saving alot of time.

there is alot more in there and a lot more to come. Give it a look see and let me know how it goes. Again this is a BETA release, it doesn't mess with your database and is uninstallable however.

If you send in an error report, PLEASE give me an example of the import file if it is applicable. thanks

[kbrill]

I just updated this to verion 2.0c fixing a problem with some .htaccess installs.

[sacramentojoe]

Hi Ken, thanks for sending me the "pro" version, this is EXACTLY what Sugar CRM was missing.
You did a great job.

[kbrill]

Just remember that it is beta, please send me any and all bug reports

[kbrill]

I just uploaded Version 2e to the SugarForge site shown in the first message. This version fixes bugs in the Targets importer.

The next version will use ALOT less memory and can import 20,000 (or more depending on your server, it starts really eating resources after 20K tho) records at a time.

That version should be out Thursday.

[aram]

Ken..
Loaded the 2e version this morning...
In the import wizard I get
"Import Step 1: Select the Source" but the rest of the wizrd form is blank.
But I got this on 2c as well.
Any idea what I need to tweak?
IIS5, php 4.5.4

[kbrill]

Not sure, probably a PHP error, there is no PHP v4.5.4, the last version was v4.4.7, but if you go into your php.ini file and turn on display_errors, then restart your webserver you should see the error that is holding you up.

[aram]

Ok Ken
Did that..
Here's the error returned:
----------------
Parse error: parse error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in C:\Inetpub\wwwroot\SQmailNuts\src\sugar\modules\Im port\ImportAccount.php on line 50

Fatal error: Cannot instantiate non-existent class: importaccount in C:\Inetpub\wwwroot\SQmailNuts\src\sugar\modules\Im port\ImportStep1.php on line 116

Ideas on the handling?

[kbrill]

Just released a new version that should fix that bug, some bugs in the Import Map function and the Date function

It is available here.

[sacramentojoe]

Just released a new version that should fix that bug, some bugs in the Import Map function and the Date function

It is available here.

I got the same error on a different server, can you send me the latest pro version?

Thanks