how do i import emails - what field delimeter is a square

Start here! No need to ask twice :)

Re: how do i import emails - what field delimeter is a square

Postby soundtherapy » 10:16am, Tue 12 May, 2009

Im doing now
hopefully
thanks
s
soundtherapy
phpList newbie
 
Posts: 3
Joined: 4:19pm, Fri 08 May, 2009

Re: how do i import emails - what field delimeter is a square

Postby soundtherapy » 8:46am, Wed 13 May, 2009

HI
I just put permission 777 on all temp directories I have on my ftp...
it is still saying Warning: The temporary directory for uploading () is not writable, so import will fail
any other check I can do for finding out what it is the problem?
thanks
Sty
soundtherapy
phpList newbie
 
Posts: 3
Joined: 4:19pm, Fri 08 May, 2009

Re: how do i import emails - what field delimeter is a square

Postby pippocl1 » 12:01pm, Tue 09 Jun, 2009

I've the same problem and i don't resolve it :(

My csv file example:

[code]Vorname,E-Mail-Adresse,E-Mail: Angezeigter Name
richard,"xxx@vodafone.it", "richard (xxx@vodafone.it)"[/code]

in phplist - manage users - import users - import emails with the same values for attributes and at the the end i've this message:

Fatal Error: Some characters that are not valid have been found. These might be delimiters. Please check the file and select the right delimiter. ,


Help me please...
pippocl1
phpList newbie
 
Posts: 2
Joined: 11:53am, Tue 09 Jun, 2009

Re: how do i import emails - Excel misbehaves

Postby teedee » 2:26am, Sun 20 Sep, 2009

Excel thinks it understands the extent of your spreadsheet by tracking where you have worked. Press CTRL END to see where it thinks the last cell is. Then delete all rows and columns outside where you want. Then do the export.
teedee
phpList newbie
 
Posts: 0
Joined: 2:17am, Sun 20 Sep, 2009

Brining Excel in line with PHP

Postby sirpaulzaf » 7:18am, Sun 20 Sep, 2009

Hi guys, new user here in South Africa

I have a huge database in Excel, over the past 3 months, people have unsuscribed from my newsletters, I have added new names to my Excel database via Outlook etc, now I want to ensure my Excel database is clean, how do I find the list of Unsubscribes within PHP so that I can export them to Excel and then delete them within Excel and then export them back to PHP.

I understand that PHP will not allow unsubscribes to be imported, but I need to ensure Excel is up to date with my rejects and unsubscribes.
sirpaulzaf
phpList newbie
 
Posts: 0
Joined: 7:08am, Sun 20 Sep, 2009

Re: how do i import emails - what field delimeter is a square

Postby neparker » 1:37am, Sun 14 Feb, 2010

I have been following and converted my email list to excel, saved as tab txt file, and when it imports, I get the following error on all emails...

Warning: Record has more values than header indicated (1!=8), this may cause trouble: customers@email.com (customers email address)

Any suggestions?
neparker
phpList newbie
 
Posts: 2
Joined: 1:35am, Sun 14 Feb, 2010

Re: how do i import emails - what field delimeter is a square

Postby poulet » 10:32pm, Sun 02 May, 2010

This thread has been a great help.

Thats what forums are for.

Thanks guys
poulet
phpList newbie
 
Posts: 0
Joined: 10:29pm, Sun 02 May, 2010

Re: how do i import emails - what field delimeter is a square

Postby patje72 » 6:51pm, Mon 17 May, 2010

People with access problems. You shoul also check your security setting of the root folder on the website. And check the permissions are NOT 777
patje72
phpList newbie
 
Posts: 0
Joined: 6:47pm, Mon 17 May, 2010

Re:

Postby favhot » 10:40pm, Fri 19 Oct, 2012

[quote="Luigi"]Hi:

This is what i did an it worked for me....(i´m using 2.9.1)

* have your database in regular exel format, make sure in the first line on each square (cell) is the title of the field ( email, name, city...and so on..)

* order in the name colums is not important..

* [u]do not [/u]save it as cvs format, save it as Text tab delimited

* in your control panel go to manage users > import email

* use the first option the give you: [u]import emails with different values for attributes[/u]

* select the text file to import, you can check the Test output box to see the results before you import the file.

* do not check this boxes it´s not necesary
Field Delimiter: (default is TAB)
Record Delimiter: (default is line break)

* you can check either one of this boxes, acording to your needs
Send Notification email
Make confirmed immediately

* hit the import buttom and

* if you are satisfied with the output , go on and hit confirm Import to upload the file

* make sure the name fields on your text file (first line) correspond to the names found on the attributes page,if not no problem, if the system can´t match the fields automatically it will give you the chance to do it manually.

It should work with this procedure

Make sure your text files are small no more than 500 mails in one file.(pain in the kneck) depending on your server capability..
or you might have this error that can freeze you list system
[i]Database error 1226 User 'website_user' has exceeded the 'max_questions' resource (current value: 50000) [/i]
if you run into this problem, don´t worry i have the pill for that too. :lol:

I hope it helps
Luigi[/quote]
Hi Luigi

I tried everything and did not work for me. I download a Excel list but did not accept...
favhot
phpLister
 
Posts: 9
Joined: 11:40am, Mon 15 Oct, 2012

Previous

Return to Frequently Asked Questions

Who is online

Users browsing this forum: No registered users and 1 guest