sent emails attached to wrong buyer!

[Lance]

Hi,

I wonder if anyone can help me with this problem?

I needed to move all the customers from one group into another and so I did this outside of actinic and then imported the data back in replacing the existing accounts. As part of this process I needed to delete all the existing order information which I did from within actinic.

I had tried updating the accounts originally but this didn't work as duplicate data got created even when I didn't edit the exported data.

Now I find that when I go back into the customer accounts the sent emails are attached to the wrong customers.

It looks like table orderMail has not been updated with the new buyer id's. I can do a match on email address to link the emails back to the original buyer and then update the order id. But will this cause any problems later on?

Is there an easier way of doing this? Should I have done this differently in the first place?

Any help would be appreciated.

[TraceyG]

Hi Lance,

I can do a match on email address to link the emails back to the original buyer and then update the order id. But will this cause any problems later on?

We can't really comment on whether you will have problems in the future or not by doing this because we've never tested doing it this way and we don't really support making changes directly to the database.

Is there an easier way of doing this?

If you are happy to remove the email information from your orders, then you could just clear the contents of the 'OrderMail' table in the database and have it make new references from then on, which should then be correct. Make a backup of your database before editing it just in case of any more problems.

Should I have done this differently in the first place?

Obviously, doing it through the interface would have been the preferred method and should have avoided any issues but without knowing exactly what you did (step-by-step) it's difficult to know what has gone wrong in your database. If you would like me to follow it up and can remember exactly what you did then please post the instructions and I'll see if I can replicate it on a default database to see if it's a software issue or something gone wrong with your site. If we can recreate a problem, we can usually fix it.

[Lance]

Hi Tracey,

Thanks for your reply. I've detailed what I did below if you want to try to reproduce it. Let me know if anything isn't clear and I'll try to provide more details.

I wanted to move all of my price schedule A customers from price schedule A to price schedule B. There doesn't seem to be any way of doing this in Actinic apart from one at a time.

1. I exported the customer accounts.
2. I imported the csv file into access
3. Updated all the customer records in group A, setting the price schedule to group B.
4. Exported back to csv file
5. Tried to import updating the existing records.
5b. This created some duplicates.
5c. Restored from backup
6. Tried to replace existing records. Couldn't because there were orders linked to accounts.
7. Deleted all orders from Actinic. Did this from within Actinic by highlighting and pressing 'Del' key.
8. Re-imported customer accounts. This seemed to work fine but the sent emails are now linked to the wrong accounts.

[TraceyG]

Hi Lance,

I haven't been able to recreate this following your instructions so it could be an issue with your database. Can I get a copy of the backup you used so that I can test it out please (tgsupport[@]actinic[dot]co[dot]uk).

[Lance]

Hi Tracey,

Thanks for looking into this for me. I've fixed the data now in OrderMail and so far everything seems ok.