NaturAppl Manual Fix - danmarksmiljoeportal/natur GitHub Wiki
The following page lists different ways in which you can try to fix issues with your NaturAppl version. Please contact Danmarks Miljøportal to find out which ones you should try.
Finding the NaturAppl data folder
Find your NaturAppl folder on your database as follows.
- Look for appdata folder: https://www.freecodecamp.org/news/appdata-where-to-find-the-appdata-folder-in-windows-10/
- Navigate to the folder: AppData\Roaming\NaturApplProd 3.0
- You should see something similar to the following:
1] the folders with a "GUID" (32 character string of letters and numbers) are individual user folders; i.e. when you log in you can have more users on the same NaturAppl version and each user will have his or her own folder with data 2] UserMetadata.xml folder contains information about the users who are using NaturAppl on the PC.
Finding a specific user's data folder
When you have more user folders in you appdata folder, you may need to find out which folder belongs to which user.
To do this you must open the UserMetadata.xml file. This you can open with fx the Notepad application.
Each user you have registered has its own section; look for each user as shown above.
Inside a section you can find all necessary information like:
- What roles did the user have the last time he logged in to NaturAppl.
- If you have multiple data folders, which one belongs to a specific user.
- What CVR abd email did the user have when he logged in. The above information might be vital to know when solving issues.
Fix Method 1 - Reset metadata for a specific user
- Close down you NaturAppl
- Open the data folder of the user you need to reset metadata for (see instructions above)
- Delete the folder called Metadata.db
Fix Method 2 - Remove all data of a specific user
WARNING: Only use this if you do not have any non committed data for that user!
- Close down you NaturAppl
- Find the data folder of the user you need to remove
- Delete the folder
Fix Method 3 - Fix the 'IsAlternative' issue
- Download SQLite: https://www.sqlite.org/download.html
- Use SQLite to open the NaturData.db database of a specific user (see above how to find user's data folder)
- Run the following script from the "Execute SQL" tab.
Script to insert:
ALTER TABLE [AktivitetStruktur] ADD [IsAlternative] bit NULL; UPDATE [AktivitetStruktur] SET [StatusKode] = 20 WHERE [StatusKode] = 10;