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 and Jason, yes the integration is very sensitive and if you have the development and database experience along with a lot of time then it looks like you're on the right path. But if your priority is to continue selling within your store and focusing on your product then consider in the future

Thanks for the information Alex. Fortunately I did have the database and development experience which allowed me to create a custom system, albeit with a lot of effort. I would definitely recommend your solution for someone that doesn't have the time or resources to develop a custom solution of their own. I use LiteCommerce for my shopping cart which is developed by the X-cart people.

I'm still using RMS 1.3 and will be upgrading to 2.0 soon. As far as I know the internet order import function operates the same in 2.0 but would you mind letting me know if I'm incorrect? It sounds like you know that it will be changing in 3.0. Is that true and if so do you know how significant the change will be?

Lance

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