Keyword

Tool for importing / exporting items to / from K2

More
8 years 2 months ago #58940 by Sunny
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.

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

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
8 years 2 months ago #58941 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
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.

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

More
8 years 2 months ago #58942 by Sunny
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

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

More
8 years 2 months ago #58943 by Sunny
Sorry, I should have zipped the csv, which is now attached.
Attachments:

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

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
8 years 2 months ago #58944 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
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

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

More
8 years 2 months ago #58945 by Sunny
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.

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

More
7 years 10 months ago #140245 by Alan Coyne
Replied by Alan Coyne on topic Tool for importing / exporting items to / from K2
Hi,

When I export items , I get a CSV files with just the column names. No items listed.

Joomla version : 1.5
OS version : Windows
K2 version : 2.1
K2 Import / Export tool version : 1.4

Any reason for this?

Thanks

Alan

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

More
7 years 9 months ago #140877 by René Bresson
Replied by René Bresson on topic Tool for importing / exporting items to / from K2
I get this error when trying to import my .csv file.

422 Found an unescaped quote in quoted field 31 of csv line 0 (text line 1). The first 50 chars from the start of the field are '"catItemTitle=\n'.


Can anyone help me? Thanks in advance!

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

More
7 years 9 months ago #140881 by René Bresson
Replied by René Bresson on topic Tool for importing / exporting items to / from K2
If you need any information, please let me know.

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

More
7 years 9 months ago - 7 years 9 months ago #140885 by Martin
I have not used this extension even though I wanted to. But the first thing you need to do is to load the csv in Excel. But not just open it. Import as data wiht correct comma Separation. There are certain cases where lines are broken (due to an unwanted linebreak by the Export i think) and you can identify them quickly with it.
Last edit: 7 years 9 months ago by Martin.

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


Powered by Kunena Forum