Data Can't Be Sent to Word or Excel Document

Problem: The target document (Microsoft Office) does not receive the sent data.

Solution: Please make sure, that all available Windows and Office updates are installed!

Related Links:

All Scanned Data is Inserted into the Same Cell

Problem: When using Microsoft Excel 2013, the selection does not move automatically to the next cell after inserting. All captured data is inserted into the same cell.

Solution: This feature is available for the following applications:

  • Microsoft Excel 2016 (or newer)
  • Microsoft Excel Online
  • Google Sheets
Workaround: You can also try to use a VBA Macro 🠢 see sample spreadsheet.

When using Microsoft Office 2016, please make sure, that all available Windows and Office updates are installed!
Related Links:

Image Support is Not Available

Problem: Scanned images are not transferred to Office documents.
You receive the following error message: Oops, unfortunately image support is not available in this Office application. Check out the FAQ for details.

Solution: Image support is available for the following applications:

  • Microsoft Word/Excel for Windows (2016 or later)
  • Microsoft Word/Excel for Mac (15.20 or later)
  • Microsoft Word Online
  • Google Sheets

Scan-IT to Office - History

Will Data Be Lost Without an Internet / Add-In Connection?

Don't worry, if the connection to the Internet / Add-In is lost during data collection the data won't get lost:

  • If offline, captured data is stored in the History as unsent (see picture).
  • The app transmits this data automatically when the Internet connection is restored.
  • The data is forwarded in the same order as it was captured.
  • Users can also manually resend individual data records from the history or resend the complete history, if required.

Please refer to the Scan-IT to Office User Manual for further information.

How to Connect Multiple Add-Ins?

If you want to forward captured data to multiple target documents (e.g. in case of multiple locations, offices, etc.), you have to connect the Scan-IT to Office App with further Add-Ins:

  • Open the main menu (Open contextual menu) of your Scan-IT to Office App.
  • Select Add Connection from the menu
  • Select Scan QR-Code and scan the QR code of the Add-In you want to pair
    (In the Add-In you can show the QR-code with the button Add Phone (Add Phone) below your Configured Phones list)
  • Repeat these steps with as many Add-Ins as you like :)
All currently connected Add-Ins and their connection states, are listed in the app item Show Connections in the main menu (Open contextual menu)

How to Activate a Bulk License on iOS Devices

Scan-IT to Office Bulk License Activation

To activate a bulk license (volume license) on a single device manually, follow these steps:

  • Start your iOS app, open the menu and select Buy Subscription or press the Subscribe button.
  • In the Subscriptions view, press the key icon at the top. A dialog will appear asking for your activation key (see picture).
  • Enter your valid activation key and confirm with OK.
  • If the activation was successful, you will receive a notification. The expiration date of your bulk license should now be displayed in the Subscriptions view.

To activate a bulk license on multiple devices via a Mobile Device Management system, follow these steps:

  • You can use Managed App Configuration to activate multiple devices via your Mobile Device Management (MDM) solution.
  • Please contact your MDM vendor for a documentation on how to configure Managed App Configuration in your MDM solution.
  • Some MDM solutions require an AppConfig spec file. You can download this file here.
  • If your MDM solution does not use a spec file please configure the Managed App Configuration as following:
    - Key = MOAS_ActivationKey
    - Type = String/Text
    - Value = < Your Activation Key>

Office Add-In on Android: Unsupported Server Location

Disable DOM Storage Error Message

Problem: If you download the Scan-IT Office Add-In on your Android device, the file can't be opened and/or installed, because this Add-In is only supported on desktop devices. You receive the following error message: Can’t open file. Sorry, Scan-IT-to-Office---Barcodescanner-for-Office.xlsx is stored in an unsupported server location.

Solution 1: Insert the Add-In directly into your Office application:

  • Go to the menu bar and click Insert
  • Now choose My Add-Ins
  • Open the store and search for Scan-IT to Office
  • Click on Add

Solution 2: Download the Add-In from Microsoft AppSource on your Desktop PC or Mac.

Can't Send Barcode Data... (on Mac OS)

Problem: You receive the following error message in the Scan-IT to Office App if you send data to Office on Mac OS: Can’t send barcode data to a Microsoft Office document. Please connect this app with Microsoft Office. This error message is displayed if a connection between App and Add-In is lost or was never established.

Solution 1: Deactivate computer sleep mode in the system settings under Energy Saver on Mac OS.
Solution 2: Re-pair the Scan-IT to Office App with the Scan-IT to Office Add-In. Contact support@tec-it.com in case of recurring problems.

Enable JavaScript for Scan-IT to Office

Office Add-In Does Not Work Because of Disabled JavaScript

Problem: JavaScript is required to use the Scan-IT to Office Add-In. If JavaScript is disabled, you receive the following error message: JavaScript is required to use this Add-In. Please check the FAQ to correct this.

Solution: Enable JavaScript by setting Active Scripting to Enable under Security - Custom - Custom level in your Internet Options.

Image FAQ

Office Add-In is Displayed Incompletely

Problem: The Scan-IT to Office Add-In looks inactive and only displays the buttons "Phones", "Log" and "Options" without functionality.

Solution: Add the Scan-IT to Office Add-In as a trusted site as follows:

  • Start Internet Explorer.
  • Click on the icon Icon Settings and then on Internet Options.
  • Open the tab Security and then select the Trusted Sites zone.
  • Click on the button Sites.
  • A dialog to add new trusted sites will appear.
  • Enter https://tecit-sto-office.azurewebsites.net in the text field and click the button Add.
  • Close Internet Explorer and restart your Office application. The Add-In should now be displayed correctly.
Another possible reason for this problem might be a disabled JavaScript setting. See next FAQ entry.

Office Add-In Does Not Work Because of an App Error

Problem: When you use Microsoft Office 2013 or later, you may receive the following error message:
APP ERROR: This app could not be started. Close this dialog to ignore the problem or click "Restart" to try again.

Solution: For Office 2013, first make sure that the update in the following Microsoft Knowledge Base article is installed: Update KB2986156 for Office 2013 (May 12, 2015)

Re-enable protected mode for Restricted Sites in Internet Explorer:

  • Open the Internet Explorer and click the tools button Icon Settings, and then click Internet Options.
  • Click the Security tab, and then select the Restricted Sites Zone.
  • Select the Enable Protected Mode check box, and then click OK.
  • Restart Internet Explorer.
For further information on this topic, please check out the Microsoft Support.
DOM Storage is Not Available in Your Browser

Settings are Not Saved

Problem: The Scan-IT to Office Add-In shows the following error message: DOM storage is not available in your browser. The Add-In is operable but settings will not be saved permanently. Please check the FAQ to correct this.

Solution: Make sure that Enable DOM Storage is checked in the Internet Options under Advanced - Security.

Use Scan-IT to Office with Lookup and Reference Function in Excel

Task: In Microsoft Excel an article name (stored in a separate table) should be displayed automatically after a barcode was captured with Scan-IT to Office (e.g. for inventory).

Solution: With VLOOKUP, Microsoft Excel provides a lookup and reference function, which lets you lookup captured data in some table automatically. For example, you will find an item description based on the remotely captured item number.

VLOOKUP is composed as follows:

VLOOKUP Function in Excel
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) 

Example:

  • =VLOOKUP(A5;ItemList!$A:$B;2)

Useful Links:

How to Upload Customer Specific Forms on iOS Devices

You can copy files between your computer and apps on your iOS device using File Sharing with Apple iTunes. The next few steps show how it works:

  1. Open iTunes on your Mac or PC
  2. Connect your iPhone or iPad to your computer
  3. Click your device in iTunes
    Input form Upload
  4. In the left sidebar, click File Sharing
  5. Select the Scan-IT to Office App
  6. Drag and drop files from a folder in the documents list or click Add. Please note that the file name has to start with "form_"
  7. iTunes copies these files to the app on your device
  8. Restart the Scan-IT to Office App on your device
  9. The uploaded custom forms are now displayed in your app
    Input form Upload
For further information about file sharing with iTunes, please check out the Apple Support.

How to Share Forms on Android Devices

Form sharing under Android currently works a bit different than in the iOS app, which has its own button for this function. Here you have to proceed as follows:

  1. Open the Scan-IT to Office App and select Forms
  2. Go to Custom forms and make a long tap on the form you want to export
  3. Select Export HMTL from the menu
  4. Connect the Android device to your PC and open the file manager
  5. Select the device and open the folders Internal shared storage and ScanItToOffice:
    Form Sharing on Android Device
  6. Open the folder Custom Forms and save the exported form (HTML file):
    Form Sharing on Android Device
  7. Now copy this HTML form to all devices on which you want to use the form in the folder \ScanItToOffice\Custom Forms (if it does not exist, please create it)

Google Sheets Add-On Stops Receiving Data After a Period of Time

Problem: Connection between the app and the Google Sheets add-on is lost or interrupted after a period of time. Restarting the add-on helps but it makes using the app inconvenient.

Solution: This issue might be caused by a functionality of Google Chrome that closes unused/inactive connections. To change the setting, please, proceed as follows:

  1. Open a Google Sheets document
  2. Open the URL chrome://discards/ in a new browser tab
  3. Now search the line with the opened Google document and click on the Toggle button in the Auto Discardable column to disable this option (see the screenshot):

  4. Google Sheets Auto Discardable Settings

Google Sheets Add-On Can't Insert Data Because of Authorization Error

Problem: If a different account is logged in to Google Chrome than in Google Sheets, the add-on may not have write permissions for spreadsheets.

  • The following error message appears when opening the add-on:
    Error: Multiple accounts issues. Please log out of your account john.doe1@gmail.com to use Scan-IT to Office with the account john.doe2@gmail.com.
  • The following error message appears when scanning data :
    Error on Insert: ScriptError: Authorization is required to perform that action.

Workaround: To solve this problem, please try these two possibilities:

  • Log out or change the account that is logged in to the Chrome Browser.
  • Share the spreadsheet with the account logged into the Chrome Browser.

How to Cancel, Pause or Change a Subscription

Problem: App subscriptions purchased on Google Play or App Store are auto-renewing by default. A subscription to the app should be cancelled, paused or renewed.

Solution: Users are able to cancel the subscription by following the steps in the links below: