Author Topic: Pull a limited set of Customers and Jobs from QB  (Read 1375 times)

doug@basebuilders.com

  • Member
  • *
  • Posts: 2
Pull a limited set of Customers and Jobs from QB
« on: August 16, 2012, 03:41:10 PM »
Is there a way to pull only Customers and Jobs that have not been previously pulled?
Currently we delete all that has been pulled and pull a fresh set. Hoping to speed up the process and only pull the missing ones.

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 470
Re: Pull a limited set of Customers and Jobs from QB
« Reply #1 on: August 16, 2012, 04:27:24 PM »
I don't know of a Query that does exactly what you want, but you can get close. Next time you run the process, make sure you extract the timestamp from the TimeModified element, convert it to an FMP timestamp, and store it in a "QB_timemodified" timestamp field in the Customer/Job record. The next time you do a Customer Query, include something like...

PCQB_RqAddFieldWithValue( "FromModifiedDate" ; Max ( yourTO::QB_timemodified )

...in your request. This will return a duplicate of whichever record had the most recent timestamp the last time the script ran, duplicates of all Customer/Job records modified since the last run, and all new records added to the QB Customer List since the last run.

HTH!

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

doug@basebuilders.com

  • Member
  • *
  • Posts: 2
Re: Pull a limited set of Customers and Jobs from QB
« Reply #2 on: August 21, 2012, 08:21:22 AM »
Thanks.