Skip to main content
L
ltourville1-Visitor
1-Visitor
November 26, 2018
Question

Custom ECR/ECN numbering scheme

  • November 26, 2018
  • 3 replies
  • 3224 views

I need to create a custom numbering scheme for our ECR/ECN process in PDMLink11.1. The numbers would be YY-XXXX, where YY is the last two digits of the year and XXXX is a sequential number starting at 0001, like "18-0152". I also need the number XXXX to reset to 0001 at the end of the year. So, regardless of the last number used in 2018, when we change to 2019, the number would become "19-0001".

 

Has anybody ever done something similar?

Or does anyone know how to skip numbers in a autogenerated numbering scheme?

 

Thanks

3 replies

B
BjoernRueegg17-Peridot
17-Peridot
November 27, 2018

My first thought is to create for each year a separate number generator (Or reset it to 0).

At the first day of the year, change the prefix and the number generator in the OIR.

If you would like to set the ECR and the ECN to the same number, this won't work without having a customizing.

P
PK_97259865-Regular Member
5-Regular Member
November 23, 2020

Dear Itourville,

 

I don´t know if your question is still open or if you have found a solution allready. 

 

But some short advises:

 

you have to create and install your needed numbering scheme in den DB (oracle or SQL) the code should also include your rules, like the rest at the beginning of the year etc.

 

Afterwards you have to change the OIR of the ECN that it will take this new numbering scheme.

 

Best Regards

 

Philipp

D
18-Opal
d_graham18-Opal
18-Opal
November 23, 2020

Why not just create a custom Java class that calculates the number based on the logic you supplied and then point the OIR's number algorithm to the custom Java class rather than the OOTB number generator.

 

Your logic is very clear.  This is very easy to do.

The solution is simple and bombproof.

    I
    Iblackie12-Amethyst
    12-Amethyst
    November 10, 2023

    Hello d_graham,
    I am working with ltourville to set this up, do you have any examples of how to get this started. Since we are not developers the java portion is unclear.
    We have a local PTC partner to help but a bit more detail would be much appreciated so we can reduce any development time from "them".
    Thank you,

    IB

    D
    18-Opal
    d_graham18-Opal
    18-Opal
    November 10, 2023

    @Iblackie 

    Id like to help you it I can’t tell you how to do something and then have you pass it onto your PTC partner for them to implement.

     

    If you want to work with me rather than them on this I’’m up for it.

    Terms & ConditionsCookie settingsAccessibility statement