Categories
View Replies (3)

Resolved Feedback on custom import

  1. waveywhite
    waveywhite
  2. RO CSVI
  3. Friday, 25 September 2015
  4.  Subscribe via email
I've been persevering with custom import and have some feedback. Some of this might be functionality that I haven't worked out yet.


  1. Combined template fields process an input column even though their input comes from the combiner. This means that all combination fields have to be at the end of the fields list or input will be skipped. The exception to this seems to be if a table field is listed twice, in which case it will not skip even if you'd like it to.

  2. I can't choose to skip irrelevant input columns, because all template fields have to map to a table field. I'd like to be able to select a "none" table field value, or similar.

  3. When combining two columns they have to map to table fields before being combined. This doesn't work in all cases and I had problems combining address fields for the contact_details table.

  4. Another issue with input columns needing to map to table fields is defining static table field values which don't correlate to an input column. I suppose they have to go at the end of the fields list.

  5. I'm having problems setting a unique alias. A plugin to generate a line number could be one way of doing it



I hope that's helpful. Please let me know if I've missed how to do any/all of these.

-David.
0
Responses (3)
rolandd
rolandd
Accepted Answer Pending Moderation
Good morning David,

Thank you for the feedback, let me go through your points.
  1. You can't have the same field twice, it will only use the last field in that case. Only exception is the skip and combine fields. Not sure what you are trying to achieve here, some more explanation would be nice.
  2. Yep, the skip field is not available for the custom tables. I have added it to the todo list.
  3. This should be fixed in the current 6.2.0 release as it allows to specify the fieldname as well and not just the Your field value.
  4. You have to specify the alias in your import file, so you can do it with a spreadsheet for example. If you want to use a plugin that is possible as well, you can code one like the current plugins replace/combine etc.
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. # 1
waveywhite
waveywhite
Accepted Answer Pending Moderation
Hi Roland,

Thank you for reviewing these

For the same-field-twice I think I was trying to find ways of working around issues 2 and 3. Having no "variables" and only having table fields I tried to set a field twice with a combination. So e.g. set name from first-name, and then set it again when the next column came along, e.g. append surname onto already set name. Unfortunately that didn't work because the surname column wasn't then stepped over although the name field was set to first-name+surname. So, the next field (e.g. address) then picked up the surname value. Confusion reigned.

The alias issue is a nice-to-have. I do have some control over the imported data so I could do that but that isn't always the case, e.g. if someone is being pushed a CSV automatically. Joomla likes its unique alias fields and throws errors if they're not set. So, the idea is to have some plugin for creating a unique alias. Would be useful for others, I thought.

Looking forward to skip-field and the fieldname fix in 6.2.0. Thank you for all your hard work and support.

-David.
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello David,

Attached is a patch file that will add the skip/combine/custom fields to the import/export of the CSVI Pro Custom Tables import/export. You can load the patch file and after that run the Update on the Available fields and they should be available to you.

So, the idea is to have some plugin for creating a unique alias.
You will go a long way with the replace plugin and have it call the PHP rand() function for generating a random number.

Looking forward to skip-field and the fieldname fix in 6.2.0.
This version was released last week.
Attachments (1)
patch_customimport_20150929.zip
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. # 3
  • Page :
  • 1


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