Importing Prospects Into Autoresponder With Custom Fields

[rizz]

Currently, I found out that if you add some custom fields in the HTML form, you cannot import prospects with these fields.

Eg.

If in my html form I add a customised field called "Mobile Phone", and later I go to Subcriber Manager and tried to import prospects, I will have no way to import them with this additional field.

Hence, the following will not work:

John Doe|johndoe@johndoe.com|92322323

where 92322323 is the custom "Mobile Phone" field.

Is there a way to do this?

This is important because sometimes we need to import prospects with more fields than just name and email.

Please look into this. Thanks.

[drquek]

FMLP stored additional fields (in addition to name and email address) in swd_doppar table with following fields

*fk_fields - ID of field record defined in swd_fields
*fk_user - ID of prospect defined in swd_user table
*value - Value

You can edit the mysql database yourself if you need to import more fields (in addition to name and email address).

Note the next update of FMLP Pro has XML export/import tool to import subscribers from XML file with additional fields.

[rizz]

Well actually I've found out that the XML import tool is already available in the version that I bought.

Tried it and worked very well. Solved my problem.

Great. Thanks.

[drquek]

Yes, you can also use the XML import tool.

[gxjenkins]

I just purchased the Pro version, and I'm trying to import my lists into it. The problem I'm running into is I don't know how to map the fields, or change them.
Any help would be appreciated.
Thanks.

[drquek]

To import prospects you have to get to the prospect menu:


Click in the account menu on the account
Click the "subscriber manager"

Here you can add new contacts to your "current prospects" list and run them through your entire message set.

You can either paste them into the "Insert text" box or upload them in a txt file using the many popular formats as follows:

Tom Jones|his@email.com
or:
his@email.com
or:
<his@email.com>
or:
Tom Jones <his@email.com>
or:
“Tom Jones” his@email.com
or:
Tom Jones his@email.com

One contact per row. When ready, click the Import Prospects button.

If you need to import more fields, use the XML import tool.</his@email.com></his@email.com>

[gxjenkins]

Thanks for your reply but I'm trying to add custom fields. I want to keep the data I have now like Address, City, State, etc. I can upload a cvs file but that only saves the email address and name.
I exported my lists to a spreadsheet. Then saved it in xml format, and uploaded to the server.
I see the file and I see the fields I created in the subscriber form, but that is where I get lost.
How do I get my current data into a new account. If that is in the manual let me know where because I can't find it.
Thanks,
Gary

[drquek]

This is the section of the Manual dealing with customization (I am not sure this answers your question):

http://www.drquek.com/amlmmanual/index.html#7._Working_with_Prospect_List__

I read your questions a few times, it seems you want to import additional field s not currently in your database.

Try to create the additional fields first, then try to XML import them and see.

[gxjenkins]

I got it working this morning. I had the fields created already, but I couldn't get "XML " importer to see the correct field names so I could map that data to the fields I had created in the database.
The problem turned out to be the xml files that Open Office, and Excel created. The user data or field names were so far down the importer never saw them, so there was always a data mis-match.
So, the answer was to export the data from the database in xml format to bypass Excel, or Open Office, and that worked like a charm.
Thanks for your help.

[drquek]

Thanks for your feedback.