280
We recently had a database failure at one of our branches. Since settign up a new database the branch is not downloading all global customer files. However, if i manually open a customer file in HQ, and press ok, it becomes updated and the affected branch would then pull the customer file. Other than doing this for thousands of files,what are my options? Is there an sql worksheet i can run?
Thanks in advance.
*This post is locked for comments
Hi
Anthony,
Thanks for your suggestion but that doesn't seem to work. The test entry when i specified a customer account worked however, but the general statement above had no effect. I was thinking, we do not use Zipcodes. Perhaps that's a field we could edit for all accounts?
Hi there.
If I understand correctly, once You open the customer properties in RMS HQ Manager and hit OK, then this customer get's downloaded to the store with new database.
If this is right, you can prepare a simple SQL quiery to update an Customer table field that you don't use, for example "UPDATE [Customer] SET [CustomText5] = '' ", and then run worksheet 401. BUT I would recomend few things:
- You always make database backup's before you act, on both RMS HQ and RMS SO
- Try this first in a test environment
- Try this with only one customer first, to see if it works correctly. In that case your SQL query should be something like "UPDATE [Customer] SET [CustomText5] = '' WHERE AccountNumber = '12345' ", where you change 12345 with a customer account number...
- Once You decide to do this, if possible, stop the RMS HQ Clients of all the stores, except the store involved...
Kind regards, A.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,329
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
