Skip to main content
All CollectionsData quality
How do you detect a duplicate image on a link type?
How do you detect a duplicate image on a link type?

Ensure that images linked to documents are unique.

Sylvain Gourvil avatar
Written by Sylvain Gourvil
Updated over a year ago

Objective

Ensure that images linked to documents are unique.

For example, avoid the same product image being linked under two different names (such as "product.jpg" and "myproduct.jpg").

This check is useful, particularly when the PIM / DAM is put into production after all the data has been recovered and initialized.

Steps

  1. Export a CSV file of type "Media".

  2. Export a CSV file of type "Link" for the type of link concerned.

  3. Use Excel to cross-reference the data ("VLOOKUP") between target_code and asset_code, in order to obtain the information for each asset linked to a document.

  4. Perform a checksum-based comparison to identify duplicates.

Did this answer your question?