1. Cyril Yuzov
  2. RO CSVI
  3. Monday, 03 February 2020
  4.  Subscribe via email
Hello!
Yesterday on your demo site i tried to import joomla categories and articles and had weird thing. Maybe it's because of Russian symbols?

When i tried to import articles categories didnt create at all.
When i tried to import categories (file below) new categories appeared, but with incorrect structure. Also i get error Another category with the same parent category has the same alias

My file

~Иордания~^~iordaniya~^~Туры/Азия/Иордания~^~1~
~Индонезия~^~indoneziya~^~Туры/Азия/Индонезия~^~1~
~Индия~^~indiya~^~Туры/Азия/Индия~^~1~
~Зимбабве~^~zimbabve~^~Туры/Африка/Зимбабве~^~0~
~Китай~^~izrail~^~Туры/Азия/Китай~^~1~
~Египет~^~egipet~^~Туры/Африка/Египет~^~1~


It takes me this structure:
Туры
- Азия
Азия
- Иордания
Индонезия
etc

Instead of
Туры
-Азия
--Иордания
--Индонезия
etc

I tried a looooot of different variants with an without aliases, title, last item after / sign, but nothing works. Why?
Accepted Answer Pending Moderation
Hello,
Yesterday on your demo site i tried to import joomla categories and articles and had weird thing. Maybe it's because of Russian symbols?

If your file is UTF8 encoded there should be no problem in processing your file with Russian symbols.

I tried a looooot of different variants with an without aliases, title, last item after / sign, but nothing works. Why?

Can you post your import debug log to check? To get the debug log check How to collect debug information? document.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Yes, please
Attachments (1)
  1. 3 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Yesterday on your demo site i tried to import joomla categories and articles and had weird thing. Maybe it's because of Russian symbols?

If your file is UTF8 encoded there should be no problem in processing your file with Russian symbols.

I tried a looooot of different variants with an without aliases, title, last item after / sign, but nothing works. Why?

Can you post your import debug log to check? To get the debug log check How to collect debug information? document.


Maybe its because of demo site? But i don't want to buy it without test.
  1. 3 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,
We did a small fix to Joomla categories code and it has been uploaded to demo site. You can run your import and check. Please remember demo site data gets reset every 6 hours so your template and logs are lost on reset. You need to create a new template for your import and check. Try the import and let us know on how it goes.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Yes, now it works great!
Also there was a problem with creating categories when i import only products with categories paths.

For example

~name~^~Изображение~^~Алиас~^~parent~^~link_created~
~Далянь - город романтиков, актуально - 2014г~^~images/tours/534.jpg~^~1878-dalyan-gorod-romantikov-aktualno-2014g~^~Tury/Aziya/Kitaj~^~2015-03-26 15:26:26~
~Новогодний тур в Гонконг 2018~^~images/tours/2087.jpg~^~2650-spetsialnoe-predlozhenie-gonkong-29-400-r-aviaperelet-prozhivanie-vklyucheny-v-stoimost~^~Tury/Aziya/Kitaj/Gonkong~^~2015-03-10 08:13:30~
~Ramada Plaza Gateway Shanghai~^~images/tours/1750.jpg~^~988-ramada-plaza-gateway-shanghai~^~Oteli~^~2014-11-08 23:57:31~


This articles import doesn't create categories like i expected. Is it correct?
  1. 3 weeks ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
However almost correct. I tried import this file below. I got categories with correct structure, but also i got server timeout when import.

~cat_name~^~alias~^~cat_parent~^~cat_published~
~Туры~^~tury~^~~^~1~
~Азия~^~aziya~^~Туры/Азия~^~1~
~Иордания~^~iordaniya~^~Туры/Азия/Иордания~^~1~
~Индонезия~^~indoneziya~^~Туры/Азия/Индонезия~^~1~
~Индия~^~indiya~^~Туры/Азия/Индия~^~1~
~Зимбабве~^~zimbabve~^~Туры/Африка/Зимбабве~^~0~
~Израиль~^~izrail~^~Туры/Азия/Израиль~^~1~
~Египет~^~egipet~^~Туры/Африка/Египет~^~1~
~Австралия и океания~^~avstraliya~^~Австралия и океания~^~1~
~Австралия~^~avstraliya~^~Туры/Австралия и океания/Австралия~^~1~
~Аргентина~^~argentina~^~Туры/Америка/Аргентина~^~1~
~Армения~^~armeniya~^~Туры/Европа/Армения~^~1~
~Багамские острова~^~bagamskie-ostrova~^~Туры/Америка/Багамские острова~^~1~
~Беларусь~^~belarus~^~Туры/Европа/Беларусь~^~0~
~Бельгия~^~belgiya~^~Туры/Европа/Бельгия~^~1~
~Болгария~^~bolgariya~^~Туры/Европа/Болгария~^~1~
~Бразилия~^~braziliya~^~Туры/Америка/Бразилия~^~1~
~Великобритания~^~velikobritaniya~^~Туры/Европа/Великобритания~^~1~
~Венгрия~^~vengriya~^~Туры/Европа/Венгрия~^~1~
~Вьетнам~^~vetnam~^~Туры/Азия/Вьетнам~^~1~
~Германия~^~germaniya~^~Туры/Европа/Германия~^~1~
~Гонконг~^~gonkong~^~Туры/Азия/Гонконг~^~1~
~Греция~^~gretsiya~^~Туры/Европа/Греция~^~1~
~Гуам~^~guam~^~Туры/Австралия и океания/Гуам~^~1~
~Дания~^~daniya~^~Туры/Европа/Дания~^~1~
  1. 3 weeks ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Excuse me, now i don't have server timeout problem. Don't know why.
I'm ready to buy. Will you include fix in the zip or just attach here a file?
  1. 3 weeks ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Cyril,

Thank you for checking out RO CSVI.

This articles import doesn't create categories like i expected. Is it correct?
That is correct. This feature is on our to do list. Although this would just be a simple category creation like you see in Joomla article editing. You cannot import all the category details in an article import.

now i don't have server timeout problem. Don't know why.
That is the world of computing :D If you need to import large files, RO CSVI offers the option to import the file in smaller pieces. We have this explained in the Manage Timeouts article. Just in case you may need it in the future.

I'm ready to buy. Will you include fix in the zip or just attach here a file?
Yes, we will post the patch here for you and include it in the next release as well. So you can update without a problem when the new release comes out.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Ok, i've just bought extension :) Order id is 2000284227. Please send me the fix
  1. 3 weeks ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello Cyril,
Thank you for your order. I have attached a patch file with the fix in the post. You can load the patch file and run the import.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
I've updated file, but still have errors.
My file

~cat_name~^~alias~^~cat_parent~^~cat_published~
~Азия~^~aziya~^~Туры/Азия~^~1~
~Иордания~^~iordaniya~^~Туры/Азия/Иордания~^~1~
~Индонезия~^~indoneziya~^~Туры/Азия/Индонезия~^~1~
~Индия~^~indiya~^~Туры/Азия/Индия~^~1~
~Зимбабве~^~zimbabve~^~Туры/Африка/Зимбабве~^~0~
~Израиль~^~izrail~^~Туры/Азия/Израиль~^~1~
~Египет~^~egipet~^~Туры/Африка/Египет~^~1~
~Австралия и океания~^~avstraliya~^~Туры/Австралия и океания~^~1~
~Австралия~^~avstraliya~^~Туры/Австралия и океания/Австралия~^~1~
~Аргентина~^~argentina~^~Туры/Америка/Аргентина~^~1~
~Армения~^~armeniya~^~Туры/Европа/Армения~^~1~
~Багамские острова~^~bagamskie-ostrova~^~Туры/Америка/Багамские острова~^~1~
~Беларусь~^~belarus~^~Туры/Европа/Беларусь~^~0~
~Бельгия~^~belgiya~^~Туры/Европа/Бельгия~^~1~
~Болгария~^~bolgariya~^~Туры/Европа/Болгария~^~1~
~Бразилия~^~braziliya~^~Туры/Америка/Бразилия~^~1~
~Великобритания~^~velikobritaniya~^~Туры/Европа/Великобритания~^~1~
~Венгрия~^~vengriya~^~Туры/Европа/Венгрия~^~1~
~Вьетнам~^~vetnam~^~Туры/Азия/Вьетнам~^~1~
~Германия~^~germaniya~^~Туры/Европа/Германия~^~1~
~Гонконг~^~gonkong~^~Туры/Азия/Гонконг~^~1~
~Греция~^~gretsiya~^~Туры/Европа/Греция~^~1~
~Гуам~^~guam~^~Туры/Австралия и океания/Гуам~^~1~
~Дания~^~daniya~^~Туры/Европа/Дания~^~1~


My log and screenshot in attach.

Issues:
1. I've already had category "Туры" with alias "tury". After import i get another one "Туры" with alias "туры". But i wait just for update for "Туры" with alias "tury".
2. Also, as you can see we have two "Азия" with the same problem.
3. "Австралия и океания" also have russian alias, not transliterated.
4. "Гуам" has no parent categories at all.
Attachments (2)
  1. 3 weeks ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Cyril,
Fixed few more issues with Joomla categories import. Please load the attached patch file with modifications. Let me know if all of the issues you mentioned above are fixed with the patch file.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
It's almost good now, but second level cats are dublicated (Европа, Азия etc) with same alias. There are only 5 of them, so it's ok. But i attach log file if you can fix it too.
But i have bigger problem with articles import :( Articles appear without category. The same issue i've already saw at demo site. I attached log and screen too.
Attachments (4)
  1. 3 weeks ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello,
It's almost good now, but second level cats are dublicated (Европа, Азия etc) with same alias. There are only 5 of them, so it's ok. But i attach log file if you can fix it too.

I see Европа and Азия in first level and second level in the screenshot. They are not in same level, Joomla does not allow same alias if the category is in same level.

But i have bigger problem with articles import :( Articles appear without category. The same issue i've already saw at demo site. I attached log and screen too.

Can you also post your import file?. Debug log shows it looks for a category id from category_path. I will run import here and check the articles and its categories. One issue i am seeing in the debug log is about images. It shows File not found: /home/c/cb12099/frega/public_html/images/tours/tours/1775.jpg for most of the images. Are these images in the given path?
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Yes, please check it.
There is no Туры/Европа or Туры/Азия at all, so i dont understand why they appear second time like second level categories without subcategories.
I know about images, its ok for now, i will fix it later.
Attachments (2)
  1. 3 weeks ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello,
Yes, please check it.

Thank you for sending the import file. I was able to reproduce your issue. The strange part is that these article import issues were hidden and were never noticed. Please load the attached patch file and run your Joomla article import again. Check if your articles are assigned to categories.

There is no Туры/Европа or Туры/Азия at all, so i dont understand why they appear second time like second level categories without subcategories.

But i see most of the categories with Туры/Европа and Туры/Азия as parents. I also found Азия as parent level category in your import file. See attached screenshots.
Attachments (3)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Yes, you are right about my categories.
Thank you, now everything seems fine :)
  1. 3 weeks ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Hello,
Glad to know that your issues are solved. Please leave us a review on Joomla Extension Directory:)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 18
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!