These are chat archives for PaperCutSoftware/PaperCutExamples

10th
Oct 2017
Alec Clews
@alecthegeek
Oct 10 2017 03:15
Some advanced technical notes about getTaskStatus() https://github.com/PaperCutSoftware/PaperCutExamples/wiki/Public-Web-Services-API
Wouter Schoofs
@WouterSchoofs
Oct 10 2017 16:21
i'll test this the gettaskstatus. But first I need to get the ID's of the tasks.
we are considering what we gonna do. We have 2 options, take the csv files (more work) or take a shared dabatase for this
what should you take @alecthegeek of @Joffcom
Jonathan Bennetts
@Joffcom
Oct 10 2017 16:27
That is an interesting question, It is all down to preference really
Wouter Schoofs
@WouterSchoofs
Oct 10 2017 16:28
what if papercut has an update? can this have some troubles with another database?
Jonathan Bennetts
@Joffcom
Oct 10 2017 16:29
In the few years I have been working with PaperCut I have not seen any issues with the database side, I have been using MS SQL and MySQL/MariaDB for my stuff
The CSV route isn't that painful either you could save the file to a share or a mount and pick it up from the web server or spin up a local web service that reads the csv and spits out a json response
With the API stuff I am working on I am using both CSV and DB reads and letting the user decide.
Just remember if you are using an external database with PaperCut don't write or delete only read
Alec Clews
@alecthegeek
Oct 10 2017 19:10
We only add new tables or columns. As far as I can remember we have never deleted information. So you select statements should continue to work across versions
with regard to getTaskStatus() -- it does not use the internal task ID. It works on the last submitted job. So you can't submit multiple async calls
PS -- in PaperCut terminology the database is called "external"