Scan-IT to Office App

App: Import/Export Custom Forms on Android

• Manual import/export:
  The App stores custom forms in an internal app directory that cannot be directly accessed via file managers (applies to versions 4.2.0+).
  
  • To import a form click on an .sto file in your file manager.
    
  • To export a form use the share function in the Form editor or long-tap on the required form in the Form manager and select Share.
  Note: All custom forms will be deleted when uninstalling the app (or when clearing the app data), so make sure you export the required forms before that.


• Auto-import of old forms (from an app version preceding 4.2.0):
  On the first start of the form manager, the app automatically recovers old forms saved with previous app versions (prior to 4.2.0).
  To be able to access all previously created forms without any further actions, please make sure the Storage permission is granted.
  The auto-import option may become unavailable on Android 11+ devices in future App versions.

App: OCR Scanner Won’t Start – Error: 'Failure, try again in a few minutes'

Launching the OCR scanner on Android results in the following error message 'Failure, try again in a few minutes. If the problem persists contact support@tec-it.com'.

The error message 'Failure, try again in a few minutes' means that the OCR library is trying to download the text detection module from the Web. Ways to fix it:

• Make sure your internet connection is active.
• Wait for some time to check if the module can be loaded. Please don’t stop the app while waiting.
• Clear the data of the Google Play Services App. Here you can find the “How-To” steps (taken from the Google Play Help page):
  
  
  • 1. Open the Settings of your Android device.
  • 2. Tap Apps & notifications.
  • 3. Open Google Play Services. If you don't see it in the list, tap See all apps first and then select Google Play Services.
  • 4. Tap Storage 🡒 Clear cache.
  • 5. Open the Google Play Store app.
  • 6. Wait for 5 minutes, then try your download again.

App: 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 () 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 () 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 ()

Scan-IT to Office Add-Ins/Tools

Office Add-In: 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:

• How to install Office updates
• If you are using a volume license or your company is using group policies to manage Office updates: Update Office with Microsoft update

Office Add-In: 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

• How to install Microsoft Office updates
• If you are using a volume license or your company is using group policies to manage Office updates: Update Office with Microsoft update

Office Add-In: Image Support Is Not Available

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 Add-In

Office Add-In: Unsupported Server Location on Android Devices

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.

Office Add-In (macOS): Can’t Send Barcode Data…

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.

Office Add-In: Is Displayed Incompletely

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 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.

Office Add-In: Does Not Work Because of Disabled JavaScript

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.

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

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

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 , 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.

Office Add-In: Find Value in Another Column or Sheet in Excel

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).

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 (lookup_value, table_array, col_index_num, [range_lookup]) 

Example:

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

Useful Links:

• Download Microsoft Excel sample file
• VLOOKUP documentation

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

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.

Google Sheets Add-On: Oops, Images Are Currently Not Supported

To insert data into Google Sheets, Scan-IT to Office provides 2 connection types:

Google Sheets (Drive):

• Transmission of images is not supported.
• Data is written into the sheet whenever the mobile App is online (you don’t need to keep the connected sheet open).
• To write data from multiple devices into the same sheet, the spreadsheet must be shared with the Google accounts of users that should be able to insert data into the sheet.

Google Sheets (Add-On):

• Supports transmission of images.
• To write data into the target sheet, the Add-On must be installed on a Windows or macOS system, the sheet and the Add-On must stay open and online.

Solution:

To insert images into a Google Sheet, use the Google Sheets (Add-On) connection.
Click here for download and installation instructions

Scan-IT to Office Smart Database Connector

Smart Database Connector: How to Insert Images into SQL Server

Your requirement: I want to receive images in my database.

Solution: Images are transmitted to Smart Database Connector as a Base64 string. This string can be internally converted to an image by SQL Server. Below you’ll find a sample solution:

1. Create two data fields:
   - for a Base64 string (nvarchar(MAX), allows nulls), e.g. ImageBase64
   - for binary data (varbinary(MAX), allows nulls), e.g. ImageBinary
   
   Here is a definition of a sample database “TestTable” in SQL Server 2005+
   
   
2. Use the SQL statement INSERT INTO in Smart Database Connector to send image data from the app (the data field name “Image”) to the field “ImageBase64” of the database “TestTable”:
   
   INSERT INTO TestTable (Data, ImageBase64) VALUES (%Barcode%, %Image%)
   
   
3. Conversion to an image can then be carried out in a TRIGGER stored procedure invoked by an INSERT event. E.g.:
   

   CREATE TRIGGER dbo.ConvertImageOnInsert 
      ON  dbo.TestTable 
      AFTER INSERT
   AS 
   BEGIN
          UPDATE TestTable SET ImageBinary = CAST('' AS XML).value('xs:base64Binary(sql:column("i.ImageBase64"))', 'VARBINARY(MAX)')
            FROM TestTable t
              INNER JOIN inserted i
                  ON t.ID = i.ID
   END
   GO
   

Smart Database Connector: How to Configure a 32-Bit ODBC DSN for ACCDB Databases

If you want to use accdb databases (created with Microsoft Access 32- or 64-bit edition) with 32-bit software (like TWedge, TFORMer and Smart Database Connector) you need to set up a suitable 32-bit ODBC data source.

• To do this, you may need to download and install the Microsoft Access Database Engine 2010 Redistributable (click the link). Install the 32-bit version of the redistributable; it includes accdb support.
• After installation adjust a new 32-bit ODBC DSN using this driver and use that DSN. For more information, visit Microsoft's questions page: Where are the 32bit ACCDB ODBC drivers in Windows 10?

Smart Database Connector: Configuration Page Is Empty

You encounter the following problem: The configuration page (http://localhost:33333) of the Smart Database Connector is empty. The service is running (check Task Manager) but the event log shows an error like Category: Microsoft.AspNetCore.Server.Kestrel - System.IO.FileNotFoundException: File name: 'Microsoft.AspNetCore.Diagnostics.Abstractions' when you perform a restart of the service.

The reason for this problem is that the temporary .NET Core execution folder has been corrupted. This comes from a bug in .NET Core from Microsoft (fix is planned in Nov-2020).

Solution:

Delete the shadow copy of the service so that it will be recreated automatically with all DLLs needed.

1. Stop the Smart Data Base Connector Service in Task Manager.
2. Locate the folder: C:\Windows\Temp\.net\Scan-IT to Office Tools - Smart Database Connector\
3. There is a sub folder like xngvhz1s.an0 (name is individual) ⇒ Delete this folder!
4. Start the Smart Database Connector Service again.