Akopia Akopia Services

[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


Search for: Match: Format: Sort by: