These are chat archives for PaperCutSoftware/PaperCutExamples

26th
Jul 2016
francispvps
@francispvps
Jul 26 2016 05:57
Hi Alec its me again. I'm working on the print release station now. "pc-release.exe"
is there a way I can make it contact our server for the card authentication?
Alec Clews
@alecthegeek
Jul 26 2016 06:18
See "Looking up card numbers in an external database" in http://www.papercut.com/products/ng/manual/applicationserver/topics/user-card-id.html
Alec Clews
@alecthegeek
Jul 26 2016 06:28
Some partners have created a JDBC end point that looks up the user name from the card number based on a SQL query. The datastore was not an RDBMS
francispvps
@francispvps
Jul 26 2016 06:31
ok ill look this up. thanks
Alec Clews
@alecthegeek
Jul 26 2016 06:56
is your card database an SQL database?
BTW, if you implement this approach then you don't need to bother to import the card numbers into PapeCut during user sync. However if you are importing the numbers into PaperCut I'm not sure why you need to do this fo the release station. The release station always asks PaperCut to validate the card number
Please make sure you are really need to do this before you go to the bother of impementing a JDBC interface
francispvps
@francispvps
Jul 26 2016 07:48
i understand
i got it working now
yes were using SQL server
Alec Clews
@alecthegeek
Jul 26 2016 07:48
Kewl
francispvps
@francispvps
Jul 26 2016 07:48
I understand we can choose either to synch or use the JDBC option
i got it working for both...
by the way you mentioned "Please make sure you are really need to do this before you go to the bother of impementing a JDBC interface"
why is this?
any issue we need to worry about?
i guessed in my point of view I looked for this option so that card numbers would only be in 1 place rather than having it in multiple places
so if card ID changes on our systems end... pc can still authenticate without running the user sync
Alec Clews
@alecthegeek
Jul 26 2016 07:54
I mean writing your own JDBC driver to interface into a custom data store. As you are using an SQL database that does not apply. You can use the JDBC driver supplied by the vendor. We already supply a jdbc driver for SQL Server
francispvps
@francispvps
Jul 26 2016 08:02
ahh yeah I know... i was using the existing one from External User LookUp
jdbc:jtds:sqlserver
i wasnt creating a separate JDBC driver
Alec Clews
@alecthegeek
Jul 26 2016 08:02
I have had partners do that :-)
Because they did not have an SQL database
francispvps
@francispvps
Jul 26 2016 08:03
i see
they must have a lot of time to set this up
heheh
Alec Clews
@alecthegeek
Jul 26 2016 08:03
They were pretty quick actually. I was impressed
francispvps
@francispvps
Jul 26 2016 08:05
thats cool... what db do they use?
Alec Clews
@alecthegeek
Jul 26 2016 08:09
Something of their own creation
francispvps
@francispvps
Jul 26 2016 08:49
oooh