Trust ID PBCEX logo 300x102

Reading Mifare back to CSV CardExchange 7 Ultimate

8 years 6 months ago
LCR
Fresh Boarder
Fresh Boarder
Posts: 3
More
Topic Author
Reading Mifare back to CSV CardExchange 7 Ultimate #2285
Hello All,

As per subject, we now have CE7 Ultimate printing to Mifare cards. As they print, we want to read the serial of the mifare card back to the CSV.

Please can somebody provide a sample or walkthough?

Thanks
8 years 6 months ago 8 years 6 months ago by Sergio Agostinho.
Sergio Agostinho
Administrator
Administrator
Posts: 508
More
Reading Mifare back to CSV CardExchange 7 Ultimate #2286
Hi LCR,

to store the chip serial number back to your data source you need to:
  1. Create a storage item in the data definition wizard called for example MifareSN and point it to the column that you want to store the serial number
  2. Create a mifare read definition in the card definition wizard without any specific sector/block defined since you just need the serial number for now
  3. In the mappings window map the MifareSN storage item to the Chip Serial Number item (if you want to even print the serial number you need to make the same mapping but to a visible item)
Now when you print the card the Mifare serial number will be stored on your data source. You can find a sample data folder in the attached zip file for this explanation above, in this sample data folder i'm storing the serial number in a notes column of the excel file.

By the way, since you're using an Ultimate edition i suggest you the create a real database as data source instead of using a csv file, or you can connect directly to an existing one.

With best regards
Sergio Agostinho
Attachments:
8 years 6 months ago
LCR
Fresh Boarder
Fresh Boarder
Posts: 3
More
Topic Author
Reading Mifare back to CSV CardExchange 7 Ultimate #2289
Thanks, this worked (we were using CSV with ISAM error.)
8 years 6 months ago
Rutger Koperdraad
Platinum Boarder
Platinum Boarder
Posts: 1566
More
Reading Mifare back to CSV CardExchange 7 Ultimate #2300
CardExchange does not support updating records in CSV files, so if you want to store chip serial numbers to a CSV file, you have to use the Advanced storage-item option that forces always to insert a new record in the CSV file.

regards,
Rutger.

Rutger Koperdraad
Senior Software Engineer

"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)
8 years 3 months ago 8 years 3 months ago by Ingo Sterthaus.
Ingo Sterthaus
Expert Boarder
Expert Boarder
Posts: 125
More
Reading Mifare back to CSV CardExchange 7 Ultimate #2712
Hello everybody,

after sending the print job the CSN is stored and everything is fine so far but the printer (Magicard Rio Pro) does not print the CSN to the card. The visible field is mapped to the database entry of the CSN.

Has somebody an idea what I am doing wrong? After reading the CSN the print works fine but it would make more sense to do it in one process.

Regards Ingo

We bring CardExchange to its limits. You can ask Rutger and Sergio. ;-)
8 years 3 months ago
Rutger Koperdraad
Platinum Boarder
Platinum Boarder
Posts: 1566
More
Reading Mifare back to CSV CardExchange 7 Ultimate #2714
Hi Ingo,

You should map the Visible Item as Chip Serial Number and not as Database Column. At the moment you print the card, the CSN is not yet stored in the database, so if you try to retrieve it from the database, you will not get anything.

regards,
Rutger.

Rutger Koperdraad
Senior Software Engineer

"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)
8 years 3 months ago 8 years 3 months ago by Ingo Sterthaus.
Ingo Sterthaus
Expert Boarder
Expert Boarder
Posts: 125
More
Reading Mifare back to CSV CardExchange 7 Ultimate #2716
Yeah, thought that's it! But the Item was already mapped as Chip Serial Number. :( Enclosed my project... I don't get it.

Download: Mifare CSN Print.zip

We bring CardExchange to its limits. You can ask Rutger and Sergio. ;-)
8 years 3 months ago
Rutger Koperdraad
Platinum Boarder
Platinum Boarder
Posts: 1566
More
Reading Mifare back to CSV CardExchange 7 Ultimate #2717
Hi Ingo,

The object in the upper-left corner is mapped to the variable MCSN and should show the chip serial number. The object in the lower-right corner is mapped directly to the database column, and will therefore not show any chip serial number or the wrong one. The chip serial number mapping is ot available yet difectly from teh designer.

regards,
Rutger.

Rutger Koperdraad
Senior Software Engineer

"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)
8 years 3 months ago
Ingo Sterthaus
Expert Boarder
Expert Boarder
Posts: 125
More
Reading Mifare back to CSV CardExchange 7 Ultimate #2718
Yeah, I tried both but the upper left (Script CSN) also doesn't work.

At the moment I am using a Omnikey Desktop Reader and the PDF Creator to test it. This shouldn't be a problem or? Because I don't have access to the Magicard Rio Pro at the moment.

We bring CardExchange to its limits. You can ask Rutger and Sergio. ;-)
8 years 3 months ago
Rutger Koperdraad
Platinum Boarder
Platinum Boarder
Posts: 1566
More
Reading Mifare back to CSV CardExchange 7 Ultimate #2720
Hi Ingo,

In the card-definition wizard, you selected both "Do you want to enable printing?" and "Do you want to put the card on the smart-card reader manually?". If you do so, the card will first print, then you have to put it on the reader manually and then it will encode. Printing the serial number on the card is something logically impossible in this configuration, as the serial number is not know when the card is being printed.

If you want to test, you can print to the Microsoft XPS Document Writer without the manual encoding option. For that virtual printer, CardExchange ignores the card-movement commands, so you can simulate in-line encoding.

regards,
Rutger.

Rutger Koperdraad
Senior Software Engineer

"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)