[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] QuickBooks
****** message to minivend-users from "Mr. Christopher F. Miller" <cfm@maine.com> ******
On Wed, Jan 19, 2000 at 12:34:31PM +0100, Christian J. Müller wrote:
> ****** message to minivend-users from "Christian J. =?iso-8859-1?Q?M=FCller?=" <cmueller@polinet.ch> ******
That can work for orders, particulary if you write out
the order in some <SGMLish>kind of way</SGMLish> so your
receiving program can parse it. But what about
updating products and auxiliary tables? I don't know
if QB can do anything with auxiliary tables at all, let
alone products, but if it can, then
QB <-> ODBC <-> mySQL (or some other real DB) <-> minivend
gives you a two way street real time.
>
> Have you looked at the way, mails are sent from within MV? (sub
> form_mail() in mvend/form_mail.cfg.)
> I think that it should be pretty straight-forward to do something
> similar and write a perl program that imports MV/perl output directly
> into your QB out of either report.html or receipt.html and without
> writing into a db and then importing manually into QB.
>
> There may be other ways of doing this, too. Good luck!
> Chris
>
>
> Barry Treahy wrote:
> >
> > ****** message to minivend-users from Barry Treahy <treahy@mmaz.com> ******
> >
> > I confirmed with Intuit Pre-Sales that QuickBooks does support ODBC yesterday.
> > Anyone interfacing directly with QB with any level of success? I really don't
> > want to deal with importing/exporting contents...
> >
> > Barry
> >
> > Russ wrote:
> >
> > > ****** message to minivend-users from "Russ" <russ@khouse.org> ******
> > >
> > > Hello,
> > >
> > > I saw the thread on QuickBooks links and thought I'd offer my $.02. I used
> > > to work for a company who had a verticalware database program in dBase.
> > > They wanted to link the accounting package with QuickBooks. I see that
> > > someone already figured out to get the specs for QB datafiles off the
> > > website, and consequently it's easy to write a program to do it. You can
> > > only go one way, MV database to QB. Since MV can have any number of
> > > different fields, it would probably be best to write a script that does a
> > > general tab delimited export, and map certain MV DB fields to certain QB
> > > files. Another option would be to write the file directly off the
> > > report.html file.
> > >
> > > TMTOWTDI
> > >
> > > Russ Mann
> > >
> > > -
> > > To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
> > > email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> > > Archive of past messages: http://www.minivend.com/minivend/minivend-list
> >
> > -
> > To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
> > email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> > Archive of past messages: http://www.minivend.com/minivend/minivend-list
> -
> To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
--
Christopher F. Miller, Publisher cfm@maine.com
MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039
1.207.657.5078 http://www.maine.com/
Database publishing, e-commerce, office/internet integration, Debian linux.
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list