topic Classification system - unique codes in Excel but still "conflicting code at row..." in Tandem Forum

Classification system - unique codes in Excel but still "conflicting code at row..."

DonnyVA — Tue, 31 Oct 2023 11:26:49 GMT

Hi,

It looks like the classification system parses the values of the codes in an Excel file not correctly.

My test Excel file contains:
Code - Description - Level
Brug - Brug - 1
Brugballast - Brugballast - 1
Brugdeel - Brugdeel - 1
Brugdek - Brugdek - 1
Brugligger - Brugligger - 1
Combiwand - Combiwand - 1

So these are all unique codes but I get an error "Conflicting Code at row 3, 4, 5, 6".

See attached screenshots.

Greetings,
Donny

Re: Classification system - unique codes in Excel but still "conflicting code at row..."

jessica_smith — Tue, 07 Nov 2023 17:18:01 GMT

Hi @DonnyVA

So the reason why you are encountering the errors is because Tandem simply does a prefix match, and the “codes” in line 3-6 all start with the one in line 2.

So we recommend either coming up with distinct codes (generally a good idea) or considering making brug (bridge) a level one and all the other bridge things a level two category.

If you haven't already reviewed the Tandem Tuesday Tip - When Creating a Custom Classification System....., I recommend giving it a read. Attached to that same forum is an example of a classification system that will upload and one that won't, with explanations in the file.

Re: Classification system - unique codes in Excel but still "conflicting code at row..."

DonnyVA — Thu, 09 Nov 2023 08:40:34 GMT

Hi Jessica,

Thank you for the link to the 'Tandem Tuesday Tip'.

The issue here is that I'm trying to implement an external, kind of, classification system (or OTL), developed by our agency responsible for road infrastructure.

More info about my example 'brug' can be found here:

I could create a level one 'Brug', but I would still need a level two 'Brug' or 'Brugdeel'...

So my only option would be to create some random/arbitrary distinct codes and use 'Brug' or 'Brugdeel' as the description?

Re: Classification system - unique codes in Excel but still "conflicting code at row..."

jessica_smith — Thu, 16 Nov 2023 17:47:49 GMT

Hi @DonnyVA ,

My suggestion would be to add a number or letter prefix in front of the codes you have already listed.

Here is one example. In this particular case, I added the second double digits in the event that a level 2 or more is needed for any of these.