Restore orders from text file

[jpurvor]

I had a failure on one of my sites from which I recovered using site snapshot and database restore.
Unfortunately the database was a few hours out of kilter with the current orders and so I have a handful of orders which are not in Actinic. I have copies of these orders in text format.

I am trying to work out how to re-instate these orders but here is the issue:
If I manually enter the order, Actinic assigns a manual order number. I would obviously like to have the correct order number.

Perhaps someone could provide some insight into how this can be done? Perhaps by 'hacking' the order database using Access??
J

[I-CC]

Well, you can set the order numbers from the software under Help | Troubleshooting, where you can set the order number, which then the next order moves on from there, so that might do what you need...

[jpurvor]

Good call, however this option is not applicable here as this only helps if there is a catastrophic error and the order numbering gets out of sequence and you want to reset the starting point for downloaded orders.

In this case I have orders which run sequentially as follows:
0010 to 0960 - present and correct in Actinic
0961 to 0970 - not in Actinic but I have email/paper copies
0971 on - Present in Actinic

So the issue is how to get the 0961 to 0970 orders back into Actinic.

I guess I could take the site offline, reset the numbers as you say and then enter all the orders via the web again, download them into the payment pending and then manually enter their payment... hmmm perhaps. But now I've got another days worth in the database!

[Jan]

Enter the orders again, then change the order number in Access, it is in the order table and is the field called Order Number, it is quite safe to do this as it is a free text field.

Regards,

[jpurvor]

Hi Jan,
Thank you (again!).

I manually re-entered the orders after setting the date/time back to the order time and ended up with a list of orders in the 'payment pending' area - then used Access to edit ActinicCatalog.mdb as you suggested - the order details, and numbers were easy to cut and paste as I'd used One Stop Automation to save reports for each order in RTF format.

Finally I updated the payments to correlate with PROTX (setting the date time back to the payment time) and voila - a perfect orders database!

Really easy. But perhaps something you might consider for a future product? (an editor for the database with date/time stamp controls). I doubt I'm the only one to have lost data this way!

J
PS anyone who has not visited Jans site, please do so.