Keyword

Tool for importing / exporting items to / from K2

More
11 years 3 months ago #58850 by Cynthia Turcotte
Replied by Cynthia Turcotte on topic Re: Tool for importing / exporting items to / from K2
This plugin works great...eventually. I ran into 2 problems though:

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.

More
11 years 2 months ago #58851 by Felipe
Hi Individual IT,

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
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
11 years 2 months ago - 11 years 2 months ago #58852 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
@Cynthia Turcotte Sorry images are not exported in the currect version. That feature might come in the next version
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
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
11 years 2 months ago #58853 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Finally I got the version for Joomla 3.x published: extensions.joomla.org/extensions/extension-specific/k2-extensions/12408

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.

More
11 years 2 months ago #58854 by Felipe
:angry: I didn't receive a notification for a new answer on this topic!
I will download the Joomla 3 version right away!

Please Log in or Create an account to join the conversation.

More
11 years 2 months ago #58855 by Felipe
This extension works as advertised!
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
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
11 years 2 months ago #58856 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hi Filipe,
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.

More
11 years 2 months ago - 11 years 2 months ago #58857 by Felipe
I can use any of the export format options of phpMyAdmin ( 4.0.8 ) to export the table zoo_item. OpenDocument Spreadsheet works fine.
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

Attachments:

Please Log in or Create an account to join the conversation.

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
11 years 2 months ago #58858 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
That data inside "elements" is JSON format. So you would need something to decode that. For example you could write a simple PHP script that gets the rows from the database, decodes the JSON and put all data in the correct columns

Please Log in or Create an account to join the conversation.

More
11 years 2 months ago - 11 years 2 months ago #58859 by chiba
Good day. bought component K2 Import / Export 1.1 & 2.0_rc1, but when I edit csv file (even the replacement of one character in the text material K2) and saving it again in csv through liber / Openoffice halyard is not imported, or rather after click Import,then continue writes "Fatal error: Call to undefined function _ () in Z: \ home \ localhost \ www \ videoguard \ administrator \ components \ com_k2import \ models \ k2import.php on line 1416"


Attachment not found

Attachments:

Please Log in or Create an account to join the conversation.

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
11 years 2 months ago #58860 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
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.

More
11 years 2 months ago #58861 by chiba

Individual IT wrote: Hi,
the values in the file are separated by tabs, not by comma thats the problem

Thanks!

Please Log in or Create an account to join the conversation.

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
11 years 2 months ago #58862 by Individual IT

Please Log in or Create an account to join the conversation.

More
11 years 1 month ago #58863 by Felipe
I tried that with a programmer but it was impossible. Right now, it is impossible to migrate my Zoo articles to K2 (Joomla 3.2)

Please Log in or Create an account to join the conversation.

More
11 years 1 month ago #58864 by TECH SUPPORT
I test the module in localhost XAMPP

• 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
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
11 years 1 month ago #58865 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hallo Alex,
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.

More
11 years 1 month ago #58866 by TECH SUPPORT
Thank you for your reply.

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
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
11 years 1 month ago #58867 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
At the moment the only way to split exports is to export category by category. If you category is huge you have to increase the different limits im PHP or delete e.g. coments, they need a lot of ressources to be exported

Please Log in or Create an account to join the conversation.

More
11 years 1 month ago #58868 by Per Mork
Hi, I just have a question: I have a newspage made with K2 in joomla 2.5, which now contains over 300 items, but I have been forced to recreate the site with a joomla 3.2 and K2. Is it possible with your solution to transfer all the items from the J2.5 page to the new J3.2 site?

Please Log in or Create an account to join the conversation.

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
11 years 1 month ago #58869 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Yes that should be possible with some limitations:
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.


Powered by Kunena Forum