Views:

Issue

You have several installations of KeySCAPE and wish to merge the softworks databases and share these in a common location with others in your team.

Solution

The default is to install the database locally so, unless KeySCAPE has been configured differently, any changes made will only be available on the local database. This means that others can't share your customisations. Also, if your hard drive fails and it is not backed up, you will lose any customisation.
We strongly recommend that the database is saved on a server, where it will be backed up and can be shared by others in the team. See: Share KeySCAPE Database
There is currently no option to merge databases but you can move the database location and combine content with others, as follows:
1. On the computer that has the most customisation (plant lists, mixes, etc.), open KeySCAPE and go to Core>Main>Configure
2. On the Softworks tab, next to ‘Database Name’ note the location and name of the database
Typically:
a. Location: C:\ProgramData\KeySCAPE Application Data\All Users\KeySOFTWORKS\Database
b. Database Name: KSW_Database.mdb
Note: if the location is already set to a shared location, go to step 7
3. Start Windows Explorer, go the folder defined and copy the named database (.mdb)
4. On the server (or shared PC), create an appropriately named folder and paste the database (.mdb) file here
5. Whilst still in Configure, Softworks tab, next to Database Name, pick […]. Browse to and open the shared copy of the database
6. Close the Configure dialog
 
This should now be using the shared copy of the database. Go to Softworks>Database Manager to confirm your customisations are still available.
7. On the second computer, open KeySCAPE and go to Softworks>Database Manager>Planting List and Mix tabs
 
If no custom planting list or mix groups have been created, close the Database Manager dialog and continue to step 10
 
8. On the Planting List tab, under the Groups window, pick Modify>Export Plant List Group and save the file to a known location. Repeat this for all remaining customised plant lists groups
9Whilst still in Database Manager, move to the Mix tabs and, if any customisations exist, use the respective Group>Modify>Export option to save the mix groups to a known location. Once all mixes and planting list groups have been exported, close the Database Manager
10. Go to Core>Main>Configure
11Next to Database Name, pick […]. Browse to and open the database located at the shared location (Step 3)
12. Close the Configure dialog
 
This should now be using the shared copy of the database. Go to Softworks>Database Manager to confirm you can see the customisations.
13. Go to Softworks>Database Manager>Planting Lists tab and Mix tabs and this time, under the respective Groups window, pick Modify>Import, browsing to a opening each of the plant list and mix groups exported at steps 8 and 9. Close the Database Manager once all imports are complete
14. Repeat steps 7 to 13 for any additional installations that wish to use or merge data with the shared KeySCAPE database
Warning: Saving the database to a file-sharing service, such as One Drive, Amazon Cloud, Dropbox or Google Drive, is not good practice as, these backup systems rely on synchronisation between the local and online copy. If the online connection is lost, there is a danger that when this connection is restored, the shared database is overwritten with your latest changes, losing changes that others may have made whist offline.
Related Products KeySCAPE