I'm currently trying to integrate a custom built website into RMS using the Yahoo Stores Emulation method. I think I've almost got my head around the way this is done but unfortunately I'm stuck on the parsing XML into the SQL Table "Exchange". From an earlier post I gathered that the processor code 'YahooStore' should be used but am not sure where to enter the XML data and in what format.
I believe that some versions of RMS come with an entry in the Exchange table but mine is blank so I have nothing to work with.
Here is an example of a sql statement executed via OSQL in a .bat file which loads xml data into the exchange table:
INSERT INTO dbo.Exchange (DateCreated,LastUpdated,ProcessorCode,Data,Status,Comment) VALUES('9/4/2005 9:12:14 AM','9/4/2005 9:12:14 AM', 'YahooStore', ' Tue Aug 30 21:12:14 2005
Joe Smith Joe Smith
1234 Lincoln Dr. #3202
Phoenix AZ US United States
12345
888-555-6666 snipped-for-privacy@email.com
John Smith John Smith
4567 E Rose Lane
Phoenix AZ US United States
12345
888-333-4444 snipped-for-privacy@email.com
FedEx Ground
9002
9002
1
12.99
NO
149.98
0.00
11.92
161.90
',0,'#7926, Fri 9/2/2005 2:12:10 PM, $161.90, ShipTo: Joe Smith, BillTo: John Smith');
The .bat file simply contains the following command: osql -ddatabase_name -Uusername -Ppassword < internet_orders.sql
internet_orders.sql is the file containing the sql statement with the xml data above.
You're right about the 'YahooStore' part needing to be present. Can't tell you how frustrating it was trying to figure out why I couldn't get the command to work when something seemingly as insignificant as that was missing.
The credit card type is simply a tender name and doesn't have to be Visa,MC,Amex, etc.
I haven't been able to get data to load into the company field...seems like a bug.
The Comment field doesn't have any specific requirement and can be modified any way you like. It's what a cashier will see when they hit at the POS.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.