COMMUNITY FORUM

Tool for importing / exporting items to / from K2

Individual IT
Topic Author
Offline
Elite Member
Developer of the K2 Import / Export Tool

12 years 5 months ago #58760 by Individual IT

Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2

I will take some time off from 12.10.2012 till 29.10.2012. Please don't expect support in that time. Please contact me after the 29.10.2012 B)

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

gerald sisimayi
Offline
Senior Member

12 years 5 months ago #58761 by gerald sisimayi

Replied by gerald sisimayi on topic Re: Tool for importing / exporting items to / from K2

perfectly understood. thanx. I guess its a manual reload. no problem.

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

Ralf Longwitz
Offline
Junior Member

12 years 5 months ago #58762 by Ralf Longwitz

Replied by Ralf Longwitz on topic Re: Tool for importing / exporting items to / from K2

Importing items using Libre Office csv works fine for me, except images. Images are in a folder on the server. The message I get for all images are like this:

importing items, please stand by
items were imported, but with some problems:
row: 2 - save item -
could not copy the file 002611.jpg
Row: 2 / memory peak: 22 MB

When the link to the images is wrong I get the expected "not found" message, so the path should be ok.
What else could be wrong?

Thank you!

---
J! 2.5.7
K2 2.6.1
K2Import 0.9a
php5.3 (XAMPP)

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

Ralf Longwitz
Offline
Junior Member

12 years 5 months ago #58763 by Ralf Longwitz

Replied by Ralf Longwitz on topic Re: Tool for importing / exporting items to / from K2

I now found that my images are actually imported correctly in spite of the error message. Now I cleared the gallery columns, and the error messages are gone. So the problem was the gallery images, not the main item images. Perhaps because I don't have the gallery extension installed.

There's still another problem:
After importing the 25 items of my test file, the importer keeps importing infinitely.
The item title will be like this:

Imported Item - 2012-10-22 09:45:57

Any idea?

(This is now K2Import v. 0.9stable)

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

Brian Gislason
Offline
New Member

12 years 5 months ago #58764 by Brian Gislason

Replied by Brian Gislason on topic Re: Tool for importing / exporting items to / from K2

Need to import images. I don't understand where to find the image information in the K2 so it can be put in the CSV. I already had to modify the CSV file to allow change to access level. I really need to get the images imported as well. I've been messing with this for 2 days and it's eating much of my time. Your directions for importing images is not very clear.

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

12 years 4 months ago #58765 by Individual IT

Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2

Sorry for the late answer I didn't get any emails even I subscribed to the forum :-(

For importing images you need to give the whole path of the image. e.g. you can put them in the tmp directory. see the example file on my page: www.individual-it.net/Instructions-for-K2-Import-Component.html

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

Sunil Sinha
Offline
New Member

12 years 3 months ago #58766 by Sunil Sinha

Replied by Sunil Sinha on topic Re: Tool for importing / exporting items to / from K2

Bought the component a couple of days ago. Need help badly in importing over 15,000 Joomla articles. Left the message in this forum but no response. See here: getk2.org/community/New-to-K2-Ask-here-first/167370-K2-Import--Export-09---How-to-use-it

Thanks.

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

12 years 2 months ago #58767 by Individual IT

Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2

Hi,
sorry I cannot watch the complete forum but I try to answer the questions in this thread.

Here is the Instructions for the K2 import/export component.

Its imports and exports K2 items. So you eather could create a CSV based on my example or you just create some K2 items and hit the export button, then you get a nice example file.
P.S. In my experience LibreOffice handles the CSV files better than Excel.

Hope that helps, if not ask again.

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

Stéphane Lumbroso
Offline
New Member

12 years 2 months ago #58768 by Stéphane Lumbroso

Replied by Stéphane Lumbroso on topic Re: Tool for importing / exporting items to / from K2

Hello
I buy com_k2import_0.9a
I want to export in k2 in joomla 3
it is possible ??

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

12 years 2 months ago #58769 by Individual IT

Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2

at the moment the software is just tested under joomla 1.5-2.5

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

Stéphane Lumbroso
Offline
New Member

12 years 2 months ago #58770 by Stéphane Lumbroso

Replied by Stéphane Lumbroso on topic Re: Tool for importing / exporting items to / from K2

:blush:
Do you know how can i do ?

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

12 years 2 months ago #58771 by Individual IT

Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2

1. Download the actual version
2. Check the documentation of Joomla 3.0
3. change the code

If you are seriously interested in changing the extension I can send you it for free.

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

wintercorn
Offline
New Member

12 years 2 months ago #58772 by wintercorn

Replied by wintercorn on topic Re: Tool for importing / exporting items to / from K2

Just installed it and it works great except for a couple of things.

All items uploaded have a Created date of 30/11/1999 - 00:00 despite the csv containing a date of 22/01/2013 13:47:00 which is the same format as the export I did.

Also, when uploaded they don't appear on the frontend even though published. It requires me to unpublish and then publish them to appear correctly.

Any ideas?

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

12 years 2 months ago #58773 by Individual IT

Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2

The date format has to be YYYY-MM-DD hh:mm:ss e.g. 2011-03-02 11:25:00
Check the file with a text editor. Exel & Calc & Co. often change the date format.

About the publish. What version of K2 and Joomla do you use?

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

Claude
Offline
New Member

12 years 2 months ago #58774 by Claude

Replied by Claude on topic Re: Tool for importing / exporting items to / from K2

Hello there at Individual IT,
I used your component to import data from an LibreOffice file.
Everything is working fine and items are created in K2 (v2.6.1) ... but they are not automatically saved so I have to open and save each item individually, and I cannot do that with more than 1600 items loaded this way.

My dates have the corret format you are mentionning (I use LibreOffice and I checked with a text editor) and they are well recorded in K2.

So, do you have any other way to auto-save these item when importing ?
Thanks in anticipation for a swift reply ....

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

12 years 2 months ago #58775 by Individual IT

Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2

Hi,
the extension is made and tested for K2 2.4.x and 2.5.x

check the K2 MySQL table what happends when you save an item manually and maybe we can figure out how to automate the saving.

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

Catherine van Dyk
Offline
New Member

12 years 2 months ago #58776 by Catherine van Dyk

Replied by Catherine van Dyk on topic Re: Tool for importing / exporting items to / from K2

I just bought the importing / exporting tool today. I try to import articles with a CSV file.
Import is working fine, but when i try to open an imported item, I have this error message:
DateTime::__construct() [datetime.--construct]: Failed to parse time string (30-11--0001 00:00:00) at position 0 (3): Unexpected character
and I can not open the item.
The same thing happen with the example csv file.
Can you help ?
Joomla 2.5.8 / K2 2.6.2 / K2Import 0.9a / French

Thks!

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

Claude
Offline
New Member

12 years 2 months ago #58777 by Claude

Replied by Claude on topic Re: Tool for importing / exporting items to / from K2

hello there at Individual IT !
Looking at the data base I found where is the problem that blocks auto-saving for new imported items (using K2 v2.6.1).
This is the "Language" value that is missing. Your tool needs to manage this value. I am using the site with 'multilanguage' and the value in this case is " * " .
Hope you can fix this problem swiftly !
Thanks in anticipation for your help :) !

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

12 years 2 months ago #58778 by Individual IT

Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2

Hi VD,
please see my post a week ago.
The date format has to be YYYY-MM-DD hh:mm:ss e.g. 2011-03-02 11:25:00

P.S. at the moment the extension is just tested for K2 2.4.x and 2.5.x

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

Claude
Offline
New Member

12 years 2 months ago #58779 by Claude

Replied by Claude on topic Re: Tool for importing / exporting items to / from K2

I guess you made a mistake when replying (tme instead of VD).
Whatever,mMy personal problem is not dates format (because it is OK with this), but in spite of that auto-saving of imported items is not working.
Obviously for the recent version of K2 (v 2.6.1) you also need to manage the "Language" parameter.
So the key is to attribute the value "*" to this parameter. i did it in the data base and my items were saved without any other actions.
So, you need to add this to your tool for being able to use it properly with current version of K2.
hope you will fix the problem soon because I have 1600 items to load !
Thanks in anticipation !

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