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

Hai i need to access quicbooks from perl using linux, This is for store and retrieve the data from online storage, i got some coding from the net but i dont know how to use, because it requires RSSBus SQLBroker, in which i dont know how to get this and where to install, i have perl and linux please help me my code is given below

#!/usr/bin/perl use strict; use DBI(); my $dbh = DBI->connect("DBI:mysql:database=QuickBooksSqlBroker;host=lo +calhost:3307", "root", "my_password", {'RaiseError' => 1}); my $result = $dbh->prepare("SELECT * FROM Customers"); $result->execute(); while (my $row = $result->fetchrow_arrayref) { my $csv = join(',', @$row); print "$csv "; } $result->finish(); $dbh->disconnect();

Thank You !!

Replies are listed 'Best First'.
Re: how to access quickbooks from perl in linux
by ww (Archbishop) on Apr 30, 2013 at 17:59 UTC
    Looks to me (without any prior knowledge of QB's API) that you're going to need a programmer with familiarity with your case. Alternately, you may want to see if there's documentation online or a QB user group to offer info/help. This is pretty specialized... and therefore, not something in the usual ambit of this site -- which is "learning Perl;" NOT writing code for free.

    of course, as an alternate to paying-for-programming, you can search (Big G, for example) for the missing modules and their docs.


    If you didn't program your executable by toggling in binary, it wasn't really programming!

Re: how to access quickbooks from perl in linux
by igelkott (Priest) on May 01, 2013 at 07:25 UTC
    DBI:mysql

    From a programming point of view, this is just accessing MySQL through Perl. A quite common and well-documented subject but rather than jump into the interface details, you should probably start by looking for a gentle introduction.

    RSSBus SQLBroker is commercial. Check with the company for the details but the important part (for programming) is that their stuff can be accessed through MySQL, which you can access through Perl, etc.