Author Topic: Import Existing Users  (Read 1519 times)

profiles

  • Posts: 5
    • View Profile
Import Existing Users
« on: May 03, 2005, 05:22:26 am »
Hello,

Is it possible to import an existing user database and have it show the original "Date Added, IP: Address,  Ref URL: and User ID" from the existing user database?

The long of it: I had originally set up a list (List 2), on one of my existing web sites with a caputure form for a different unrelated web site.

Now I have set up LMP on the other web site and I have imported "List 2" into the other web site, although I didn't see how to import those fields into the new database.

I want to import the "Date Added, IP: Address,  Ref URL: and User ID" from the existing user database into the new user database so I can track the users "click throughs" as well as know when they actually signed up and from which one of my web sites.

Thanks,

Mike

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Import Existing Users
« Reply #1 on: May 03, 2005, 07:24:43 pm »
Unfortunately, this is not yet possible.  While the import process supports the extra fields, the export process does not.  This is easy enough to fix, but there is the added issue that when you re-import users they are given a new UID.   Therefore, you must use PhpMyAdmin to extract the entire row information for users on your list, then re-import the rows, again using PhpMyAdmin, to the lm_users table on the new host.

Keep in mind that no two users in the database should have the same UID and there is a (very small) chance of this happening as ListMail is not checking for duplicates.

If you are not familiar with PhpMyAdmin I can provide more specific instructions.

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting