anexiole has asked for the wisdom of the Perl Monks concerning the following question:

hi there

 i am in australia . Over here,SMEs use MYOB(MIND YOUR OWN BUSINESS) as an accounting package.

Are there any pre-made PERL modules that interfact with it?

Replies are listed 'Best First'.
Re: Can PERL interface with MYOB?
by Fletch (Bishop) on Sep 15, 2006 at 22:54 UTC

    Not a sure thing, but lots of financial applications like this can read Quicken's interchange format. Finance::QIF might be of use if your software can.

Re: Can PERL interface with MYOB?
by GrandFather (Saint) on Sep 16, 2006 at 01:53 UTC

    My vague recollection is that MYOB is pretty much a wrapper around Access database. Depending on what you want to achieve, you may be able to access the data using the Jet driver for DBI.


    DWIM is Perl's answer to Gödel
Re: Can PERL interface with MYOB?
by graff (Chancellor) on Sep 15, 2006 at 22:39 UTC
    A quick scan at CPAN doesn't turn up anything for "MYOB". Maybe if you happen to have any sort of documentation or samples of the file format(s) that MYOB uses/supports, that would be a place to start.

    It might not be too bad a stretch for someone to build a suitable set of perl modules, if this software isn't too much in the Microsoft design paradigm... (i.e. arcane, proprietary, and fiercy secretive about it).

Re: Can PERL interface with MYOB?
by aquarium (Curate) on Sep 16, 2006 at 14:33 UTC
    use the module test::gui to "interact" with any GUI program, including MYOB. if you want to read/write MYOB files, that's another story.
    the hardest line to type correctly is: stty erase ^H
Re: Can PERL interface with MYOB?
by hesco (Deacon) on Sep 16, 2006 at 14:54 UTC
    Once you extract your data from MYOB, consider dropping it into SQL-Ledger, a GAAP compliant accounting package written in perl which uses postgres as its backend. The SQL-Ledger site has a page on converting from one accounting program to another, at:

    http://www.sql-ledger.org/cgi-bin/nav.pl?page=misc/conversions.html&title=Conversions

    It does not list MYOB, but if you can convert to Quicken or GnuCash, there is a pathway to get you all the way home to a perl based application.

    Good luck.

    if( $lal && $lol ) { $life++; }