web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Global Gift Card
Microsoft Dynamics RMS (Archived)

Global Gift Card

(0) ShareShare
ReportReport
Posted on by KristaBez 7

We use the integrated Global Gift Card solution to manage gift cards sold in 6 separate locations.  We recently experienced a total loss of our HQ server (with no viable back-up) and upon trying to recreate the GGC database, we noticed that there are a lot of discrepancies.  Does anyone know of a way that I can clear all vouchers in HQ and start fresh by importing a correct card#/balance listing that I have in .csv format?  And then repeat the process for the stores?  Or push it down somehow?  Thanks

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Global Gift Card

    I believe there may be a KB out there for the purposes of rebuilding the HQ database which may prove useful. I also believe there is a MS unsupported import utility you may also be able to obtain. I recommend working with MS or a MS partner for directions necessary to correct data. In order to obtain these two resources you will likely need to create a case with MS support or a MS Partner who performs database repair. I hope this proves helpful to you, as I do understand this is not a good position to be in.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Global Gift Card

    Hi KristaBez,

    Are you using RMS Global Gift Card feature. Then all your gift card numbers are saved in voucheronline table with respective values. You can recreate the table with correct values. Would suggest to replace the correct values without deleting the table as it maintain voucheronline ID for Gift card related reports.

  • KristaBez Profile Picture
    KristaBez 7 on at
    RE: Global Gift Card

    Thank you! Do you know if there is a way to add many records add a time to the voucheronline table?  I have 5000 gift cards to enter.

  • Suggested answer
    Antonijo Todorovik Profile Picture
    Antonijo Todorovik 4,025 on at
    RE: Global Gift Card

    Hi KristaBez.

    The best (and probably the only) way to import this values into your RMS database is by SQL, with queries or importing from an Excel (or similar external file). The problem is that You can´d just add the records, if they allready exists (or some of them). You will need to create a logic that will update the existing records and add the new ones (if any).

    For this, you better talk to Your RMS partner, as it´s not easy task. Your RMS partner shoudl be able to help you, they need knowledge of RMS database structure, SQL and maybe a little bit of programming also...

    If not, please contact me, my company can help You.

    Best regards, A.

  • Community Member Profile Picture
    Community Member on at
    RE: Global Gift Card

    Hi Krista, 

    If you have around 5000 records, you can use excel to create the script and apply it in SQL Manager studio. If you want to update the records, first get the list from SQL voucher table to excel and then add the new values for existing voucher numbers You need little bit SQL knowledge on this. Take a fresh back up before applying any scripts. Keep the voucher server disabled during the process. 

    PM if you need further support on this. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans