--- title: "Configuration Library" canonical: "https://servicedesk.maxgeo.com/space/LogChief/1275691094/Configuration%20Library" format: markdown --- > Macro (toc) This menu option provides Library related operations. These library tables are related to Configuration. Logchief will bring across the data for all the tables referenced by Configuration Tables and also tables referenced by referenced table. This cycle will fetch the data till last referenced table in hierarchy. User can also export the Library data as an XML file and later on import back or send it to another location and import back. Click on the ***Tools > Configurations**** Libraries...* menu item in the main window of LogChief ## **Refresh Libraries** This functionality will bring across the data, from MDS to Configuration database, for all the tables referenced by tables used in selected configuration, we call them library tables. It will also bring the data for tables referenced by library tables. Along with library tables, LogChief also provides an alternative option to bring across data for the tables other than a library. The list of tables to be refreshed or synchronized is stored in the LogChief System database ('LogChiefSystem3', in this example) in the table tblSYSLibraryTablesList. Setting the **'Refresh'** field to 'Y' will send all table records from the MDS to the configuration database. Setting the **'Synchronize'** field to 'Y' will send all table records from the configuration database to the MDS. **'Order'** field determines in which order records will be synchronized between the MDS and the configuration database. This is important if one table's records link on another table's records. Add and remove records from this table to alter how LogChief's Synchronization functions. There are few default table entries exist in this table. These tables are required by other MxApps which run from LogChief or run on the Configuration database. Note: You will need access to the server on which the LogChief System database is stored and have permissions to edit it's records in. ![image](media://48678e99-4dbd-457f-9863-d18a3701464e) On the main screen click the 'Refresh Libraries' button to perform a data synchronization between the MDS and configuration database. LogChief disables all triggers and constraints on the Configuration database before importing the data for Library tables. The only exception is for the tables mapped as Project & DataSet table-type. When the operation is complete, LogChief enables them again. **Note**: for the user to be able to access this option, they must first have a Configuration created and rights to log data. (Refer to 'User Groups' section for this). ![image](media://51fc028a-e38f-4378-ab02-dc315ba379e3) The refresh in progress: ![image](media://df4104c4-c7e7-4ba1-bb80-663703a65fe7) If any table added in "tblSYSLibraryTableList" table in the LogChief-System database references a table which is part of the Configuration, LogChief will only bring in the desired data for that table and will not delete or update any data. For example: **Configuration Database** Configuration Tables - tblDHColl, which has 3 records H001, H002 and H003 **LogChief-System Database** User added tblDHPhoto for Refresh-Library operation and tblDHPhoto is not part of Configuration Tables. Table tblDHPhoto references tblDHColl as library table for DataSet and Hole-ID **MDS** tblDHColl has amost 100 Hole-IDs from H001 to H100 tblDHPhoto has 10 rows which required H003, H004, H005 & H006 in tblDHColl Now if you perform a Refresh-Library, LogChief will bring 10 records for tblDHPhoto table and also bring in H004, H005 and H006 in tblDHColl table. H003 already exists in Configuration database so LogChief would not touch that Hole-ID ***Note - LogChief always applies this rule for tblDHColl table even if it is not part of the Configuration Tables.*** ## **Export Libraries** This option allows user to export the library tables in XML format. Export doesn't include extra tables from tblSYSLibraryTablesList. ![image](media://b139bd89-6251-4bff-86ca-959151f6a555) The following screen will be displayed by LogChief: ![image](media://a91cd8d1-0cd9-40fb-9a6c-d5849d466a27) A dropdown displays the configurations a user has access to. The next thing needed to do is to select the export path. LogChief will save XML Formatted data in the selected location. ## **Import Libraries** This functionality will allow a user to import library data for the **current configuration**. The user must select the configuration first before importing library data and make sure that they are selecting the correct file. This exported file can be from any computer, the same computer or from another user. ![image](media://7e67028b-5a64-45ca-9cbc-5fdc24c77756) ![image](media://42b904fd-5856-4e22-8384-79195c315b04)