Skip to main content
Solved

Error on State when importing site contacts in Astea v15.3.0.1

P
Sidekick (Customer)
Forum|alt.badge.img+9

We do not use States/Provinces when importing sites, it is also not defined as a mandatory field. The site import site went through in 2 steps: first with GIS validation on, which results in some sites with an address validation error and second step, the errored sites with GIS services off. But when importing the site contacts, we got errors on some sites in Italy and Swiss: The “state Lombardia is not in country IT. Please use lookup. -(API Error)” It was only on some sites, not on all sites imported in this countries.

  • Why this error on a non mandatory field ? And why on some sites and not on all sites in the same country ? We imported sites in several countries in Europ.

The only way to continue was to create the requested states for Italy and Swiss.

  • my next question is where can I find the correct way to import the sites ? I found out that I had to use the same syntax the error showed.

Best answer by Phil Seifert

Hi Piet,

You may want to experiment with the following setting in the configuration editor whether it handles your request or not.

 

View original
    Did this topic help you find an answer to your question?

    6 replies

    A
    Hero (Employee)
    Forum|alt.badge.img+10

    To better understand the issue, do you have the State\Province defined in your import template for the site, or is the GIS address validation finding a State\Province and populating that field automatically during import?

    P
    Sidekick (Customer)
    Forum|alt.badge.img+9
    • PDesrumaux
    • Author
    • Sidekick (Customer)
    • 40 replies
    • August 27, 2021

    The State\Province isnot defined in the import template for the site, the GIS address validation populates that field automatically during import.

     

    P
    Sidekick (Customer)
    Forum|alt.badge.img+9
    • PDesrumaux
    • Author
    • Sidekick (Customer)
    • 40 replies
    • August 30, 2021

    Is there a standard to populate the state/provinces so the GIS validation doesn’t give an error at import or do I have to create the state retroactive each time an error occurs ?

    Or can the population of the state/province field be excludes during the GIS validation as it is a non mandatory field ?

    Phil Seifert
    Ultimate Hero (Employee)
    Forum|alt.badge.img+24
    • Phil Seifert
    • Ultimate Hero (Employee)
    • 1341 replies
    • Answer
    • September 3, 2021

    Hi Piet,

    You may want to experiment with the following setting in the configuration editor whether it handles your request or not.

     

    Please mark any comments which answered your question as Best Answer so the topic is easier recognised as answered and closed.
    bskallerud
    P
    2 people like this
    • bskallerud
      bskallerud
    • P
      PDesrumaux
    P
    Sidekick (Customer)
    Forum|alt.badge.img+9
    • PDesrumaux
    • Author
    • Sidekick (Customer)
    • 40 replies
    • November 9, 2021

    I left only US and CA as an exception in both rules and had no further errors on importing site or contact.

    Will those settings in the configuration editor be overwritten when we install a HF or upgrade to a new version ?

    Phil Seifert
    Ultimate Hero (Employee)
    Forum|alt.badge.img+24
    • Phil Seifert
    • Ultimate Hero (Employee)
    • 1341 replies
    • November 9, 2021

    No, these changes are not modified in the global.xml by later updates such as HFx, etc.  Even if they were, you would have backup copies on your server in the AsteaShare folder which are made every time there is a modification made to the global.xml.

    Please mark any comments which answered your question as Best Answer so the topic is easier recognised as answered and closed.

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings