<< Click to Display Table of Contents >> Navigation:  Import  Export Module > Generic Import/Export Module  > Import Data Sample

This sections covers the configuration of the data to import and the file name.   At the prsent moment the import of the PLU files is designed to work primarily with a scanning file.

 

Each section consists of a file name, and a list of fields that can be imported.   Each field is marked with a number that indicates which column in the CSV file its located at. The first column will always start at zero.

 

The section below shows the departments will be imported from a file called department.csv the first column will be the department number, the next will be te name and the third will be the group link.

 

An example of the CSV file would look like

 

1,Spirits, 2

2,Beer,2

3,Wines,2

 

Note : - Default values can be used for fields that are not in the import file.

 

 <!--department-->

   <add key="FILEIMPORTDEPARTMENT" value="departments.csv" />

   <add key="IMPORT_DEPARTMENT_ID" value="0" />

   <add key="IMPORT_DEPARTMENT_NAME" value="1" />

   <add key="IMPORT_DEPARTMENT_GROUP_ID" value="2" />

   <add key="IMPORT_DEPARTMENT_TAXCODE_ID" value="NULL" />

   <add key="IMPORT_DEPARTMENT_MARGIN" value="NULL" />

   <add key="IMPORT_DEPARTMENT_DEFAULT_VALUE_MARGIN" value="0" />

   <add key="IMPORT_DEPARTMENT_DEFAULT_VALUE_GROUP_ID" value="1" />

   <add key="IMPORT_DEPARTMENT_DEFAULT_VALUE_TAXCODE_ID" value="1" />

 

 

 

<!--stock levels-->

   <add key="FILEIMPORTStockLevels" value="stock.csv" />

   <!--0 by outlet ID - guid / 1 by outlet code-->

   <add key="IMPORT_BY_OUTLET_CODE" value="1" />

   <add key="IMPORT_STOCK_OUTLET_CODE" value="4" />

   <add key="IMPORT_STOCK_OUTLET_ID" value="NULL" />

   <!--0 by PLU product ID - / 1 by scancode / 2 by stock record id -->

   <add key="IMPORT_BY_SCANCODE" value="1" />

   <add key="IMPORT_STOCK_ITEM_ID" value="NULL" />

   <add key="IMPORT_STOCK_PLU_ID" value="NULL" />

   <add key="IMPORT_STOCK_SCANCODE" value="1" />

   <add key="IMPORT_STOCK_VOLUME" value="3" />

 

 

 

   <!--plus-->

   <add key="FILEIMPORTPLU" value="data.csv"/>

   <!--optional because may want to create with MAX + 1-->

   <add key="IMPORT_PLU_ID" value="NULL"/>

   <add key="IMPORT_PLU_DEPARTMENT_ID" value="0"/>

   <add key="IMPORT_PLU_NAME" value="1"/>

   <add key="IMPORT_PLU_NAME2" value="NULL"/>

   <add key="IMPORT_PLU_NAME3" value="NULL"/>

   <add key="IMPORT_PLU_NAME4" value="NULL" />

   <add key="IMPORT_PLU_SCANCODE1" value="2"/>

   <add key="IMPORT_PLU_SCANCODE2" value="NULL"/>

   <add key="IMPORT_PLU_PRICE" value="3"/>

   <add key="IMPORT_PLU_COST" value="4"/>

   <!--(1-standard/2-zero/3-special)-->

   <add key="IMPORT_PLU_TAXCODE_ID" value="NULL"/>

   <!--( buy unit conversion - number items in case)-->

   <!-- it is set to null or is missing then no stock is created -->

   <add key="IMPORT_PLU_UNIT_CONVERSION" value="5"/>

   <add key="IMPORT_PLU_PACK_SIZE" value="6"/>

   <add key="IMPORT_PLU_SUPPLIER_ID" value="7"/>

   <add key="IMPORT_PLU_SUPPLIER_REF" value="8"/>

   <add key="IMPORT_PLU_SHELF_EDGE_ID" value="NULL"/>

 

   <add key="IMPORT_PLU_DEFAULT_VALUE_SUPPLIER_ID" value="1"/>

   <add key="IMPORT_PLU_DEFAULT_VALUE_SHELF_EDGE_ID" value="300"/>

   <add key="IMPORT_PLU_DEFAULT_VALUE_TAXCODE_ID" value="1"/>

   <add key="IMPORT_PLU_DEFAULT_VALUE_DEPARTMENT_ID" value="1"/>