Categories
View Replies (35)

Resolved Install problem on RO CSVI

  1. PattiH
    PattiH
  2. RO CSVI
  3. Monday, 04 July 2022
  4.  Subscribe via email
I am moving a site from one hosting company to another. I am doing a clean install to get rid of all the junk accumulated over the years. I've updated the old site to Joomla 3.10.10 and installed the same on the new site. I was hoping to use RO CSVI to export the articles and convert K2 items and import them into the new site. But when I install RO CSVI on the old site, I get the message that the plugin is activated, but a warning: "Could not record the package ID for this package's extensions." I do not see the RO CSVI under the "Components." I have also installed it in the new Joomla site, and I do see it there. I have tried exporting the "content" from phpMyAdmin from the old site, but it times out when I attempt to import it (csv) on the new site.

The articles are not so numerous that I could not replicate them manually on the new site, but it makes me cry to think of manually converting the almost 1500 K2 items.
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Patti,
I did run the solution for categories and that did enable me to export the categories and import them into the new site.

Not sure why but language field was empty instead of *.

The export does now work, but when I try to import the K2 items export csv into the new site, I get this

That is because you have set wrong Component and Operation on Details tab. See attached screenshot. I have changed it to K2 component and Item operation. Your import should work now. Please check.
Attachments (1)
Screenshot 2022-07-15 at 7.12.03 PM.png Screenshot 2022-07-15 at 7.12.03 PM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (35)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Patti,
Thank you for your kind words. We are glad to know that issues are solved and import went good. Please rate us with a review on Joomla Extension Directory :)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
PattiH
PattiH
Accepted Answer Pending Moderation
Oh, goodness, what a stupid mistake! But unless there is something unexpected I'm not seeing, they appear to have imported correctly! I can't think you enough. Your customer support has been wonderful.

Patti
  1. more than a month ago
  2. RO CSVI
  3. # 2
PattiH
PattiH
Accepted Answer Pending Moderation
For access to new site, see below.
  1. more than a month ago
  2. RO CSVI
  3. # 3
PattiH
PattiH
Accepted Answer Pending Moderation
I did run the solution for categories and that did enable me to export the categories and import them into the new site.

The export does now work, but when I try to import the K2 items export csv into the new site, I get this
Attachments (1)
K2ItemsError4.jpg K2ItemsError4.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Patti,
Did you run the solution I gave in the reply earlier here?

When I ran the Custom table export of K2 Categories, the language field value empty for most of the fields instead of *. So I ran custom table import and updated the language field. Now there is no error ""Cannot load the category path for category ID 2 and language *" with K2 Items export. Please check the export and let me know.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
PattiH
PattiH
Accepted Answer Pending Moderation
I'm sorry. I thought that the log would tell you. It says "(for 1476 lines) "the action is "incorrect," the result is "failure" and the message is "Cannot load the category path for category ID 2 and language *"

If I remove itemID and titleAttribute, the same thing occurs.

Thank you.
Attachments (1)
K2ItemsError3.jpg K2ItemsError3.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Patti,
You did not tell us the error you are having with the export. What if you remove the fields itemID and titleAttribute from export fields and run the export? Does the export finish without any error?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
PattiH
PattiH
Accepted Answer Pending Moderation
Thank you for your continued help. I loaded the patch file. The K2 items export failed however. I have attached the log file.
Attachments (1)
K2Items-com_csvi.log.55.zip
  1. more than a month ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Patti,
Are those in addition to other fields? Or I should export using ONLY those fields? As far as I know none of my K2 items have attachments.

Yes those are additional fields and can be added along with other export fields. These fields are specific to K2 attachments data and if you are sure that you do not have attachments or don't want to export attachments data you can remove these fields from export.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
PattiH
PattiH
Accepted Answer Pending Moderation
I haven't done anything yet. Thanks for your efforts. But I have a question about the fields you say to use in the export file. Are those in addition to other fields? Or I should export using ONLY those fields? As far as I know none of my K2 items have attachments.
  1. more than a month ago
  2. RO CSVI
  3. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Patti,
Thank you for posting the debug log. I was able to see the cause for the error. Please load the attached patch file and run the export. Also, to export K2 item attachments data use fields attachments_filename, attachments_hits, attachments_title and attachments_titleAttribute in export template. Let me know on how the export goes with patch file.
Attachments (1)
patch_k2_2022_07_13.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
PattiH
PattiH
Accepted Answer Pending Moderation
OK, here you go. I should have thought of doing that. I just saw that there was no log and forgot it had to be turned on for each template.
Attachments (1)
K2Items-com_csvi.log.55.zip
  1. more than a month ago
  2. RO CSVI
  3. # 12
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Patti,
Please post export debug log to check. To get the debug log check How to collect debug information? document.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 13
PattiH
PattiH
Accepted Answer Pending Moderation
Thank you. That worked. But now (of course!) I'm having problems exporting the K2 items. I have selected all fields except those asking for created by or modified by.

I tried removing "filename" from the fields, but I just got a different error for not finding "itemID"

Thank you.
Attachments (2)
K2ItemsError.jpg K2ItemsError.jpg
K2ItemsError2.jpg K2ItemsError2.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 14
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for posting the requested file. Found the cause for error "Cannot load the category path for category ID X and language *". In your #__k2_categories the language field is empty but RO CSVI looks for language with value * in query. Since that row is not found you are seeing the error on export.

To solve this
1. In the export file ChristianCoMOGen-CSVI-CustomExport.csv you sent, update the language column value to * for all rows.
2. Create RO CSVI Custom table import template.
3. On Options tab set the table to k2_categories table and import based on field to id. See attached screenshot.
4. Run the import with updated ChristianCoMOGen-CSVI-CustomExport.csv file.
5. Run K2 categories export after that.
Attachments (1)
Screenshot 2022-07-12 at 10.35.33 AM.png Screenshot 2022-07-12 at 10.35.33 AM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 15
PattiH
PattiH
Accepted Answer Pending Moderation
OK, here you go. Thanks so much.
Attachments (1)
ChristianCoMOGen-CSVI-CustomExport.csv
  1. more than a month ago
  2. RO CSVI
  3. # 16
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Patti,
The below query for selecting the categories is failing and so the error. I would like to see how the categories are stored in K2 table. Please run custom table export of #__k2_categories table with template fields id, name, parent, language and send me the export file to check. 



SELECT `c`.`parent`,`c`.`name` FROM `n2z6y_k2_categories` AS `c` LEFT JOIN `n2z6y_k2_categories` AS `x` ON `x`.`parent` = `c`.`id` WHERE `c`.`id` = 2 AND `c`.`language` = '*'
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 17
PattiH
PattiH
Accepted Answer Pending Moderation
This is for exporting K2 categories. I have tried various things in adding and removing fields, and I still get the error "Cannot load the category path for category ID X and language."
Attachments (1)
ForK2CategoryExport5com_csvi.log.42.zip
  1. more than a month ago
  2. RO CSVI
  3. # 18
PattiH
PattiH
Accepted Answer Pending Moderation
OK, Yay! Joomla articles successfully imported. Thanks so much. Now moving on to K2.
  1. more than a month ago
  2. RO CSVI
  3. # 19
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Patti,

I found by looking at the table in phpMyAdmin that the main content area was in the "intro text" field.
That is correct, it is a bit counter-intuitive but it is because of historical reasons the name is like that. We have this field also in our Content import documentation.

But now all the fields are not aligned properly (the right text is not in the right column).
That is because your regular text will also include commas. To deal with this in your export template you need to set both the field delimiter and text enclosure on the File tab. As per the CSV standard, the field delimiter is a comma ( , ) and the text enclosure is a double quote ( " ). If you set those in your export template and run the export, the data will properly align. Once that is fixed, you should be able to import your file.

Let us know how it goes.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


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