Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Current »

It is possible to edit and bulk update Item Number values to suit requirements. 

Edit serial number manually

To change the numeric value of an Item Number, select Change Serial from the dRofus Ribbon Menu and you are provided with a panel which allows you to replace the current numeric value with a new value (but only if the resulting Item Number value is unique for that Item Group).

Consolidating Item Numbers

For example, if several Items have been deleted from the Project leaving gaps in the Item numbering sequences and the user would like to consolidate and order the numbering on the Items remaining then the following procedure will allow you to do this.

The option to Renumber is available when you right click on the lowest level of the relevant Item Group in the Item Group hierarchy:

The Item Numbers are regenerated to be sequential and without gaps:

Edit serial number: Excel import

How to fil gaps in the serialnumber.

  1. Number: Find out which numbers you want to use.

2. Make Excel-fil: Create or Export out exel-fil that contains:

A: Item ID

B and C: Item Group number and Sub Group number. You need to export out all levels. In this example we use 2 level.

D : Serial Number

E: Item Name

3. Update serial number in the Excel-fil

4. Import Excelfil:

Updating already existing Items with new number you need to fill out:

  • Identifier Item

  • Item Number / Serial number

Creating new Item you need to fill out:

  • Item Groups (all levels)

  • Name

  • Serial Number

4. Click “Import”

5. Click “Ok”

6. Serial number updated: You will see that the gap is filled

  • No labels