- Posts: 9
COMMUNITY FORUM
Tool for importing / exporting items to / from K2
- Sunny
-
- Offline
- New Member
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
-
Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
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.
- Sunny
-
- Offline
- New Member
- Posts: 9
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.
- Sunny
-
- Offline
- New Member
- Posts: 9
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
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.
- Sunny
-
- Offline
- New Member
- Posts: 9
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.
- Alan Coyne
-
- Offline
- New Member
- Posts: 4
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.
- René Bresson
-
- Offline
- New Member
- Posts: 4
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.
- René Bresson
-
- Offline
- New Member
- Posts: 4
Please Log in or Create an account to join the conversation.
- Martin
-
- Offline
- New Member
- Posts: 14
Please Log in or Create an account to join the conversation.
- René Bresson
-
- Offline
- New Member
- Posts: 4
I solved it, however, by checking some field in phpmyadmin when doing another export of the file.
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
please update to the newest version of K2
Alan Coyne wrote: 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.
- Dean
-
- Offline
- New Member
- Posts: 15
is not a valid date in the "created" column. Will set to 2015-02-16 03:33:35
"2/14/15 12:00 AM" is not a valid date in the "Publish Up" column. Will set to 2015-02-16 03:33:35
"2/14/15 12:00 AM" is not a valid date in the "Publish Down" column. Will set to 0000-00-00 00:00:00 what means "never"
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
You have to format the date in that way: 2015-02-16 03:33:35Dean wrote: "2/14/15 12:00 AM" is not a valid date
Make sure the date is in that format in the CSV file. Open it with a simple text-editor to check.
In my experience its best to edit the CSV files with LibreOffice. It handles the files better than Excel
Please Log in or Create an account to join the conversation.
- Dean
-
- Offline
- New Member
- Posts: 15
Individual IT wrote:
You have to format the date in that way: 2015-02-16 03:33:35Dean wrote: "2/14/15 12:00 AM" is not a valid date
Make sure the date is in that format in the CSV file. Open it with a simple text-editor to check.
In my experience its best to edit the CSV files with LibreOffice. It handles the files better than Excel
disreguard this post..i was sleepy when i responded
Here is what i have and it looks just like what you suggested.
Please Log in or Create an account to join the conversation.
- Dean
-
- Offline
- New Member
- Posts: 15
My next question is how can I set the access level in the csv so K2 picks it up? I see it asking but when I extract the items from zoo it does not include it in the csv. So i would have to open each item and change it to public or registered. I tried adding a column Access and used 0 and 1 but neither worked.
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
In the import process check if the columns are associated correctly.
You can also set the level how you need it in some items and then export them, so you would have an example file
Please Log in or Create an account to join the conversation.
- Michael Frede
-
- Offline
- New Member
- Posts: 6
we have a problem to import the extra fields.
The export works fine the fields are all in to our csv file.
if we will import the fields in the new webpage we dont see any possibility to get a field for this.
We think it was working automatcly but it dont work so.
What must we do to import the extra fields with the contend.
Yes we read your documentation !!
Here our configuration:
the joomla version 3.3.6
the OS version: php 5.5.12 on linux Centos 6.xx
the K2 version 2.6.8
the K2 Import / Export tool version: 2.2 vom 14.10.2014
Best Regards
Michael
Please Log in or Create an account to join the conversation.
- drknickel
-
- Offline
- New Member
- Posts: 2
thanks for your great tool :)
I just paied and downloaded again but cant get it to work, i get this error:
Komponenteninstallation: Datenbankfunktion erzeugt keine Fehlermeldungen
Fehler bei der Komponenten-Installation.
I guess the problem is that i had already installed an older version of the component:
K2 Import Administrator Komponente 1.4 2014-10-02 Artur Neumann Unbekannt 10315
K2 Import Administrator Komponente 1.4 2014-10-02 Artur Neumann Unbekannt 10316
K2 Import Administrator Komponente 1.3 2014-09-14 Artur Neumann Unbekannt 10314
K2 Import Administrator Komponente 1.4 2014-10-02 Artur Neumann Unbekannt 10313
K2 Import Administrator Komponente 0.9_beta3 2012-07-04 Artur Neumann Unbekannt 10220
K2 Import Administrator Komponente 0.9_beta3 2012-07-04 Artur Neumann Unbekannt 10219
This is how it looks like in my extension list. I can not uninstall any of those components:
JFolder: :files: Der Pfad ist kein Ordner! Pfad: /administrator/components/com_k2import
JFolder: :files: Der Pfad ist kein Ordner! Pfad: /administrator/components/com_k2import
JInstaller: :Install: Die XML-Installationsdatei konnte nicht gefunden werden.
JFolder: :files: Der Pfad ist kein Ordner! Pfad: /administrator/components/com_k2import
JFolder: :files: Der Pfad ist kein Ordner! Pfad:/administrator/components/com_k2import
JInstaller: :Install: Die XML-Installationsdatei konnte nicht gefunden werden.
JFolder: :delete: Der Pfad ist kein Ordner! Pfad: /administrator/components/com_k2import
JFolder: :delete: Der Pfad ist kein Ordner! Pfad:/components/com_k2import
Komponentendeinstallation: Deinstallation nicht möglich. Bitte manuell löschen.
The directorys are empty.
What can i do? :)
Greets
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
Please Log in or Create an account to join the conversation.