Import adresses (using german version)

Alpino

New Member
Hi,

I tried to import adresses and nothing works fine :-(

First, I Tried to use the "From a website", because I have an external .php-Script that generates an output like this:

Name;Email;Idx
Don Joe;[email protected];1234
NextName;[email protected];3456
....

That generates the following:

Vorname E-Mail Adresse
Don Joe;don.joe [email protected]

So, it combines the Name with the name-part from the e-mal adress and the Idx is gone at all.

The forum told me too use "Import plain text".

OK. I copied the output from my script to the clipboard an paste it into the text-input field.

The same result.

Than I copied the list into an Text-File an renamed the german fieldnames I found in an exported CSV-file:

Nachname;E-Mail Addresse;Opt1
Don Joe;[email protected];1234

I select the ";"-delimiter and the option "Use the first line to rename field names"

The result is an error "Nothing to import"

At last, I typed in a few adresses by hand and use the "Export"-function, select all fields i need and the seperator and got this:

Vorname;Nachname;E-Mail Adresse;Opt1
Jon;Doe;[email protected];1234

(Also "E-Mail Adress" doesnt work!!)

If i try to import the exported text-file, using ";" as delimtier and the option to use the information from the first line as field-names, the message is "

Nothing could be imported, because 1234 is'nt a valid e-mail-adress!?!?!!

A working "Import CSV from an web-Adress" would be fine.

If I need to copy the .php-output to clipboard or file, no problem, but than: How to import to get what is listed?
 

Alpino

New Member
OK, I found an work-a-round:

I'm not free in design of the CVS, it works only with TABs and with an fix field-order.

FirstName1<tab>Surname1<tab>Company1<tab>Email1<tab>Opt1<tab>....Opt20<Return>

With this, I can Import from anywhere ...
 
Top