1. jimmywiddle
  2. RO CSVI
  3. Tuesday, 21 July 2015
  4.  Subscribe via email
Hi, Basically im trying to use an import csv file which doesn't contain any of the standard fields:
"title";"alias";"category_path";"introtext"

instead id like title to be made up from a combination of extra fields and the category path to be the same for all items imported.... i dont need the introtext or alias (alias will be autogenerated from the title right?) and all items imported need to be auto published.

thanks in advance
Accepted Answer Pending Moderation
Many thanks! :)
  1. more than a month ago
  2. RO CSVI
  3. # 21
Accepted Answer Pending Moderation
Hello,

I will work on the patch and it should be ready tomorrow. Will post it here when done.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 22
Accepted Answer Pending Moderation
Hi, Thanks for your reply and help, i got everything I mentioned in my post working now, except the alias, there is no data in the csv file for this, yes if you can create this patch so its autogenerated from the title it would be wonderful thanks!
  1. more than a month ago
  2. RO CSVI
  3. # 23
Accepted Answer Pending Moderation
Hello,

I see you adjusted your message, not a problem but I just wanted to say that you can always ask for help if things don't work out.

Basically im trying to use an import csv file which doesn't contain any of the standard fields:
Those fields are required for a reason of course :)

instead id like title to be made up from a combination of extra fields
That can be done by using the combine function in CSVI. There is even a tutorial for that, the Combine multiple fields into one tutorial.

category path to be the same for all items imported
That is possible as well by adding the category_path field with a default value. This field doesn't have to be in your import file as long as the number of fields in the CSV file is less than the fields you assigned to the template. Let's say your CSV file has 5 fields, the first 5 fields assigned to the template should correspond to the 5 fields in your import file. Field number 6 can then be the category path with the default value.

i dont need the introtext
You can leave that out, your articles just won't have any content.

alias (alias will be autogenerated from the title right?)
No, the alias is used as unique identifier for your content. Without this, CSVI won't have any clue which item to update/add. If you want I can create a patch for you that will generate the alias based on the title.

all items imported need to be auto published.
The same goes here as for the category_path, you can add the published field with a default value of 1 or Y. Just add it to the end of the fields list assigned to your import template.

Let me know if you have any further questions.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 24
Accepted Answer Pending Moderation
.
  1. more than a month ago
  2. RO CSVI
  3. # 25
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
Be one of the first to reply to this post!