Productive Computing, Inc. Support Forum

Plug-ins => FM Books Connector => Topic started by: jasono on May 12, 2011, 06:52:40 AM

Title: FMBooks session
Post by: jasono on May 12, 2011, 06:52:40 AM
Hello, I'm working at migrating from FileBooksLink to FMBooks Connector, and am wondering if I should be beginning and ending the session at the beginning and end of each script that is communicating with QB, or if I should just begin the session when the database is opened, and end the session when the database is closed?

Also not sure exactly what the difference is between the PCQB_ZCloseConnection function and PCQB_EndSession?

Thanks for your assistance!

Jason
Title: Re: FMBooks session
Post by: Geoffrey Gerhard on May 12, 2011, 11:57:04 AM
Your first question has two practical considerations:

1) Are there other external applications that would access QuickBooks via the API in the same time frame as your FileMaker solution?
This is rare, in my experience, but if it's relevant to your system you'll want to minimize the potential for conflicts (record locks) in QB by opening and closing the connection each time a script interacts with QB.

2) Are all interaction happening in a batch process, or will users trigger interactions with QB throughout the day?
Opening a connection to QB is slow compared to pushing data to (and pulling data from) QB. Rather than losing up to 20 seconds on the connection process with each exchange of data, I open the connection the first time a user attempts to exchange data with QB in any session and then leave it open until the user ends the session (by quitting FileMaker) or calls a script that explicitly closes the connection.

HTH!


Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852