- Posts: 3
COMMUNITY FORUM
Tool for importing / exporting items to / from K2
- Cynthia Turcotte
- Offline
- New Member
Less
More
10 years 9 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
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
Less
More
- Posts: 63
10 years 9 months ago #58851
by Felipe
Replied by Felipe on topic Re: Tool for importing / exporting items to / from K2
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, 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
10 years 9 months ago - 10 years 9 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 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
10 years 9 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
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
Less
More
- Posts: 63
10 years 8 months ago #58854
by Felipe
Replied by Felipe on topic Re: Tool for importing / exporting items to / from K2
:angry: I didn't receive a notification for a new answer on this topic!
I will download the Joomla 3 version right away!
I will download the Joomla 3 version right away!
Please Log in or Create an account to join the conversation.
- Felipe
- Offline
- Senior Member
Less
More
- Posts: 63
10 years 8 months ago #58855
by Felipe
Replied by Felipe on topic Re: Tool for importing / exporting items to / from K2
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.
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
10 years 8 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.
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
Less
More
- Posts: 63
10 years 8 months ago - 10 years 8 months ago #58857
by Felipe
Replied by Felipe on topic Re: Tool for importing / exporting items to / from K2
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
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
10 years 8 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.
- chiba
- Offline
- New Member
Less
More
- Posts: 2
10 years 8 months ago - 10 years 8 months ago #58859
by chiba
Replied by chiba on topic Re: Tool for importing / exporting items to / from K2
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
Please Log in or Create an account to join the conversation.