https://wikido.isoftdata.com//index.php?action=history&feed=atom&title=Acomba 2026-05-03T17:37:04Z Revision history for this page on the wiki MediaWiki 1.37.2 https://wikido.isoftdata.com//index.php?title=Acomba&diff=10436&oldid=prev 2018-05-30T21:28:27Z

<p>A GL integration between Acomba and ITrack Enterprise</p> <p><b>New page</b></p><div>= Acomba Integration =<br /> == Installation ==<br /> The necessary files can all be found through SVN at SVN\Trunk\Utility\Scripts\DuboisAcomba.<br /> # Run acombaGLView.sql and custom_inventory_triggers.sql on their itrack enterprise database.<br /> # Install python 3.4 and the python mysql connector, ensuring both 32bit or 64bit. <br /> # 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.<br /> # 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.<br /> # 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.<br /> == Operation ==<br /> Grab the most recently created export file in the path specified in glExport.py.<br /> Ask the client to open Acomba and login.<br /> Import the file in acomba by clicking on the menu&gt;Input&gt;Utilities&gt;Import Data, select the &quot;Transactions to the General Ledger&quot; radio button, then click import and select the file. <br /> If there were errors, view them. Note that old errors are not automatically deleted, it&#039;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.<br /> == Summary ==<br /> 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.</div>

Zfreeman