End of product life cycle on December 20, 2019.

We are winding down the development and the support for the Inventory Scanner X app. We are very proud that we have been able to help so many of you to manage their private and business inventories, but we need to focus our resources elsewhere. Of course, the app support is available until the end of product life cycle on December 20, 2019.

The app will remain in the App Store for free including all advanced features and should continue working without any problems as long as Apple does not change anything very big in iOS.

Data Import Format

Data can be imported from a CSV file. The data fields with their requirements and restrictions are listed below.

 

General Notes

  • For all products and fields applies: If an entry does not exist, it will be automatically transferred to the database.
  • When importing multiple values for a data field, e.g. photos and serial numbers, they must be separated by spaces in the data field. Conversely, the data itself may not contain any spaces (applies only to that data fields).

 

Other constraints and requirements:

  • Please use UTF-8 encoding.
  • The field separator should not be used in the data. The semicolon is defined as default separator character. If necessary, the separator character can be changed for importing data into the app. The choices are ; TAB & | and #.
  • It is important to ensure that the number of data fields in each row is the same. Otherwise, the data will be rejected as invalid to avoid errors during data import.
  • Do NOT use any of these “new line” characters within the data fields.
    • Line feed (LF, Unicode 0x0A)
    • Vertical tabulation (VT, Unicode 0x0B)
    • Form feed (FF, Unicode 0x0C)
    • Carriage return (CR, Unicode 0x0D)
    • Next line (NEL, Unicode 0x85)
  • It is generally recommended to create a backup before each data import.
  • There are two import modes:
    • Pure import of the master data.
    • Import of master and inventory data. For the inventory data, a new inventory will be created, i.e. old inventories are not overwritten.
  • In both cases, the imported master data are compared with the existing and potential conflicts are collected. Afterwards, the conflicts can be resolved using the conflict assistant.
  • The import is only possible if there are no conflicts or all conflicts have been resolved.

 

In the following the necessary conditions are marked with an asterisk.
*   = required field
**  = property is required

 

Master Data, unique for a product (-ID)

 

productId * Unique product-ID or barcode, usually the barcode this field is required
name Name of product
image1 Master data product images, list of filenames separated by spaces
Up to 3 images per product (in master data)
File names must not contain spaces **
Alternative key: image (instead of image1)
description Product description (continuous text)
category Product category (1st level)
If the category doesn’t already exist, it is automatically copied into the database
subcategory Product category (2nd level)
If the sub-category doesn’t exist, it is automatically copied into the database
If a sub-category is specified, a corresponding upper category ** must be available
internalId Internal product ID or name (useful for mapping of the official barcodes to internal names)
custom1 Custom field 1 in master data
custom2 Custom field 2 in master data
custom3 Custom field 3 in master data
dateCreated1 Time stamp of creation according to RFC 3339 standard based on UTC time zone, e.g. 2014-11-14T10:28:47Z
If no timestamp is specified during import, the current date and time is taken.
dateModified1 Time stamp of last change according to RFC 3339 standard based on UTC time zone, e.g. 2014-11-14T10:28:47Z
If no timestamp is specified during import, the current date and time is taken.

 

Inventory data (can be different in each list)

 

quantity Quantity in dotted decimal notation.
Please note: The value cannot be negative.
unit Unit of quantity as text (abbreviation). It’s recommended to use bl or bbl instead of barrel.
If the unit doesn’t already exist, it is automatically copied into the database.
unitCost Cost per unit in dotted decimal notation.
Please note: The value cannot be negative.
unitPrice Price per unit in dotted decimal notation.
Please note: The value cannot be negative.
currency 3-letter ISO code for currency, for example, USD for US Dollar or EUR for Euro

 

Optional: Different currencies for costs and prices

currencyCost Currency for charge (costs)
currencyPrice Currency for price

 

location Name of vocation
If the location is not yet available, it is automatically copied into the database
image2 Inventory data product images, list of filenames separated by spaces
Up to 3 images per product (in inventory data)
File names must not contain spaces **
comment Comment (continuous text)
serials List of serial numbers, separated by spaces
Serial numbers must not contain spaces **
custom4 Custom field 1 in inventory data
custom5 Custom field 2 in inventory data
custom6 Custom field 3 in inventory data
dateCreated2 Time stamp of creation according to RFC 3339 standard based on UTC time zone, e.g. 2014-11-14T10:28:47Z
If no timestamp is specified during import, the current date and time is taken
dateModified2 Time stamp of last change according to RFC 3339 standard based on UTC time zone, e.g. 2014-11-14T10:28:47Z
If no timestamp is specified during import, the current date and time is taken

 

Example Files

 

Manual