...

Follow these steps to change the format: (The following instructions uses the OpenOffice Calc application)
1. Go to File -> Open. Select the Item Listing file exported from Wavelet Management Portal. Click on the Open button to open the file
2. You will see the window below. Make sure the Tab checkbox is "checked" and the Text delimited field is empty. Click on column header as shown below to select first column.

Image Modified

3. Follow instructions in the diagram below to show the last column.

Image Modified

4. Follow instructions as shown below to select all columns.

Image Modified

5. Follow the instructions as shown below to change the format of all columns into "Text.

Image Modified

6. Notice that all columns are now properly formatted to "Text".

Image Modified

7. The following steps are meant to copy the item codes ("Code") and bar codes ("EanCode") from the Item List file formatted above (Steps 1 - 6) into the StockTakeImportData.xls file.

...

In order to import the StockTakeImportData.xls Excel file, Mobile POS will need the data to be entered in the following format:

Image Modified

Format Specifications:

...

11. Left click on the cell below the "Code" column name to select the first row.

Image Modified

12. Go to the last row of column "Code" as shown below.

Image Modified

13. Select all the rows in "Code" column by Pressing the "Shift key and Left Mouse Click at the same time as shown below.

Image Modified

14.Copy all the rows of column "Code" except for the column name.

Image Modified

15. Go to the StockTakeImportData.xls file.Select the first row of the "Stock Code" column.

Image Modified

16. Paste the "Code" data from the Item List file exported from Wavelet Management Portal into "Stock Code" column of the StockTakeImportData.xls file.

Image Modified

17. Repeat steps 11 to 16 for "EanCode" to copy the data in "EanCode" column from the formatted Item List file produced from steps 1- 6 into the "Barcode" column in the StockTakeImportData.xls file.

...

19. "Copy" the default value for Category, Description, Location1, Location2, Location3 as shown below.

Image Modified

20. Paste the default values into the other rows using "Edit" menu -> "Paste".

21. The other rows now have default values as shown below.

Image Modified

22. The StockTakeImportData.xls file is now ready and properly formatted for import into the Mobile POS Software.
You may save the file with the naming format of StockTakeImportData_<yyyymmdd>xls. (For Example: StockTakeImportData_20110201.xls)