Developer forum

Forum » Integration » Dataintegration - import csv/xml using ItemProvider

Dataintegration - import csv/xml using ItemProvider

Finn Frost
Reply

Hi All,

I wonder if there is any documentation available regarding the new itemprovider in the dataintegration module?

  • If so, where can i find it?
  • If not, when will be be available?

I managed to import data from CSV to a paragraph item, with the help of the dataintegration module, CSVProvider as source and ItemProvider as destination. Worked ok, but it would really help with some documentation.
Such as, can i specify the paragraph name in the import (i saw a field called NewPageName) ? - which i tried to add to my mapping table/csv, but resulted an error.

Also, it doesn't seem to be possible to import to a specific ItemList (item(s) in a ItemList), which actually would be really useful. Consider this a feature request if not already possible.

It will allow us to have that itemList as a container of the imported items, and not have to rely on a content-area-container to hold the imported items. Thus making it easier/simpler to have/use a template design for that specific list / listitems. In general, when having multiple items in a container, we prefer to have an itemlist of these items, rather that a content-area, since on an item with an itemlist (containing the multiple items of same type), we can add custom/default settings for all items in the containing list.

In the DataIntegration module, when using ItemProvider as destination, simple let us pick the paragraph which, is an item. That item should contain an ItemList of the Items we are about to append to (ie. 1 foreach row in the csv).

 

Also, any documentation of what the "Remove missing rows after import" and "Delete page, paragraph associated with missing items" fuctions does if the check those in the Destination Settings of the ItemProvider.
Regarding:

  • Remove missing rows after import
    • Since i selected a page for the items to be imported to, I would expect that if the select this option, then only the missing items for that specific page is deleted.
    • However, i know there was/is an issue of this with the EcomProvider, where importing products to a specifik shop, then if you select the option "Remove missing products after import" - then, if the file only contained 1 product, all products from all Shops would be deleted - except the imported product. I just want to make sure that the same doesn't apply to the ItemProvider ??
    • I see multiple levels regading removing missing rows after import, either:
      • Remove all from that table, that are not in the import
      • Remove all rows from that table that are not in the import AND IS in the selected: Shop/Page/Paragrahp/ParagraphList
ItemProvider_remove_missing_rows_after_import.jpg

Replies

 
Jonas Krarup Dam
Reply
This post has been marked as an answer

Hi Finn,

Currently, it is only possible to import items to pages and paragraphs.

The "Remove missing" checkbox will remove all items of that itemType that are not in the data you are currently importing. It would make sense to have it as an option to only remove the items under the selected page/paragraph.

We are planning an overhaul of the ItemProvider, since quite a lot has changed with regards to items, and I will definitely take your input into consideration for this updated version. If you need to know details before they are released, let me know, and I'll give you an update on what we're planning (once we have a plan).

Otherwise, look out for the release notes for 8.6 :-)

 

Regards, Jonas

Votes for this answer: 1
 
Finn Frost
Reply

Hi Jonas,

Thank you for your reply.

I'll keep a close eye out for the 8.6 release notes.

Do you have any documentation available regarding itemfields (meta-data?), that are not self-created in the item, such as, is it possible to set the paragraph name and other settings, when importing a paragraph item?


[This might need its own thread?]
Also, could you check/verify wether you have a ticket/featurerequest regarding the deletion "remove missing" when importing with dataintegration, in particular the EcomProvider.
We have a specific example where we need to import data(products/groups) to a specific shop, which is feasable, but also want to remove missing rows, but only missing rows for that shop.

 

 
Jonas Krarup Dam
Reply

Hi Finn,

We had a bug for the problem with remove missing from shops - we where unable to reproduce it in the 8.5 build.

If you still have the problem in 8.5 or newer, I would appreciate your help in reproducing the problem, possibly with a copy of your site.

 

Regards, Jonas

 
Jonas Krarup Dam
Reply

Hi Finn

I missed the first part:

you can set page names when adding new items as pages - this is done by adding a value to the "NewPageName" column.

This is the only setting that you can currently set during import.

If you have a scenario where you need to set something else, I would like to hear it, so that we can take it into consideration when are making plans for the itemProvider.

Regards, Jonas

 

You must be logged in to post in the forum