:blush:
Do you know how can i do ?

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.

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?

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?

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 ....

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.

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!

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 :) !

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

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 !

Hi,

This is a great utility and I have tried to follow the instructions very carefully. Everything works except I am having the same problem a couple other users reported, that K2 import is putting something strange in the "start publishing" field:

-0001-11-30 00:00:00

Which is stopping the items from appearing. I thought it might be that I was using templates, so I actually made a fresh install of Joomla and K2 just to test this, but it is still giving me the issue. The time zone is set to UTC.

The file that I am trying to upload is attached. I will PM my testing site and super user details. Thanks.

I am just at a loss.

M

About the previous issue, the solution I found was to create a column and force something to go in to the "Publish Up" field. This will then put something in that field instead of the bad text.

You must be extremely careful that whatever spreadsheet program you use (and libreoffice does handle it better than excel - i chased that problem for at least an hour) does not make the field into a date field with a different format. Go into cell formatting and override the cells to be text fields, and make sure the date is entered exactly YYYY-MM-DD HH:MM:SS or it will not work. I don't know if specifying a date field to use that format would work.

Disappointed in this bug, because as far as I can tell I followed the instructions perfectly, but still a useful product at a reasonable price.

Mike

The file that I am trying to upload is 8MB and it has 10.000 items but I get error message while I am trying to upload it.

How can I upload that items?

Also how the images are imported to k2 items?

Sorry I was on holidays when you wrote your messages.

@mikexcite How would you like the extension to react on wrong formated date. I'm happy to implement good suggestions.

@stavros What an error do you get?
Images can be imported by the full path. Check the Instruction for that: www.individual-it.net/Instructions-for-K2-Import-Component.html

I install the new versions of k2 import component and everything works fine.

Thank u ;)

Using Joomla 2.5.8 with K2 2.6.5 with 0.9a and the issue with newly imported items not showing UNLESS you edit+save is the LANGUAGE field. Imports as blank and needs the ' * ' (star, shift + # eight).



Is there a quick fix for this? Working great besides this!

Soory at the moment this tool is just tested with k2 2.5 and 2.6

I'm testing the export from Joomla 1.5.26 locally (xammp) into a clean install of Joomla 2.5.9 and I keep getting a "403 - You are not authorized to view this resource error" when I create a menu item with K2 categories. I changed the "Access" column from 0 to 1, but it didn't solve the problem. What's causing this issue and how can I fix it? Working on a client site and need an answer as soon as possible.

Hi All!

I need priority support for this extension. I'd like to use it daily to update my k2 items/products.

My problem: There is few hundred items in my database and I'd like to update only few extrafields of them daily. The current version of the import tool set the value of non-existing fields (in csv) to default. I need it to leave the current value in database of non-existing fields and update only the fields that exists in csv file.

Sorry for my english, I hope it's understandable.

I can pay for this modification. Best regards

Hi there,

I am trying to export approx. 180 items from K2 on Joomla 1.5 install to K2 on Joomla 3.0 install. Any idea when this component will be 3.0 compatible? I really hope I didn't waste my money on this.