- Posts: 4
COMMUNITY FORUM
Tool for importing / exporting items to / from K2
- Franklin
- Offline
- New Member
Less
More
12 years 2 months ago #58740
by Franklin
Replied by Franklin on topic Re: Tool for importing / exporting items to / from K2
Hi there,
The component is working fine except for two problems:
1. The alias is importing without considering the hifen. Ex.: "Agricultor-prefeitura-de-maranguape-esaf-fundamental-2008" turns in "agricultorprefeiturademaranguapeesaffundamental2008" .
2. The Attachment1 Title is not being recognized and it is taking the name of the file instead of the name put in the csv file.
I'm using LibreOffice, my csv file is encoded in UTF-8 and I'm putting quotation marks in all text cells.
Since all others csv data is being imported correctly I'm not understanding why the two issues above are happening.
Can anyone help me with it please?
Thanks in advance.
PS: I put the csv file attached.
The component is working fine except for two problems:
1. The alias is importing without considering the hifen. Ex.: "Agricultor-prefeitura-de-maranguape-esaf-fundamental-2008" turns in "agricultorprefeiturademaranguapeesaffundamental2008" .
2. The Attachment1 Title is not being recognized and it is taking the name of the file instead of the name put in the csv file.
I'm using LibreOffice, my csv file is encoded in UTF-8 and I'm putting quotation marks in all text cells.
Since all others csv data is being imported correctly I'm not understanding why the two issues above are happening.
Can anyone help me with it please?
Thanks in advance.
PS: I put the csv file attached.
Please Log in or Create an account to join the conversation.
- Franklin
- Offline
- New Member
Less
More
- Posts: 4
12 years 2 months ago #58741
by Franklin
Replied by Franklin on topic Re: Tool for importing / exporting items to / from K2
Here's the file.
Attachment not found
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
12 years 2 months ago #58742
by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hi,
I will have a look at it, but could you please report what PHP / Joomla / K2 / Import-tool version you are using.
I will have a look at it, but could you please report what PHP / Joomla / K2 / Import-tool version you are using.
Please Log in or Create an account to join the conversation.
- Franklin
- Offline
- New Member
Less
More
- Posts: 4
12 years 2 months ago #58743
by Franklin
Replied by Franklin on topic Re: Tool for importing / exporting items to / from K2
PHP Version: 5.2.17
Joomla! Version: Joomla! 2.5.6 Stable [ Ember ] 19-June-2012 14:00 GMT
K2 Version: 2.5.7
K2 Importing Version: 0.9_beta4
Joomla! Version: Joomla! 2.5.6 Stable [ Ember ] 19-June-2012 14:00 GMT
K2 Version: 2.5.7
K2 Importing Version: 0.9_beta4
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
12 years 2 months ago #58744
by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
I found the problem with the aliases and today I will investigate the Attachment problem
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
12 years 2 months ago - 12 years 2 months ago #58745
by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Just declared the version 0.9 as stable and published it: www.individual-it.net/en/Joomla/ .
The only change from 0.9_beta4 are that it now accepts "-" in the aliases and the auto association with the fields are improved a (very) little bit.
@Franklin This version should solve your problem with the aliases. And are you sure you associated the Attachment Title correctly with the right column in the CSV file. If in the "associate the fields" screen the attachment title dropdown is set to "take standard or leave empty" the software will try to generate a title.
The automatic association is just guess work. You have always to double-check it. But you can help it by naming the column "Attachment Title 1" instead of "Attachment1 Title". I changed my example file and the export according to it.
P.S. if your download link does not work anymore, write me a short email
The only change from 0.9_beta4 are that it now accepts "-" in the aliases and the auto association with the fields are improved a (very) little bit.
@Franklin This version should solve your problem with the aliases. And are you sure you associated the Attachment Title correctly with the right column in the CSV file. If in the "associate the fields" screen the attachment title dropdown is set to "take standard or leave empty" the software will try to generate a title.
The automatic association is just guess work. You have always to double-check it. But you can help it by naming the column "Attachment Title 1" instead of "Attachment1 Title". I changed my example file and the export according to it.
P.S. if your download link does not work anymore, write me a short email
Please Log in or Create an account to join the conversation.
- Franklin
- Offline
- New Member
Less
More
- Posts: 4
12 years 2 months ago #58746
by Franklin
Replied by Franklin on topic Re: Tool for importing / exporting items to / from K2
Hi,
I was leaving the attachment title empty in the "associate the fields". It's working fine now.
Could you please send the new stable version to my email? I was not able to find the link to download it again.
Thank you.
I was leaving the attachment title empty in the "associate the fields". It's working fine now.
Could you please send the new stable version to my email? I was not able to find the link to download it again.
Thank you.
Please Log in or Create an account to join the conversation.
- Edgar
- Offline
- New Member
Less
More
- Posts: 1
12 years 2 months ago #58747
by Edgar
Replied by Edgar on topic Re: Tool for importing / exporting items to / from K2
Hello,
I already have 5,000 items living in K2. Now I need to import 5,000 images, one for each item.
Does this tool can import only item images and leave the rest of the items info just as they are already in the database?
That would solve my problem
Please advise.
I already have 5,000 items living in K2. Now I need to import 5,000 images, one for each item.
Does this tool can import only item images and leave the rest of the items info just as they are already in the database?
That would solve my problem
Please advise.
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
12 years 2 months ago #58748
by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
The easiest way would be to export the items, then change the CSV with the images and the reimport the file with the option: Overwrite - based on ID.
BUT before you are doing this make a full database backup!!!
BUT before you are doing this make a full database backup!!!
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
12 years 1 month ago #58749
by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Just published the version 0.9a just some minor fixes included.
extensions.joomla.org/extensions/extension-specific/k2-extensions/12408
extensions.joomla.org/extensions/extension-specific/k2-extensions/12408
Please Log in or Create an account to join the conversation.