Tips and Advice

Please post in this forum topics that contain any general tips or advice that is related to the Connector software, and existing functionality within it. Look to post in one of the following forums if the topic relates more specifically to one section of the platform:

Inventory Tips and Advice
Users Tips and Advice
Online Store Tips and Advice
Marketing Tips and Advise
Content Managed Websites Tips and Advice
Data Tips and Advice

If you have found a bug in the platform please post it in the Bugs forum.

If you wish to discuss about an improvement or new feature you would like to see in the Connector then please post in the New Features/Improvements Wish List forum.

Please ensure that you do not post any information containing user names, passwords, or any other sensitive information that could compromise the security of a the Connector, a project or website relating to an organisation or person.

Customers have data exports to the TOTECS platform scheduled to run multiple times a day (Typically Product Stock Quantities export). Data exports to Totecs Platform infrequently fail due to connection issues identified by: -The request was aborted: Could not create SSL/TLS secure channel.( The most common reason) -Error: The remote server returned an error: (502) Bad Gateway. What is the best way to investigate causes of these issues?

Here are the steps on how to remap an exported field in the connector: 1. Open the SQUIZZ.com Connector application where the export is set up. 2. In the row of the relevant adapter click the ‘Settings’ button. 3. In the window that pops up click the ‘Data Exports’ tab. 4. From the ‘Exports Type’ drop-down menu select the export that that you would like to remap a field in. 5. Click the ‘Data Fields’ tab. 6. Find the filed that you would like to remap in the table, ensure that the ‘Set Custom Field’ checkbox is ticked and put the new fields technical name (eg database column) in the ‘Custom Data Field Definition’ cell for that row. 7. Click the ‘Reload Data Fields’ button

In the maker model export, the released date and the created date are in the form of a number of milliseconds since the 01-01-1970 12:00am Epoch in UTC time-zone. In order to convert in excel a date format YYYY to a UNiX epoch number of millisecond for all model, I have used the following formula: epochdate = (DateValue(YYYY) - 25569) * 86400 * 1000 Note: This formula also works for model with date prior to 1970. You can also found help to perform this conversion in different programming language using the following website https://currentmillis.com/ Further help can be found in the Connector 1.13 release video at https://youtu.be/PQ6osVe57uw

In the lucrative market of smartphones, every businessman is looking for an emerging market as it may gain them a higher profit comparatively others. It is one of the reasons that a lot of users prefer Android due to its usability, affordability, user-friendly interface, and many other benefits. Now, it has become the responsibility of Android application developers like: https://www.ingic.ae/android-app-development/ to come up with the kind of strategy that may sweep them off feet. 1. Identify the Audience’s Needs Indeed, identifying what our target audience wants is the most essential things to understand in any kind of business. First off, seek out what your audience wants and what they are looking for. Now is the time to embed all those features into our app to provide them with the exceptional user experience. 2. App Marketing Not only that the visibility but also the viability of a mobile app when it is marketed the right way. Google play store is the giant platform amongst all; when you work hard to increase its traffic, it may rank it on the top of listing. Attractive graphics and descriptive features may also create brand awareness.

In on instance when running the SQUIZZ.com Connector application installer, the installer failed to complete and showed a error dialog containing the message "Application cannot be started. Contact the application vendor.". Upon clicking on the "Details..." button the error log file contained the message "The application binding data format is invalid". This installation issue occurred when trying to install the Connector on a computer that previously had Ransomware installed that was rebuilt from a back up of the computer.

A question was asked on what is the different between the Connector's WIndows Service host, and the Connector application.

How do I go about reinstalling the old xsquizzit Accounting Connector? Will it make any difference if I am installing the application on a user session that was different to the user session that originally installed the service/application? Does the re-installation of the squizz.com connector differ in any way?

Below are steps required to be able to upgrade and migrate data, as well as settings from the Xsquizzit Accounting Connector version 0.x to Squizz.com Connector version 1.x. 1. Check, download and install Microsoft's .NET 4.6.1 library if not already installed on the computer 2. Download the Squizz.com Connector Host Service installer. Ask the TOTECS team for the URL to download the software. 3. Stop the Xsquizzit Accounting Connector Host windows service. This will stop any data exports, sales order imports, or account enquiry requests from the totecs project configured with the Connector. 4. Run the installer of the Squizz.com Connector Host Service. 5. In Windows open up a Folder Explorer window, locate and delete the Squizz.com Connector's database file. Ask TOTECS staff where this is located. 6. Download the Squizz.com Connector application. Ask the TOTECS team for the URL to download the software. 7. Install the Squizz.com Connector application. 8. Open Xsquizzit Accounting Connector application. If it asks whether you want to upgrade the application ensure that you accept. The latest version of the application must be installed. 9. Click on the Tools menu. 10. Click on the Upgrade Connector Database to Version 1.x 11. In the window's Connector Database Save Folder set the folder location where the Squizz.com Connector contains its program data. This is typically C:/Program Data/SquizzCom/Connector 12. Click on the Start Upgrade button. This will create a new connector database file in the Squizz.com Connector program data folder and copy all data and configurations across from the old Connector into the new Connector database. 13. Close the Xsquizzit Accounting Connector application. 14. Start the Squizz.com Connector Host windows service. 15. Start the Squizz.com Connector application. 16. View the logs and check that no severe errors have occurred when the host service was started. 17. Verify that all Connector settings and adaptor settings have correctly migrated across. 18. For each adaptor click on the Adaptor button. 19. In the Adaptor Password field enter a password then click the save button. Repeat for each adaptor. 20. Open a web browser and login as an administrator user into the TOTECS project that is configured to use the Connector. 21. Click on the Data menu button. 22. Click on the Connector settings menu item. 23. In the Connector Version setting set the version to "1.x or higher" 24. In the Adaptor Password setting set the password as set in step 19 25. Maximise the Squizz.com Connector application again. 26. Run data exports for each adaptor to confirm that data is correctly being exported from the Connector in the TOTECS project. Within the Administration Centre of the TOTECS project verify that the data correctly migrated. Optional Steps 27. Archive the Xsquizzit Accounting Connector database file to a safe and secure location. This is typically located in C:/Program Data/Xsquizzit/AccountingConnector/accountingconnectordb.db3 28. Uninstall the Xsquizzit Accounting Connector Host Service. 29. Uninstall the Xsquizzit Accounting Connector application.

A connector continually gets an stating "Unable to process and cache export data for the adaptor, instead exporting full data set. Error: An error occurred whilst trying to process the cached pricing records. Error: SQLite error no such table: esd_record_account_product_price_group_account" What needs to be done to sort out that error?

After migrating the data of the Connector across computers to a Windows 2012 server, after installing the Connector application which reads from the migrated connector files, then trying to update the setting of an adaptor, the error dialog appears with the error "An error has occurred whilst trying to save the credentials. Technical details: The SQL query could not be successfully executed Attempt to write a read-only database. Attempt to write a readonly database." Why cannot the adaptor settings be updated?

It has been reported that a TOTECS project had been configured with a Micronet Distribution system using the Connector application, and the Connector had been pushing up images associated with the Distribution system's items into a TOTECS project. However when product image export runs from the Connector old primary images remain in the project, why is this so?

An issue was reported where the Connector's host window service was unable to be uninstalled on a Windows Server 2011 operating system. After navigating to the Programs and Features section within the Control Panel, then selecting the program named "Xsquizzit Accounting Connector Service" and pressing the Uninstall button, a dialog was appearing asking for the location of the installation file. Upon choosing the install location Windows would then advise that the program could not be uninstalled.

How do I have my trade online store display pack prices in the search results? Currently the trade interface is showing unit prices. My customers prefer to see pack prices. Eg a Pack of 12 Pens for $20.