pixi

Address Import Rules

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.

Back to top

Examples

In the following table you can find some examples of address information and how they are processed:

XML Tag <STREET>

Street

House Number

<STREET>219-241 Cleveland St</STREET>
<COUNTRY>Australia</COUNTRY>

219-241 Cleveland St

empty

<STREET>12 rue de la montagne</STREET>
<COUNTRY>France</COUNTRY>

12 rue de la montagne

empty

<STREET>Rue du Vivier 7C bte 5</STREET>
<COUNTRY>Belgium</COUNTRY>

Rue du Vivier 7C bte 5

empty

<STREET>485 5th Avenue at 41st Street</STREET>
<COUNTRY>United States</COUNTRY>

485 5th Avenue at 41st Street

empty

<STREET>poslovna cona 2a</STREET>
<COUNTRY>Slovenia</COUNTRY>

poslovna cona

2a


Back to top

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

<STREET>Berliner Ring 27</STREET>

Berliner Ring

27

<STREET>Berliner Ring 27a</STREET>

Berliner Ring

27a

<STREET>Hindenburgdamm 19 a</STREET>

Hindenburgdamm

19 a

<STREET>Hindenburgdamm 19 A</STREET>

Hindenburgdamm

19 A

<STREET>Hochstraße 56/58</STREET>

Hochstraße

56/58

<STREET>Hochstraße 56 - 58</STREET>

Hochstraße

56 - 58

<STREET>Universitätsplatz 274a Appartment Müller</STREET>

Universitätsplatz 274a Appartment Müller

empty

<STREET>Universitätsplatz 15a Tor I</STREET>

Universitätsplatz

15a Tor I

<STREET>Universitätsplatz 215a Tor I</STREET>

Universitätsplatz 2

15a Tor I

<STREET>9., Gasse</STREET>

empty

9., Gasse


Back to top