OS Property support center

Can you explain me this message?

  • Jaime
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
11 years 8 months ago #39572 by Jaime
Can you explain me this message? was created by Jaime
Hello...

When trying to install sample data, this was shown:

(If there are not country, states and cities avaialble. Please setup the countries and import your location):

I am trying to install sample data for Chile. Who can explain me what to do next?

Thanks
Jaime

Please Log in or Create an account to join the conversation.

More
11 years 8 months ago #39574 by Dang Thuc Dam
Replied by Dang Thuc Dam on topic Re: Can you explain me this message?
Hi Jaime,
Please watch this video

It's the installation steps tutorial. And the "Install sample data" step is included in the clip also.
Thanks
Dam

Please Log in or Create an account to join the conversation.

  • Jaime
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
11 years 8 months ago - 11 years 8 months ago #39589 by Jaime
Replied by Jaime on topic Re: Can you explain me this message?
Thanks a lot...

however, there is an error. I imported information from Chile, and the following error occurs:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Higgins','39','91',0),(NULL,'Tortel','39','91',0),(NULL,'Cochrane','39','91',0)' at line 1 SQL=INSERT INTO jom_osrs_cities (id,city,country_id,state_id,published) VALUES (NULL,'O'Higgins','39','91',0),(NULL,'Tortel','39','91',0),(NULL,'Cochrane','39','91',0);

This was produced because we have the apostrophe in a name, which breaks the SQL. You should modify the algorithm to accept those cases. I have replaced the quote by two quotes in the txt file in order to import the data.

On the other hand, I have found another problem. When I tried to add sample data, after importing country information, Chile appears by default, with the State/Province dropdown box empty. I tried by adding a second country, for example, United States. In that case, country appears as a combobox. If I select USA, the State dropdown is filled, when I select Chile, dropdown is cleared.

Please see attached image.

Any help will be appreciated
Thanks

Jaime
Last edit: 11 years 8 months ago by Jaime.

Please Log in or Create an account to join the conversation.

More
11 years 8 months ago #39590 by Dang Thuc Dam
Replied by Dang Thuc Dam on topic Re: Can you explain me this message?
Hi,
It seems we have the problem with Chilean location file, please use this version of that file
Thanks
Dam

Please Log in or Create an account to join the conversation.

  • Jaime
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
11 years 8 months ago #39888 by Jaime
Replied by Jaime on topic Re: Can you explain me this message?
Hello...

I have imported the file you have sent and the same happen. No Chilean states or provices are shown.

Regards,
Jaime

Please Log in or Create an account to join the conversation.

More
11 years 8 months ago #39889 by Dang Thuc Dam
Replied by Dang Thuc Dam on topic Re: Can you explain me this message?
Hi Jaime,
Please submit ticket and send your site information with super admin acc, i will import the Chilean location for you
Thanks
Dam

Please Log in or Create an account to join the conversation.

  • Jaime
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
11 years 8 months ago #39893 by Jaime
Replied by Jaime on topic Re: Can you explain me this message?
done!!

Please Log in or Create an account to join the conversation.

  • Jaime
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
11 years 8 months ago #39930 by Jaime
Replied by Jaime on topic Re: Can you explain me this message?
Hello again... I want to warn you that the word "available" in the sentence that is subject of the this thread is badly spelled in the osProperty control panel import sample data module:

(If there are not country, states and cities avaialble. Please setup the countries and import your location)

Regards
Jaime

Please Log in or Create an account to join the conversation.

More
11 years 8 months ago #39934 by Dang Thuc Dam
Replied by Dang Thuc Dam on topic Re: Can you explain me this message?
Hi Jaime,
All the text of OS Property can be defined by using Translator labels feature at back-end of component, you can adjust the content by yourself
Thanks
Dam

Please Log in or Create an account to join the conversation.

  • Jaime
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
11 years 8 months ago #39937 by Jaime
Replied by Jaime on topic Re: Can you explain me this message?
Yes, I know, however I am telling you so that you can provide the software with the right text for the next releases.

Regards,
Jaime

Please Log in or Create an account to join the conversation.

Moderators: Dang Thuc DamNguyen Phu Quan