PDA

View Full Version : Importing CSV file


dallen
03-04-2008, 02:32 PM
I am trying to import a csv file with the following format:

email,fname,lname,address,city,state,zip,phone,ip, date time

The subsciber import option is only grabbing the email address and name. I there particular order for the format?

As well, if using a csv to XML converter is there particular feild names required?

dallen
03-04-2008, 04:49 PM
I figured it out.

I added field names in the CSV file for each comma seperated value as the first row. Then, I used a free tool from the Internet to convert from CSV to XML format. Next, I added additional fields for the HTML forms for the autoresponder.

Finally, I performed an XML Import and mapped the the fields accordingly.

drquek
03-07-2008, 12:30 AM
I am glad you figure out how to do this.

Sorry for not replying to you earlier as my notebook PC was send for repair last 48 hours (due to a malfunctioning motherboard) and I was unable to access the Internet.