CMS Made Simple Forums

Posted: **Thu Feb 06, 2014 2:06 pm**

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

Posted: **Thu Feb 06, 2014 6:47 pm**

you have to follow its CSV format which is

Code: Select all

name@email.com,First Last

Posted: **Wed Feb 12, 2014 12:00 am**

CapereSpiritum wrote: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.

CMS Made Simple Forums

Issue with importing CSV file into NMS

Issue with importing CSV file into NMS

Re: Issue with importing CSV file into NMS

Re: Issue with importing CSV file into NMS