Import Price List

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
Line 80: Line 80:
 
<ul>
 
<ul>
 
<li>Not all fields are required;</li>
 
<li>Not all fields are required;</li>
−
<li>Required fields are:              
+
<li>Required fields are:                
 
<ul>
 
<ul>
 
<li>ITEM_NAME</li>
 
<li>ITEM_NAME</li>
Line 100: Line 100:
 
<li>If price is defined but billing category and insurance name stays empty,</li>
 
<li>If price is defined but billing category and insurance name stays empty,</li>
 
<li>this price will be the default price (always valid). --&gt; if you have only one price for an item,<br />it is better to leave billing category and insurance name empty.</li>
 
<li>this price will be the default price (always valid). --&gt; if you have only one price for an item,<br />it is better to leave billing category and insurance name empty.</li>
−
<li>FOR EACH PRICE there needs to be ONE line.<br />
+
<li>FOR EACH PRICE there needs to be ONE line.<br />  
 
<ul>
 
<ul>
 
<li>Item name, item code, code type, short code, item group and item description should have exactly the same information (this will be saved in one table).</li>
 
<li>Item name, item code, code type, short code, item group and item description should have exactly the same information (this will be saved in one table).</li>
Line 109: Line 109:
 
</ul>
 
</ul>
 
</td>
 
</td>
−
</tr>
 
−
</tbody>
 
−
</table>
 
−
<table style="float: right;" border="0">
 
−
<tbody>
 
−
<tr>
 
−
<td><br /></td>
 
−
<td></td>
 
 
</tr>
 
</tr>
 
</tbody>
 
</tbody>
Line 151: Line 143:
 
</table>
 
</table>
 
<p><span id="result_box" lang="en"><span title="Sollte der Ordner &bdquo;Updates&quot; nicht vorhanden sein, einfach erstellen.  "><span lang="en"><span class="hps"><span id="result_box" lang="en"><span> </span></span></span></span></span></span></p>
 
<p><span id="result_box" lang="en"><span title="Sollte der Ordner &bdquo;Updates&quot; nicht vorhanden sein, einfach erstellen.  "><span lang="en"><span class="hps"><span id="result_box" lang="en"><span> </span></span></span></span></span></span></p>
−
 
+
<table style="float: right;" border="0">
−
<p></p>
+
<tbody>
 +
<tr>
 +
<td>
 +
<p style="text-align: left;"><a href="/index.php?title=Import_and_Export_tools">Back to Import and Export tools</a></p>
 +
</td>
 +
<td><a href="#top">Back to top</a><br /></td>
 +
</tr>
 +
</tbody>
 +
</table>
 +
<p><span id="result_box" lang="en"><span title="Sollte der Ordner &bdquo;Updates&quot; nicht vorhanden sein, einfach erstellen.  "><span lang="en"><span class="hps"><span id="result_box" lang="en"><span><br /></span></span></span></span></span></span></p>

Revision as of 16:03, 9 July 2014

This page contains additional importing features supported by MedITEX.

 

Price List Import

It is possible to import price lists by providing a spreadsheet with the information described on this section.

An example of this file can be downloaded from the link below.

<tbody> </tbody>
<img src="/images/plus48.png" alt="" width="48" height="48" />

Click here to download an example of Insurance information import file.

 

The structure of this file is described in the table below: 

<tbody> </tbody>
   Column name  Column content
1. ITEM_NAME Name of an item.
2. ITEM_CODE This code is UNIQUE for each item.
3. CODE_TYPE

The type of your code. Possible here:
3 - CPT
4 - HCPCS
5 - E/M
6 - LOINC
7 - GRC
4. SHORT_CODE Some characters of your choice. Not nessesary.(10 characters)
5. ITEM_GROUP Group for items.
6.
 ITEM_PRICE Price for an item
7. BILLING_CATEGORY The type of payment.
8.
 INSURANCE_NAME Name of the insurance.
9. ITEM_DESCRIPTION
 Description.

 

<tbody> </tbody>
<img src="/images/hint129.png" alt="" width="129" height="129" />
  • Not all fields are required;
  • Required fields are:
    • ITEM_NAME
    • ITEM_CODE

 

<tbody> </tbody>
NOTE:
  • If price is defined but billing category and insurance name stays empty,
  • this price will be the default price (always valid). --> if you have only one price for an item,
    it is better to leave billing category and insurance name empty.
  • FOR EACH PRICE there needs to be ONE line.
    • Item name, item code, code type, short code, item group and item description should have exactly the same information (this will be saved in one table).
    • Item price, billing category insurance name will be saved in a second table.
  • The importer looks if a item with this specific item code exists already.
    If yes, then the other item information (item name, code type, short code, group, description) will be updated and prices will be updated or inserted. If item is not find, the item with all information and all prices will be inserted.
<tbody> </tbody>
unzip
  • In item tabel "Material XYZ" will be inserted ONCE. But in price table 4 prices for this item "Material XYZ" will be inserted.
 
  • BILLING_CATEGORY must be exactly the name how you defined it in billing category list.
  • INSURANCE_NAME must be exactly the name how you defined it in MedITEX IVF - Insurance administration

 

<tbody> </tbody>

<a href="/index.php?title=Import_and_Export_tools">Back to Import and Export tools</a>

 <a href="#top">Back to top</a>