tags:

views:

107

answers:

2

All I want to do is figure out what the date range of the data is. At present I have to open the file in MYOB, convert it to the v18.5 format, check it for consistency, and then run a report so that I can visually check the date range. I'd prefer something a little less labour intensive. Any ideas?

+1  A: 

There doesn't appear to be any API to AccountEdge or other software from acclivity (the new name for MYOB).

Also I don't believe that the "MYOB" file formats (emphasis on 's' - plural) are anything but proprietary and undocumented.

This leaves mainly two options...

  • hack your way into the format and write a custom parser; this could be viable, but do expect bumps on the road, when the format is changed (and/or when some of the format's idiosyncrasies, not apparent during the discovery/hacking phase, eventually appear)
  • automate the manual procedure you describe in the question.
mjv
A: 

You might be interested in the answers to this question, as MYOB offers an ODBC driver.

csjohnst
And ouch, doesn't it cost!
boost