CINXE.COM

<!DOCTYPE html> <html lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head id="ctl00_Head1"><meta charset="UTF-8" /><base href="https://www.tec-it.com/"></base><title> Scan-IT to Office FAQ, Frequently Asked Questions </title>   <link rel="preload" as="font" type="font/woff2" href="fonts/sourcesanspro/v21/6xK3dSBYKcSV-LCoeQqfX1RYOo3qOK7j.woff" crossorigin="" /><link rel="preload" as="font" type="font/woff2" href="fonts/sourcesanspro/v21/6xKydSBYKcSV-LCoeQqfX1RYOo3ig4vwlxdo.woff" crossorigin="" /><link rel="stylesheet" type="text/css" href="/FB83D299FBEEA5A78AE4F9339AED3650__120552.css" />   <script type="text/javascript" src="/6A9D4F5D45D37D7024F2082BF6C1F772__11eb84.js"></script>  <script> /* Opt out handler */ var gaPropertyLgcy = 'UA-277689-1'; var gaDisableLgcy = 'ga-disable-' + gaPropertyLgcy; var gaProperty = 'G-6QM2EKL8PV'; var gaDisable = 'ga-disable-' + gaProperty; if (document.cookie.indexOf(gaDisableLgcy + '=true') > -1) { window[gaDisable] = true; } function gaOptout() { document.cookie = gaDisableLgcy + '=true; expires=Thu, 31 Dec 2099 23:59:59 UTC; domain=tec-it.com; path=/'; window[gaDisable] = true; } </script> <script> /* GTag initialization */ window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'G-6QM2EKL8PV'); /* GTag loading */ function ClientLoadGoogleTag() { var _gts=document.createElement("script"); _gts.setAttribute("src", "https://www.googletagmanager.com/gtag/js?id=G-6QM2EKL8PV"); _gts.setAttribute("async", true); var _scn=document.getElementsByTagName("script")[0]; _scn.parentNode.insertBefore(_gts, _scn); /* Clarity Tag */ ( function(c,l,a,r,i,t,y){ c[a]=c[a]||function(){ (c[a].q=c[a].q||[]).push(arguments)}; t=l.createElement(r); t.async=1; t.src="https://www.clarity.ms/tag/"+i; y=l.getElementsByTagName(r)[0]; y.parentNode.insertBefore(t,y);} ) (window, document, "clarity", "script", "ouqrz2i6cm"); } var gaAccepted = typeof (hasAcceptedCookieConsent) !== 'undefined' && hasAcceptedCookieConsent(); if (gaAccepted) ClientLoadGoogleTag(); var cookiesAcceptedCallbacks = cookiesAcceptedCallbacks || new Array(); cookiesAcceptedCallbacks.push(function() { ClientLoadGoogleTag(); }); </script><meta name="copyright" content="TEC-IT Datenverarbeitung GmbH (c) 2024" /><meta name="DESCRIPTION" content="Scan-IT to Office FAQ: Answers to common questions and issues for this cloud-based barcode scanner. " /><meta name="KEYWORDS" content="Scan-IT to Office, ScanITtoOffice, FAQ, Frequently Asked Questions, Question, Problem, Issue, Answer, Solution, Work Around, Workaround" /><meta name="date" content="2024-08-02" /><meta name="REVISIT-AFTER" content="7 days" /><meta name="ROBOTS" content="all,NOODP" /><link rel="canonical" href="/en/support/faq/mobile-daq/scan-it-to-office/Default.aspx" /><meta property="og:site_name" content="TEC-IT" /><meta property="og:type" content="article" /><meta property="og:url" content="https://www.tec-it.com/en/support/faq/mobile-daq/scan-it-to-office/Default.aspx" /><meta property="og:title" content="Scan-IT to Office FAQ, Frequently Asked Questions " /><meta property="og:description" content="Scan-IT to Office FAQ: Answers to common questions and issues for this cloud-based barcode scanner. " /><link rel="apple-touch-icon" sizes="180x180" href="https://www.tec-it.com/images/favicon/apple-touch-icon.png" /><link rel="icon" type="image/png" href="https://www.tec-it.com/images/favicon/favicon-32x32.png" sizes="32x32" /><link rel="icon" type="image/png" href="https://www.tec-it.com/images/favicon/favicon-16x16.png" sizes="16x16" /><link rel="manifest" href="https://www.tec-it.com/manifest.json" /><link rel="mask-icon" href="https://www.tec-it.com/images/favicon/safari-pinned-tab.svg" color="#be202e" /><link rel="shortcut icon" href="https://www.tec-it.com/images/favicon/favicon.ico" /><link name="msapplication-config" href="https://www.tec-it.com/browserconfig.xml" /><link name="theme-color" content="#253e86" /><link rel="alternate" type="application/rss+xml" title="Barcode Software RSS Feeds" href="//www.tec-it.com/en/rss/RSS-2.0.aspx" /></head> <body class="en">  <form name="aspnetForm" method="post" action="./Default.aspx?nav-path=en%2fsupport%2ffaq%2fmobile-daq%2fscan-it-to-office%2f" id="aspnetForm"> <div> <input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKLTg5MjE0NjgxNmRkF4CHf+IWjD279jyt33aAE0QZQV4EOdSGquRFysbffSM=" /> </div> <div> <input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="CA0B0334" /> </div> <div class="container"> <header> <div id="preHeader" class="block-full clearfix"> <div id="ctl00_MenuShortLinks" class="linksBar"> <a id="ctl00_MenuBarcodes" title="Free Online Barcode Generator" href="//barcode.tec-it.com/en" target="_blank">Barcode Generator</a> <a id="ctl00_MenuOnlineLabelPrinting" title="Free Barcode Label Generator" href="//label.tec-it.com/en" target="_blank">Online Label Printing</a> <a id="ctl00_MenuVDA4902" title="Online VDA-4902 Label Generator" href="//label.tec-it.com/en/Group/VDA" target="_blank">VDA-4902</a> <a id="ctl00_MenuShippingLabels" title="Free Online Shipping Label Generator" href="//label.tec-it.com/en" target="_blank">Shipping Labels</a> <a id="ctl00_MenuBusinessCards" title="Free Online Business Cards with 2D Codes (QR Code, Data Matrix)" href="//businesscards.tec-it.com/en" target="_blank">QR Code Business Cards</a> </div> <div class="utilityBar"> <a id="ctl00_LinkContactIcon" title="Contact" class="contact" href="/en/company/contact/Default.aspx" target="_self">  <svg x="0px" width="15px" height="15px" viewBox="0 0 15 15" enable-background="new 0 0 15 15" xmlns:xlink="http://www.w3.org/1999/xlink" y="0px" xmlns="http://www.w3.org/2000/svg" version="1.1"> <g> <path fill="#808080" d="M12.617,13.299l-1.548-2.862c-0.171-0.314-0.564-0.433-0.88-0.263l-1.387,0.725 c0,0-1.558,0.921-3.144-2.012C4.073,5.953,5.474,4.74,5.474,4.74l1.421-0.703c0.316-0.169,0.435-0.52,0.264-0.834L5.612,0.341 c-0.17-0.315-0.564-0.433-0.88-0.263l-1.378,0.74c0,0-2.765,2.491,0.687,8.875c3.452,6.386,6.935,5.225,6.935,5.225l1.379-0.741 C12.669,14.007,12.787,13.614,12.617,13.299z"/> </g> </svg></a> <a id="ctl00_LinkEmailIcon" title="Email" class="mail" href="https://www.tec-it.com/en/company/contact/onlineform/Default.aspx" target="_self">  <svg x="0px" width="15px" height="15px" viewBox="0 0 15 15" enable-background="new 0 0 15 15" xmlns:xlink="http://www.w3.org/1999/xlink" y="0px" xmlns="http://www.w3.org/2000/svg" version="1.1"> <g> <polygon fill="#808080" points="7.502,7.624 15,4.058 15,2.5 0,2.5 0,4.009 "/> <polygon fill="#808080" points="7.498,9.286 0,5.675 0,12.5 15,12.5 15,5.72 "/> </g> </svg></a> <ul id="ListLanguages" class="styled-list languageList"><li><a href="/de/support/faq/mobile-daq/scan-it-to-office/Default.aspx" title="Deutsch"><span>de</span></a></li><li><a href="/en/support/faq/mobile-daq/scan-it-to-office/Default.aspx" title="English" class="selected"><span>en</span></a></li><li><a href="/es/support/faq/mobile-daq/scan-it-to-office/Default.aspx" title="Español"><span>es</span></a></li><li><a href="/fr/support/faq/mobile-daq/scan-it-to-office/Default.aspx" title="Français"><span>fr</span></a></li><li><a href="/it/support/faq/mobile-daq/scan-it-to-office/Default.aspx" title="Italiano"><span>it</span></a></li><li><a href="/ru/support/faq/mobile-daq/scan-it-to-office/Default.aspx" title="Русский"><span>ru</span></a></li><li><a href="/zh-cn/support/faq/mobile-daq/scan-it-to-office/Default.aspx" title="中文"><span>zh-cn</span></a></li></ul> </div> </div>  <div id="logo-pane" class="block-3 no-mar"> <div class="block-1 block-h-1"></div> <div class="block-2 block-h-1"> <a id="ctl00_LinkHome" title="Barcode Software and More..." href="/en/start/Default.aspx" target="_self"></a> </div> </div> <ul id="MainMenu" class="link-list block-6 no-mar styled-list primary-menu"><li class="link-list-item block-1 _no-mar block-h-1 bg-color-menu"><a href="/en/software/Default.aspx" target="_self"><span>Software</span></a><ul class="sub-menu styled-list"><li><div><div class="alt-text">Software and Apps</div><div class="column"><p class="icon" style="background-image: url('pics/menu/barcode-software.png')"><a href="/en/software/barcode-software/Default.aspx" target="_self"><span>Barcode Software, QR/2D</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/software/barcode-software/barcode-creator/barcode-studio/Default.aspx" target="_self"><span>Barcode Studio</span></a></li><li class="icon"><a href="/en/software/barcode-software/office/word-excel/Default.aspx" target="_self"><span>TBarCode Office</span></a></li><li class="icon"><a href="/en/software/barcode-software/tbarcode/overview/Default.aspx" target="_self"><span>TBarCode SDK</span></a></li><li class="icon"><a href="/en/software/barcode-software/barcode-linux-unix-mac-os-x/overview/Default.aspx" target="_self"><span>TBarCode/X</span></a></li></ul><p class="icon" style="background-image: url('pics/menu/barcode-software-sap.png')"><a href="/en/software/sap/Default.aspx" target="_self"><span>Barcode Software - SAP</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/software/sap/barcode-dll/general/Default.aspx" target="_self"><span>SAP Barcode DLL</span></a></li><li class="icon"><a href="/en/software/sap/barcode-direct/general/Default.aspx" target="_self"><span>TBarCode/Direct</span></a></li><li class="icon"><a href="/en/software/barcode-software/barcode-linux-unix-mac-os-x/overview/Default.aspx" target="_self"><span>TBarCode/X</span></a></li><li class="icon"><a href="/en/software/sap/seh300/barcode-server/Default.aspx" target="_self"><span>TBarCode/Embedded</span></a></li></ul><p class="icon" style="background-image: url('pics/menu/label-software.png')"><a href="/en/software/label-printing/Default.aspx" target="_self"><span>Label Software</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/software/label-printing/label-software/tformer/Default.aspx" target="_self"><span>TFORMer Designer</span></a></li><li class="icon"><a href="/en/software/label-printing/label-software/labeling-sdk/Default.aspx" target="_self"><span>TFORMer SDK</span></a></li></ul><p class="icon" style="background-image: url('pics/menu/report-generator.png')"><a href="/en/software/report-generator/Default.aspx" target="_self"><span>Reporting Software</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/software/report-generator/report-designer/tformer-designer/Default.aspx" target="_self"><span>TFORMer Designer</span></a></li><li class="icon"><a href="/en/software/report-generator/reporting-component/tformer-runtime/Default.aspx" target="_self"><span>TFORMer SDK</span></a></li></ul></div><div class="column"><p class="icon" style="background-image: url('pics/menu/data-acquisition.png')"><a href="/en/software/data-acquisition/Default.aspx" target="_self"><span>Data Acquisition</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/software/data-acquisition/twedge/keyboard-wedge/Default.aspx" target="_self"><span>TWedge</span></a></li><li class="icon"><a href="/en/software/data-acquisition/Event_Check-In/overview/Default.aspx" target="_self"><span>BlueBooking</span></a></li><li class="icon"><a href="/en/software/data-acquisition/tconnector/activex/Default.aspx" target="_self"><span>TConnector</span></a></li><li class="icon"><a href="/en/software/data-acquisition/twedgece/pocket-pc/Default.aspx" target="_self"><span>TWedgeCE</span></a></li></ul><p class="icon" style="background-image: url('pics/menu/android.png')"><a href="/en/software/mobile-data-acquisition/Default.aspx" target="_self"><span>Mobile Data Acquisition</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/software/mobile-data-acquisition/scan-it-to-office/overview/Default.aspx" target="_self"><span>Scan-IT to Office</span></a></li><li class="icon"><a href="/en/software/mobile-data-acquisition/barcode-keyboard/barcodekeyboard-overview/Default.aspx" target="_self"><span>Scanner Keyboard</span></a></li><li class="icon"><a href="/en/software/mobile-data-acquisition/rapid-inventory/overview/Default.aspx" target="_self"><span>Rapid Inventory</span></a></li><li class="icon"><a href="/en/software/mobile-data-acquisition/wireless-barcode-scanner/overview/Default.aspx" target="_self"><span>Wireless Barcode Scanner</span></a></li><li class="icon"><a href="/en/software/mobile-data-acquisition/getblue/android-smartphone/Default.aspx" target="_self"><span>GetBlue</span></a></li><li class="icon"><a href="/en/software/mobile-data-acquisition/bluepiano/keyboard-wedge/Default.aspx" target="_self"><span>BluePiano</span></a></li></ul></div><div class="column"><p class="icon" style="background-image: url('pics/menu/free-tools.png')"><a href="/en/software/online/Default.aspx" target="_self"><span>Online Tools</span></a></p><ul class="styled-list"><li class="icon"><a href="//qrcode.tec-it.com/en" target="_blank"><span>QR Code Generator</span></a></li><li class="icon"><a href="//barcode.tec-it.com/en" target="_blank"><span>Barcode Generator</span></a></li><li class="icon"><a href="//label.tec-it.com/en/Group/VDA" target="_blank"><span>VDA 4902 Labels</span></a></li><li class="icon"><a href="//label.tec-it.com/en" target="_blank"><span>Shipping Labels</span></a></li><li class="icon"><a href="//label.tec-it.com/en" target="_blank"><span>Barcode Labels</span></a></li><li class="icon"><a href="//businesscards.tec-it.com/en" target="_blank"><span>QR Code Business Cards</span></a></li></ul></div></div></li></ul></li><li class="link-list-item block-1 _no-mar block-h-1 bg-color-menu"><a href="/en/download/Default.aspx" target="_self"><span>Download</span></a><ul class="sub-menu styled-list"><li><div><div class="alt-text">Software Downloads</div><div class="column"><p class="icon" style="background-image: url('pics/menu/barcode-studio.png?v0.1')"><a href="/en/download/barcode-studio/Default.aspx" target="_self"><span>Barcode Studio</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/download/barcode-studio/windows/Download.aspx" target="_self"><span>For Windows</span></a></li><li class="icon"><a href="/en/download/barcode-studio/mac-os-x/Download.aspx" target="_self"><span>For macOS</span></a></li><li class="icon"><a href="/en/download/barcode-studio/unix-linux-mac-os-x/Download.aspx" target="_self"><span>For Linux</span></a></li></ul><p class="icon" style="background-image: url('pics/menu/tbarcode-office.png?v0.1')"><a href="/en/download/tbarcode-office/Download.aspx" target="_self"><span>TBarCode Office</span></a></p><p class="icon" style="background-image: url('pics/menu/tbarcode-sdk.png?v0.1')"><a href="/en/download/tbarcode/Download.aspx" target="_self"><span>TBarCode SDK</span></a></p><p class="icon" style="background-image: url('pics/menu/tbarcode-x.png')"><a href="/en/download/tbarcodex/Default.aspx" target="_self"><span>TBarCode/X</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/download/tbarcodex/linux/Download.aspx" target="_self"><span>Linux</span></a></li><li class="icon"><a href="/en/download/tbarcodex/unix-linux/Download.aspx" target="_self"><span>UNIX</span></a></li><li class="icon"><a href="/en/download/tbarcodex/mac-os/Download.aspx" target="_self"><span>macOS</span></a></li></ul><p class="icon" style="background-image: url('pics/menu/barcode-software-sap.png')"><a href="/en/download/sap/Download.aspx" target="_self"><span>TBarCode/SAPwin</span></a></p><p class="icon" style="background-image: url('pics/menu/tformer.png')"><a href="/en/download/tformer/Default.aspx" target="_self"><span>TFORMer</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/download/tformer/windows/Download.aspx" target="_self"><span>Windows</span></a></li><li class="icon"><a href="/en/download/tformer/unix-linux-mac-os/Download.aspx" target="_self"><span>UNIX, Linux, Mac OS X</span></a></li></ul></div><div class="column"><p class="icon" style="background-image: url('pics/menu/data-acquisition.png')"><a href="/en/download/data-acquisition/Default.aspx" target="_self"><span>Data Acquisition</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/download/data-acquisition/twedge/Download.aspx" target="_self"><span>TWedge</span></a></li><li class="icon"><a href="/en/download/data-acquisition/bluebooking/Download.aspx" target="_self"><span>BlueBooking</span></a></li><li class="icon"><a href="/en/download/data-acquisition/tconnector/Download.aspx" target="_self"><span>TConnector</span></a></li><li class="icon"><a href="/en/download/data-acquisition/twedgece/Download.aspx" target="_self"><span>TWedgeCE</span></a></li></ul><p class="icon" style="background-image: url('pics/menu/android.png')"><a href="/en/download/mobile-data-acquisition/Default.aspx" target="_self"><span>Mobile Data Acquisition</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/download/mobile-data-acquisition/barcode-keyboard/Download.aspx" target="_self"><span>Scanner Keyboard</span></a></li><li class="icon"><a href="/en/download/mobile-data-acquisition/scan-it-to-office/Download.aspx" target="_self"><span>Scan-IT to Office</span></a></li><li class="icon"><a href="/en/download/mobile-data-acquisition/rapid-inventory/Download.aspx" target="_self"><span>Rapid Inventory</span></a></li><li class="icon"><a href="/en/download/mobile-data-acquisition/wireless-barcode-scanner/Download.aspx" target="_self"><span>Wireless Barcode Scanner</span></a></li><li class="icon"><a href="/en/download/mobile-data-acquisition/getblue/Download.aspx" target="_self"><span>GetBlue</span></a></li><li class="icon"><a href="/en/download/mobile-data-acquisition/bluepiano/Download.aspx" target="_self"><span>BluePiano</span></a></li></ul><p class="icon" style="background-image: url('pics/menu/free-tools.png')"><a href="/en/download/free-software/Default.aspx" target="_self"><span>Freeware</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/download/free-software/qrcode-studio/Download.aspx" target="_self"><span>QR-Code Studio</span></a></li></ul></div></div></li></ul></li><li class="link-list-item block-1 _no-mar block-h-1 bg-color-menu"><a href="/en/order/Default.aspx" target="_self"><span>Order</span></a><ul class="sub-menu styled-list"><li><div><div class="alt-text">Buy Software</div><div class="column"><p class="icon" style="background-image: url('pics/menu/online-order.png')"><a href="https://www.tec-it.com/en/order/orderform/OrderForm.aspx" target="_self"><span>Online Order</span></a></p><p class="icon" style="background-image: url('pics/menu/prices.png')"><a href="/en/order/prices/PriceList.aspx" target="_self"><span>Prices</span></a></p><p class="icon" style="background-image: url('pics/menu/faqs.png')"><a href="/en/order/faq/how-to-order/Default.aspx" target="_self"><span>FAQs</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/order/faq/how-to-order/Default.aspx" target="_self"><span>Ordering</span></a></li><li class="icon"><a href="/en/order/faq/licenses/Default.aspx" target="_self"><span>License Types</span></a></li><li class="icon"><a href="/en/order/faq/update/Default.aspx" target="_self"><span>Updates</span></a></li><li class="icon"><a href="/en/order/faq/upgrade/Default.aspx" target="_self"><span>Upgrades</span></a></li></ul><p class="icon" style="background-image: url('pics/menu/license-terms.png')"><a href="/download/PDF/LicTerms_EN.pdf" target="_blank"><span>License Terms (PDF)</span></a></p></div></div></li></ul></li><li class="link-list-item block-1 _no-mar block-h-1 bg-color-menu"><a href="/en/support/Default.aspx" target="_self" class="selected"><span>Support</span></a><ul class="sub-menu styled-list"><li><div><div class="alt-text">Let Us Help You</div><div class="column"><p class="icon" style="background-image: url('pics/menu/faqs.png')"><a href="/en/support/faq/Default.aspx" target="_self"><span>FAQs</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/order/faq/how-to-order/Default.aspx" target="_self"><span>Ordering</span></a></li><li class="icon"><a href="/en/support/faq/licensing/Default.aspx" target="_self"><span>Licensing</span></a></li><li class="icon"><a href="/en/support/faq/barcode/bar-code-config/Default.aspx" target="_self"><span>Barcodes</span></a></li><li class="icon"><a href="/en/support/faq/barcode-studio/Default.aspx" target="_self"><span>Barcode Studio</span></a></li><li class="icon"><a href="/en/support/faq/tbarcode/barcode-ocx/Default.aspx" target="_self"><span>TBarCode SDK</span></a></li><li class="icon"><a href="/en/support/faq/tbarcode-office/tbarcode-office-installation/Default.aspx" target="_self"><span>TBarCode Office</span></a></li><li class="icon"><a href="/en/support/faq/tbarcodex/Default.aspx" target="_self"><span>TBarCode/X</span></a></li><li class="icon"><a href="/en/support/faq/tformer/designer/Default.aspx" target="_self"><span>TFORMer</span></a></li><li class="icon"><a href="/en/support/faq/sap/barcode-dll/Default.aspx" target="_self"><span>Software for SAP</span></a></li><li class="icon"><a href="/en/support/faq/daq/twedge/Default.aspx" target="_self"><span>Data Acquisition</span></a></li><li class="icon"><a href="/en/support/faq/mobile-daq/scan-it-to-office/Default.aspx" target="_self"><span>Mobile Data Acquisition</span></a></li></ul></div><div class="column"><p class="icon" style="background-image: url('pics/menu/help-me.png')"><a href="/en/company/contact/onlineform/Default.aspx" target="_self"><span>Help Me!</span></a></p><p class="icon" style="background-image: url('pics/menu/knowledge-base.png')"><a href="/en/support/knowbase/Default.aspx" target="_self"><span>Knowledge-Base</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/support/knowbase/barcode-overview/linear/Default.aspx" target="_self"><span>Barcode Overview</span></a></li><li class="icon"><a href="/en/support/knowbase/symbologies/qrcode/Default.aspx" target="_self"><span>Barcode Symbologies</span></a></li><li class="icon"><a href="/en/support/knowbase/gs1-application-identifier/Default.aspx" target="_self"><span>GS1 Application Identifier</span></a></li></ul><p class="icon" style="background-image: url('pics/menu/links.png')"><a href="/en/support/links/Default.aspx" target="_self"><span>Links</span></a></p><p class="icon" style="background-image: url('pics/menu/protected-area.png')"><a href="/en/support/customer/Default.aspx" target="_self"><span>Protected Area</span></a></p></div></div></li></ul></li><li class="link-list-item block-1 _no-mar block-h-1 bg-color-menu"><a href="/en/service/Default.aspx" target="_self"><span>Service</span></a><ul class="sub-menu styled-list"><li><div><div class="alt-text">More Benefits</div><div class="column"><p class="icon" style="background-image: url('pics/menu/software-development.png')"><a href="/en/service/development/Default.aspx" target="_self"><span>Software and Apps</span></a></p><p class="icon" style="background-image: url('pics/menu/web-solutions.png')"><a href="/en/service/web/Default.aspx" target="_self"><span>Web and Cloud</span></a></p><p class="icon" style="background-image: url('pics/menu/training-courses.png')"><a href="/en/service/schulung/Default.aspx" target="_self"><span>Training Courses</span></a></p><p class="icon" style="background-image: url('pics/menu/sap-consulting.png')"><a href="/en/service/consulting/Default.aspx" target="_self"><span>SAP Consulting</span></a></p></div></div></li></ul></li><li class="link-list-item block-1 _no-mar block-h-1 bg-color-menu"><a href="/en/company/Default.aspx" target="_self"><span>About Us</span></a><ul class="sub-menu styled-list"><li><div><div class="alt-text">About Us</div><div class="column"><p class="icon" style="background-image: url('pics/menu/contact.png')"><a href="/en/company/contact/Default.aspx" target="_self"><span>Contact</span></a></p><ul class="styled-list"><li class="icon"><a href="https://www.tec-it.com/en/company/contact/onlineform/Default.aspx" target="_self"><span>Online Inquiry</span></a></li><li class="icon"><a href="/en/company/contact/map/Default.aspx" target="_self"><span>Map</span></a></li></ul><p class="icon" style="background-image: url('pics/menu/reference.png')"><a href="/en/company/references/success/Default.aspx" target="_self"><span>References</span></a></p><ul class="styled-list"><li class="icon"><a href="/en/company/references/success/Default.aspx" target="_self"><span>Success Stories</span></a></li><li class="icon"><a href="/en/company/references/barcode/Default.aspx" target="_self"><span>Standard Software</span></a></li></ul><p class="icon" style="background-image: url('pics/menu/reseller.png')"><a href="/en/company/resellers/Default.aspx" target="_self"><span>Resellers</span></a></p><p class="icon" style="background-image: url('pics/menu/integrators.png')"><a href="/en/company/integrators/Default.aspx" target="_self"><span>Integrators</span></a></p><p class="icon" style="background-image: url('pics/menu/partner.png')"><a href="/en/company/partners/Default.aspx" target="_self"><span>Partners</span></a></p><p class="icon" style="background-image: url('pics/menu/link-tecit.png')"><a href="/en/company/linktous/Default.aspx" target="_self"><span>Link to TEC-IT</span></a></p></div><div class="column"><p class="icon" style="background-image: url('pics/menu/jobs.png')"><a href="/en/company/jobs/Default.aspx" target="_self"><span>Jobs</span></a></p><p class="icon" style="background-image: url('pics/menu/agb.png')"><a href="/en/company/agb/Default.aspx" target="_self"><span>Legal Terms</span></a></p><p class="icon" style="background-image: url('pics/menu/impressum.png')"><a href="/en/company/impressum/Default.aspx" target="_self"><span>Imprint</span></a></p></div></div></li></ul></li></ul> <div class="clear anti-mar"> </div> <div id="logo-pane-small" class="clearfix block-full"> <div class="logo"><a href="/"></a></div> <div class="homeWrapper"> <a href="/"></a> <div class="primary-menu-select"> <div class="styled-select"> <select size="1" name="ctl00$SelectMainMenu" id="ctl00_SelectMainMenu" onchange="if(this.value!=''){document.location.href=this.value}"> <option value="/en/start/Default.aspx">OVERVIEW</option> <option value="/en/software/Default.aspx">SOFTWARE</option> <option value="/en/software/barcode-software/Default.aspx">- Barcode Software, QR/2D</option> <option value="/en/software/sap/Default.aspx">- Barcode Software - SAP</option> <option value="/en/software/label-printing/Default.aspx">- Label Software</option> <option value="/en/software/report-generator/Default.aspx">- Reporting Software</option> <option value="/en/software/data-acquisition/Default.aspx">- Data Acquisition</option> <option value="/en/software/mobile-data-acquisition/Default.aspx">- Mobile Data Acquisition</option> <option value="/en/software/online/Default.aspx">- Online Tools</option> <option value="/en/download/Default.aspx">DOWNLOAD</option> <option value="/en/download/barcode-studio/Default.aspx">- Barcode Studio</option> <option value="/en/download/tbarcode-office/Download.aspx">- TBarCode Office</option> <option value="/en/download/tbarcode/Download.aspx">- TBarCode SDK</option> <option value="/en/download/tbarcodex/Default.aspx">- TBarCode/X</option> <option value="/en/download/sap/Download.aspx">- TBarCode/SAPwin</option> <option value="/en/download/tformer/Default.aspx">- TFORMer</option> <option value="/en/download/data-acquisition/Default.aspx">- Data Acquisition</option> <option value="/en/download/mobile-data-acquisition/Default.aspx">- Mobile Data Acquisition</option> <option value="/en/download/free-software/Default.aspx">- Freeware</option> <option value="/en/order/Default.aspx">ORDER</option> <option value="https://www.tec-it.com/en/order/orderform/OrderForm.aspx">- Online Order</option> <option value="/en/order/prices/PriceList.aspx">- Prices</option> <option value="/en/order/faq/how-to-order/Default.aspx">- FAQs</option> <option value="/download/PDF/LicTerms_EN.pdf">- License Terms (PDF)</option> <option value="/en/support/Default.aspx">SUPPORT</option> <option selected="selected" value="/en/support/faq/Default.aspx">- FAQs</option> <option value="/en/company/contact/onlineform/Default.aspx">- Help Me!</option> <option value="/en/support/knowbase/Default.aspx">- Knowledge-Base</option> <option value="/en/support/links/Default.aspx">- Links</option> <option value="/en/support/customer/Default.aspx">- Protected Area</option> <option value="/en/service/Default.aspx">SERVICE</option> <option value="/en/service/development/Default.aspx">- Software and Apps</option> <option value="/en/service/web/Default.aspx">- Web and Cloud</option> <option value="/en/service/schulung/Default.aspx">- Training Courses</option> <option value="/en/service/consulting/Default.aspx">- SAP Consulting</option> <option value="/en/company/Default.aspx">ABOUT US</option> <option value="/en/company/contact/Default.aspx">- Contact</option> <option value="/en/company/references/success/Default.aspx">- References</option> <option value="/en/company/resellers/Default.aspx">- Resellers</option> <option value="/en/company/integrators/Default.aspx">- Integrators</option> <option value="/en/company/partners/Default.aspx">- Partners</option> <option value="/en/company/linktous/Default.aspx">- Link to TEC-IT</option> <option value="/en/company/jobs/Default.aspx">- Jobs</option> <option value="/en/company/agb/Default.aspx">- Legal Terms</option> <option value="/en/company/impressum/Default.aspx">- Imprint</option> </select> </div> </div> </div> </div> <div class="block-full nav-path"> <ul id="SiteMapPath1" class="styled-list"><li><a href="/en/start/Default.aspx" title="Home..." target="_self"><span>Home</span></a></li><li><a href="/en/support/Default.aspx" title="Support, FAQ, Barcode Overview, Links, Tips and Tricks" target="_self"><span>Support</span></a></li><li><a href="/en/support/faq/Default.aspx" title="Questions, problems? Check out the FAQ!" target="_self"><span>FAQs</span></a></li><li><a href="/en/support/faq/mobile-daq/scan-it-to-office/Default.aspx" title="FAQ about Scan-IT to Office..." target="_self"><span>Mobile Data Acquisition</span></a></li><li><a href="/en/support/faq/mobile-daq/scan-it-to-office/Default.aspx" title="FAQ Scan-IT to Office" target="_self"><span>Scan-IT to Office</span></a></li></ul> </div> </header>  <div class="clear anti-mar" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:custom="customNS"> </div><div class="block-full bg-color-main content-without-sidebar" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:custom="customNS"><div class="inbetween"><div class="block-inner"><div id="Title" class="Title _none_A"><a id="109810" name="109810"></a><div class="tbl-bottom"><div class="tbl-td has-image"><img src="pics/data-acquisition/scan-it-to-office/icon_sto_45px.png" alt="" /></div><div class="tbl-td has-image"><h1 class="page-h1">Scan-IT to Office FAQ </h1></div></div><div class="clear page-h1-divider"></div><div id="PageLinks" class="Title"><a href="/en/support/faq/mobile-daq/scan-it-to-office/Default.aspx" title="FAQ Scan-IT to Office" target="_self" class="selected header">Scan-IT to Office</a><a href="/en/support/faq/mobile-daq/scanner-keyboard/Default.aspx" title="FAQ Scanner Keyboard" target="_self" class=" header">Scanner Keyboard</a></div><div class="clear"></div><div class="subtitle"> <ul class="directory "><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#111954">App: Will Data Be Lost Without an Internet / Add-In Connection?</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#112050">App: How to Activate a Bulk License</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#112209">App: Auto-Import License and/or Settings File</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#111784">App: How to Upload Customer Specific Forms</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#109967">App: How to Upload Customer Specific Forms via File Sharing (iOS)</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#111835">App: Import/Export Custom Forms on Android</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#111749">App: OCR Scanner Won’t Start – Error: 'Failure, try again in a few minutes'</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#110464">App: How to Cancel, Pause or Change a Subscription</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#110321">App: How to Connect Multiple Add-Ins?</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#109809">App: How Can I Use the Zebra TC57 Built-In Scanner?</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#111666">How to Send Form Data to Different Sheets</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#111955">Office Add-In: Data Can’t Be Sent to Word or Excel Document</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#109932">Office Add-In: All Scanned Data Is Inserted into the Same Cell</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#112350">Office Add-In: How to Use Developer Mode </a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#109933">Office Add-In: Image Support Is Not Available</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#110511">Office Add-In: Unsupported Server Location on Android Devices</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#110035">Office Add-In (macOS): Can’t Send Barcode Data…</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#110033">Office Add-In: Is Displayed Incompletely</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#110222">Office Add-In: Does Not Work Because of Disabled JavaScript</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#109820">Office Add-In: Does Not Work Because of an App Error</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#109935">Office Add-In: Settings Are Not Saved</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#110030">Office Add-In: Find Value in Another Column or Sheet in Excel</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#110275">Google Sheets Add-On: Can’t Insert Data Because of Authorization Error</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#112033">Google Sheets Add-On: Oops, Images Are Currently Not Supported</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#110759">Google Sheets Add-On: Stops Receiving Data After a Period of Time</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#112047">How to Correct the Time Stamp in Google Sheets?</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#111660">Smart Database Connector: How to Insert Images into SQL Server</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#112188">Smart Database Connector: How to Configure a 32-Bit ODBC DSN for ACCDB Databases</a></li><li><a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#111800">Smart Database Connector: Configuration Page Is Empty</a></li></ul></div></div><div class="ContentBlock post-big _none_A"><a id="110481" name="110481"></a> <hr size=""></hr><h1 class="" style="">Scan-IT to Office App</h1></div><div class="ContentBlock post-big _none_C"><a id="111954" name="111954"></a><div class="post-pic block-3 float-right img-right"><div class="block-3 zero-mar"><div class="block-inner"><img src="pics/FAQ/image_faq-sto-offline-mode_en.webp" alt="Scan-IT to Office - History" vspace="10px"></img></div></div></div> <h2 class="" style="">App: Will Data Be Lost Without an Internet / Add-In Connection?</h2> <p>Don't worry, if the connection to the Internet / Add-In is lost during data collection the data won't get lost:</p> <ul class=""> <li>If offline, captured data is stored in the <i>History</i> as <font class="red">unsent</font> (see picture).</li> <li>The app transmits this data automatically when the Internet connection is restored.</li> <li>The data is forwarded in the same order as it was captured.</li> <li>Users can also manually resend individual data records from the history or resend the complete history, if required.</li> </ul> <p>Please refer to the <a href="en/software/mobile-data-acquisition/scan-it-to-office/manual-app/Default.aspx" title="Scan-IT to Office user Manual">Scan-IT to Office User Manual</a> for further information.</p><div class="clear"></div></div><div class="ContentBlock post-big _none_C" id="DIV_LICENSE"><a id="112050" name="112050"></a><a name="LICENSE"></a> <h2 class="" style="">App: How to Activate a Bulk License</h2> <h3 class="">Requirements</h3> <p><b>Android</b> users need to download and install Scan-IT to Office from the <a href="en/download/mobile-data-acquisition/scan-it-to-office/Download.aspx" target="_blank" title="Scan-IT to Office download page">Scan-IT to Office download page</a>, or they can use the app version from Managed Google Play (the organization ID must be sent to TEC-IT). The public Google Play version will not accept activation keys.</p> <p><b>iOS</b> users can download Scan-IT to Office via our <a href="en/download/mobile-data-acquisition/scan-it-to-office/Download.aspx" target="_blank" title="Scan-IT to Office download page">Scan-IT to Office download page</a> or directly from the <a href="https://apps.apple.com/app/scan-it-to-office/id1241932661" target="_blank" title=" App Store."> App Store.</a></p> <h3 class="">Instructions</h3> <p>Please, follow the instructions on the <a href="en/support/faq/licensing/Default.aspx#BULK" title="Licensing FAQ">Licensing FAQ</a> page.</p> </div><div class="ContentBlock post-big _none_C" id="DIV_AutoImport"><a id="112209" name="112209"></a><a name="AutoImport"></a><h2 class="" style="">App: Auto-Import License and/or Settings File</h2> <p>For <b>auto-import (on multiple Android devices)</b> place the TEC-IT activation file (or license file) in one of the supported folders on the device. The app validates the license during startup (or when you open the Subscriptions view).</p> <ul class=""> <li>Scan-IT to Office 4.2.0 or later:<br />Use the external app folder <i>/sdcard/Android/data/com.tecit.android.bluescanner.office/files</i><br />(or <i>/sdcard/Android/data/com.tecit.android.bluescanner.office.moas/files</i> for the Private / Managed Google Play version).<br />Please note that this folder is not available before the first app start. For license distribution via Mobile Device Management (MDM) solution, it may be necessary to automatically create this folder.</li> <li>Scan-IT to Office prior to 4.2.0:<br />Use the download folder <i>/sdcard/Download</i></li> </ul> <p>Settings can be imported in the same way: Rename the exported settings file to <i>ScanItToOfficePrefs.xml</i> and place it in that folder. It will be automatically loaded on startup.</p> <div class="div-note">Please note:<br />Alternatively, you have the possibility to distribute activation keys and app settings via managed app configuration (MDM). In this case no files are needed. The settings are directly provided via the Device Management Software. Requires Scan-IT to Office version 4.5.0+.</div> </div><div class="ContentBlock post-big _none_C"><a id="111784" name="111784"></a> <h2 class="" style="">App: How to Upload Customer Specific Forms</h2> <p><b>Android</b></p> <ol> <li>Open the HTML Form file (eg. <kbd>MyForm.html</kbd>) on the device for example by opening the mail attachment or by opening the file in a file manager app.</li> <li>Select <kbd>Open With</kbd> -> <kbd>Scan-IT to Office</kbd></li> <li>The Form should now appear in the app in <kbd>Forms</kbd> -> <kbd>Uploaded Forms</kbd></li> </ol> <p><b>iOS</b></p> <ol> <li>Open the HTML Form file (eg. <kbd>MyForm.html</kbd>) on the device for example by opening the mail attachment or by opening the file in the <kbd>Files</kbd> app.</li> <li>Tap the <img src="pics/FAQ/image_ios-upload-button_20x24.png" alt="iOS upload button" width="20px"></img> button and select <kbd>Copy to Scan-IT</kbd></li> <li>The Form should now appear in the app in <kbd>Forms</kbd> -> <kbd>Uploaded Forms</kbd></li> </ol> <p>Alternatively you can upload the form files from your Mac to your iOS device using <kbd>File Sharing</kbd>. The next few steps show how it works:</p> <ol> <li>Open <kbd>Finder</kbd> on your Mac</li> <li>Connect your iPhone or iPad to your Mac</li> <li>Select your iOS device in <kbd>Finder</kbd></li> <li>Select the <kbd>Files</kbd> tab</li> <li>Drag and drop your form file on Scan-IT</li> <li>Restart the app on your device</li> <li>The uploaded form is now displayed in your app<br /><br /> <img src="pics/FAQ/image_sto-upload-customer-specific-form_698x428.webp" alt="Customer Specific Form Upload" vspace="10" width="698" height="428"></img></li> </ol> <div class="div-note">Note: If you are using Windows or an older version of macOS (Mojave or lower) you can find the <kbd>File Sharing</kbd> feature in <kbd>iTunes</kbd>. For further information, check out this <a href="en/support/faq/mobile-daq/scan-it-to-office/Default.aspx#iOS_UploadForm_FileSharing" title="FAQ How to Upload Customer Specific Forms on iOS Devices via File Sharing">FAQ</a> or see <a href="https://support.apple.com/en-us/HT201301" target="_blank" title="About File Sharing on iPhone, iPad, and iPod touch">Apple Support</a>.</div></div><div class="ContentBlock post-big _none_C" id="DIV_iOS_UploadForm_FileSharing"><a id="109967" name="109967"></a><a name="iOS_UploadForm_FileSharing"></a><h2 class="" style="">App: How to Upload Customer Specific Forms via File Sharing (iOS)</h2> <p>You can copy files between your computer and apps on your iOS device using <i>File Sharing</i> with Apple iTunes. The next few steps show how it works:</p> <ol> <li>Open iTunes on your Mac or PC</li> <li>Connect your iPhone or iPad to your computer </li> <li>Click your device in iTunes<br /> <img src="pics/FAQ/image_input-form-upload_device.png" alt="Input form Upload" vspace="10" width="632"></img></li> <li>In the left sidebar, click <kbd>File Sharing</kbd></li> <li>Select the <kbd>Scan-IT to Office App</kbd></li> <li>Drag and drop files from a folder in the documents list or click <kbd>Add</kbd>.</li> <li> iTunes copies these files to the app on your device</li> <li>Restart the <kbd>Scan-IT to Office App</kbd> on your device</li> <li>The uploaded custom forms are now displayed in your app<br /> <img src="pics/FAQ/Imgae_Input-form-upload2.png" alt="Input form Upload" vspace="10" width="632"></img></li> </ol> For further information about file sharing with iTunes, please check out the <a href="https://support.apple.com/en-us/HT201301" target="_blank" title="About File Sharing on iPhone, iPad, and iPod touch">Apple Support</a>.</div><div class="ContentBlock post-big _none_A"><a id="111835" name="111835"></a><h2 class="" style="">App: Import/Export Custom Forms on Android</h2> <ul class=""> <li><b>Manual import/export</b>:<br /> The App stores custom forms in an internal app directory that cannot be directly accessed via file managers (applies to versions 4.2.0+).<br /> <ul class=""> <li>To <b>import a form</b> click on an .sto file in your file manager.<br /></li> <li>To <b>export a form</b> use the share function in the Form editor or long-tap on the required form in the Form manager and select <kbd>Share</kbd>.</li> </ul> <div class="div-note">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.</div> </li> <br /> <li><b>Auto-import of old forms</b> (from an app version preceding 4.2.0):<br /> On the first start of the form manager, the app automatically recovers old forms saved with previous app versions (prior to 4.2.0).<br /> To be able to access all previously created forms without any further actions, please make sure the <kbd>Storage permission</kbd> is granted. <br /> The auto-import option may become unavailable on Android 11+ devices in future App versions. </li> </ul></div><div class="ContentBlock post-big _none_A"><a id="111749" name="111749"></a><h2 class="" style="">App: OCR Scanner Won’t Start – Error: 'Failure, try again in a few minutes'</h2> <p>Launching the OCR scanner on Android results in the following error message <i>'Failure, try again in a few minutes. If the problem persists contact support@tec-it.com'</i>.</p> <p>The error message <i>'Failure, try again in a few minutes'</i> means that the OCR library is trying to download the text detection module from the Web. Ways to fix it:</p> <ul class=""> <li>Make sure your internet connection is active.</li> <li>Wait for some time to check if the module can be loaded. Please don’t stop the app while waiting.</li> <li>Clear the data of the Google Play Services App. Here you can find the “How-To” steps (taken from the <a href="https://support.google.com/googleplay/answer/7512202?hl=en" target="_blank" title="Google Play Services App - How to Clear Cache and Data">Google Play Help</a> page): <br /><br /> <ul class="nostyle"> <li>1. Open the <kbd>Settings</kbd> of your Android device.</li> <li>2. Tap <kbd>Apps & notifications</kbd>.</li> <li>3. Open Google Play Services. If you don't see it in the list, tap <kbd>See all apps</kbd> first and then select <kbd>Google Play Services</kbd>.</li> <li>4. Tap <kbd>Storage</kbd> 🡒 <kbd>Clear cache</kbd>.</li> <li>5. Open the Google Play Store app.</li> <li>6. Wait for 5 minutes, then try your download again.</li> </ul> </li> </ul> </div><div class="ContentBlock post-big _none_C"><a id="110464" name="110464"></a><h2 class="" style="">App: How to Cancel, Pause or Change a Subscription</h2> <p>App subscriptions purchased on Google Play or App Store are auto-renewing by default. In case you want to cancel, pause or renew the subscription, follow the steps in the links below:</p> <ul class=""> <li><a href="https://support.google.com/googleplay/answer/7018481" target="_blank" title="How to Cancel, Pause or Change a Subscription for Android">Cancel, pause, or change a subscription on Google Play</a> (<a href="https://support.google.com/googleplay/answer/7018481?co=GENIE.Platform%3DDesktop&oco=1" target="_blank" title="How to Cancel, Pause or Change a Subscription for Android on a Computer">Computer</a> | <a href="https://support.google.com/googleplay/answer/7018481?co=GENIE.Platform%3DAndroid&oco=1" target="_blank" title="How to Cancel, Pause or Change a Subscription for Android on your Smartphone">Android</a>)</li> <li><a href="https://support.apple.com/en-us/HT202039" target="_blank" title="View, change, or cancel your subscriptions on iOS">View, change, or cancel your subscriptions on iOS</a></li> </ul> <p>On Android, you may cancel a subscription also from within the app: Open the Scan-IT to Office menu, tap <kbd>Buy subscription</kbd>, tap <kbd>Manage Subscription</kbd>, tap the active subscription and finally tap <kbd>Cancel subscription</kbd>.</p> </div><div class="ContentBlock post-big _none_A"><a id="110321" name="110321"></a><h2 class="" style="">App: How to Connect Multiple Add-Ins?</h2> <p>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:</p> <ul class=""> <li>Open the main menu (<img src="pics/android/wireless-barcode-scanner/icons/contextual-menu.svg" alt="Open contextual menu" width="15px"></img>) of your <i>Scan-IT to Office App</i>.</li> <li>Select <kbd>Add Connection</kbd> from the menu</li> <li>Select <kbd>Scan QR-Code</kbd> and scan the QR code<sup><span class="reg">®</span></sup> of the Add-In you want to pair <br /> (In the Add-In you can show the QR-code with the button <kbd>Add Phone</kbd> (<img src="pics/FAQ/add.svg" alt="Add Phone" width="20px"></img>) below your <kbd>Configured Phones</kbd> list)</li> <li>Repeat these steps with as many Add-Ins as you like :)</li> </ul> <div class="div-note"> All currently connected Add-Ins and their connection states, are listed in the app item <kbd>Show Connections</kbd> in the main menu (<img src="pics/android/wireless-barcode-scanner/icons/contextual-menu.svg" alt="Open contextual menu" width="15px"></img>)</div></div><div class="ContentBlock post-big _none_C"><a id="109809" name="109809"></a><h2 class="" style="">App: How Can I Use the Zebra TC57 Built-In Scanner?</h2> <p>Use the <b>DataWedge</b> tool from Zebra. It can forward the data from the barcode scanner to associated applications.</p> <p>DataWedge provides barcode scanning and processing services for Zebra devices running Android. Included with every Zebra device, DataWedge enables all apps on the device (whether stock or added later) to acquire scanned data without using scanner APIs directly.</p> <div class="div-note">Note: The DataWedge profile must be configured for Keystroke Output.</div> <p>Sample workflow:<br /></p> <ol> <li>In the Scan-IT to Office form you can use a normal text input field instead of a barcode field. </li> <li>Set the cursor into the required input field</li> <li>Scan data with the device's built-in barcode scanner</li> <li>Data from the Data Wedge will be inserted into the field.</li> </ol> <p>Related links:</p> <ul class=""> <li><a href="https://techdocs.zebra.com/datawedge/8-1/guide/gettingstarted/" target="_blank" title="Zebra DataWedge Features">Zebra DataWedge Features</a></li> <li><a href="https://www.zebra.com/us/en/support-downloads/knowledge-articles/evm/DataWedge-for-Android.html" target="_blank" title="Zebra DataWedge for Android">Zebra DataWedge for Android</a></li> </ul></div><div class="ContentBlock post-big _none_A"><a id="111667" name="111667"></a><hr size=""></hr><h1 class="" style="">Scan-IT to Office Add-Ins/Tools</h1></div><div class="ContentBlock post-big _none_C"><a id="111666" name="111666"></a><div class="post-pic block-3 float-right img-right"><div class="block-3 zero-mar"><div class="block-inner"><img src="pics/FAQ/image_faq_sto_app_form.png" alt="STO App Form" vspace="10px"></img></div></div></div> <h2 class="" style="">How to Send Form Data to Different Sheets</h2> <p>Sometimes you may want to create multiple forms and send each form to its own sheet in your spreadsheet.</p> <p>This can be solved with a Macro in Excel or with Google Apps Script in Google Sheets.<br /> By adding a Static Text field with a category identifier to your forms the Macro/Script can identify the category of the captured data and move it to the desired sheet automatically.</p> <h4 class="" style="">Scan-IT to Office APP:</h4> <ol> <li>Add two new forms or edit your existing forms and add a “Static Text” field to each form.</li> <li>Set the values of the “Static Text” fields to your desired category names <br /> (in this example we used “Cat1” and “Cat2”).</li> <li>Make sure the “Static Text” field is the first field in your forms.</li> <li>You may also want to hide the “Static Text” fields.</li> </ol> <br /><br /><br /><br /><br /><br /> <div class="post-pic block-2 float-right img-right"><div class="block-2 zero-mar"><div class="block-inner"><img src="pics/FAQ/image_faq_sto_excel_add_in.png" alt="STO Add In"></img></div></div></div> <h4 class="" style="">Microsoft Excel:</h4> <ol> <li>Download the <a href="Download/Samples/Scan-IT_Excel.zip" title="Excel Sample Spreadsheet Download">sample spreadsheet</a> and open it in Excel.</li> <li>Insert the Scan-IT to Office Add-In.</li> <li>Select “Insert after last non-empty row” in the Add-In options and make sure “ScanData” is selected.</li> <li>Open the “Categories” sheet and change the values under “Category” to match the values of the “Static Text” fields.</li> <li>If you want to rename your Sheets you also need to change the values under “Sheet” accordingly.</li> <img src="pics/FAQ/image_faq_sto_excel_values.png" alt="STO Excel Values" width="300"></img> <li>Note: Do not rename the “ScanData” sheet and the “Categories” sheet otherwise the Macro will stop working.</li> </ol> <br /><br /><br /><br /><br /><br /> <div class="post-pic block-3 float-right img-right"><div class="block-3 zero-mar"><div class="block-inner"><img src="pics/FAQ/image_faq_sto_sheets_trigger.png" alt="STO Sheets Add Trigger" vspace="10px"></img></div></div></div> <h4 class="" style="">Google Sheets: </h4> <ol> <li>Open our <a href="https://docs.google.com/spreadsheets/d/1MD20jGCMeW-6WP6Lzkzfl-B_eFB8uWIMDxxIYzJZuPA/" target="_blank" title="sample spreadsheet">sample spreadsheet</a>.</li> <li>Choose File -> Make a copy to make an editable copy of the sample.</li> <li>Open the script editor select Tools -> Script editor.</li> <li>In the script editor add a new trigger to the sheet<br /> Edit -> Current project’s triggers -> + Add Trigger<br /> Change the “Select event time” to “on change” and save the changes.</li> <li>Insert the Scan-IT to Office Add-On into the spreadsheet or connect to the “ScanData” sheet via Google Sheets (Drive) connection.</li> <li>If you are using the Add-On select "Insert after last non-empty row” in the Add-On options and make sure “ScanData” is selected.</li> <li>Open the “Categories” sheet and change the values under “Category” to match the values of the “Static Text” fields.</li> <li>If you want to rename your Sheets you also need to change the values under “Sheet” accordingly.<br /> <img src="pics/FAQ/image_faq_sto_sheets_values.png" alt="STO Sheets Value" width="300"></img> </li> <li>Note: Do not rename the “ScanData” sheet and the “Categories” sheet otherwise the Google Script will stop working.</li> </ol><div class="clear"></div></div><div class="ContentBlock post-big _none_A"><a id="111955" name="111955"></a><h2 class="" style="">Office Add-In: Data Can’t Be Sent to Word or Excel Document</h2> <p>Problem: The target document (Microsoft Office) does not receive the sent data.</p> <p>Solution: Please make sure, that all available Windows and Office updates are installed!</p> <p>Related Links:</p> <ul class=""> <li><a href="https://support.office.com/en-us/article/install-office-updates-2ab296f3-7f03-43a2-8e50-46de917611c5 " target="_blank" title="How to install Office updates">How to install Office updates</a> </li> <li>If you are using a volume license or your company is using group policies to manage Office updates: <a href="https://support.office.com/en-us/article/update-office-with-microsoft-update-f59d3f9d-bd5d-4d3b-a08e-1dd659cf5282 " target="_blank" title="Group policy to manage Office updates">Update Office with Microsoft update </a></li> </ul></div><div class="ContentBlock post-big _none_A" id="DIV_excel2013Workaround"><a id="109932" name="109932"></a><a name="excel2013Workaround"></a><h2 class="" style="">Office Add-In: All Scanned Data Is Inserted into the Same Cell</h2> <p>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. </p> <p> Solution: This feature is available for the following applications:</p> <ul class=""> <li>Microsoft Excel 2016 (or newer)</li> <li>Microsoft Excel Online</li> <li>Google Sheets</li> </ul> Workaround: You can also try to use a <i>VBA Macro</i> 🠢 see <a href="download/samples/SelectNextRowWorkaround_STO.zip" title="Download SelectNextRowWorkaround_STO.zip">sample spreadsheet</a>.<br /> <br /> <div class="div-note">When using Microsoft Office 2016, please make sure, that all available Windows and Office updates are installed!</div> Related Links: <ul class=""> <li><a href="https://support.office.com/en-us/article/install-office-updates-2ab296f3-7f03-43a2-8e50-46de917611c5 " target="_blank" title="How to Install Office Updates">How to install Microsoft Office updates</a> </li> <li>If you are using a volume license or your company is using group policies to manage Office updates: <a href="https://support.office.com/en-us/article/update-office-with-microsoft-update-f59d3f9d-bd5d-4d3b-a08e-1dd659cf5282 " target="_blank" title="Group policy to manage Office updates">Update Office with Microsoft update </a></li> </ul></div><div class="ContentBlock post-big _none_C" id="DIV_DeveloperMode"><a id="112350" name="112350"></a><a name="DeveloperMode"></a><h2 class="" style="">Office Add-In: How to Use Developer Mode </h2> <p>JavaScript action endpoints <b>under developer tools section</b> are used to customize the data acquisition logic when scanning data into Excel worksheets. With the help of JavaScript and the <b>Office-JS API</b> you are able to:</p> <ul class=""> <li>Insert data into specific worksheet fields,</li> <li>Check if a data entry is eligible for insertion,</li> <li>Perform arbitrary lookups and validations,</li> <li>Send feedback to the device, etc.</li> </ul> <p>Our <b>demo endpoints</b> show examples of how inserts can be manipulated.</p> <img src="pics/FAQ/image_faq-STO-developer-mode_924x327.png" alt="STO Add In developer mode"></img> <p>Here is how you can download <b>sample Excel sheets:</b></p> <img src="pics/FAQ/image_faq-STO-developer-mode-demo-maintenance_921x438.png" alt="STO Add In"></img> <p><b>Note:</b> The JavaScript action is triggered only if a matching action name (see "Supported Actions") is sent from the data entry form in the Scan-IT to Office app. Currently, this feature is only supported by custom forms.</p> <p><b>Debugging:</b> For <b>custom scripts</b>, use the log tab to see errors and debug with the addLogEntry function as shown in the JavaScript code section.</p> <img src="pics/FAQ/image_faq-STO-developer-mode-debugging_921x96.png" alt="STO Add In"></img> <p><b>Note:</b> Once a JS action endpoint is deleted, it cannot be recovered.</p> <p>The <b>Backup/Restore feature</b> allows you to save and load endpoint scripts and AddIn settings locally. This enables us to <b>create</b> custom JS action endpoints and share them with our users.</p> <img src="pics/FAQ/image_faq-STO-developer-mode-backup-restore_433x279.png" alt="STO Add In"></img> <p>Additionally, users can <b>backup</b> their custom JS action endpoints and <b>transfer</b> them between devices.</p> </div><div class="ContentBlock post-big _none_A"><a id="109933" name="109933"></a><h2 class="" style="">Office Add-In: Image Support Is Not Available</h2> <p>Scanned images are not transferred to Office documents. You receive the following error message: <i>Oops, unfortunately image support is not available in this Office application. Check out the FAQ for details.</i></p> <p>Solution: Image support is available for the following applications: <ul class=""> <li>Microsoft Word/Excel for Windows (2016 or later)</li> <li>Microsoft Word/Excel for Mac (15.20 or later)</li> <li>Microsoft Word Online</li> <li>Google Sheets Add-In</li> </ul> </p></div><div class="ContentBlock post-big _none_A"><a id="110511" name="110511"></a><h2 class="" style="">Office Add-In: Unsupported Server Location on Android Devices</h2> <div class="post-pic block-2 float-right img-right"><div class="block-2 zero-mar"><div class="block-inner"><img src="pics/FAQ/image_faq-sto-add-in_en.png" alt="Disable DOM Storage Error Message"></img></div></div></div> <p>If you download the <i>Scan-IT Office Add-In</i> 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: <i> Can’t open file. Sorry, Scan-IT-to-Office---Barcodescanner-for-Office.xlsx is stored in an unsupported server location.</i> </p> <p> Solution 1: Insert the Add-In directly into your Office application: <ul class=""> <li>Go to the menu bar and click <i>Insert</i></li> <li>Now choose <i>My Add-Ins</i></li> <li>Open the store and search for <i>Scan-IT to Office</i></li> <li>Click on <i>Add</i></li></ul></p> <p>Solution 2: Download the Add-In from <a href="https://store.office.com/app.aspx?assetid=WA104381026" target="_blank" title="Microsoft AppSource">Microsoft AppSource</a> on your Desktop PC or Mac. </p><div class="clear"></div></div><div class="ContentBlock post-big _none_A"><a id="110035" name="110035"></a><h2 class="" style="">Office Add-In (macOS): Can’t Send Barcode Data…</h2> <p>You receive the following error message in the <i>Scan-IT to Office App</i> if you send data to Office on Mac OS: <i>Can’t send barcode data to a Microsoft Office document. Please connect this app with Microsoft Office.</i> This error message is displayed if a connection between App and Add-In is lost or was never established.</p> <p>Solution 1: Deactivate <i>computer sleep mode</i> in the system settings under <i>Energy Saver</i> on Mac OS.</p> <p>Solution 2: Re-pair the <i>Scan-IT to Office App</i> with the <i>Scan-IT to Office Add-In</i>. Contact <a href="https://www.tec-it.com/en/company/contact/onlineform/Default.aspx" target="self" title="Contact Support">support@tec-it.com</a> in case of recurring problems. </p></div><div class="ContentBlock post-big _none_A"><a id="110033" name="110033"></a><div class="post-pic block-4 float-right img-right"><div class="block-4 zero-mar"><div class="block-inner"><img src="pics/FAQ/image_sto-internet-options.png" alt="Image FAQ"></img></div></div></div> <h2 class="" style="">Office Add-In: Is Displayed Incompletely</h2> <p>The <i>Scan-IT to Office Add-In</i> looks inactive and only displays the buttons "<i>Phones</i>", "<i>Log</i>" and "<i>Options</i>" without functionality.</p> <p>Solution: Add the Scan-IT to Office Add-In as a trusted site as follows:</p> <ul class=""> <li>Start <i>Internet Explorer</i>.</li> <li>Click on the icon <img src="pics/FAQ/image-sto-icon-settings.png" alt="Icon Settings" style="width:1em"></img> and then on <i>Internet Options</i>.</li> <li>Open the tab <i>Security</i> and then select the <i>Trusted Sites</i> zone.</li> <li>Click on the button <i>Sites</i>.</li> <li>A dialog to add new trusted sites will appear.</li> <li>Enter <a href="https://tecit-sto-office.azurewebsites.net" target="_blank" title="Scan-IT to Office on Microsoft Azure">https://tecit-sto-office.azurewebsites.net</a> in the text field and click the button <i>Add</i>.</li> <li>Close <i>Internet Explorer</i> and restart your Office application. The Add-In should now be displayed correctly.</li> </ul> <div class="div-note"> Another possible reason for this problem might be a disabled JavaScript setting. <i>See next FAQ entry.</i> </div> <div class="clear"></div></div><div class="ContentBlock post-big _none_A"><a id="110222" name="110222"></a><div class="post-pic block-4 float-right img-right"><div class="block-4 zero-mar"><div class="block-inner"><img src="pics/FAQ/image_sto-enable-javascript_4.png" alt="Enable JavaScript for Scan-IT to Office"></img></div></div></div> <h2 class="" style="">Office Add-In: Does Not Work Because of Disabled JavaScript</h2> <p>JavaScript is required to use the Scan-IT to Office Add-In. If JavaScript is disabled, you receive the following error message: <i>JavaScript is required to use this Add-In. Please check the FAQ to correct this.</i> </p> <p>Enable JavaScript by setting <kbd>Active Scripting</kbd> to <kbd>Enable</kbd> under <kbd>Security - Custom - Custom level</kbd> in your Internet Options.</p> <div class="clear"></div></div><div class="ContentBlock post-big _none_A"><a id="109820" name="109820"></a><div class="post-pic block-2 float-right img-right"><div class="block-2 zero-mar"><div class="block-inner"><img src="pics/FAQ/image_faq-sto_add-in-error_EN.png" alt="Add-In App Error"></img></div></div></div> <h2 class="" style="">Office Add-In: Does Not Work Because of an App Error</h2> <p>When you use Microsoft Office 2013 or later, you may receive the following error message: <var>APP ERROR: This app could not be started. Close this dialog to ignore the problem or click "Restart" to try again.</var> </p> <p>Solution:</p> <p>For Office 2013, first make sure that the update in the following Microsoft Knowledge Base article is installed: <a href="https://support.microsoft.com/en-us/help/2986156" target="_blank" title="Update for Office 2013 (KB2986156)">Update KB2986156 for Office 2013 </a> (May 12, 2015)</p> <p>Re-enable protected mode for Restricted Sites in Internet Explorer: </p> <ul class=""> <li>Open the Internet Explorer and click the tools button <img src="pics/FAQ/image-sto-icon-settings.png" alt="Icon Settings" style="width:1em"></img>, and then click <kbd>Internet Options</kbd>.</li> <li>Click the <kbd>Security tab</kbd>, and then select the <kbd>Restricted Sites Zone</kbd>.</li> <li>Select the <kbd>Enable Protected Mode</kbd> check box, and then click <kbd>OK</kbd>.</li> <li>Restart Internet Explorer.</li> </ul> For further information on this topic, please check out the <a href="https://support.microsoft.com/en-us/help/2761180/apps-for-office-don-t-start-if-you-disable-protected-mode-for-the-rest" target="_blank" title="Apps for Office don't start">Microsoft Support</a>.<div class="clear"></div></div><div class="ContentBlock post-big _none_C"><a id="109935" name="109935"></a><div class="post-pic block-4 float-right img-right"><div class="block-4 zero-mar"><div class="block-inner"><img src="pics/FAQ/image_sto-dom-storage-error-message_5.png" alt="DOM Storage is Not Available in Your Browser"></img></div></div></div> <h2 class="" style="">Office Add-In: Settings Are Not Saved</h2> <p>The Scan-IT to Office Add-In shows the following error message: <var>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. </var> </p> <p>Solution:</p><p> Make sure that in the Internet Properties of MS IE under <kbd>Advanced - Security</kbd> the option <kbd> Enable DOM Storage</kbd> is activated. We are not aware of any such settings for MS Edge.</p><div class="clear"></div></div><div class="ContentBlock post-big _none_A"><a id="110030" name="110030"></a><h2 class="" style="">Office Add-In: Find Value in Another Column or Sheet in Excel</h2> <p>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).</p> <p>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. </p> <p>VLOOKUP is composed as follows: </p> <div class="post-pic block- float-right img-right"><div class="block- zero-mar"><div class="block-inner"><img src="pics/FAQ/image_faq-sto-vlookup-function_V3_en.png" alt="VLOOKUP Function in Excel"></img></div></div></div> <pre style="width:50%">VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) </pre> <p>Example:</p> <ul class=""><li> =VLOOKUP(A5;ItemList!$A:$B;2)</li></ul> <p>Useful Links:</p> <ul class=""> <li><a href="download/samples/ItemLookupExcel_STO.zip" title="Download ItemLookupExcel_STO.zip">Download Microsoft Excel sample file</a></li> <li><a href="https://support.office.com/en-us/article/VLOOKUP-function-0BBC8083-26FE-4963-8AB8-93A18AD188A1" target="_blank" title="Microsoft Office support - VLOOKUP documentation">VLOOKUP documentation</a></li> </ul></div><div class="ContentBlock post-big _none_A"><a id="110275" name="110275"></a><h2 class="" style="">Google Sheets Add-On: Can’t Insert Data Because of Authorization Error</h2> <p>If a different account is logged in to Google Chrome than in Google Sheets, the add-on may not have write permissions for spreadsheets. </p> <ul class=""> <li>The following error message appears <b>when opening the add-on</b>: <br /> <var>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</var>.</li> <li>The following error message appears <b>when scanning data</b> : <br /> <var>Error on Insert: ScriptError: Authorization is required to perform that action</var>.</li> </ul> <p>Workaround: To solve this problem, please try these two possibilities:</p> <ul class=""> <li><b>Log out or change the account</b> that is logged in to the Chrome Browser.</li> <li><b>Share the spreadsheet</b> with the account logged into the Chrome Browser.</li> </ul></div><div class="ContentBlock post-big _none_A"><a id="112033" name="112033"></a><h2 class="" style="">Google Sheets Add-On: Oops, Images Are Currently Not Supported</h2> <p>To insert data into Google Sheets, Scan-IT to Office provides 2 connection types: </p> <p><b>Google Sheets (Drive): </b></p> <ul class=""> <li>Transmission of images is not supported.</li> <li>Data is written into the sheet whenever the mobile App is online (you don’t need to keep the connected sheet open).</li> <li>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.</li> </ul> <p><b>Google Sheets (Add-On): </b></p> <ul class=""> <li>Supports transmission of images.</li> <li>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.</li> </ul> <p>Solution:</p> <p>To insert images into a Google Sheet, use the Google Sheets (Add-On) connection.<br /> <a href=" en/software/mobile-data-acquisition/scan-it-to-office/manual-add-in/Default.aspx#tab-install-google-sheets" title="Download and installation instructions:">Click here for download and installation instructions</a></p></div><div class="ContentBlock post-big _none_C"><a id="110759" name="110759"></a> <h2 class="" style="">Google Sheets Add-On: Stops Receiving Data After a Period of Time</h2> <p>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. </p> <p>This issue might be caused by a functionality of Google Chrome that closes unused/inactive connections. To change the setting, please, proceed as follows:</p> <ol> <li>Open a Google Sheets document</li> <li>Open the URL <i>chrome://discards/</i> in a new browser tab </li> <li>Now search the line with the opened Google document and click on the <i>Toggle</i> button in the <i>Auto Discardable</i> column to disable this option (see the screenshot):</li><br /> <img src="pics/FAQ/faq_data-cannot-be-sent-to-google-sheet2.png" alt="Google Sheets Auto Discardable Settings" width=""></img> </ol></div><div class="ContentBlock post-big _none_C"><a id="112047" name="112047"></a><h2 class="" style="">How to Correct the Time Stamp in Google Sheets?</h2> <p>The App uses the date/time settings of the mobile device and sends data with the timestamps converted to UTC+0 time. The targets receive the UTC+0 time and convert this value to the time zone used by the system or - in case of Google Sheets - to the time zone set for the spreadsheet.</p> <p>Please check your Google spreadsheet settings:</p> <ol> <li>File</li> <li>Spreadsheet setting (set the required Locale and the time zone)</li> <li>Refresh the sheet </li> </ol></div><div class="ContentBlock post-big _none_A"><a id="111809" name="111809"></a><hr size=""></hr><h1 class="" style="">Scan-IT to Office Smart Database Connector</h1></div><div class="ContentBlock post-big _none_A"><a id="111660" name="111660"></a><h2 class="" style="">Smart Database Connector: How to Insert Images into SQL Server</h2> <p>Your requirement: <i>I want to receive images in my database</i>.</p> <p>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:</p> <ol> <li>Create two data fields: <br /> - for a <kbd>Base64 string</kbd> (nvarchar(MAX), allows nulls), e.g. ImageBase64<br /> - for <kbd>binary data</kbd> (varbinary(MAX), allows nulls), e.g. ImageBinary<br /> <br /> Here is a definition of a sample database “TestTable” in SQL Server 2005+<br /> <br /> <img src="pics/FAQ/image_faq-sto_insert-images-into-databases_en.png" alt="Insert Images into an ODBC Database" vspace="..." width="..."></img> </li> <li>Use the SQL statement <kbd>INSERT INTO</kbd> in Smart Database Connector to send image data from the app (the data field name “Image”) to the field “ImageBase64” of the database “TestTable”:<br /> <br /> INSERT INTO TestTable (Data, ImageBase64) VALUES (%Barcode%, %Image%)<br /> <br /> </li> <li>Conversion to an image can then be carried out in a TRIGGER stored procedure invoked by an INSERT event. E.g.:<br /> <pre style="width:50%">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 </pre> </li> </ol></div><div class="ContentBlock post-big _none_A"><a id="112188" name="112188"></a><h2 class="" style="">Smart Database Connector: How to Configure a 32-Bit ODBC DSN for ACCDB Databases</h2> <p>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 <var>32-bit ODBC data source</var>.</p> <ul class=""> <li>To do this, you may need to download and install the <a href="https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255" title="Download and installation instructions">Microsoft Access Database Engine 2010 Redistributable</a> (click the link). Install the 32-bit version of the redistributable; it includes accdb support.</li> <li>After installation adjust a new 32-bit ODBC DSN using this driver and use that DSN. For more information, visit Microsoft's questions page: <a href="https://answers.microsoft.com/en-us/msoffice/forum/all/where-are-the-32bit-accdb-odbc-drivers-in-windows/477bf234-c699-4c5f-a538-4fd7d2c7c333" title="Microsoft Community FAQ about ODBC drivers in Windows 10">Where are the 32bit ACCDB ODBC drivers in Windows 10?</a></li> </ul></div><div class="ContentBlock post-big _none_A"><a id="111800" name="111800"></a><h2 class="" style="">Smart Database Connector: Configuration Page Is Empty</h2> <p>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 <var>Category: Microsoft.AspNetCore.Server.Kestrel</var> - <var>System.IO.FileNotFoundException: File name: 'Microsoft.AspNetCore.Diagnostics.Abstractions'</var> when you perform a restart of the service.</p> <p>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).</p> <p>Solution:</p> <p>Delete the shadow copy of the service so that it will be recreated automatically with all DLLs needed.</p> <ol> <li>Stop the Smart Data Base Connector Service in Task Manager.</li> <li>Locate the folder: <var>C:\Windows\Temp\.net\Scan-IT to Office Tools - Smart Database Connector\</var></li> <li>There is a sub folder like <var>xngvhz1s.an0</var> (name is individual) ⇒ Delete this folder!</li> <li>Start the Smart Database Connector Service again.</li> </ol></div></div></div></div> <footer class="clearfix"> <div class="footer block-full bg-color-footer"> <div class="eat-outer-margins"> <div class="clearfix"> <div class="block-3"> <div class="block-inner">  <div id="ctl00_AboutCompany"><h3>TEC-IT Datenverarbeitung GmbH</h3> <p>TEC-IT, Austria, has been developing software for <a href="en/software/barcode-software/Default.aspx" title="Barcode Software">barcoding</a>, <a href="en/software/barcode-software/Default.aspx" title="QR Code Software">QR and 2D-codes</a>, <a href="en/software/label-printing/label-software/tformer/Default.aspx" title="Label Printing">printing</a>, <a href="en/software/label-printing/Default.aspx" title="Label Software">labeling</a>, <a href="en/software/report-generator/Default.aspx" title="Reporting Software">reporting</a> and <a href="en/software/data-acquisition/twedge/keyboard-wedge/Default.aspx" title="Data Acquisition Software">data acquisition</a> since 1996.</p> <p>Our company offers standard software like <a href="en/software/report-generator/Default.aspx" title="Label Software, Report Designer">TFORMer</a>, <a href="en/software/barcode-software/Default.aspx" title="Barcode Generator Software, QR- and 2D-Code Creation" >TBarCode</a> and <a href="en/software/barcode-software/barcode-creator/barcode-studio/Default.aspx" title="Barcode Maker Software, QR and 2D Code Maker Software">Barcode Studio</a>. The data acquisition tools <a href="en/software/data-acquisition/twedge/keyboard-wedge/Default.aspx" title="Data Acquisition Software">TWedge</a> and <a href="en/software/mobile-data-acquisition/scan-it-to-office/overview/Default.aspx" title="ScannerApp with PC, Mac, Excel, Word, Google Sheets and Database Integration">Scan-IT to Office</a>, an Android/iOS app for <a href="en/software/mobile-data-acquisition/Default.aspx" title="App for Mobile Data Collection and Barcode, QR, 2D, NFC and OCR Scanning">mobile data collection</a>, complete our portfolio. Custom solutions are available <a href="https://www.tec-it.com/en/company/contact/onlineform/Default.aspx" title="Online Inquiry Form">on request</a>.</p> <p>High quality software is what you are looking for — TEC-IT supplies this quality successfully.</p> </div>  </div> </div> <div class="block-3"> <div class="block-inner">  <div id="ctl00_ShortNews"><h3>TEC-IT News</h3><div class="news-item"> <div class="news-item-text"> <div class="date">9/10/2024</div> <div><a class="title" href="/en/start/news/Default.aspx#112281" title="TFORMer V8.8.0">TFORMer 8.8 with SVG Support and Improved User Experience</a></div> </div> </div><div class="news-item"> <div class="news-item-text"> <div class="date">8/20/2024</div> <div><a class="title" href="/en/start/news/Default.aspx#112359" title="">Personnel Changes TEC-IT</a></div> </div> </div><div class="news-item"> <div class="news-item-text"> <div class="date">7/31/2024</div> <div><a class="title" href="/en/start/news/Default.aspx#112341" title="">Scan-IT to Office 3.17.0: Developer Mode and Fresh Features!</a></div> </div> </div><div class="news-item"> <div class="news-item-text"> <div class="date">6/6/2024</div> <div><a class="title" href="/en/start/news/Default.aspx#112347" title="">Scan-IT to Office Meets CASA Requirements! </a></div> </div> </div><div class="news-item"> <div class="news-item-text"> <div class="date"></div> <div><a class="title" href="/en/start/news/Default.aspx" title="More news from TEC-IT...">More News...</a></div> </div> </div></div>  </div> </div> <div class="block-3"> <div class="block-inner">  <div id="InfoBox"><h3>Quick Links</h3><ul> <li><b>Windows</b> - <a href="en/software/barcode-software/barcode-creator/barcode-studio/Default.aspx" title="Barcode Image Creator Software">Barcode Creator</a> - <a href="en/software/barcode-software/office/word/Default.aspx" title="Barcode Add-In for Microsoft Word and Office 365">Barcode for Word</a> - <a href="en/software/barcode-software/office/excel/Default.aspx" title="Barcode Add-In for Microsoft Excel and Office 365">Barcode for Excel</a> - <a href="en/software/barcode-software/tbarcode/overview/Default.aspx" title="Barcode Generator SDK">Barcode Software (SDK)</a> - <a href="en/software/label-printing/Default.aspx" title="Barcode Label Software">Label Software</a> - <a href="en/software/report-generator/Default.aspx" title="Reporting Software">Reporting</a> - <a href="en/software/data-acquisition/Default.aspx" title="Data Acquisition Software">Data Acquisition Software</a></li> <li><b>macOS</b> - <a href="en/software/barcode-software/barcode-creator/barcode-studio/Default.aspx" title="Barcode Image Creator Software">Barcode Maker</a> - <a href="en/software/barcode-software/barcode-linux-unix-mac-os-x/overview/Default.aspx" title="Barcode Generator SDK">Barcode SDK</a></li> <li><b>Linux, UNIX</b> - <a href="en/software/barcode-software/barcode-creator/barcode-studio/Default.aspx" title="Barcode Image Creator Software">Barcode Creator</a> - <a href="en/software/barcode-software/barcode-linux-unix-mac-os-x/overview/Default.aspx" title="Barcode Generator SDK">Barcode Software (SDK)</a> - <a href="en/software/barcode-software/barcode-linux-unix-mac-os-x/overview/Default.aspx" title="Barcode Spoolfilter">Barcode Server</a></li> <li><b>SAP</b> - <a href="en/software/sap/barcode-dll/general/Default.aspx" title="SAP Barcode DLL">Barcode DLL</a> - <a href="en/software/sap/barcode-direct/general/Default.aspx" title="SAP Barcode Solution">Barcode Solution (no Middleware)</a></li> <li><b>Android</b> - <a href="en/software/mobile-data-acquisition/scan-it-to-office/overview/Default.aspx" title="Mobile Data Collection for Excel, Word, Google Sheets, Databases, Applications">Remote Data Collection for PC/Mac</a> - <a href="en/software/mobile-data-acquisition/rapid-inventory/overview/Default.aspx" title="Inventory Control and Stocktaking App">Stocktaking App</a> - <a href="en/software/mobile-data-acquisition/barcode-keyboard/barcodekeyboard-overview/Default.aspx" title="Keyboard Which Scans Barcodes, Text and NFC Tags into Apps">Scanner Keyboard</a></li> <li><b>iOS</b> - <a href="en/software/mobile-data-acquisition/scan-it-to-office/overview/Default.aspx" title="Mobile Data Collection for Excel, Word, Google Sheets, Databases, Applications">Remote Data Collection for PC/Mac</a></li> <li><b>Web Services</b> - <a href="//label.tec-it.com/en" target="_blank" title="Label Generator">Online Label Printing</a> - <a href="//barcode.tec-it.com/en" target="_blank" title="Barcode Generator">Online Barcode Generator</a> - <a href="//qrcode.tec-it.com/en" target="_blank" title="QR Code® Generator">QR Code® Generator</a></li> </ul></div>  </div> </div> </div> <div class="sub-footer-divider"> </div>  <div class="block-full sub-footer"> <div class="block-inner clearfix"> <div class="one-third sub-footer-column-1"> <span>© TEC-IT Datenverarbeitung GmbH, Austria</span> </div> <div class="one-third sub-footer-column-2"> <a class="social color-light twitter" href="https://twitter.com/tecit" target="_blank" title="Twitter">Twitter</a> <a class="social color-light facebook" href="https://www.facebook.com/TECITSoftware" target="_blank" title="Facebook">Facebook</a> <a class="social color-light linkedin" href="https://www.linkedin.com/company/tec-it" target="_blank" title="LinkedIn">LinkedIn</a> <a class="social color-light rss" href="https://www.tec-it.com/rss/RSS-2.0.aspx" target="_blank" title="RSS Feed">RSS Feed</a> <a class="social color-light youtube" href="https://www.youtube.com/user/TECITSoftware" target="_blank" title="YouTube">YouTube</a> <a href="https://eepurl.com/kTj6v" id="ctl00_LinkNewsletter" class="social color-light newsletter" target="_blank" title="Newsletter">Newsletter</a> </div> <div class="one-third last sub-footer-column-3"> <a id="ctl00_LinkSiteMap" title="TEC-IT.COM Site Map" href="/en/website/sitemap/SiteMap.aspx" target="_self">Site Map</a> | <a id="ctl00_LinkImprint" title="Click to view the imprint of our website." href="/en/company/impressum/Default.aspx" target="_self">Imprint</a> | <a id="ctl00_LinkLegal" title="Legal conditions and privacy policy for accessing this website" href="/en/website/legalconditions/Default.aspx" target="_self">Terms of Use and Privacy</a> | <a id="ctl00_LinkContact" title="How to contact and how to find us in Steyr/Austria." href="/en/company/contact/Default.aspx" target="_self">Contact</a> </div> </div> </div> </div> </div> </footer>  </div> </form>   </body> </html>