Does anyone have an example of how to receive a payment via the Sage SDK? It's looking to me like you have to go directly at the tables (which is a HUGE gap in the SDK in my opinion) but that sounds risky. Anyone know how to do this?
Does anyone have an example of how to receive a payment via the Sage SDK? It's looking to me like you have to go directly at the tables (which is a HUGE gap in the SDK in my opinion) but that sounds risky. Anyone know how to do this?
Noesis said:I am not usre if you are referring to enable the binary log
I think that Binary logging is at more of a redo / undo binary data block level as in ib_logfile0 and ib_logfile1.
You want SQL Query Logging http://dev.mysql.com/doc/refman/5.7/en/query-log.html
Add a line to dbengine.ini:
general_log = 'ON'
(probably under C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.6.10) (Check the properties of the Connection Manager service for the path)
There will be a log file created in the 'SAJ' folder with the name of the workstation and a 'LOG' extension.
Execute the transaction, copy the log file and paste it somewhere you can work on it. I found that renaming to .CSV formatted it the best
On starting Sage 50 there will be a log file created in the 'SAJ' folder with the name of the workstation and a 'LOG' extension. The file will be deleted when closing the Sage 50 Company File.
Execute the transaction you want to see, copy the log file and paste it somewhere you can work on it, the transactions are in chronological order. I found that renaming to .CSV and autofiltering it in Excel worked best.
The above information is intended for study and troubleshooting only, the user of it takes all responsibility for not violating the Sage 50 software and SDK End User license agreements.
Noesis said:I am not usre if you are referring to enable the binary log
I think that Binary logging is at more of a redo / undo binary data block level as in ib_logfile0 and ib_logfile1.
You want SQL Query Logging http://dev.mysql.com/doc/refman/5.7/en/query-log.html
Add a line to dbengine.ini:
general_log = 'ON'
(probably under C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.6.10) (Check the properties of the Connection Manager service for the path)
There will be a log file created in the 'SAJ' folder with the name of the workstation and a 'LOG' extension.
Execute the transaction, copy the log file and paste it somewhere you can work on it. I found that renaming to .CSV formatted it the best
On starting Sage 50 there will be a log file created in the 'SAJ' folder with the name of the workstation and a 'LOG' extension. The file will be deleted when closing the Sage 50 Company File.
Execute the transaction you want to see, copy the log file and paste it somewhere you can work on it, the transactions are in chronological order. I found that renaming to .CSV and autofiltering it in Excel worked best.
The above information is intended for study and troubleshooting only, the user of it takes all responsibility for not violating the Sage 50 software and SDK End User license agreements.
*Community Hub is the new name for Sage City