importing custbranchcode restrictions

[Bill Schlaerth]

When setting up Cust Branch Records we found we could use - (dash) as part of he custbranchcode. However when we import using the dash with the Z_ImportDebtors.php as a custbranchcode (eg. 10958-00) we receive the following messages:


ERROR Message Report : The Branch code cannot contain any of the following characters - & \' < >

ERROR Message Report : Failed on row 1. Batch import has been rolled back.


So is a dash allowed or not? It is allowed in the Stock Code (different import)

Both are version 4.12.2

We have tested / and that does allow for import.

Was this an earlier restriction that has gone or dependent on the database engine being used?

Thanks Bill

[Exsonqu_Qu]

Hi, Bill,

The not allowed code is : + plus, ” quotation mark, &, ' single quotation mark, \ back slash, ? question mark, . dot.
You should check if it contains above characters. slash is allowed.

Best regards!

Exson

[TimSchofield]

Hi Bill, you are quite correct Z_ImportDebtors.php is inconsistent with CustomerBranches.php. Line 436 of Z_ImportDebtors.php should be changed to

if (ContainsIllegalCharacters($_POST['BranchCode']) OR mb_strstr($_POST['BranchCode'],' ')) {

Thanks
Tim

[agaluski]

Not allowing a & is problematic as we have vendors with that official name