Keyword

Tool for importing / exporting items to / from K2

More
12 years 6 months ago #58740 by Franklin
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.

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

More
12 years 6 months ago #58741 by Franklin
Here's the file.

Attachment not found

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
12 years 6 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.

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

More
12 years 6 months ago #58743 by Franklin
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

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
12 years 6 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
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
12 years 6 months ago - 12 years 6 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

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

More
12 years 6 months ago #58746 by Franklin
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.

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

More
12 years 6 months ago #58747 by Edgar
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.

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
12 years 6 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!!!

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
12 years 6 months 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

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

More
12 years 6 months ago #58750 by Kostas Georgiadis
Replied by Kostas Georgiadis on topic Re: Tool for importing / exporting items to / from K2
Hello,

I have purchased the component and I have successfully tested it.

I want to build a directory using K2 in two languages (Greek (primary) and English).

I am using the following fields in K2:
Title, Category, Image, Item description, tag1, …, tag n, extra field 1, … , extra field n

I have made the translation of all the K2 field names in English using Joomfish.

When I use your component only the data for the primary language (greek) are inserted in K2. Is it feasible to use different CSVs (one for each language) so I will not insert manually the translation in Joomfish (now for each item I have to go to Joomfish, K2 items and edit the translated field contents manually. This is time consuming since I have more than 2000 items !).

Any ideas ?

I am using
Joomla v1.5.25
Joomfish v2.1.3
K2 v2.5.7
K2 import / export v0.9 stable


Thanks in advance.

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
12 years 5 months ago #58751 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hi,
sorry the extension just import items into K2, not Joomfish - this is an other extension.

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

More
12 years 5 months ago #58752 by jarod159
Hi man!
i've just bought the component (transaction id 7E279573T9850502) but i need help because i'm going to import a lot of articles that contain "," so i'm encountering problem with component delimiter.

Is it possible to change the delimiter with something else? (for example ||)

thanks a lot!

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
12 years 5 months ago #58753 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Text has to be included between " " then a , is also no problem

Should look like:

"Title","Alias","Introtext"
"Title Article1","alias-title-article1","Example with a lot of ,,, but this does not make Problems and even "" are fine if there are double "" Introtext"

You can also just make an export to have an example.

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

More
12 years 5 months ago #58754 by gerald sisimayi
Replied by gerald sisimayi on topic Re: Tool for importing / exporting items to / from K2
Hello,

Great little application. I have used it to import successfully but my question is how to I import actual options for a K2 Item?

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
12 years 5 months ago #58755 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
what do you mean by "options" the "extra fields"?

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

More
12 years 5 months ago #58756 by gerald sisimayi
Replied by gerald sisimayi on topic Re: Tool for importing / exporting items to / from K2
Hello there,

Thanx for replying. What I mean is - say I want to import a field called eye colour, I also want to bring in its options such as brown, green, grey etc - how would I do this ?

Thx

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
12 years 5 months ago #58757 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
first create the extra field in K2, associate it with a group and greate 2 or 3 items in this group with the different possible extra field values.
The make an export with the k2 import / export tool and you have an example file you can work with,

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

More
12 years 5 months ago #58758 by gerald sisimayi
Replied by gerald sisimayi on topic Re: Tool for importing / exporting items to / from K2
Hmmm,

Ok I understand. It would still be long for me since I have over 100 questions with some have 10 - 30 options - I wanted to avoid entering all this but thanx good sir, I get the idea.

I more question - I have a database on the system - How would I export its pictures,? I cannot see the picture column

Thanx in advance

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
12 years 5 months ago #58759 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
As its says in the description the tool can import images but not export them. The reason is the way K2 stores them.

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


Powered by Kunena Forum