webERP Forum

Full Version: import items with special characters in part number
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
We are trying to determine if certain characters can be imported.
The template has given us an error on ' & + " . (space) that these characters cannot be in the Part Number.

Is this an issue with the version PHP or MySQL.
The PHP doc says MyqSql 5.1.6 (and later) supports all characters for identifiers (indexes?) except ASCII null.

Is this a webERP restriction?

Thanks Bill
Hi Bill, it is a webERP restriction, Tim
(03-11-2015 03:09 AM)falkoner Wrote: [ -> ]Hi Bill, it is a webERP restriction, Tim

Thanks Tim that will save mea lot of digging. Bill
You can see the full range of disallowed characters in this function from includes/MiscFunctions.php:

function ContainsIllegalCharacters ($CheckVariable) {
if (mb_strstr($CheckVariable,"'")
OR mb_strstr($CheckVariable,'+')
OR mb_strstr($CheckVariable,'?')
OR mb_strstr($CheckVariable,'.')
OR mb_strstr($CheckVariable,"\"")
OR mb_strstr($CheckVariable,'&')
OR mb_strstr($CheckVariable,"\\")
OR mb_strstr($CheckVariable,'"')
OR mb_strstr($CheckVariable,'>')
OR mb_strstr($CheckVariable,'<')){
return true;
} else {
return false;
}
}

Tim
Reference URL's