1. konstantinos29
  2. RO CSVI
  3. Tuesday, 05 January 2021
  4.  Subscribe via email
Hello,

Just to be sure we are doing this the right way... here's our current scenario:

We have source CSV files for VM products. These contain the complete products, with all possible fields.

We want to create separate templates, to import them partially.
e.g. We want a template to just import/update prices + availability, and ignore all the rest.

Can this be done?

I know there is a field selection for each template, but I am wondering if this is the filter we want, or if this just defines the format of the CSV file.

Thanks
Accepted Answer Pending Moderation
Hello,
We want to create separate templates, to import them partially.
e.g. We want a template to just import/update prices + availability, and ignore all the rest.
Can this be done?

Yes, You can use skip template field for the fields you don't want to include in import. For doing this you need to set Use file for configuration as No in your template settings and on File tab. Add template fields you need to import and for the fields to be ignored add skip as template field.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Thank you.

Followup questions..

With your mentioned approach, I assume we need to define all the fields, and in the order they appear in the CSV file? And set which are to be skipped?

If so, may I suggest an improvement for some future version...

Because the import CSV files we get, may sometimes be re-ordered (columns), or perhaps a helper column may be inserted, the ordering is not 100% guaranteed.
It would be great if CSVi didn't care about the ordering of the fields, and simply define which fields we care about in a template, and just ignore all the rest.
(and perhaps the other way around, ignore X fields)

Irrespective of their ordering in the source file.

Thank you!
  1. 3 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
With your mentioned approach, I assume we need to define all the fields, and in the order they appear in the CSV file? And set which are to be skipped?

Yes, you need to add fields in the order of headers of CSV file. The fields you want to ignore assign them to be skip template field.

Because the import CSV files we get, may sometimes be re-ordered (columns), or perhaps a helper column may be inserted, the ordering is not 100% guaranteed.
It would be great if CSVi didn't care about the ordering of the fields, and simply define which fields we care about in a template, and just ignore all the rest.
(and perhaps the other way around, ignore X fields)

Irrespective of their ordering in the source file.

The ordering is needed else if the import file has columns headers which is not same as RO CSVI template fields, RO CSVI will not know which columns to match from the file.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation

The ordering is needed else if the import file has columns headers which is not same as RO CSVI template fields, RO CSVI will not know which columns to match from the file.


There could be a mode which combines "Use import file as configuration" and "Include/Exclude" specified fields.
In our custom PHP code, we scan CSV files for pre-specified fields, irrespective of their position. And ignore all the rest. It works great (but it is built for other purposes).

Our CSV files contain the fields that CSVi understands (by their name), as well as other fields for other purposes, all in one document. It would just speed things up a lot, to just arbitrarily pick stuff out.

Maybe this is a very niche scenario we're discussing here, and there's no demand for this from the majority of your users.

Thanks for listening!
  1. 3 weeks ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
In our custom PHP code, we scan CSV files for pre-specified fields, irrespective of their position. And ignore all the rest. It works great (but it is built for other purposes).

RO CSVI can do the same provided you have supported fields as column headers in import file.

Our CSV files contain the fields that CSVi understands (by their name), as well as other fields for other purposes, all in one document. It would just speed things up a lot, to just arbitrarily pick stuff out.

If your CSV file has fields that CSVI can understand then you can set Use file for configuration to Yes and run the import, CSVI will pick only the supported fields and ignores the rest of the fields. Note that all the supported fields will be picked from the file and not any specific fields. Please try and let me know.

Maybe this is a very niche scenario we're discussing here, and there's no demand for this from the majority of your users.

That is correct, you are our first user asking for this feature.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


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