Keyword

Tool for importing / exporting items to / from K2

More
10 years 2 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
10 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
10 years 2 months ago - 10 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
10 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
10 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
10 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
10 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
10 years 2 months ago - 10 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
10 years 1 month 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
10 years 1 month ago - 10 years 1 month 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.


Powered by Kunena Forum