Easy & Wireless: Setup 'Scan-IT to Office' as Mobile #ScannerApp for MS Access (1)
6.3 هزار بار بازدید -
2 سال پیش
-
https://tec-it.com - This video series shows how you can use the Scan-IT to Office app to save remotely captured data directly in databases on your PC or server. The solution is straightforward to configure, works wireless, in real-time and supports all types of remotely collected data (barcodes, QR/2D codes, NFC tags, geo-locations, photos, sketches, signatures, text in images, manual inputs, timestamps, ...).
✴️ P R E R E Q U I S I T E S
To benefit from this solution, you need
➡️ the "Scan-IT to Office" app for your smartphone
➡️ and the "Smart Database Connector" software for Microsoft Windows.
✴️ I N S T A L L A T I O N
Install the Scan-IT to Office app for Android or iOS on your mobile device and the receiving software Smart Database Connector on a PC or server connected to the Internet. The Smart Database Connector saves the data recorded with the app immediately into on-premise databases of your choice. The installer is available for download on TEC-IT's website.
Once installed, manage the Smart Database Connector in the browser. The address is usually http://localhost:33333 (or 33334, 33335 - depending on available ports during installation).
On the panel to the right, you see some pre-configured databases. In this video, we use the Demo Database (Microsoft Access). It is suitable to store barcodes or QR codes scanned with the default scanner view of the app.
✴️ O P E R A T I O N
To showcase the functionality, pair the app with the database by scanning the QR code presented by the Smart Database Connector. Whenever you scan a barcode with the app, the data is transmitted via cloud services to the Smart Database Connector, saving the data in the Microsoft Access database using the configured SQL statement.
✴️ S E C U R I T Y
➡️ Your data is safe. Collected data is end-to-end encrypted before sending it over the Internet. Even TEC-IT, as the developer of the solution, is not able to decrypt the transmitted information.
➡️ The Smart Database Connector runs as a system service in the background of your PC. Data collection works even without a logged-on user.
✴️ C U S T O M I Z A B L E
The Scan-IT to Office solution supports the configuration and use of arbitrary databases and tables. The Smart Database Connector can connect to any ODBC-compatible database like Microsoft SQL Server, Microsoft Access, MySQL, ORACLE or even Microsoft Excel tables.
To use a custom database, create an ODBC System data source (for 32 bit!) on operating system level. Invoke the ODBC data source admin tool by searching for ODBC Data Sources in Windows Search or start the 32-bit ODBC Data Source Administrator manually using the command %windir%\syswow64\odbcad32.exe (administrator rights required).
Stay tuned; more information on using custom ODBC data sources will be available in the following video(s).
✴️ L I N K S
➡️ Smart Database Connector for Microsoft Windows: https://tec-it.com/sto
➡️ Scan-IT to Office App (Android): https://play.google.com/store/apps/de...
➡️ Scan-IT to Office App (iOS): https://apps.apple.com/app/scan-it-to...
C O P Y R I G H T ©
TEC-IT Datenverarbeitung GmbH, Austria
https://www.tec-it.com
Music: The Forest of Lights von Hiddeminside (https://www.jamendo.com/track/873884/...)
T R A D E M A R K S
A QR code is a two-dimensional code (2D code) compliant to ISO 18004. QR Code® is a registered trademark of DENSO WAVE INCORPORATED in the United States and other countries.
✴️ P R E R E Q U I S I T E S
To benefit from this solution, you need
➡️ the "Scan-IT to Office" app for your smartphone
➡️ and the "Smart Database Connector" software for Microsoft Windows.
✴️ I N S T A L L A T I O N
Install the Scan-IT to Office app for Android or iOS on your mobile device and the receiving software Smart Database Connector on a PC or server connected to the Internet. The Smart Database Connector saves the data recorded with the app immediately into on-premise databases of your choice. The installer is available for download on TEC-IT's website.
Once installed, manage the Smart Database Connector in the browser. The address is usually http://localhost:33333 (or 33334, 33335 - depending on available ports during installation).
On the panel to the right, you see some pre-configured databases. In this video, we use the Demo Database (Microsoft Access). It is suitable to store barcodes or QR codes scanned with the default scanner view of the app.
✴️ O P E R A T I O N
To showcase the functionality, pair the app with the database by scanning the QR code presented by the Smart Database Connector. Whenever you scan a barcode with the app, the data is transmitted via cloud services to the Smart Database Connector, saving the data in the Microsoft Access database using the configured SQL statement.
✴️ S E C U R I T Y
➡️ Your data is safe. Collected data is end-to-end encrypted before sending it over the Internet. Even TEC-IT, as the developer of the solution, is not able to decrypt the transmitted information.
➡️ The Smart Database Connector runs as a system service in the background of your PC. Data collection works even without a logged-on user.
✴️ C U S T O M I Z A B L E
The Scan-IT to Office solution supports the configuration and use of arbitrary databases and tables. The Smart Database Connector can connect to any ODBC-compatible database like Microsoft SQL Server, Microsoft Access, MySQL, ORACLE or even Microsoft Excel tables.
To use a custom database, create an ODBC System data source (for 32 bit!) on operating system level. Invoke the ODBC data source admin tool by searching for ODBC Data Sources in Windows Search or start the 32-bit ODBC Data Source Administrator manually using the command %windir%\syswow64\odbcad32.exe (administrator rights required).
Stay tuned; more information on using custom ODBC data sources will be available in the following video(s).
✴️ L I N K S
➡️ Smart Database Connector for Microsoft Windows: https://tec-it.com/sto
➡️ Scan-IT to Office App (Android): https://play.google.com/store/apps/de...
➡️ Scan-IT to Office App (iOS): https://apps.apple.com/app/scan-it-to...
C O P Y R I G H T ©
TEC-IT Datenverarbeitung GmbH, Austria
https://www.tec-it.com
Music: The Forest of Lights von Hiddeminside (https://www.jamendo.com/track/873884/...)
T R A D E M A R K S
A QR code is a two-dimensional code (2D code) compliant to ISO 18004. QR Code® is a registered trademark of DENSO WAVE INCORPORATED in the United States and other countries.
2 سال پیش
در تاریخ 1401/11/05 منتشر شده
است.
6,385
بـار بازدید شده