Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Super Contributor
DFeller
Posts: 2,943
Registered: 10-28-2008
0
Accepted Solution

Credit Card Swipe machines

I have a little credit card swipe machine that can pass data in this format:

 

Cardholder Name ^ Card number ^ expiration date

 

Via customizer I was able to add a temp field onto the credit card screen, and parse the data out into the individual fields -- card holder name, expiration month, expiration year, credit card number, payment type (by parsing the first digit of the card number), however it won't process.  If someone manually types in the card it works fine.

 

What I've discovered is that when it passes the card number into the field, it's passing it straight-on, where as if you type it in, as soon as you leave the field it changes it to the xxxx-xxxx-xxxx-9999 format.  This does something so that it recognizes it as a valid card.

 

Any suggestions on what I should do to "push" the data in this field so that it recognizes it?  I'm using Form.Controls("...") methodology.

 

Dawn

Sage MAS Partner
LouDavis
Posts: 545
Registered: 10-29-2008

Re: Credit Card Swipe machines

Without looking at the code, I beleive that once you tab off the control (lose focus), code fires that encrypts and saves the credit card information to the vault.  If you are storing the credit card infromation locally, you should see this in a SQL trace if an insert or update is occuring on tccVault. 

 

You also could try within your vbScript to set focus to each control before populating it.  Once you populate it, set focus to another control to try and trigger the underlying code that is running when manually typing in these values.

Louis Davis MCSD, MCAD, MCITP
e2b teknologies, inc
www.e2btek.com

Moderator
JennyWilson
Posts: 78
Registered: 07-23-2009
0

Re: Credit Card Swipe machines

The routine that validates the credit card number is in CCTransactions.frm, bIsValidCreditCardNumber.    This calls another routine in CCTransactions.cls, moClass.ValidateCCNum.    No vaulting occurs at this point.

 

I'm not real familiar with the customizer, but you may be able to just fire a txtCCNumber_LostFocus to get the validation to fire.

 

On another note, credit card information is not vaulted in tccVault unless you are using local vaulting.   If you are using SPS vaulting, tccVault is not used - the information is stored on the SPS server.   Also, you may not be vaulting at all. 

 

Hope this helps.

 

Jenny

Jenny Wilson
Principal Software Engineer
Sage 500 ERP
Super Contributor
DFeller
Posts: 2,943
Registered: 10-28-2008
0

Re: Credit Card Swipe machines

I did try the "set focus" on another field after the credit card field and that did not work.

 

I will keep trying other suggestions/ideas.

 

Dawn

Super Contributor
DFeller
Posts: 2,943
Registered: 10-28-2008

Re: Credit Card Swipe machines

Okay, I re-did my test by setting the focus to the credit card number before setting the field, then doing a set focus to another field, then setting that field, and THAT worked!

 

If anyone needs to use credit card readers with MAS 500, I would recommend model MU-B2-6 from ID Innovations (http://www.idinnovations.com) as that is the one I used to get this working.

 

Dawn