DAVID Systems

Portal  FAQ  Search  Usergroups  Register  Profile


Site Menu
 News (Home)
 Community Forum
 Knowledge Base & FAQ
 Product Lifecycle
 Software Download
 Desktop Searching

My DigaSystem
 TestTrack Login
 Contact Support
 Hardware return

Module Database
 All Parameters
Search Parameters

Log in
Username:

Password:

Remember Password 



I forgot my password

Don't have an account yet?
Join Us Now!

DAVID Systems - Customer Service Portal Forum Index -> General ->
Defining a global unique identifier (running number)

Post new topic   Reply to topic    Printer-friendly view
View previous topic :: View next topic  
Author Message
mb
All-Star
All-Star


Joined: 23 Dec 2005
Posts: 436
Location: Berlin

PostPosted: Thu, 8. Oct 09, 12:40    Post subject: Defining a global unique identifier (running number) Reply with quote

In DigaSystem each item of a table has a unique reference number. Additional there are database fields which can be filled automatically to create metadata with unique numbers like MUSICID or MOTIVE for e.g. music or commercials.

All of these unique values are based on tables.

In some special workflows it is necessary to have a global unique ID system which ensures that everything which is created at e.g. one local site has its own numbering system.

With the current version 3.3.x.x of DigaSQL.dll and DBM this is possible by defining the following global parameters:

Global Settings \ DigaSQL \ RunningNumber :

Column = Your database field, e.g. REGISTRATION for storing the numbers inside the field [REGISTRATION] File = \\server\share\runningnumber.cnt Header = This is a prefix which can describe your local site, e.g. BERLIN- Mode = Complete (does not overwrite existing metadata) Range = 0001-9999 (Describes the range of unique IDs

Unfortunately the description in DigParam.rtf is not good for reading it in Infopad. Therefore we are posting the content here:

- New entry Mode REPLACE (default): New RN Mode COMPLETE: New RN

- Copy complete Metadata from Original; RN exists in Source Mode REPLACE (default): New RN Mode COMPLETE: New RN

- Copy complete Metadata from Original; RN does not exist in Source Mode REPLACE (default): New RN Mode COMPLETE: New RN

- Copy an entry within the same table Mode REPLACE (default): New RN Mode COMPLETE: Old RN

- Copy an entry into a new table Mode REPLACE (default): New RN Mode COMPLETE: Old RN

- Simulated Overwrite (replacing an existing entry) Mode REPLACE (default): New RN Mode COMPLETE: New RN

- Move an entry between tables Mode REPLACE (default): New RN Mode COMPLETE: Old RN

- Modify Metadata Mode REPLACE (default): Old RN Mode COMPLETE: Old RN

- Add text media file Mode REPLACE (default): Old RN Mode COMPLETE: Old RN

- Add any media file Mode REPLACE (default): Old RN Mode COMPLETE: Old RN

- Create entry through automated processes (e.g. DigAlign, Replication); target entry exists

Mode REPLACE (default): Old RN Mode COMPLETE: Old RN

- Create entry through automated processes (e.g. DigAlign, Replication); target entry does not exist; Source contains RN

Mode REPLACE (default): New RN Mode COMPLETE: Old RN

- Create entry through automated processes (e.g. DigAlign, Replication); target entry does not exist; Source does not contain RN

Mode REPLACE (default): New RN Mode COMPLETE: New RN

_________________
Michael Burkhardt
DigaSystem Expert since 2001
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Printer-friendly view Page 1 of 1




Jump to:  


Forum Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum