Issue with importing CSV file into NMS

[CapereSpiritum]

Hi Folks

We launched a site a while back complete with NMS (Newsletter Made Simple). The client has just got around to using NMS and is trying to import contacts in a CSV file generated by Mail Chimp

It throws up the folloowing for all complete entries

Code: Select all

Number of elements: 3
Array
(
    [0] => aabbott@ddfire.gov.uk
    [1] => Alison
    [2] => Abbott
)

I trimeed the file down to 7 contacts and combined the Forename and Surnames to a single field which works fine.

There are 30,000 + contacts in the file so diing a manaual 'tweak' is no small task.

Does anyone know if there is a 'fix' for this situation?

Details
CMS Version 1.11.5 WILL BE UPDATING SOON

CMSMailer 5.2.1
CMSPrinting 1.0.4
FileManager 1.4.3
MenuManager 1.8.5
MicroTiny 1.2.5
ModuleManager 1.5.5
News 2.12.12
Search 1.7.8
ThemeManager 1.1.8
Showtime 3.3
FormBuilder 0.7.3
Captcha 0.4.6
CGExtensions 1.36
FrontEndUsers 1.21.2
CGSimpleSmarty 1.6.2
CustomContent 1.8.3
JQueryTools 1.2.4
Products 2.18.4
CGEcommerceBase 1.3.11
Cart 1.8.4
CGPaymentGatewayBase 1.1
Orders 1.13.3
PaypalGateway 2.3.9
CGJobMgr 1.2.15
NMS 2.7.3
CGFeedback 1.5.12
SiteMapMadeSimple 1.2.7

[JohnnyB]

you have to follow its CSV format which is

Code: Select all

name@email.com,First Last

[paulbaker]

There are 30,000 + contacts in the file so diing a manaual 'tweak' is no small task.

Whilst I admit data processing is irritating and boring I'll bet this is possible with the use of Excel (using Text to Column feature), Textpad (using replace (F8) and possibly a regular expression, or your favourite text editor) and a couple of cups of coffee.