RTO Pro Help File

Auto receive / import inventory from XML or CSV file

Auto receive / import inventory from XML or CSV file

This is the first topic This is the last topic  

Auto receive / import inventory from XML or CSV file

This is the first topic This is the last topic JavaScript is required for the print function Mail us feedback on this topic!  

Comments (...)

 

Example of using the auto receive inventory by XML file passed as switch to RTO Pro. Note CSV files can also be used now, click here for info on receiving by CSV file.

 

Below is an example of the command line you would use to pass the file containing the inventory data to RTO Pro. The "c:\xmlfiles\myxml.xml" would be changed to the actual path to your file.

rto-win.exe -r c:\xmlfiles\myxml.xml

 

Below are the field names and descriptions, with a * are required, the fields can be in any order, field names are not case sensitive

<model> *Model alphanumeric 15 characters max

<serial> *Serial alphanumeric 30 characters max

<stock> Stock number numeric 15 characters max (if auto stock numbers are set in RTO Pro this will be generated if not passed otherwise 0 if not passed)

<daterec> Date received, defaults to today if not passed, please note this date must be in US format such as "12/31/2013" or "12-31-2013"

<cost> Inventory cost

<balance> RBV Tax, defaults to cost if not passed

<rbvbook> RBV Book, defaults to cost if not passed

<description> Description alphanumeric 250 characters max

<invoice> Invoice number alphanumeric 15 characters max

<brand> Brand or manufacturer. alphanumeric 15 characters max

<category> Inventory category, defaults to "NONE" if not passed 31 characters max(15 main category, 15 sub category with a : separating for instance "APPLIANCE:WASHER", sub category is optional)

<vendor> Vendor for this item alphanumeric 15 characters max

<AGENT> FP agent, defaults to "NONE" if not passed. alphanumeric 15 characters max

<BOR> BOR YES or NO defaults to YES if not passed

<RENTALRETAIL> Rental or RETAIL, defaults to RETAIL if not passed (rental would make the item show as idle BOR retail would not)

<QUANTITY> Quantity for non serialized or pieces for serialized

<STORE> Store number, defaults to current store if not passed

<RETAIL> Retail price

<RTO> RTO$ field (not used by most but some use it to store total RTO price).  alphanumeric 15 characters max

 

Below is an example of how the XML file should look

 

<rtoproinventory>

<record>

<model>T1000</model>

<serial>T1000SER</serial>

<stock>1000</stock>

<daterec>1/17/2011</daterec>

<cost>100</cost>

<balance>100</balance>

<rbvbook>100</rbvbook>

<description>T1000 test load</description>

<invoice>1000</invoice>

<brand>BRandT1000</brand>

<category>WASHER</category>

<vendor>TvENDOR</vendor>

<AGENT>RENTALAGENT</AGENT>

<BOR>YES</BOR>

<RENTALRETAIL>RENTAL</RENTALRETAIL>

<QUANTITY>1</QUANTITY>

<STORE>1</STORE>

<RETAIL>300</RETAIL>

<RTO>100</RTO>

</record>

<record>

<model>T1000</model>

<serial>T1000SER1</serial>

<stock>1001</stock>

<daterec>1/17/2011</daterec>

<cost>100</cost>

<balance>100</balance>

<rbvbook>100</rbvbook>

<description>T1000 test load</description>

<invoice>1000</invoice>

<brand>BRandT1000</brand>

<category>WASHER</category>

<vendor>TvENDOR</vendor>

<AGENT>RENTALAGENT</AGENT>

<BOR>YES</BOR>

<RENTALRETAIL>RENTAL</RENTALRETAIL>

<QUANTITY>1</QUANTITY>

<STORE>1</STORE>

<RETAIL>300</RETAIL>

<RTO>100</RTO>

</record>

<record>

<model>T1000</model>

<serial>T1000SER2</serial>

<stock>1002</stock>

<daterec>1/17/2011</daterec>

<cost>100</cost>

<balance>100</balance>

<rbvbook>100</rbvbook>

<description>T1000 test load</description>

<invoice>1000</invoice>

<brand>BRandT1000</brand>

<category>WASHER</category>

<vendor>TvENDOR</vendor>

<AGENT>RENTALAGENT</AGENT>

<BOR>YES</BOR>

<RENTALRETAIL>RENTAL</RENTALRETAIL>

<QUANTITY>1</QUANTITY>

<STORE>1</STORE>

<RETAIL>300</RETAIL>

<RTO>100</RTO>

</record>

</rtoproinventory>

 

Below is an example of how the result file will look: c:\rtowin\AutoReceiveresult.txt (c:\rtowin if default folders were used in install)

 

01/17/2011 03:18 PM

0 <Received count

3 <Skipped count

Record below skipped, model / serial combination exists in database already.

Model:T1000 Serial:T1000SER Stock: 1000

Record below skipped, model / serial combination exists in database already.

Model:T1000 Serial:T1000SER1 Stock: 1001

Record below skipped, model / serial combination exists in database already.

Model:T1000 Serial:T1000SER2 Stock: 1002

 

 

Auto receive by CSV file

 

You can also auto receive inventory in a CSV file below are the specs and requirements:

Command line:

rto-win.exe -r c:\csvfiles\mycsv.csv

 

The field names and descriptions are the same as XML files (see above). A sample of what the file will look like is below, the fields can be in any order. Note the example below only includes 13 fields, all 19 fields are available but not required.

 

model,serial,category,description,invoice,stock,vendor,agent,cost,retail,rto,brand,store

BARN,32396,BARN,5-B-32396-1016-070911-VA,0811VA,473,MY VENDOR,MY AGENT,2752.00,2752.00,4586.67,MY BRAND,1

GARDEN SHED,31981,GARDEN SHED,5-GSX-31981-1420-063011-VA,0811VA,473,MY VENDOR,MY AGENT,5206.00,5206.00,8676.67,MY BRAND,1

 

 

 

Comments (...)