RMS Internet Orders- CTRL+ SHIFT+ F10

I use the internet order feature regularly and recall how sensitive RMS is to the syntax when I was developing my import system. I'm not an expert and ultimately succeeded through lots of trial and error. Without analyzing what's wrong with your code I've copied code that I know works for me. The code is a sql statement which I execute using the osql command called from a .bat file. The osql statement takes the form: osql -ddatabasename -Uusername -Ppassword < sql_statement_file.sql

Here is the contents of sql_statement_file.sql:

INSERT INTO dbo.Exchange (DateCreated,LastUpdated,ProcessorCode,Data,Status,Comment) VALUES('5/21/2008 3:14:59 AM','5/21/2008 3:14:59 AM', 'YahooStore', ' Wed May 21 3:14:59 2008

Joe Smith Joe Smith

Phoenix AZ

Joe Smith Joe Smith

Phoenix AZ

FedEx Ground

NO

',0,'#1588, Wed May 21 3:14:59 2008, $49.99, Joe Smith ');

OK... I played ALOT with it and got it! Started by dropping everything before the order command . All the information before the order command is ignored by RMS. Omit time and numeric time, they are ignored as well. Everything else looks ok until the last line. Remove the command as well. Also remember to convert or remove any illegal characters. Illegal characters will kill the process without any error codes.

Good Luck.

Lance, rumor has it that RMS 3.0 will have a whole new look and is being redeveloped from the ground up. I would assume a lot of the short cut keys and functionality will still remain the same. I'm hoping, as you are that the database structure will remain closely the same but who knows. We'll just have to wait and see.

Alex

Jasoncleme / Lance

Thanks for the info - I was just starting to work on this on a volunteer basis for an NGO group which can't afford any add-in. Feel free to send me any more information you have discovered. Just debating which cart to use... Xcart, OSCcommernce, home made cart, Drupal ubercart or ecommernce. I have played with most of them... but will look at LiteCommerce.

Thanks Danny(AT)skatepei.ca