In case the whole customer address is provided in the <STREET> tag in the XML, then pixi* follows several rules in order to parse the information correctly to the corresponding fields in pixi*. There are different rules for addresses in Germany and foreign countries.
Those rules are used in the following order import elements of the XML:
Address Import for foreign Countries
Since there is no unified structure of foreign country addresses, the whole address is imported to the "Street" field in case of uncertanty. The following rules are used for those addresses:
If the address consists of several strings and the last string is longer than or equals 12 characters,
the whole address is imported into the "Street" field - "House Number" will be empty.If the address consists of several strings, the last string is shorter than 12 characters and it doesn't start with a number,
the whole address is imported into the "Street" field - "House Number" will be empty.If the address consists of several strings, the last string is shorter than 12 characters, it starts with a number and there is another string that contains a number, the whole address is imported into the "Street" field - "House Number" will be empty.
If the address consists of several strings, the last string is shorter than 12 characters, it starts with a number and there is no another string that contains a number, the last string is imported into the "House Number" and everything before the last string is imported into the "Street" field.
Examples
In the following table you can find some examples of address information and how they are processed:
XML Tag <STREET> |
Street |
House Number |
|
219-241 Cleveland St |
empty |
|
12 rue de la montagne |
empty |
|
Rue du Vivier 7C bte 5 |
empty |
|
485 5th Avenue at 41st Street |
empty |
|
poslovna cona |
2a |
Address Import for Germany
In case the XML contains address data with country Germany, the following rule is used:
If the last 9 characters contain a digit, everything starting from the digit will be imported into the "House Number" field.
Everything before is imported into the "Street" field.If the last 9 characters don't contain a digit, the whole address is imported into the "Street" field - "House Number" will be empty.
Examples
In the following table you can find some examples of address information and how they are processed:
XML Tag <STREET> |
Street |
House Number |
|
Berliner Ring |
27 |
|
Berliner Ring |
27a |
|
Hindenburgdamm |
19 a |
|
Hindenburgdamm |
19 A |
|
Hochstraße |
56/58 |
|
Hochstraße |
56 - 58 |
|
Universitätsplatz 274a Appartment Müller |
empty |
|
Universitätsplatz |
15a Tor I |
|
Universitätsplatz 2 |
15a Tor I |
|
empty |
9., Gasse |