- Posts: 3
COMMUNITY FORUM
Tool for importing / exporting items to / from K2
- Cynthia Turcotte
-
- Offline
- New Member
1. The URL of the image that I uploaded for my K2 item (via the Image tab) did not export
2. When I try to import a single test item, it ends up importing that item and 20 or 30 rows of useless content.
This client is running K2 on a Joomla 2.5 installation
Thanks!
Cynthia
Please Log in or Create an account to join the conversation.
- Felipe
-
- Offline
- Senior Member
- Posts: 63
Please, when are you going to have the Joomla 3 version?
I so urgent need to export my Zoo articles to K2 or at least joomla articles.
Regards,
Felipe
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
Please check also hom many rows you have in your CSV file
@Felipe I've nearly finished a version for Joomla 3.x but it still has one bug I like to fix before I publish it. Please drop me an Email and I will send you the development version.
www.individual-it.net/en/kontakt-impressum.html
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
Additional there is a new version 1.0 for Joomla 1.5 till 2.x with some bugfixes
Use version 1.0 for Joomla 1.5 till 2.5
and version 2.0 for Joomla 3.x
Please Log in or Create an account to join the conversation.
- Felipe
-
- Offline
- Senior Member
- Posts: 63
I will download the Joomla 3 version right away!
Please Log in or Create an account to join the conversation.
- Felipe
-
- Offline
- Senior Member
- Posts: 63
Sadly, importing Zoo articles to K2 is a whole different and more tricky task.
This is so because when exporting the corresponding zoo_item table to csv or to open spreadsheet format, there is one column, "elements", that has several data on it:
- subtitle
- first text area (intro)
- second text area (main text)
- image url
among other important data.
So, what I can't do is to extract these data to different columns.
Besides, I exported the table on UTF-8 format, but the data inside this column is not on UTF-8 anyway.
Any ideas?
Regards,
Felipe Z.
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
how did you export the data from Zoo?
And how is the format of the "elements" column? can you post a line? maybe you can write a fancy LibreOffice formular to split it.
Please Log in or Create an account to join the conversation.
- Felipe
-
- Offline
- Senior Member
- Posts: 63
On LibreOffice I identified the "titles" of the data I'm interested in inside "elements" and "params" columns. For example, on my spreadsheet (I don't know if it changes for everyone) the "title" for textarea is "2e3c9e69-1f9e-4647-8d13-4e88094d2790" and the "title" for image url is "cdce6654-4e01-4a7f-9ed6-0407709d904c"...
Then, the trick is to separate these data on different columns.
I'm attaching the file. My original file has 1700 lines, this one only has ten lines (all the columns obviously).
Regards,
Felipe
Attachment not found
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
Please Log in or Create an account to join the conversation.
- chiba
-
- Offline
- New Member
- Posts: 2
Attachment not found
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
the values in the file are separated by tabs, not by comma thats the problem
Please Log in or Create an account to join the conversation.
- chiba
-
- Offline
- New Member
- Posts: 2
Thanks!Individual IT wrote: Hi,
the values in the file are separated by tabs, not by comma thats the problem
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
Please Log in or Create an account to join the conversation.
- Felipe
-
- Offline
- Senior Member
- Posts: 63
Please Log in or Create an account to join the conversation.
- TECH SUPPORT
-
- Offline
- New Member
- Posts: 2
• Joomla version 3.2.3.
• XAMPP
• K2 version K2 v2.6.8
• the K2 Import / Export tool version latest: com_k2import_2.0_rc1
I use the Import for K2 module to transfer K2 items from one website to another. I have K2 Extrafield Groups and Extra fields in K2.
Problem 1
I tried to export more than 2.300 K2 items from one K2 category and always have the same error: /…/administrator/index.php?option=com_k2import&format=raw The export hangs and nothing happened.
Problem 2
In categories with fewer K2 items I managed to export the data (with Extra fields etc.). When I Import the data all of the K2 items and Category are correct but no Extrafields and ExtraField groups imported.
Are there any solutions on those problems?
Thank you
Alex
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
exporting large sets can cause your server to run out of memory. Try to export category by category.
Before the export did you create the extra group in K2? and was the association correct during the import?
Please Log in or Create an account to join the conversation.
- TECH SUPPORT
-
- Offline
- New Member
- Posts: 2
I must first to create the Extra Fields and associate them. That is clear I' ve done it and it worked.
The problem with the category remain. I have more than a 2.000 items in one category. The module has not the ability to split a category for export in parts.
Do you have any other proposal to export large categories.
Thank you
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
Please Log in or Create an account to join the conversation.
- Per Mork
-
- Offline
- Junior Member
- Posts: 38
Please Log in or Create an account to join the conversation.
- Individual IT
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
1. some minor fields might not be transfered
2. images names are exported but you would need to transfer them to a place where you can access them from the new page and maybe modify the path in the export file
3. the structure of the categories is not exported. So the only way to import the complete structure is to create it first on the destnation system and have unique names for every single category. Then import with the option "recognize if the category already
exists regardless of the level"
Please Log in or Create an account to join the conversation.