Thanks for checking and confirming a bug.

I have tested 2.2 and that appears to have resolved the date issue.

Next, click on the Import, but do not select a file first.
It returns error: An error has occurred. 0 The file could not be uploaded.

Personally, it should be better to have the import button disabled until a file has been selected or, provide feedback that no file has been selected.

You'll find a great tool here : www.individual-it.net/en/Joomla/ K2 import and Export

Documentation:

getk2.org/community/English-K2-Community/1546-Tool-for-importing--exporting-items-to--from-K2

Tested and approved :)

I've found the bug an fixed it. So there are 2 new versions:
2.2 for Joomla 3.x and 1.4 for Joomla 1.5 - 2.x

Please use the link you got after payment to download the new version. For most people that one should still work. For every EUR you pay you get 10 days of update-service.

www.individual-it.net/en/Joomla/#27

Sorry, I should have zipped the csv, which is now attached.

FYI, there is a bug in 2.6.8, which there is a fix here: github.com/joomlaworks/k2/commit/9b4c27b60034bc80def73a0c28cd4a15bf81cd38

I have committed the fix and retested, but it still fails, so I attach a csv which was just exported and has not been edited.

PHP Version is 5.3.29

Yea that looks strange, "2014-09-27 15:38:14" should import.
Could you please post that file, so I can try to import it on my computer.

P.S. might be useful to know what version of PHP you are using.

Date Errors.

I am using J!3.3.3 K2 v2.6.8. Import 2.1
I did an export of my data, then reimport.

When the import runs, it returns an error.

items were imported, but with some problems:
row: 1 - save item -
"2014-09-27 15:38:14" is not a valid date in the "created" column. Will set to 2014-10-01 06:04:16
"2014-09-27 15:38:14" is not a valid date in the "Publish Up" column. Will set to 2014-10-01 06:04:16
"0000-00-00 00:00:00" is not a valid date in the "Publish Down" column. Will set to 0000-00-00 00:00:00 what means "never"

Now I am not sure why it does not like the date format, as it seems to be exactly the same format.

My export file, if opened in text editor shows for example a publish date of "2014-09-27 15:38:14"
When viewed in excel, the column formats the data to 27-09-2014 15:38:14, so I change the date format for the columns to be yy-mm-dd, save and import, still the same error.

Can you help please.

there is this thread you can look at getk2.org/community/English-K2-Community/1546-Tool-for-importing--exporting-items-to--from-K2

I've just updated the extension and published two new versions:

2.1 for Joomla 3.x
changes:

• small bugfixes
• better date checks
• import/export Hints + Item Parameters

1.3 for Joomla 1.5 - 2.x
changes:

• small bugfixes
• better date checks
• works better with K2 2.6.8 , actually K2 2.6.8 is now required. If you are using an older version of K2 please make an update of K2

As always: If you recently bought the extension please check the link you received after payment, it might be still valid (for every EURO you pay you get 10 days of free download)

Have fun: K2 Import/Export tool

Glad to hear its working.
The values do correspond directly to the values in the database.

If you like the extension a comment or rating at JED would be great

Individual IT wrote: Hi,
please try not to place the images into the same folder as on the source system. Place them into the tmp folder of joomla and in the CSV file give the path starting from the joomla root without leading slash.
Please check also the documentation www.individual-it.net/en/Instructions-for-K2-Import-Component.html

Afterwards please report if you still have problems.

Thanks a lot. I finally got it working, after i created a menu item for the imported category i noticed my imported items were not showing, i noticed that access level was set to 0 on the CSV file so i changed a few access level on some k2 items in the k2 component and the few i changed showed up on the front page with out issues.
My Question! when editing my other CSV files, in the access level column what value should i set for public access instead of the 0 value? thanks for your patience am almost done!

Solved! i simply changed the value from 0 to 1 in all my exported CSV files. that way they become public on the frontend. This is one plugin i enjoyed working with. thanks!

Hi,
please try not to place the images into the same folder as on the source system. Place them into the tmp folder of joomla and in the CSV file give the path starting from the joomla root without leading slash.
Please check also the documentation www.individual-it.net/en/Instructions-for-K2-Import-Component.html

Afterwards please report if you still have problems.

Individual IT wrote: I'm happy to hear its working but its still strange.
If it works with 500rows in one go it should work with less.
can you post your CSV file?

been working on this for days now.. need help desperately, i have backed up my images from /media/k2/items/src. and copied them to my localhost on my laptop, when ever i edit the image column of the exported .csv file to point to the new image location, i get an endless looping and eventually the import page stops to load, i dont get to see a success on import page, but when i check k2 i see my items, also after creating a menu link to the category i get this error message on the frontpage;

An error has occurred.
The requested page cannot be found.

Home Page
If difficulties persist, please contact the System Administrator of this site and report the error below.
#403 You are not authorized to view this resource

here is the link to the export CSV file.
Pressplay360.opendrive.com/files/OF80ODUyNTMzMl9qNGxSeF85OTI4/Hype.zip

I'm happy to hear its working but its still strange.
If it works with 500rows in one go it should work with less.
can you post your CSV file?

Individual IT wrote: Hi kelvin.
Did you select the option to overwrite items. If you did so then maybe some items are overwritten.

The export of images only exports the path. you have to transfer the images yourself to the new server and give its path in the CSV file.
the "path to an image" can be the path to an existing file on your server, starting from the joomla-root e.g. images/stories/pastarchives.jpg

Please check also the documentation:
www.individual-it.net/en/Instructions-for-K2-Import-Component.html

I did not select the option to overwrite items. i worked with the default settings. i have tried to export and import the category again and am still getting the same result.
I also noticed that the category imported does not appear in the category tab.
this is very urgent as am under pressure from my client.

[Solved] Eventually i was able to find a way around this issue. I increased the "Import Rows Per Loop" from 10 to 500. this way i was able to import all my 197 items without issues. This was done on the test website i had installed on my laptop. I am yet to try this on the Live site, this may be an issue based on PHP max_execution_time. But am thinking if the Live site can handle it then its ok, if not then i can import 10-15 rows per loop and then continue by using "Start num row" to import 10 - 15 rows at a time. If there is any other way to make this easier for me i would appreciate it.
I hope this would help someone out there.

Having a dedicated forum might have been a good idea for searching, announcements, bugs and so on. But if you prefer to keep this post, then it's OK with me :)

Hi Fotis,
yes I'm glad its used a lot.
Do you mean that I should install a forum on my own domain? If possible I would prefer to stay on getk2.org. It's simply just less work for me.

Hi kelvin.
Did you select the option to overwrite items. If you did so then maybe some items are overwritten.

The export of images only exports the path. you have to transfer the images yourself to the new server and give its path in the CSV file.
the "path to an image" can be the path to an existing file on your server, starting from the joomla-root e.g. images/stories/pastarchives.jpg

Please check also the documentation:
www.individual-it.net/en/Instructions-for-K2-Import-Component.html

@Artur I think it's time for you to setup a forum for your extension. It's proven to be quite popular :)

Hello, I just bought the component and exported a category on my website, when importing the csv file for that category i get this error massage at the end (Had to make the error massage short because it was very long);
row: 1 there is no user with the ID: 62 I'm using the ID:411
row: 1 - save item -

could not find item to overwrite I will create a new one. WHERE clause: title = 'Music | D-Eye - Caro [@Yungboy_D_Eye]' AND `catid` ='3'

row: 1 - save image - Local file doesn't exist. /home/content/93/9888393/html/media/k2/items/src/73d7edd1405081e5433c41d9ad2ee18c.jpg
row: 2 there is no user with the ID: 62 I'm using the ID:411
row: 2 - save image - Local file doesn't exist. /home/content/93/9888393/html/media/k2/items/src/ce93b7c97ea8831859bbe17c36b83648.jpg
row: 3 there is no user with the ID: 62 I'm using the ID:411
row: 3 - save item -

After which the exported category that had 197 items on the old site now has just only 9 items on the new site after importing. what happened to the remaining items and why are images not imported.

How do i export and import the complete amount of items that was in the category?
How do i export and import the images for all the items belonging to that category?