Author Topic: Importing old records  (Read 2686 times)

chris1

  • Posts: 5
    • View Profile
Importing old records
« on: August 09, 2007, 02:43:09 pm »
I'm trying to import old records from a 3-year-old version of the ListMail MySQL database into a new database running on the latest version of ListMail. It ain't working.

Anything I should know?

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Importing old records
« Reply #1 on: August 09, 2007, 09:07:53 pm »
Do you still have the old database up on a server, or is it a PhpMyadmin dump or ListMailPRO backup file?

Are you trying to overwrite your entire database, or just retrieve some users from one or more lists contained in the backup?

Since this could be expected to work, I'd be willing to investigate.  For hands-on troubleshooting please submit your info along with all relevant access details and what you want to do.  You can email me files at dean@... or simply upload them to your ListMail folder where I can easily access them.

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

chris1

  • Posts: 5
    • View Profile
Importing old records
« Reply #2 on: August 10, 2007, 06:49:48 am »
Hey Dean,

We set up the new database with the new version of ListMail no problem, then imported the old records from the old database with the old version of ListMail.

We were able to get the old records into the new database, but ListMail ain't seein' em.

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Importing old records
« Reply #3 on: August 10, 2007, 07:15:56 am »
So the rows were imported and exist in the newest database, but ListMail doesn't see them?  I recommend viewing the records with a tool like PhpMyAdmin to see if there are any obvious data differences.  Please use the link to send me your info if you want hands-on help.

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

chris1

  • Posts: 5
    • View Profile
Importing old records
« Reply #4 on: August 14, 2007, 08:02:36 am »
Well, we viewed all the records in the lm_users table with PHP admin, and here's the table breakdown:

id:  numeric value
uid:  alpha numeric value
list: All have the number "2"
fname: blank
lname: blank
email: email address'
user1-user10: all blank
cseq: all have the number "1"
cdel: all have the number "0"
cnf: all have the number "1"
dateadd: all have a valid y2k date
ipaddr:  all have a valid formatted ip
refurl:  either contain "unknown" or "http://inpics.net/notify.html"
htmail:  All have a "1"
bounces:  all have a "0"

What do you think?

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Importing old records
« Reply #5 on: August 15, 2007, 02:00:48 am »
The records look good and "Active" on list 2.  Could you have chosen to view "Removed" or " Bounced" emails instead of "Active" on the User Database page?  Are the id's properly incrementing and do the uid's appear to be unique?

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

chris1

  • Posts: 5
    • View Profile
Just can't see 'em
« Reply #6 on: August 17, 2007, 06:00:19 am »
All the old records are in the new database, and the tables look good. They just aren't showing up in the admin interface:

http://inpics.net/newsletter/edituser.php?list=2

Is there a tool to export records from an old version of ListMail/database to a new version/database?

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Importing old records
« Reply #7 on: August 17, 2007, 02:33:36 pm »
Are you sure your config.php is set up to access the new database and not the old or an incorrect one?
Quote
Is there a tool to export records from an old version of ListMail/database to a new version/database?

The way I usually do it is by migrating the entire old database using PhpMyAdmin then upload the new ListMail files and browse to the login page for the database to be updated to the new version.

I don't recommend using PhpMyAdmin to copy certain users from an old installation to a new one directly - doing this could result in duplicate UIDs or emails.  It is best to either migrate the entire database or set up the new copy then export and import leads from within ListMail.

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