Thank you Alon,
Your solution looks interesting but it is also a bit "hard core".
Do you have any feedback to give me, maybe share with me part of the datamodel you understood from priority. Would you like to share your code?
As priority is a local application running on windows on the desktop of my customer, and will need to develop those kinds of wrappers:
- a windows app in python that will connect to the mssql and handle the updates to and from priority. This app should run on the same machine as priority, and the machine should be always switched on. The app will reside in the iconTray of windows most probably. Then this app is keeping a live TCP connection to a server, located ouside of the office of my customer.
- the server is another python script, listening on some port, running on the same server where the django apps of the website of my customer are running. This server will talk to the windows client in RPC maybe? this server-client TCP connection is required to get rid of the NAT problems in my customer's office. If the connection is lost, the client is expected to reconnect automatically. If the server do not receive any connection after some timeout, it sends an email to my customer and me.
- the server is also providing a JSON HTTP API on localhost to the django apps around. This webservice is about what ever i need (invoicing, account balance, stocks...) and is just a wrapper redirecting everything into the RPC tunnel towards the windows app that will do the job on the MSSql.
Alon if you help me with your code and knowledge, and maybe developement, i propose you to open source this project.
Ifi do it all alone, i ll open source it when it will have been sold enough ;)
It should not be so much work, as it all about wrappers at the end.
Priority is a widely used accounting software in israel, i am sure it can benefit many developers around.
If anybody is willing to join, you are welcome!
N.