Import Price List

From MedITEX - Wiki

(Difference between revisions)
Jump to: navigation, search
Line 25: Line 25:
 
<tr>
 
<tr>
 
<td align="center">1.</td>
 
<td align="center">1.</td>
<td style="text-align: left;" align="center"><br /></td>
+
<td style="text-align: left;" align="center">ITEM_NAME</td>
 
<td style="text-align: left;" align="center"><br /></td>
 
<td style="text-align: left;" align="center"><br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td align="center">2.</td>
 
<td align="center">2.</td>
<td style="text-align: left;" align="center"><br /></td>
+
<td style="text-align: left;" align="center">ITEM_CODE</td>
 
<td style="text-align: left;" align="center"><br /></td>
 
<td style="text-align: left;" align="center"><br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td align="center">3.</td>
 
<td align="center">3.</td>
<td style="text-align: left;" align="center"><br /></td>
+
<td style="text-align: left;" align="center">CODE_TYPE</td>
 
<td style="text-align: left;" align="center"><br /></td>
 
<td style="text-align: left;" align="center"><br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td align="center">4.</td>
 
<td align="center">4.</td>
<td style="text-align: left;" align="center"><br /></td>
+
<td style="text-align: left;" align="center">SHORT_CODE</td>
 
<td style="text-align: left;" align="center"><br /></td>
 
<td style="text-align: left;" align="center"><br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td align="center">5.</td>
 
<td align="center">5.</td>
<td style="text-align: left;" align="center"><br /></td>
+
<td style="text-align: left;" align="center">ITEM_GROUP</td>
 
<td style="text-align: left;" align="center"><br /></td>
 
<td style="text-align: left;" align="center"><br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td align="center">6.<br /></td>
 
<td align="center">6.<br /></td>
<td style="text-align: left;" align="center"><br /></td>
+
<td style="text-align: left;" align="center">ITEM_PRICE</td>
 
<td style="text-align: left;" align="center"><br /></td>
 
<td style="text-align: left;" align="center"><br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td align="center">7.</td>
 
<td align="center">7.</td>
<td style="text-align: left;" align="center"><br /></td>
+
<td style="text-align: left;" align="center">BILLING_CATEGORY</td>
 
<td style="text-align: left;" align="center">
 
<td style="text-align: left;" align="center">
 
<p><span><br /></span></p>
 
<p><span><br /></span></p>
Line 62: Line 62:
 
<tr>
 
<tr>
 
<td align="center">8.<br /></td>
 
<td align="center">8.<br /></td>
<td style="text-align: left;" align="center"><br /></td>
+
<td style="text-align: left;" align="center">INSURANCE_NAME</td>
 
<td style="text-align: left;" align="center"><br /></td>
 
<td style="text-align: left;" align="center"><br /></td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
 
<td align="center">9.</td>
 
<td align="center">9.</td>
<td style="text-align: left;" align="center"><br /></td>
+
<td style="text-align: left;" align="center">ITEM_DESCRIPTION<br /></td>
<td style="text-align: left;" align="center"><br /></td>
+
</tr>
+
<tr>
+
<td align="center">10.</td>
+
<td style="text-align: left;" align="center"><br /></td>
+
 
<td style="text-align: left;" align="center"><br /></td>
 
<td style="text-align: left;" align="center"><br /></td>
 
</tr>
 
</tr>
Line 85: 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>IIII</li>
 
<li>IIII</li>

Revision as of 11:24, 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. This document contains the insurance information about one insurer.

<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
2. ITEM_CODE
3. CODE_TYPE
4. SHORT_CODE
5. ITEM_GROUP
6.
ITEM_PRICE
7. BILLING_CATEGORY


8.
INSURANCE_NAME
9. ITEM_DESCRIPTION

 

<tbody> </tbody>
<img src="/images/hint129.png" alt="" width="129" height="129" />
  • Not all fields are required;
  • Required fields are:
    • IIII
    • IIII
    • IIII
<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>