Why the import button is grayed out
In the latest version of Data Manager, only one user can edit the database at a time. This is to prevent multiple users from stepping on each other's work which could result in Data loss.
In Data Manager, any user that has edit right will see the Access Tab when they click on their Cost Database.
When that user clicks on this tab they will see the Aquire Lock button. This button is the manual override if the last user that edits the database lock didn't update properly after they close out of Data Manager.
When a user clicks that Acquire Lock they now have edit rights to the database until they close the application.
Hosted Environment Data Manager lock
In the Hosted Environment, that tab is not enabled because Beck Technology is responsible for the database operations. If this happens, we will run the script below to clear the table that controls the lock.
DELETE
FROM [dbo].[Synchronization]
WHERE [dbo].[Synchronization].CostStructureType Not in ('ASSEMBLY', 'BUILDING_TYPE', 'CHOICE', 'COLLECTION', 'CONCEPTUAL_ASSEMBLY', 'COST_ITEM_PROP',
'FORMULA', 'LINE_ITEM', 'MARKUP', 'RATE_TABLE', 'RESOURCE', 'RESOURCE_GROUP', 'UNIT_OF_MEASURE', 'VARIABLE', 'WBS_PROPERTY')