- Posts: 15
COMMUNITY FORUM
Tool for importing / exporting items to / from K2
- Stéphane Lumbroso
- Offline
- New Member
Less
More
11 years 10 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 ?
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
11 years 10 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.
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
Less
More
- Posts: 13
11 years 10 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?
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
11 years 9 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?
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
Less
More
- Posts: 3
11 years 9 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 ....
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
11 years 9 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.
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
Less
More
- Posts: 2
11 years 9 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!
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
Less
More
- Posts: 3
11 years 9 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 :) !
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
11 years 9 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 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
Less
More
- Posts: 3
11 years 9 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 !
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.