Non-consecutive record numbers in Dédalo

Gerard_La Foneria

Dear all,

In a Dédalo installation, the automatically generated record number has jumped, preventing the record numbers from being consecutive. How can we restore consecutive numbering?

Alex

You have some options:

1.- Counters can be reset easily on Dédalo Counter Status in Maintenance panel.

When the last number of the section do not match with the counter, you will see the Fix counter button, to set the counter to the last record id in the section.

As I can see in your screenshot you will need to delete the records >6945 to set the last record to this number and back to the maintenance panel to see the Fix counter

2.- Set the counter manually in PostgreSQL. You will need to know the section_tipo that you want to reset and perform something as:

UPDATE "matrix_counter" SET
"dato" = '6945',
WHERE "tipo" = 'rsc170';

Note: tipo needs to be the section_tipo, in this example I set the Image section rsc170

Take account that if you don't delete the records > 6945 when Dédalo will arrive to the record number 30171 the creation, import, etc. will fail because the conflict with existing records.

I hope is clear.

best