Export to Quickbooks

The data exportation service is designed to allow the extraction of data from the database in order to export it for use by other software such as Zed-Axis which expects the data in csv format, and then translates it for use by quick books.  The data exportation service is also responsible for setting up the data layer.

At this stage Amicus Service will export rows to an Excel Spreadsheet. Amicus Service feature is a timed backend service. The service will scan the database every x minutes and export every product that has not previously been exported. Each new row scanned is marked with the type of export file, so all existing products don’t get exported on successive scans. To prevent excessive load to your system, Amicus Service will sleep in regular intervals. Most of the load is also performed by SQL server, so little to no performance reductions take effect on terminals or registers.

Note: On first run, your system will take significant time to perform the export procedure as no products will have been exported. On successive scans your system will perform normally, pending on the number of additional products added to your system between scans.

I.e. if your scan is set to a daily basis & you currently have 500,000 products before the initial scan. 500,000 products will be exported to excel taking a significant load time, each product will also be marked as exported. 1000 new products added tomorrow, tomorrows scan will export the additional 1000 products. In timed internal tests, exporting 1000 products has taken only a fraction of a second. 50, 000 rows take on average 15 seconds.