Skip to Content
avatar image
Former Member

start auto id from specific number

Hi people!

How can I resolve this,

I have 1000 records, but the numeration starts in 100,000.

For example the first record is the 100,001 and the last is the 101,000.

Actually this ID is generated in MM automatically, but now when you want to create a record, it will be created from MDM and then send the important data to MM.

So I have to import the records, and then start the auto id, from 101,000. How can i solve this?

thanx

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    May 09, 2008 at 05:45 PM

    Hi,

    I saved this reply in my fav.

    get remote keys for your records created in data manager. For that you must have key mapping field as Yes in console.In console, in the remote systems, you must have key generation set to either range or qualified range.If you want that your key generated should be based on some criteria say you have three account groups as A, B and C. You want that the key generated for records having group A should be ranging from 1 to 100, similarly for B from 101 to 200 and for C from 201 to 300. Then you should select key generation as qualified range and your lookup field should be your account group table. In qualified range field, you have to specify the ranges you want in front of the account groups.

    If you want your keys should be generated in a range with no other constraints then you should choose key generation as range and specify the range.

    If key generation is none then no keys will be generated for that particular remote system.

    Do the same for all the remote systems to which you want to syndicate the records.Then map the remote key fields on source and destination side in syndicator. You can see the generated keys in data manager by right clicking on record and then choosing edit key mapping.

    Remeber that you can see the key mapping only after syndicating the records once.Before syndication you can't see the keys even in syndication preview.

    Hope this will help,

    Will appreciate if you will be able to update on result,

    + An

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 09, 2008 at 06:32 PM

    it's the only way to do that?

    how about assignments? (I can't prove your solution right now, that's why I would like other answers)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 12, 2008 at 04:53 AM

    Hi,

    It is possible through Assignments.

    Create one field of type AutoId and one simple text field say Material ID.Write an Assignment on Material ID field as (AutoId+10000) and keep this Assignment in the Workflow that will be triggered on Record Add.

    Other approach that I can suggest is though quite vague but it will surely work.Import the no. of records till the count reaches to the desired number in AutoId field and then delete all the records.Now when you create the new record it gets the AutoId as the Count which you have deleted + 1 because AutoId will not reset its counter even after record deletion.

    Regards,

    Jitesh Talreja

    Add comment
    10|10000 characters needed characters exceeded