5. Verifying the data model and uploading it

to upload a data model to litmus production record database or, if in offline mode, create a sql file, the configurator will always verify the configuration done by the user first to make sure that on a technical level all values are correctly formatted note the configurator will not verify if the data model makes sense or configured correctly according to what the user wanted to define verifying the configuration the configurator will always verify the configuration first before publishing users can run the verification also as a stand alone operation without publishing the data model using the verify configuration button in online modus, the user can be prompted multiple times, throughout the verification, to provide the sql authenticated login user name and password test for invalid ascii characters the verification process will verify in the sheets nodeoptions nodestructure items if any entry has invalid ascii characters to learn more about which ascii characters are allowed, review the section restrictions on ascii characters allowed to be used in the case that invalid characters are found, a prompt is shown to the user to inform them about the fact and request from the user to select the next action users can either stop the verification using the no option or replace all invalid characters with and underscore " " trim long strings the configurator also will auto trim all strings which exceed the allowed maximum length sheet string maximum length nodeoptions node name 50 nodeoptions node description 256 nodestructure level names 50 nodestructure level descriptions 256 items item name 50 items item description 256 verify every item has a value type set the configurator will verify that every item has a value type set if an item does have a missing value type, the user will be shown a prompt the user can define if they want to stop the verification using the yes option or set the default value type of isstring using the no option verify every item has an identifier setting the configurator will verify that every item has a value in the column labeled is identifier? if an item has no identifier setting, the user will be shown a prompt the user can define if they want to stop the verification using the yes option or set the default value of no using the no option verify the only hierarchy level 0 items are set as identifier the configurator will verify that only items defined under the hierarchy level 0 are set as identifier if an item which is not defined under hierarchy level 0, the user will be shown a prompt the user can define if they want to stop the verification using the yes option or clear the value for the column labeled node/level for this item to make it a hierarchy level 0 item using the no option verify that at least one item is set as an identifier as identifiers are essential for litmus production record database to be able to record production events, at least one item has to be set as a identifier why this is required can be reviewed in the chapter how are data recorded in litmus production record database docid\ ulfmhqnmwb91rkntbaqqn if no item is set as identifier, the user will be prompted the user can define if they want to stop the verification using the yes option or ignore the warning using the no option there can be reasons why a user has not set any item as identifier in the current configuration such as adding new items to an existing data model while the configurator does allow the upload of a configuration without an identifier, users have to make sure that the data model has at least one identifier set up this can for example be checked by reading back an existing data model as shown in the chapter 2 defining the data model name and number of hierarchy levels docid\ rxq28wvkkcydozezewunw uploading the data model to litmus production record database to upload the configuration as new data model or update an existing data model, the user will need to have a connection to the sql server as well as the databases le productionrecord in place to upload the configuration, the user does press the button verify and upload throughout the process, the user can be prompted multiple times, throughout the verification, to provide the sql authenticated login user name and password the configurator will first run the verification process which was explained in the previous section progress is shown by a progress bar only if the verification has found no errors or was stopped, will the configurator upload the configuration to litmus production record database up on completing the upload, the user will be shown a summary of the sql logs to be able to review if all items where correctly added to litmus production record database or if any errors occurred on the sql side this log extract can be saved as a file using the save output to file button the file will be stored in the same folder, where the file litmus production record data model configurator v1 0 0 xlsm is located the name includes the name of the user as well as the date and time of the upload close sql out put window to finish the configuration creating a sql file in offline mode in offline mode, the user can create a sql file which can be later executed using applications like sql management studio to create a new data model or update an existing data model in litmus production record database to create the sql file, the user does press the button verify and upload the configurator will first run the verification process which was explained in the previous section only if the verification has found no errors or was stopped, will the configurator create the content of the file the user is then prompted to select the path where the file is stored as well as being able to modify the file name before saving it the result is a file with the ending " sql " which can be executed using applications like sql server management studio