Hello,
I have been working on several projects aimed at reducing the number of anonymous, general admission, and constituent 0 orders in the system and I have found a way to gather email address and order numbers independently, but now I need to attach them in the system.
What I would like to do is call a procedure that will look up the order number and write in the correct constituent from a local table. Has anyone written a procedure to do this? I am assuming this is more involved than just updating T_ORDER.constituent_no. Can anyone tell me what all I would need to touch or what procedure system calls when you key it from the front end?
Thanks in advance.
SADIE PRATER
Systems Analyst
Perot Museum of Nature and Science
Hi Sadie
I must admit I haven;t updated custoemr number, but you can do it through the client. So if you have a time when your Test environment is quiet, run a sql trace and then update a customer number in an order via the Tess client and see what it actually does update.
That said think transcations, line items and sub line items just have order number, is payments that have the customer_no attached and not sure you need to move payments.
Probably need to refresh tickey history after doing it to ensure that picks up the changes.
Alternative is to add your new customer_no as the initiator of the order (or recipients) which would tag the order(tickets) back to the customer but have less impact and depending on your setup may still populate ticket history so can be used in lists etc.
Mark
Mark,
I had thought of the Trace, but hadn't yet had the time to pick through it. The initiator idea had not occurred to be and may be just the thing!
Thanks for your help. This community is the best.
Sadie
> I am assuming this is more involved than just updating T_ORDER.constituent_no.
You can move an order from one customer_no to another with just that update, yes, as happens e.g. during a merge. (Don't forget T_PAYMENT, too, though.)