*This post is locked for comments
method I've been using looks something like this:
clear out existing macro and event table, then recreate macro names
delete from macro
insert into macro (RegisterID, Caption, AssignmentNumber) values (1,'Macro Name', 1)
...
delete from macroevent
bcp database..macroevent in macro.txt -c -Scompname -Uuser -Ppassord
macro.txt has exported events from another store using
bcp database..macroevent out macro.txt -c -Scompname -Uuser -Ppassord
reassign macroid in new event table to match new macro table
update macroevent set macroid=macro.id from macroevent join macro on macroid=assignmentnumber
Of course none of this matters anymore since win10 wont let you use macros in RMS POS
Did you get a solution for this? I see that the actual string is not stored int he SQL.
A good solution is to configure the macro in your template before creating the initial store databases. I have had limited sucess with bulk export/import and bcp (see http://technet.microsoft.com/en-us/library/cc917564.aspx) but once a store database has been created, future macro edits are best done by re-recording the key strokes from the terminal.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,818 Super User 2024 Season 2
Martin Dráb 229,147 Most Valuable Professional
nmaenpaa 101,156