Protx form - 'Address Numerics: Not Matched'

[UncleSteve]

I'm using Protx Form.

 

I'm getting an awful lot (vertually all) of payments saying 'Address Numerics: Not Matched' which is a pain.

 

Looking at the address in the Protx form which has been supplied by my osc. It seems like all the line breaks have been removed, so where I should have an address that looks like this

25 Nowhere Street,

Urban Town,

The County,

AA1 2BB,

 

I'm getting

25 Nowhere Street,Urban Town,The County,AA1 2BB, (yes the space is missing after the comma)

 

I have found if the address is edited to lay out on seperate lines in Protx when entering your card details I don't gett the 'Not matched' error.

 

I made the same enquiry on the Protx forum, and they came back with;

The address and post code checks that are run by the issuing banks depend/rely solely on the numeric’s of the address and not the alpha characters.

 

So for example:

 

22 Soho Square

London

W1D 4NS

 

would be read as:

22

14

 

It is very important that you split the billing address and billing post code into separate fields so that they are not provided as follows:

2214

Since I'm only getting the one error message, I don't think their reply applies to my problem.

 

When I get an error and check the customer postcode against a postcode database, the address given in the database always matches what the customer gave, so why the error message

 

 

Can anyone give me a clue where to start looking and making good please?

 

Thanks in advance :)

[GemRock]

The only thing I can think of is the address id you use, but given the very little info about your site, it might not be relevant.

 

Ken

[UncleSteve]

The only thing I can think of is the address id you use, but given the very little info about your site, it might not be relevant.

 

Ken

Hi Ken,

 

What additional info would you like?

 

Can you expand further on the address ID please?

 

Thanks

 

Steve

[GemRock]

Sorry steve, it was a bit too late in the night - I meant address format which is idetified by its id. protx form takes the address from the order class which in turn reads the address according the af id - if I remember correctly. I was thinking somehow the af had been changed: the cr was taken away hence there was no carriage return & no line changing. But I could be wrong.

Good Luck!

 

Ken

[UncleSteve]

Sorry steve, it was a bit too late in the night - I meant address format which is idetified by its id. protx form takes the address from the order class which in turn reads the address according the af id - if I remember correctly. I was thinking somehow the af had been changed: the cr was taken away hence there was no carriage return & no line changing. But I could be wrong.

Good Luck!

 

Ken

I get the idea of what your explaining, but actioning it is another :(

 

In admin you can change tha layout of the address, but none that I have tried removes the CR. It chages the order of the info, like the postcode before or after the county etc.

 

Thanks

 

Steve

[GemRock]

I was referring to the address_format table in the db, where the cr could only be removed (somehow) from the format string. But now it seems not likely because (obviousely perhaps) you hadnt touched that table, or...? Sorry, I am not aware of any other reason that may cause the multi-line address becoming a one liner.

 

Ken

[Guest]

I've just had a look at the protx form code - it doesn't include any CR in the address format.

 

Try finding this code:

$delivery_address = $order->delivery['street_address'];
  if (ACCOUNT_SUBURB == 'true') {
	$delivery_address .= ',' . $order->delivery['suburb'];
  }

  $delivery_address .= ',' . $order->delivery['city'];

  if (ACCOUNT_STATE == 'true') {
	$delivery_address .= ',' . $order->delivery['state'];
  }

  $delivery_address .= ',' . $order->delivery['country']['title'];

  $billing_address = $order->billing['street_address'];

  if (ACCOUNT_SUBURB == 'true') {
	$billing_address .= ',' . $order->billing['suburb'];
  }

  $billing_address .= ',' . $order->billing['city'];

  if (ACCOUNT_STATE == 'true') {
	$billing_address .= ',' . $order->billing['state'];
  }

  $billing_address .= ',' . $order->billing['country']['title'];

 

and changing to:

$delivery_address = $order->delivery['street_address'];
  if (ACCOUNT_SUBURB == 'true') {
	$delivery_address .= ",\n" . $order->delivery['suburb'];
  }

  $delivery_address .= ",\n" . $order->delivery['city'];

  if (ACCOUNT_STATE == 'true') {
	$delivery_address .= ",\n" . $order->delivery['state'];
  }

  $delivery_address .= ",\n" . $order->delivery['country']['title'];

  $billing_address = $order->billing['street_address'];

  if (ACCOUNT_SUBURB == 'true') {
	$billing_address .= ",\n" . $order->billing['suburb'];
  }

  $billing_address .= ",\n" . $order->billing['city'];

  if (ACCOUNT_STATE == 'true') {
	$billing_address .= ",\n" . $order->billing['state'];
  }

  $billing_address .= ",\n" . $order->billing['country']['title'];

 

This should format the address correctly, but I don't see that having any impact on AVS check since they only use the numerics and it is correctly sending the street address & postcode separately.

 

Tom

[UncleSteve]

I've just had a look at the protx form code - it doesn't include any CR in the address format.

 

Try finding this code:

snip

and changing to:

snip

This should format the address correctly, but I don't see that having any impact on AVS check since they only use the numerics and it is correctly sending the street address & postcode separately.

 

Tom

Hi Tom,

 

I've change my code to your's, and that's added the CR's. :D

 

Due to my host messing me around (who switched off 'Register Globals' a couple of weeks a go which killed my site - without notice!!!), I've had small problems all over the site after getting it back up. One was the Protx payment would go through (bar the error above), but none of the OSC emails were being sent, that was cured with some extra code I found to add to the Protx code. However one of the errors still remaining is that the 'County' isn't forwarded to some places like the Protx script above. (it gets forwarded to the customer email, but not the vendors email!). The same goes for the 'Country', however where there is no country code, it leaves the number '2' in its place! Perhap its this error that is causing the 'numerics not matched' problem (I hadn't thought of it before).

 

Perhaps a fresh post is required to sort the end of address problem, unless you have some ideas please.

 

Thanks for your input and help :)

 

Steve

[GemRock]

...my host messing me around (who switched off 'Register Globals' a couple of weeks a go which killed my site...

That's one piece of the missing crucial info: turning it off would break a lot of things as far as the current version of osc is concerned. From what I can see and my own experience from live sites that use protx form tells me that protx form doesnt need these added line feeds. If there is such a need then thats an indication of sometnig wrong somewhere on the site, albeit difficut if not impossible to say where or what without actually working on the site.

 

Ken

[UncleSteve]

That's one piece of the missing crucial info: turning it off would break a lot of things as far as the current version of osc is concerned. From what I can see and my own experience from live sites that use protx form tells me that protx form doesnt need these added line feeds. If there is such a need then thats an indication of sometnig wrong somewhere on the site, albeit difficut if not impossible to say where or what without actually working on the site.

 

Ken

I've now clearly established that adding the CR code given above tidies the layout of the address, however it doesn't cure the 'numerics not matched' problem.

 

Poking around further, I found a problem with the lack of information being passed over to the Protx site. As pointed out in my previous post, the 'county' is not being forwarded, neither is the 'country', though it's being replaced with '2'! To overcome the Protx site looking for these missing fields, I commented them out in protx_form.php Now I don't get the error messages :D

 

Yes I do have a problem remaining on my site, but at least I've crossed another issue off my list :) The address problem, I have now listed under a fresh topic here http://www.oscommerce.com/forums/index.php?showtopic=251264 where I have given further details of he problem.

 

Steve