Hi all -
I've read thru most of the threads here on PT - here's my situation...
I have a ticketing system I am finishing up for a client in .asp/sql2000. The client is now asking that I pull all customer and inventory data from their PT system when creating service requests, and later entering general ledger records when requests are closed.
I have set up a nightly batch process to pull exports of the customer list from pt, as well as their inventory master, importing into sql to deal with the routine searches on equipment availability and customer accounts.
My next step is to (1)perhaps pull the customer/inventory data right from PT, and (2)write the data back to PT directly, versus a DTS process to export out ledger records for importing back into PT. It'd be much easier to just dump in at the transaction level into the PT file, as well as give realtime access to inventory and customer control.
Most of the documentation for pawcom revolves around using MSaccess as a front-end - I am more interested in utilizing the com object to access the data directly.
Enough of my blabbing - to access the data, am i able to directly access the customer/inventory/ledger info, and if so, which files represent that data (I am a total newb to PT, and documentation really leaves a lot to be desired)
If possible, could someone post up a sample chunk of code that might get me started?
Thanks in advance for any help!!
I've read thru most of the threads here on PT - here's my situation...
I have a ticketing system I am finishing up for a client in .asp/sql2000. The client is now asking that I pull all customer and inventory data from their PT system when creating service requests, and later entering general ledger records when requests are closed.
I have set up a nightly batch process to pull exports of the customer list from pt, as well as their inventory master, importing into sql to deal with the routine searches on equipment availability and customer accounts.
My next step is to (1)perhaps pull the customer/inventory data right from PT, and (2)write the data back to PT directly, versus a DTS process to export out ledger records for importing back into PT. It'd be much easier to just dump in at the transaction level into the PT file, as well as give realtime access to inventory and customer control.
Most of the documentation for pawcom revolves around using MSaccess as a front-end - I am more interested in utilizing the com object to access the data directly.
Enough of my blabbing - to access the data, am i able to directly access the customer/inventory/ledger info, and if so, which files represent that data (I am a total newb to PT, and documentation really leaves a lot to be desired)
If possible, could someone post up a sample chunk of code that might get me started?
Thanks in advance for any help!!