Community

Batch Name

Hi every one
I has question about batch number count. How I know when batch Id will start at one again?
refer to first question Can I Fix or not?
This case is very sensitive because I keep this data for recognition and Batch Name is my primary key.

Thank you.
0

Comments

6 comments

  • Avatar
    Vladislav Suvorov
    Hi,

    Batch ID that is a batch property:
    1.a)For a local project it becomes 1 after you create another local project. Those IDs are unique for each project on your hard drive.
    1.b)For your uploaded to server projects Batch IDs are unique across all projects. Meaning uploading another project to server won't change ID count.
    3)It absolutely doesn't matter if batch was either processed or deleted\etc. ID of a deleted\processed batch won't be assigned to any other one after that.
    4)As this property is read-only you cannot change it without manipulating FlexiCapture system files(I strongly recommend not to do that). But it can be read\stored and used somehow.
    5)It is possible to use batch processing script to make each batch name unique using its ID.

    Hope that helped,
    Vladislav
    0
  • Avatar
    laptorkung
    Hi,

    Batch ID that is a batch property:
    1.a)For a local project it becomes 1 after you create another local project. Those IDs are unique for each project on your hard drive.
    1.b)For your uploaded to server projects Batch IDs are unique across all projects. Meaning uploading another project to server won't change ID count.
    3)It absolutely doesn't matter if batch was either processed or deleted\etc. ID of a deleted\processed batch won't be assigned to any other one after that.
    4)As this property is read-only you cannot change it without manipulating FlexiCapture system files(I strongly recommend not to do that). But it can be read\stored and used somehow.
    5)It is possible to use batch processing script to make each batch name unique using its ID.

    Hope that helped,
    Vladislav


    Thank you for your answer.

    But, I need to know about large values of batch number. like 99999999 or other

    Thank you.
    0
  • Avatar
    Vladislav Suvorov
    Hello,

    The maximum ID of a batch is 2 147 483 647 which is essentially int32 maximum value. However, this ID won't automatically go down to 1. You will need to make special SQL command\s to reset it manually.

    Hope that helped,
    Vladislav
    0
  • Avatar
    laptorkung
    Hello,

    The maximum ID of a batch is 2 147 483 647 which is essentially int32 maximum value. However, this ID won't automatically go down to 1. You will need to make special SQL command\s to reset it manually.

    Hope that helped,
    Vladislav



    Hi.

    Can you explain me about how to make special SQL command\s to reset it manually?

    Because may be need to reset every year for start at 1 again.

    Thank you
    0
  • Avatar
    Vladislav Suvorov
    Hello James,

    Please read this post till the end.
    Me and my colleagues still STRONGLY recommend not to do that without extreme necessity and proper experience. It is very easy to corrupt the whole database.
    To perform ID reset please make sure that dbo.Batch table doesn't have any values at all(==is absolutely empty). Meaning you have to delete all of the batches from FlexiCapture before resetting ID.
    Here is a link that contains information about setting identity value in SQL database:https://msdn.microsoft.com/en-us/library/ms176057.aspx

    Best regards,
    Vladislav
    0
  • Avatar
    laptorkung
    Hello James,

    Please read this post till the end.
    Me and my colleagues still STRONGLY recommend not to do that without extreme necessity and proper experience. It is very easy to corrupt the whole database.
    To perform ID reset please make sure that dbo.Batch table doesn't have any values at all(==is absolutely empty). Meaning you have to delete all of the batches from FlexiCapture before resetting ID.
    Here is a link that contains information about setting identity value in SQL database:https://msdn.microsoft.com/en-us/library/ms176057.aspx

    Best regards,
    Vladislav


    Thank you for your response.

    I will inform my boss and be careful for this case.

    Best regards,
    James
    0

Please sign in to leave a comment.