deutsch english

[ Smart Inventory ] - [ Functions ]

FAQ for Smart Inventory

The functions of Smart Inventory are simple and intuitive. Here are some common questions that have arisen when using Smart Inventory:

  1. How can I enter or scan barcodes?
  2. How do I use a Bluetooth scanner and which models can I use?
  3. The environment is too dark to scan barcodes with the integrated scanning function
  4. The CSV file could not be imported
  5. If you want to save a CSV file in the e-mail program, MS Excel opens (or another spreadsheet)
  6. After saving from the e-mail program, the CSV file is only 2 bytes in size
  7. When opening the CSV file in Excel, the EAN is not displayed correctly, but in scientific notation (e.g. 4.016E + 12 instead of 4016032334705)
  8. How can I import serial numbers (or device numbers / IMEI's)?
  9. How should the csv file for serial numbers be structured?
  10. Wrong characters are scanned by the external Bluetooth scanner


  1. How can I enter or scan barcodes?
    You can easily scan bar codes (EAN, UPC-A or article numbers) with the integrated scanner or a Bluetooth scanner. If you want to scan the barcodes, You can deactivate the display of the on-screen keyboard in the setting. Alternatively, you can use the on-screen keyboard to display the digits that the barcode represents enter. If you have deactivated the display of the on-screen keyboard and still want to enter it using the keyboard, tap once in the input field of the EAN, the keyboard will be displayed.

  2. How do I use a Bluetooth scanner and which models can I use?
    You can use just about any Bluetooth scanner that can pair with your smartphone. After the barcode, the scanner must send a line end character (Return / Enter). You can set this to some scanners, please consult the manual of the scanner. Successfully tested were e.g. the Bluetooth hand-held scanners Netum RD-M7, Aibecy BWM2 and Inateck BCST-70.

  3. The environment is too dark to scan barcodes with the integrated scanning function
    The integrated scan function uses your smartphone's camera to scan barcodes. In a dark environment, the barcode can therefore be badly recognized. You can use the volume buttons to turn your smartphone's light on and off to light the barcode.

  4. The CSV file could not be imported
    Please check the format of the CSV file. In particular, make sure that you have selected the correct delimiter and exactly one line for each article is used, so e.g. there are no line breaks in the article description. If the delimiter of the fields in the CSV file is e.g. in the description, the description must be enclosed in double quotation marks (").

  5. If you want to save a CSV file in the e-mail program, MS Excel opens (or another spreadsheet)
    Be careful to touch the Save icon, not the file name.

  6. After saving from the e-mail program, the CSV file is only 2 bytes in size
    File attachments are encoded using special 7-bit methods so that they can be sent easily. CSV files are predominantly "quoted-printable" and " base64" for use. MS Outlook, Thunderbird, and MS Mail use "base64", but Apple Mail uses "quoted-printable". Gmail on Android handles "quoted-printable" not correct and saves a 2 byte file. In this case, please use a different e-mail program to get the csv filesto send to your smartphone or transfer them by other means, e.g. Google Drive.

  7. When opening the CSV file in Excel, the EAN is not displayed correctly, but in scientific notation (e.g. 4.016E + 12 instead of 4016032334705)
    If you open a CSV file in Excel directly (e.g. with a double click), Excel does not treat large numbers (e.g. EAN) correctly during import, but displays them in scientific notation. The imported file then looks like the following figure:



    To import the data correctly into Excel, you have to import the CSV file. To do this, click on "Data" -> "From Text" in the menu. In the following window, select the character set "65001 : Unicode (UTF-8)" under "File origin":



    Click on "Next" and select the "Semicolon" under "Delimitiers":



    Click on "Next" and select the column with the EAN code in the "Data preview". Under "Column data format" select "Text":



    Click again on "Next" and enter the upper left cell where the data should be inserted or select a new worksheet:



    After clicking "OK", you will receive the correctly imported data:



  8. How can I import serial numbers (or device numbers / IMEI's)?
    The serial numbers are imported via a second csv file. When importing, activate the option "Import serialnumbers". You will receive a second file selection button with which you can import the csv file for serial numbers. All imported serial numbers are listed under the item details, you can mark existing serial numbers there. When performing the inventory, you can also scan the serial number instead of the EAN / article number, then the scanned serial number is marked directly and the actual sock increased by 1.

  9. How should the csv file for serial numbers be structured?
    The csv file for the serial numbers has two columns. The EAN is in the first column and the serial number in the second column. The separator and whether the first column contains headings is adopted in the csv import settings, e.g .:



  10. Wrong characters are scanned by the external Bluetooth scanner
    The Bluetooth scanner uses a different character set than your smartphone. If possible, you should set the same character set on the Bluetooth scanner as on your smartphone. If you cannot set the correct character set (often referred to as "Keyboard Setting") on your Bluetooth scanner or the character set cannot be set at all, you can set the character set in Android. To do this, open the "Settings" app and select the menu item "General Management" and then "Language and input" (depending on the Android version and smartphone, the names may differ). Your scanner appears as a "Physical keyboard":



    In this example, the Bluetooth scanner is called "NETUM buetooth" (the scanner must be switched on and paired). Tap on the scanner and select the character set of your Bluetooth scanner in the following screen. Now alphanumeric barcodes are also recorded correctly.