Simplify adding of cities, regions and countries
« on: February 09, 2025, 11:24:55 PM »
Process of adding of cities, regions and countries needs to be simplified. Import SQL file with easy structure.
« Last Edit: February 13, 2025, 08:45:02 PM by Oleksandr Kravchuk »

*

MB Themes

Re: Simplify adding of cities, regions and counries
« Reply #1 on: February 10, 2025, 06:48:13 AM »
Osclass already support importing data via sql, structure is based on table structure
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

Re: Simplify adding of cities, regions and countries
« Reply #2 on: February 10, 2025, 10:53:51 AM »
I get error when I add "s_name_native".
« Last Edit: February 11, 2025, 07:09:06 PM by Oleksandr Kravchuk »

*

MB Themes

Re: Simplify adding of cities, regions and countries
« Reply #3 on: February 12, 2025, 02:58:57 PM »
You have it in data?
You will need to provide much more details than you did...
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

Re: Simplify adding of cities, regions and countries
« Reply #4 on: February 13, 2025, 09:02:01 PM »
REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES
('UA', 'Ukraine', 'Україна', 'ukraine', '380', 'UAH');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, s_name_native, b_active, s_slug) VALUES
(3686966, 'UA', 'Zhytomyr Obl.', 'Житомирська обл.', 1, 'zhytomyr-obl'),

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, s_name_native, b_active, s_slug, d_coord_lat, d_coord_long) VALUES
(3686967, 3686966, 'UA', 'Zhytomyr', 'Житомир', 1, 'zhytomyr', 50.26487, 28.67669),

Osclass understand s_name_native in t_country, but not in t_region and t_city.

*

MB Themes

Re: Simplify adding of cities, regions and countries
« Reply #5 on: February 14, 2025, 12:38:28 PM »
Then you probably do not have it in table definitions.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots