CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute »
  • Community Contributed Payment Processors »
  • Is the Authorize.net transaction ID stored as an INT or String?
Pages: [1]

Author Topic: Is the Authorize.net transaction ID stored as an INT or String?  (Read 3801 times)

MacRonin

  • I post frequently
  • ***
  • Posts: 153
  • Karma: 14
Is the Authorize.net transaction ID stored as an INT or String?
September 04, 2008, 08:52:56 pm
I just got an email from Authorize.net informing me that they will be updating their Transaction ID format as of Oct 1,2008. I have included the email content below. When I did some searching on Transaction ID I saw references to both String and INT. They say if we are String we are probably OK(I think that we are)  but INT definitions may have problems. So being the careful guy that I am, I wanted to make sure that are safe. Especially with that new ver 2.1 coming up which would be a great time to make sure the fix(If needed) is in place.

Paul


Quote
Important System Notice

Dear Authorize.Net Merchant:

In early October, Authorize.Net will be expanding the range of Transaction IDs issued by the payment gateway. Please read this e-mail thoroughly as it contains important information on how to ensure that your account is not affected.

The Authorize.Net Transaction ID is the payment gateway-generated number used to uniquely identify each transaction you submit for processing. The Transaction ID can be found in the transaction response and in the Search and Reports features of the Merchant Interface.

The Transaction ID field was originally developed with a maximum numeric value of 2,147,483,647. As the number of merchants using the Authorize.Net Payment Gateway has grown, we have identified a time in which the Transaction ID count will surpass 2,147,483,647. For this reason, we are in the process of expanding the range of Transaction IDs that the payment gateway can issue. Accordingly, we are communicating to all merchants to verify that your systems can accommodate a 10-digit Transaction ID greater than 2,147,483,647.

In most cases your transaction processing will not be affected. However, if you have an internal business application or solution that relies upon the Transaction ID field, your system may fail if it cannot handle a Transaction ID larger than 2,147,483,647. For more information, please review the Transaction ID FAQs located at http://www.authorize.net/transid.

It is critical that you contact your developer to verify whether your integration will be impacted. Specifically, please provide your developer with the following information:

    The Transaction ID, or x_trans_id, is specified as a 10-digit integer and will only be affected if that value is represented as an INT data type, which has a max value of 2,147,483,647. If you have specified the Transaction ID as a string value, then your system will not be affected. Failure to accommodate 10-digit values larger than 2,147,483,647 will result in your system's inability to accept Authorize.Net transactions.

Note: If you need to make updates to your Transaction ID architecture, you should do so prior to October 1, 2008, to ensure that you will not be affected.

If you have any questions, please contact Customer Support at support@authorize.net.

Sincerely,
Authorize.Net

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Is the Authorize.net transaction ID stored as an INT or String?
September 04, 2008, 08:57:37 pm

it is stored as a string (varchar(32) or so i think)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

MacRonin

  • I post frequently
  • ***
  • Posts: 153
  • Karma: 14
Re: Is the Authorize.net transaction ID stored as an INT or String?
September 04, 2008, 09:14:17 pm
Wow, you're slowing down. You response took a whole four minutes  ;D

I thought that we were, but glad to hear that we are probably OK

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute »
  • Community Contributed Payment Processors »
  • Is the Authorize.net transaction ID stored as an INT or String?

This forum was archived on 2017-11-26.