Line Item Import From File

Updated 6 months ago by Melissa Albright

Updated import vendor list (added Permobil):

Import a available manufacturer file as an alternative to manually filling out order forms. The advantage includes guaranteed accurate cost and eliminates configuration issues. Only specific manufacturers offer this file as part of their quote process.
Import an ARTSCO file from an Exported configuration. An export file can be generated from any order form in the system. Importing an ARTSCO file saves time by automatically filling order forms from commonly used configurations.
Depending on the file, you may have to select the appropriate 'Choose Vendor' selection after choosing the file.
In the Line Items window you can edit the imported information.  The column labeled 'Imported' will show a check for all imported items.
Line items can be re-imported more than once for the same order.  Any existing line items from a previous import for the manufacturer will be deleted prior to importing the current file.
Sunrise items that start with ">> ", OWNERS MANUAL, STANDARD PACKAGING, HANDLING FEE, or FREIGHT are not imported.
Sunrise can only match to order forms and order form check boxes based on part numbers contained in the file.  All unmatched items in the Sunrise file will have a form name of 'Order Form'. 
Only the ARTSCO and Sunrise file types make selections on existing order forms. All other file types generate line items only and are not associated with an order form in the system.
Contact the associated manufacturer to set up receiving files compatible with the RxWeb (formally Rehab Accelerate) Import feature.
Each manufacturer has a specific file structure. If an import does not work properly, make sure you are using a proper file for the manufacturer selected. The file structures are given below.

Available Manufacturers

  1. BioDynamics: Configurator software gives the opportunity to save an *.xml file to any folder that you choose and the * (name of file) of the *.xml can be the name of the patient and the evaluation date to easily identify the folder (ex. JohnJonesNov30.xml).
  2. Comfort Company
  3. Ki Mobility
  4. Pride
  5. Sunrise: Configurator is available as a Web application and the xml file is returned via email as an attachment.   If you do not currently receive xml files from Sunrise, contact your Sunrise account manager for details on setting up your company to receive them.   Save this attachment to a convenient local or network folder. The feature described here requires you to open the desired order manually before importing the file and it may not always be apparent, based on the file name, what order should be opened. Note: Sunrise items that start with ">> ", OWNERS MANUAL, STANDARD PACKAGING, HANDLING FEE, or FREIGHT are not imported. Sunrise can only match to order forms and order form check boxes based on part numbers contained in the file.  All unmatched items in the Sunrise file will have a form name of 'Order Form'. 
  6. Therafin: Configurator software saves a file with the name of 'REHAB ACCELERATE.CSV' in a folder named C:\TSEXP.  The configurator is an Excel file named tsa44.xlsm and can be downloaded from http://therafin.com/tsa44.xlsm. To use the configurator, open tsa44.xlsm in Excel, fill the form, click Form button then click 'Export to EXTERNAL FILE'.
  7. Ti Lite
  8. Permobil: The following values are filled from values in the XML file into the first page of the Permobil order form and also into related fields on the measurement data form: 1.) Weight, 2.) Height (separated out into feet and inches), 3.) Top of Shoulders, 4.) Chest Depth, 5.) Seat Depth, 6.) Top of Head, 7.) Elbow to Hand, 8.) Seat Pan to Elbow, 9.) Hip Width, and 10.) Knee to Foot. After the import, right click on any line item row and select the 'Open Form' menu item to open a page containing the measurement values pulled from the XML file. Alternatively open any Permobil wheelchair order form to view the measurement values pulled from the XML file.

File Structure

Biodynamics:

<?xml version="1.0" encoding="UTF-8"?>
<configurator>
<items>
<item>
<sku>SS01-NB</sku>
<quantity>1</quantity>
<description>Bio ST Custom Solid Seat Insert, 1/2" HDPE, a 2" medium density foam pkg., zippered Neoprene cover, steel mtg hdwr</description>
<hcpcs>E2609</hcpcs>
<retail>510.00</retail>
</item>
<item>
<sku>SS01-NB-SRM</sku>
<quantity>1</quantity>
<description>Medium Package: 1" Soft Sunmate on 1" Medium Sunmate</description>
<hcpcs> </hcpcs>
<retail>0.00</retail>
</item>
</items>
</configurator>

Comfort Company:

<items>
<item>
<sku>C-A-15W16H</sku>
<description>CUSTOM ACTA-BACK: 15W16H</description>
<hcpcs>E2617</hcpcs>
<msrp>$672</msrp>
</item>
<item>
<sku>COMFORT-TEK</sku>
<description>COMFORT-TEK FABRIC</description>
<msrp>$0</msrp>
</item>
</items>

Ki Mobility:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<configurator>
<items>
<item>
<sku>CAT4</sku>
<quantity>1</quantity>
<description>CAT4</description>
<hcpcs>K0004</hcpcs>
<retail>1140.00</retail>
<cost>430.00</cost>
</item>
<item>
<sku>40FCS016</sku>
<quantity>1</quantity>
<description>Frame Color - Iridescent Navy</description>
<retail>0.00</retail>
<cost>0.00</cost>
</item>
</items>
</configurator>

Pride:

<ACKNOWLEDGEMENT>
<QUOTE_NO>2238501</QUOTE_NO>
<QUOTE_NAME>TEST</QUOTE_NAME>
<QUOTE_VERSION>1</QUOTE_VERSION>
<QUOTE_DATE>27-FEB-17</QUOTE_DATE>
<EXPIRY_DATE>26-AUG-17</EXPIRY_DATE>
<HEADER>
<BILL_TO>
<CUSTOMER_NUMBER>9999</CUSTOMER_NUMBER>
<CUSTOMER_NAME>TEST ACCOUNT</CUSTOMER_NAME>
<ADDRESS1></ADDRESS1>
<ADDRESS2></ADDRESS2>
<ADDRESS3></ADDRESS3>
<ADDRESS4></ADDRESS4>
<CITY></CITY>
<STATE></STATE>
<POSTAL_CODE></POSTAL_CODE>
</BILL_TO>
<SHIP_TO>
<CUSTOMER_NUMBER>9999</CUSTOMER_NUMBER>
<CUSTOMER_NAME>TEST ACCOUNT</CUSTOMER_NAME>
<ADDRESS1></ADDRESS1>
<ADDRESS2></ADDRESS2>
<ADDRESS3></ADDRESS3>
<ADDRESS4></ADDRESS4>
<CITY></CITY>
<STATE></STATE>
<POSTAL_CODE></POSTAL_CODE>
</SHIP_TO>
<QUOTE_EXPIRATION_DATE>26-AUG-17</QUOTE_EXPIRATION_DATE>
<ORDER_TYPE>QUANTUM STANDARD US</ORDER_TYPE>
<CUST_PO_NUMBER></CUST_PO_NUMBER>
<SHIP_VIA></SHIP_VIA>
</HEADER>
<LINE>
<LINE_NO>10000</LINE_NO>
<ITEM>Q6 EDGE 2.0 3SP-SS</ITEM>
<ITEMDESC>Q6 EDGE 2.0 3SP-SS-K0856</ITEMDESC>
<QUANTITY/>
<HCPCS>K0856</HCPCS>
<UOM>EA</UOM>
<LNRETAIL>7595</LNRETAIL>
<LNNET>5316.5</LNNET>
<LNDISC>2509.38</LNDISC>
</LINE>
<LINE>
<LINE_NO>10000</LINE_NO>
<ITEM>DGN152585-PSL3</ITEM>
<ITEMDESC>GREY STREET STANDARD FRONT BATTERY DOOR</ITEMDESC>
<QUANTITY/>
<HCPCS></HCPCS>
<UOM>EA</UOM>
<LNRETAIL>0</LNRETAIL>
<LNNET>0</LNNET>
<LNDISC>0</LNDISC>
</LINE>
<TOTAL>2509.38</TOTAL>
</ACKNOWLEDGEMENT>

Sunrise:

<?xml version="1.0"?>
<!DOCTYPE ACKNOWLEDGEMENT [
<!ELEMENT ACKNOWLEDGEMENT (SUPPLIER, ORDTYPE, HEADER, LINE+, TOTALLINE, NOTES*, NOTICE?)>
<!ELEMENT SUPPLIER (#PCDATA)>
<!ELEMENT ORDTYPE (#PCDATA)>
<!ELEMENT HEADER (BILLTO, SHIPTO, PONUMBER?, ORDNUM, OMARKFOR?, CUSTREF?, ORDDATE, ESTSHIPDT?, ACKDATE, SHIPVIA?, BUYER?)>
<!ELEMENT BILLTO (BTNUMBER, BTNAME, BTADDR1?, BTADDR2?, BTADDR3?, BTADDR4?, BTCITY, BTSTATE, BTPOSTAL, BTCOUNTRY?)>
<!ELEMENT BTNUMBER (#PCDATA)>
<!ELEMENT BTNAME (#PCDATA)>
<!ELEMENT BTADDR1 (#PCDATA)>
<!ELEMENT BTADDR2 (#PCDATA)>
<!ELEMENT BTADDR3 (#PCDATA)>
<!ELEMENT BTADDR4 (#PCDATA)>
<!ELEMENT BTCITY (#PCDATA)>
<!ELEMENT BTSTATE (#PCDATA)>
<!ELEMENT BTPOSTAL (#PCDATA)>
<!ELEMENT BTCOUNTRY (#PCDATA)>
<!ELEMENT SHIPTO (STNUMBER, STNAME, STADDR1?, STADDR2?, STADDR3?, STADDR4?, STCITY, STSTATE, STPOSTAL, STCOUNTRY?)>
<!ELEMENT STNUMBER (#PCDATA)>
<!ELEMENT STNAME (#PCDATA)>
<!ELEMENT STADDR1 (#PCDATA)>
<!ELEMENT STADDR2 (#PCDATA)>
<!ELEMENT STADDR3 (#PCDATA)>
<!ELEMENT STADDR4 (#PCDATA)>
<!ELEMENT STCITY (#PCDATA)>
<!ELEMENT STSTATE (#PCDATA)>
<!ELEMENT STPOSTAL (#PCDATA)>
<!ELEMENT STCOUNTRY (#PCDATA)>
<!ELEMENT PONUMBER (#PCDATA)>
<!ELEMENT ORDNUM (#PCDATA)>
<!ELEMENT OMARKFOR (#PCDATA)>
<!ELEMENT CUSTREF (#PCDATA)>
<!ELEMENT ORDDATE (#PCDATA)>
<!ELEMENT ESTSHIPDT (#PCDATA)>
<!ELEMENT ACKDATE (#PCDATA)>
<!ELEMENT SHIPVIA (#PCDATA)>
<!ELEMENT BUYER (#PCDATA)>
<!ELEMENT NOTES (ONSEQ, ONOTETEXT)>
<!ELEMENT ONSEQ (#PCDATA)>
<!ELEMENT ONOTETEXT (#PCDATA)>
<!ELEMENT NOTICE (#PCDATA)>
<!ELEMENT LINE (ORDLINE, ITEM, ITEMDESC?, UOM?, QUANTITY?, LNRETAIL?, LNNET?, DISCDESC?, LNDISC?, PDISCDESC?, PRIMARYDISC?, SHIPFROM?, LMARKFOR?, LNESTDATE, HCPC?, LINENOTES*)>
<!ELEMENT ORDLINE (#PCDATA)>
<!ELEMENT ITEM (#PCDATA)>
<!ELEMENT ITEMDESC (#PCDATA)>
<!ELEMENT UOM (#PCDATA)>
<!ELEMENT QUANTITY (#PCDATA)>
<!ELEMENT LNRETAIL (#PCDATA)>
<!ELEMENT LNNET (#PCDATA)>
<!ELEMENT DISCDESC (#PCDATA)>
<!ELEMENT LNDISC (#PCDATA)>
<!ELEMENT PDISCDESC (#PCDATA)>
<!ELEMENT PRIMARYDISC (#PCDATA)>
<!ELEMENT SHIPFROM (#PCDATA)>
<!ELEMENT LMARKFOR (#PCDATA)>
<!ELEMENT LNESTDATE (#PCDATA)>
<!ELEMENT HCPC (#PCDATA)>
<!ELEMENT LINENOTES (ORDLN, LNSEQ, LNOTETEXT)>
<!ELEMENT ORDLN (#PCDATA)>
<!ELEMENT LNSEQ (#PCDATA)>
<!ELEMENT LNOTETEXT (#PCDATA)>
<!ELEMENT TOTALLINE (TOTRETAIL?, TOTNET?, TOTDISC?)>
<!ELEMENT TOTRETAIL (#PCDATA)>
<!ELEMENT TOTNET (#PCDATA)>
<!ELEMENT TOTDISC (#PCDATA)>
]>
<ACKNOWLEDGEMENT>
<SUPPLIER>Sunrise Medical Inc</SUPPLIER>
<ORDTYPE>QUOTE</ORDTYPE>
<HEADER>
<BILLTO>
<BTNUMBER>224079</BTNUMBER>
<BTNAME>WHEELCHAIR INC</BTNAME>
<BTADDR1/>
<BTADDR2>36 IVY RD</BTADDR2>
<BTADDR3>PITTSBURGH PA 15232</BTADDR3>
<BTADDR4/>
<BTCITY>PITTSBURGH</BTCITY>
<BTSTATE>PA</BTSTATE>
<BTPOSTAL>15232</BTPOSTAL>
<BTCOUNTRY/>
</BILLTO>
<SHIPTO>
<STNUMBER>33469</STNUMBER>
<STNAME>WHEELCHAIR CAP REGION</STNAME>
<STADDR1/>
<STADDR2>231 NORTON STREET</STADDR2>
<STADDR3>PITTSBURGH PA 15629</STADDR3>
<STADDR4/>
<STCITY>PITTSBURGH</STCITY>
<STSTATE>PA</STSTATE>
<STPOSTAL>15629</STPOSTAL>
<STCOUNTRY/>
</SHIPTO>
<PONUMBER>QUOTE</PONUMBER>
<ORDNUM>6522118</ORDNUM>
<OMARKFOR>JANE SMITH</OMARKFOR>
<CUSTREF/>
<ORDDATE>20180308</ORDDATE>
<ESTSHIPDT/>
<ACKDATE>20180308</ACKDATE>
<SHIPVIA>Ground Service</SHIPVIA>
<BUYER>MARC</BUYER>
</HEADER>
<LINE>
<ORDLINE>1.000</ORDLINE>
<ITEM>EIZ9</ITEM>
<ITEMDESC>QUICKIE SR45</ITEMDESC>
<UOM>EA</UOM>
<QUANTITY>1.00</QUANTITY>
<LNRETAIL>0.00</LNRETAIL>
<LNNET>1182.15</LNNET>
<DISCDESC>0.00%</DISCDESC>
<LNDISC>1182.15</LNDISC>
<SHIPFROM>SUNRISE MEDICAL TECH SA DE CV - TJ</SHIPFROM>
<LMARKFOR/>
<LNESTDATE>20180313</LNESTDATE>
</LINE>
<LINE>
<ORDLINE>1.001</ORDLINE>
<ITEM>194WM77</ITEM>
<ITEMDESC>QUICKIE SR45</ITEMDESC>
<UOM>EA</UOM>
<QUANTITY>1.00</QUANTITY>
<LNRETAIL>2715.00</LNRETAIL>
<LNNET>1629.00</LNNET>
<DISCDESC>49.00%</DISCDESC>
<LNDISC>830.79</LNDISC>
<SHIPFROM>SUNRISE MEDICAL TECH SA DE CV - TJ</SHIPFROM>
<LMARKFOR/>
<LNESTDATE>20180313</LNESTDATE>
</LINE>
<LINE>
<ORDLINE>1.002</ORDLINE>
<ITEM>194FO3</ITEM>
<ITEMDESC>STANDARD FRAME AND SEAT FRAME</ITEMDESC>
<UOM>EA</UOM>
<QUANTITY>1.00</QUANTITY>
<LNRETAIL>0.00</LNRETAIL>
<LNNET>0.00</LNNET>
<DISCDESC>0.00%</DISCDESC>
<LNDISC>0.00</LNDISC>
<SHIPFROM>SUNRISE MEDICAL TECH SA DE CV - TJ</SHIPFROM>
<LMARKFOR/>
<LNESTDATE>20180313</LNESTDATE>
</LINE>
<TOTALLINE>
<TOTRETAIL>4081.00</TOTRETAIL>
<TOTNET>2346.60</TOTNET>
<TOTDISC>1309.82</TOTDISC>
</TOTALLINE>
</ACKNOWLEDGEMENT>

Therafin (no header - column order is: pn, qtyOrdered, desc, retail, code) :

50020,1,R-Back -- Full width --  in. W x 12 in. H -- Tube=1 in.,0,E2617
71051,1,Back: Base with foam & cover,382,E2617
Desc,1,Back: Planar with 1-1/2 in. soft visco foam -- foam thickness=1.5 in.,0,
Foam,1,Back: Foam bottom layer - 1-1/2 in. Soft Foam ,0,
Warning, ,** No back attaching hardware selected **,0,0
MISSING,1,CHECK BOX -- ENTER DESC. HERE & RETAIL PRICE & ITEM #,0,0
51058,1,Basic 4-point hip belt w/pad -- 1 in. strap & SR plastic buckle,142,E0978

Ti Lite:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<configurator>
<items>
<item>
<sku>CAT4</sku>
<quantity>1</quantity>
<description>CAT4</description>
<hcpcs>K0004</hcpcs>
<retail>1140.00</retail>
<cost>430.00</cost>
</item>
<item>
<sku>40FCS016</sku>
<quantity>1</quantity>
<description>Frame Color - Iridescent Navy</description>
<retail>0.00</retail>
<cost>0.00</cost>
</item>
</items>
</configurator>

Permobil:

<Xmlreportdetails xmlns="http://www.e-consolutions.com/webservices/">
<order>
<type>chair</type>
<source>eCon</source>
<version></version>
<createdBy></createdBy>
<quoteId>P000262386</quoteId>
<purchaseOrder></purchaseOrder>
<shipToAddress>
<shipToAddress>
<shipToName>BEST MEDICAL</shipToName>
<address1>123 My Way</address1>
<address2></address2>
<city>Hartford</city>
<state>CT</state>
<postalCode>15203</postalCode>
<country>USA</country>
</shipToAddress>
</shipToAddress>
<deliveryMethod>00</deliveryMethod>
<branch>AAAA</branch>
<requestDeliveryDate>2022-03-07</requestDeliveryDate>
<clientReference>Bob Smith, ATP</clientReference>
<internalReference>Jane Doe</internalReference>
<confirmationSettings>
<confirmationSettings>
<shipConfEmail>bob.smith@my.com</shipConfEmail>
<orderConfEmail>bob.smith@my.com</orderConfEmail>
<pricingOption>3</pricingOption>
<showFundingCodes>true</showFundingCodes>
</confirmationSettings>
</confirmationSettings>
<externalOrderId></externalOrderId>
<notes>
<notes>
<transactionHistory></transactionHistory>
<verifyError></verifyError>
</notes>
</notes>
<TotalPriceDetails>
<TotalPriceDetails>
<TotalExtendedMSRP>35588.86</TotalExtendedMSRP>
<TotalExtendedDealerPrice>24912.2</TotalExtendedDealerPrice>
<TotalExtendedNet>10689.99</TotalExtendedNet>
</TotalPriceDetails>
</TotalPriceDetails>
<attachments>
<attachments>
<fileName></fileName>
<stream></stream>
</attachments>
</attachments>
<models>
<model>
<externalConfigurationId>2afec419-e4f0-46c7-a54c-becd8a0f0429</externalConfigurationId>
<product>1A</product>
<patientInformation>
<patientInformation>
<firstName>Sue</firstName>
<lastName>Smith</lastName>
<diagnosis></diagnosis>
<fundingSource></fundingSource>
<age>0</age>
<weight>240</weight>
<height>74</height>
<topOfShoulders>21</topOfShoulders>
<chestDepth>9</chestDepth>
<seatDepth>22</seatDepth>
<topOfHead>32</topOfHead>
<elbowToHand>0</elbowToHand>
<seatPanToElbow>10</seatPanToElbow>
<hipWidth>19</hipWidth>
<kneeToFoot>22</kneeToFoot>
<uomLength>in</uomLength>
<uomWeight>lb</uomWeight>
</patientInformation>
</patientInformation>
<state>
<state>
<valid>true</valid>
</state>
</state>
<config>
<option>
<configOptionId>1</configOptionId>
<configOptionKey>c42d9303-e37d-477f-8518-8bd49f379a1b</configOptionKey>
<partNumber>I109052-99-0</partNumber>
<PartDescription>M3 Base Corpus - M3 MPO</PartDescription>
<qty>1</qty>
<retailPrice>8457</retailPrice>
<dealerPrice>5919.9</dealerPrice>
<secondaryDiscount>48</secondaryDiscount>
<netPrice>3078.35</netPrice>
<freeText></freeText>
<HCPC>K0861</HCPC>
</option>
<option>
<configOptionId>2</configOptionId>
<configOptionKey>51a23754-74d5-471e-a13a-267cb2824e00</configOptionKey>
<partNumber>103775-99-0</partNumber>
<PartDescription>User Weight 221-265lb (100-120kg)</PartDescription>
<qty>1</qty>
<retailPrice>0</retailPrice>
<dealerPrice>0</dealerPrice>
<secondaryDiscount>48</secondaryDiscount>
<netPrice>0</netPrice>
<freeText></freeText>
<HCPC></HCPC>
</option>
</config>
<custom />
</model>
</models>
</order>
</Xmlreportdetails>


How did we do?