Jump to content

Using same cards - PaperCut and Paxton Net2 (converting Papercut token to Paxton)

mb2k01

By mb2k01
in How do you do....it?

 Share

Recommended Posts

mb2k01

mb2k01

Posted
Posted

Hi All,

 

We have a PaperCut solution which reads 1K MiFare cards (some a mixture of generic 1k cards, while some cards are specific Salto 1k cards for a soon-to-be legacy system)

We are hoping that we might be able to utilise the token stored against a user in PaperCut to populate the token area in a new Paxton NET2 installation - does anyone do that?

 

The problem I've got is that PaperCut has a 10 digit token and Paxton an 8 digit token.

E.G. when reading a single card PaperCut shows 3966179326 yet Paxton reads it as 38104464 when scanned.

Is there some kind of conversion utility around, or a formula that I could use in Excel to convert etc?

Or... are others doing this a completely different way / with some kind of middleware?

 

Cheers

 

Mark

  • Popular Post
qwerty94

qwerty94

Posted
  • Popular Post
Posted

We are doing exactly this, 1k MiFare cards used for Paxton door system and PaperCut, we use the following formula in Excel.

 

Papercut: *ENTER TOKEN HERE*

Transfer Cell: =DEC2HEX(Papercut)

Live Register/Another Transfer Cell: =MID(Transfer Cell,7,2)&MID(Transfer Cell,5,2)&MID(Transfer Cell,3,2)&MID(Transfer Cell,1,2)

Net2: =RIGHT((HEX2DEC(Live Register)),8)

 

I hope that makes sense!

  • Thanks 5
mb2k01

mb2k01

Posted
  • Author
Posted
We are doing exactly this, 1k MiFare cards used for Paxton door system and PaperCut, we use the following formula in Excel.

 

Papercut: *ENTER TOKEN HERE*

Transfer Cell: =DEC2HEX(Papercut)

Live Register/Another Transfer Cell: =MID(Transfer Cell,7,2)&MID(Transfer Cell,5,2)&MID(Transfer Cell,3,2)&MID(Transfer Cell,1,2)

Net2: =RIGHT((HEX2DEC(Live Register)),8)

 

I hope that makes sense!

 

That looks amazing, but could you double check the formulae for me?

If I type Papercut 3966179326 then it outputs NET2 62946796 which differs from what NET read when it scanned my card manually (38104464)

qwerty94

qwerty94

Posted
Posted
That looks amazing, but could you double check the formulae for me?

If I type Papercut 3966179326 then it outputs NET2 62946796 which differs from what NET read when it scanned my card manually (38104464)

 

Just tried your papercut token in our spreadsheet I'm getting the same output (62946796) - Have you tried it? As far as I know, if we scan manually or through the spreadsheet we get the same code.

mb2k01

mb2k01

Posted
  • Author
Posted
Just tried your papercut token in our spreadsheet I'm getting the same output (62946796) - Have you tried it? As far as I know, if we scan manually or through the spreadsheet we get the same code.

 

Technician 101 - check the basics first!

Turned out I hadn't registered my latest card in PaperCut - doh!

Now that Papercut actually has my latest card, the formula works perfectly - huge thanks for this. Will save a massive amount of time.

 

Do you enter the tokens manually for users in Paxton, or have you managed to script it somehow?

 

Cheers

 

Mark

qwerty94

qwerty94

Posted
Posted
Technician 101 - check the basics first!

Turned out I hadn't registered my latest card in PaperCut - doh!

Now that Papercut actually has my latest card, the formula works perfectly - huge thanks for this. Will save a massive amount of time.

 

Do you enter the tokens manually for users in Paxton, or have you managed to script it somehow?

 

Cheers

 

Mark

 

Glad you got it sorted! - We register manually in PaperCut, Net2 and Live Register, just using the spreadsheet to scan the cards, so we only scan once.

  • 5 months later...
IrritableTech

IrritableTech

Posted
Posted

I've been using Carpeek with my ACR122 reader - but it takes longer and show a great deal more than the UID. I built some RFID readers using an Arduino Pro Micro and an RC522 module - it simply grabs the UID and types it into anything you want, the Pro Micro acts like a keyboard. I did make it a bit more complicated using a keypad - that way I can press a button and it'll type the UID as HEX, DEC or the decimal conversion paxton uses where it knocks off the first to digits of the decimal UID. This helps me avoid the use of a spreadsheet to convert across the various standards - but isn't necessary. Total cost - about £3.80 plus a bit of filament!

 

IMG-0263.jpg

  • 2 months later...
  • 2 weeks later...
  • 2 years later...
Dp2811

Dp2811

Posted
Posted

Hi All,

 

I know this is an old thread but I thought I'd help out here, you can add a js script into papercut and use the hex2dec command which is natively supported in papercut. What we do is make papercut read the Paxton number.

 

We use the ext-device.card-no-converter option with the argument as hex2dec|javascript:custom/cardconvert.js and our script reads as below:

 

function convert(cardNumber) { var returnValue; if (cardNumber.length == 10) { returnValue = cardNumber.substring(2,10).toLowerCase(); } else if (cardNumber.length == 9) { returnValue = cardNumber.substring(1,9).toLowerCase(); } else if (cardNumber.length == 7) { returnValue = '0' + cardNumber; } else { returnValue = cardNumber; } return returnValue;}

 

Hope this helps someone out.

  • Thanks 3
  • 2 years later...
EssentialRug

EssentialRug

Posted
Posted

Apologies to resurrect and slightly hijack this thread...

 

We have been using PaperCut MF with MiFare 4K cards, but have recently switched over to using UniFLOW which comes with a different reader. This reader is giving us different card token ID's. For instance:

 

PaperCut: 3664013c

UniFLOW: 3c016436

 

Does anyone have any funky formula for converting our PaperCut token ID's to UniFLOW ones? Any help would be much appreciated! Thanks!

Steve21

Steve21

Posted
Posted (edited)
Apologies to resurrect and slightly hijack this thread...

 

We have been using PaperCut MF with MiFare 4K cards, but have recently switched over to using UniFLOW which comes with a different reader. This reader is giving us different card token ID's. For instance:

 

PaperCut: 3664013c

UniFLOW: 3c016436

 

Does anyone have any funky formula for converting our PaperCut token ID's to UniFLOW ones? Any help would be much appreciated! Thanks!

 

That's just hex pairs reversed

 

PaperCut: 36 64 01 3c

UniFLOW: 3c 01 64 36

 

In Excel put the Papercut one in A1 and then use B1 as

 

=RIGHT(A1,2) & MID(A1,5,2) & MID(A1,3,2) & LEFT(A1,2)

 

Repeat it down the column etc

 

Steve

Edited by Steve21
  • Thanks 1
  • 1 year later...
Planehazza

Planehazza

Posted
Posted (edited)
On 20/09/2018 at 11:43, qwerty94 said:

We are doing exactly this, 1k MiFare cards used for Paxton door system and PaperCut, we use the following formula in Excel.

 

Papercut: *ENTER TOKEN HERE*

Transfer Cell: =DEC2HEX(Papercut)

Live Register/Another Transfer Cell: =MID(Transfer Cell,7,2)&MID(Transfer Cell,5,2)&MID(Transfer Cell,3,2)&MID(Transfer Cell,1,2)

Net2: =RIGHT((HEX2DEC(Live Register)),8)

 

I hope that makes sense!

I'm being exceptionally thick, and I'm not at all data/excel driven. How do I use this please? I assumed the = cells are referring to named cells, but I'm not entirely sure how to lay this out in Excel. Any rookie pointers would be great, thanks! 

Edited by Planehazza
DGardiner

DGardiner

Posted
Posted
6 minutes ago, Planehazza said:

I'm being exceptionally thick, and I'm not at all data/excel driven. How do I use this please? I assumed the = cells are referring to named cells, but I'm not entirely sure how to lay this out in Excel. Any rookie pointers would be great, thanks! 

 

 

im assuming he means like this: https://docs.google.com/spreadsheets/d/1qSenmbT3_g8CBTq2y2yvC1Wwdw2qfiT1GdYL_0lVcJ8/edit?usp=sharing

 

 

  • Like 1
Planehazza

Planehazza

Posted
Posted (edited)

You guys rock, this will save me and the site guy a lot of fecking about with manual fob registering. Thank you!

 

As it happens, I was doing what the two examples above were doing but I was naming the cells and thinking that's how the formula worked. I wasn't actually too far off!

Edited by Planehazza
Planehazza

Planehazza

Posted
Posted (edited)

Ah nope unforunately not. Our papercut seems to be using hexadecimal, and when I enter the ID into cell B2 from the papercut primary ID field it comes with with !VALUE errors

 

If I convert to decimal and punch that number in,the resultant number for net 2 doesn't match what I see for my fob that is already registered to both...

Edited by Planehazza
DGardiner

DGardiner

Posted
Posted
On 22/08/2025 at 11:14, Planehazza said:

Ah nope unforunately not. Our papercut seems to be using hexadecimal, and when I enter the ID into cell B2 from the papercut primary ID field it comes with with !VALUE errors

 

If I convert to decimal and punch that number in,the resultant number for net 2 doesn't match what I see for my fob that is already registered to both...

 

 

Just skip the first formula is papercut is already hex

 

the first cells is dec the second cell converts that to hex judging from the formula (im assumign by the name)

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing


×
×
  • Create New...