Why doesn't my cascade resource import?

Using the import function of the cascading resource can help you save great amount of time. There are some things to keep in mind though.

The file itself:

Should be a .csv format

Should not contain a header (so make sure you start with the actual data)

If you are using codes, every cascade value should have it's own unique code.

Common mistakes

Cascade containing duplicates

The system will tell you that the import of the cascade has failed. Often this is caused by a duplicated value in the cascade.

Cascade containing duplicates

If the lowest level contains an unique code it is easy to find the duplicates with Excel using the find duplicates feature. If this is not the case, it's recommended to create another column where you merge the cascade without the codes. This way you can find the duplicates based on the last column, avoiding not finding any duplicates as the code of the lowest level might be unique.

Once you have found the duplicate and you are sure these can be removed, use the remove duplicates feature.

Cascade containing duplicates

Codes are not unique

In some cases the codes are used for different values. If you are not sure if this is set-up correct in your file, you can use the Vlookup function. While doing this you need a sheet where all the codes per cascade value are defined.

Cascade Codes are not unique

The file contains header rows

Uploading the file with header rows will break the import.

The file contains header rows

For more information on this topic please have a look at the cascade resources tab.