Support Forums - Classified Ads Script Osclass
General osclass questions => General discussion => Topic started by: Oleksandr Kravchuk on November 06, 2023, 03:08:01 AM
-
I want to help to translate to Ukrainian language. Please translate the following:
Register - Зареєструватися;
Publish Ad - Подати оголошення;
What are you looking for today? - Що ви шукаєте сьогодні?;
Keyword - Ключове слово;
All locations - Всі локації.
-
No idea what you want, use google translate for string translations.
-
Awesome ;)
-
Можу допомогти з українським
-
Yes and no.
That is reason why you can modify locations in your backoffice.
-
You can do it by yourslef in backoffice, you are already big boy, does not need assistance for that.
-
I translated cities in backoffice, but it does not show up.
-
https://docs.osclasspoint.com/translate-osclass-locations
-
Thanks
-
How can I share translation of cities to community?
-
Export city, region & country tables and you may share it here.
-
Thanks ;)
-
It's used more and more by different features.
-
;)
-
I added missing coordinates.
-
Cool :)
-
Depends from where it comes. Could be in core.po, messages.po or admin.po
-
Just update the cope.po file, the missing lines will appear automatically.
-
Please update tables that I provided above. I need to make a new install of an Osclass with those updates.
-
I need help.
-
Me too.
What is yours about?
-
Can you update cities in Ukraine? I uploaded above in attached file. I will pay for that.
-
No.
You can update existing SQL file based on your need and import again.
https://osclass-classifieds.com/geolocation
-
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),
Am I doing correct in UA-Ukraine.sql? I added s_name_native.
-
I tried to import above sql file and it gives an error. I deleted Ukraine and it gives an error. Then deleted second time successfully. Imported country from Osclass. And I found that all of my listings deleted.
-
Because of only English for locations I cannot use Osclass in Ukraine.
-
File looks OK.
If you remove location, all listings on that location are removed.
-
SQL file gives an error. Try to import and see what is wrong.
-
Sorry what SQL file?
-
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),
-
There should be no replace and at the end should be semicolon.
Besides that I do not see problem.
-
I get error when I add "s_name_native".