Author Topic: import csv and data file (Read 2095 times)

lemacurbain · « **on:** December 21, 2004, 11:56:45 am »

Hi!...

I am trying to import the CSV made in Excel but i don't have any success.

I'm waiting when the file is send but nothing is happening!..

Can you guide me ?

Thank you

DW · « **Reply #1 on:** December 21, 2004, 01:19:36 pm »

It's possible that your host has a problem with uploading files via the web. Try sending your CSV file with FTP to your main ListMail directory. Then, type the filename into the second box on the Import page.

lemacurbain · « **Reply #2 on:** December 22, 2004, 05:53:13 am »

i have try this thing two and it s not working!... everything seems ok but the import is not successful .. i have try this with Firefox and IE..

Any other suggestion?

lemacurbain · « **Reply #3 on:** December 22, 2004, 06:00:33 am »

Do you want me to send you by email the csv and the access code so you could test it faster? let me know!!

lemacurbain · « **Reply #4 on:** December 22, 2004, 08:34:19 am »

Note: This script can take awhile and the counters may not update properly. Be patient for best results. and nothing is happening!

lemacurbain · « **Reply #5 on:** December 24, 2004, 11:28:38 am »

Hello again .. i have import only one collum the email adresss but the first name and last name i have not been able to import them can you guide me on this.

Is there a special way the CSV are done.. or i use a french alphabet any advice on this?

Let me know.

I never had any response from my last post, let me know.

DW · « **Reply #6 on:** December 30, 2004, 02:52:09 am »

Standard CSV format is quote-separated with the fields in no particular order, similar to as follows:

"email@site.com","First","Last"
"email2@site.com","First","Last"

When you choose the file to import you should be presented with a "Field match" page where you can match up fields to data based on the first line of the file. ie:

email@site.com -> Email Address
First -> First Name
Last -> Last Name

Setting the fields this way should allow all data to be imported as expected.