3rd generation web-based lead loader added

[mflorell]

We just added third generation web-based lead loader capable of loading more data file types and optionally loading all of them with custom list fields. (This is only in SVN/trunk[soon to be 2.4 branch]).

You must install the following perl modules on your web server for this
new lead loader to work:
- cpan> install Spreadsheet::XLSX
- cpan> install Spreadsheet::Read
To get to the new lead loader, click to:
- Lists -> Load New Leads -> 3rd Gen Lead Loader
Here is a list of the file formats(by file extension) that are now
supported by the third generation web lead loader:
- TXT - tab or pipe delimited
- CSV - comma separated values
- XLS - MS Excel 2000/XP
- XLSX - MS Excel 2007+
- SXC - OpenOffice.org First Generation Spreadsheet
- ODS - OpenOffice.org OpenDocument Spreadsheet

Please test it out if you can and let us know what you think!

[Trying]

I am out of words

[mcargile]

The neat thing is how we added support for these new format. Basically everything that is not a tab delimited or pipe delimited txt file is first passed through a conversion script turning it into a tab delimited file, then it is loaded. In this way we can very easily add additional formats by just writing a conversion script and telling the list loader to use that script when loading the leads.

[Trying]

Well anybody who was still unsure whether you guys rock or not should be convinced now that you do!! The only "big" feature it still needs now is QC.

[ruben23]

@matt

i have followed your steps matt to enable the 3rd generation leads loader, but before i used the 3rd generation loader i used the normal loader and i got this error while loading any idea regarding about this..

i cant use the old loader when i enable the 3rd generation loader..?

[mflorell]

I just tested this with the standard lead loader and do not have this problem.

[gmcust3]

Third generation web-based lead loader ??

Whats the difference in earlier and the third generation web-based lead loader ??

[mflorell]

It is compatible with more input formats and you can load data into custom list fields.

[mcargile]

It also has better error handling for weird characters in your lead file such as single quotes.

[roundqube]

I running:
VERSION: 2.4-277
BUILD: 100827-1535

Standard installation of 2.2 and upgrade to SVN trunk via documented process.

However, when I try the third gen lead load (my csv file only has three columns and no weird characters, simple file)... when I try the new loader, it just shows me " (double quote) for every thing I want to select, whether its firstname, lastname or phone number. I do not have a header in the csv file, its simple 3 column csv so figured I'd select the first, last and phone manually but I only see ".

[mflorell]

How many rows in the file?

Please provide a sample row.

Have you tried converting it to tab delimited?

Did you load the new perl modules during your upgrade process?

[roundqube]

Matt you are right, I forgot to upgrade the modules. After doing this, it worked.
Thanks!