Acomba

From ISoft Wiki
Revision as of 16:28, 30 May 2018 by Zfreeman (talk | contribs) (A GL integration between Acomba and ITrack Enterprise)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

Acomba Integration

Installation

The necessary files can all be found through SVN at SVN\Trunk\Utility\Scripts\DuboisAcomba.

  1. Run acombaGLView.sql and custom_inventory_triggers.sql on their itrack enterprise database.
  2. Install python 3.4 and the python mysql connector, ensuring both 32bit or 64bit.
  3. Create a folder called AcombaExport in the ISoft Data Systems folder in program files, where the enterprise folder exists. Copy the glExport.py file and the PythonTools folder into your new folder.
  4. Create a task in Windows Task Scheduler to run the export on whatever schedule the client would like. The executable will be python, the argument will be ./glExport.py and the working directory should be the folder you created in step 3.
  5. In the glExport.py file, there will be a line at the beginning indicating the folder it writes files to as well as the mysql credentials. Ensure both are valid and what the client wants.

Operation

Grab the most recently created export file in the path specified in glExport.py. Ask the client to open Acomba and login. Import the file in acomba by clicking on the menu>Input>Utilities>Import Data, select the "Transactions to the General Ledger" radio button, then click import and select the file. If there were errors, view them. Note that old errors are not automatically deleted, it's all just saved to a file in the export folder called GLIMPORT.ERR, so you may see errors that were generated long ago. Renaming or deleting the error file can help clear out the noise.

Summary

The python script simply reads from the view v_acomba_glexport, which contains all unexported gl information. This information is formatted in the fixed width manner required by acomba and written to a date stamped file. It then marks all glentries as exported in the enterprise database.