NAV 2009 - Where is the zup file?
In previous versions, all local client settings are stored in the .zup file. In Microsoft Dynamics NAV 2009, this is a bit more complex. This post tries to describe which settings are stored where.
In addition to that, with NAV 2009 you may be spending a lot of time looking for files with long folder-names. So this post also shows you the location of each file, to make it quicker to find them.
/// Blog updated October 2nd: Section "temporary server files" updated with path for Windows Server 2003.
Setup files and tables in NAV 2009
In NAV 2009, settings are stored in various places. The following lists what is stored where. some settings are stored in files, and some in tables. I hope I have included everything here. But if the list should be incomplete, I would appreciate comments at the end of this post.
Client side:
PersonalizationStore.xml
stored in:
%AppData%\Microsoft\Microsoft Dynamics NAV\
This file stores some personal settings for the client like resizing of columns. It is probably the closest thing to the old zup file there is. The data in this file is primarily binary because it it not supposed to be updated manually. Even if you could edit the file (if you could find the settings you wanted to edit), then this is unsupported. But, like the old zup file, you can delete or rename it, and next time the client opens, it will create a new one.
ClientUserSettings.Config
Stored in:
%ProgramData%\Microsoft\Microsoft Dynamics NAV\
This file is where you can set RTC to connect to a specific service tier and/or a specific port.
Server side:
CustomSettings.config
stored in (default):
C:\Program Files\Microsoft Dynamics NAV\60\Service\
This is where you set up parameters for the Service Tier like SQL Server name, Database name, port number etc.
temporary Server files
Stored in:
%ProgramData%\Microsoft\Microsoft Dynamics NAV\60\Server
/// Update
The path above is for a Vista OS. If you run NAV server on Windows Server 2003, the path is:
C:\Documents and Settings\All Users\Application Data\Microsoft\Microsoft Dynamics NAV\60\Server\
/// -----
The service tier uses this folder for various temporary files. It is definitely not recommended to change any files here! But it might be a place for troubleshooting certain problems (though I am not sure what kind of problems).
Tables:
2000000075 - "User Metadata"
When you go to "Customize this page", then it's stored here.If for example a user ads new parts, like a chart or does anythign else herel,this table contains one record for each urse, for ach pae that they have persinalised.
2000000071 - "Object Metadata"
This table stores all the objects for RTC. Whenever you compile an object, it transforms it to a format that is designed for RTC and stores it in this table. You can delete entries here, though I would not recommend it. But if you do, and want it back, then compile the missing object from Object Designer. The data in this table is generally binary, so also not something to modify and definitely not necessarily supported or documented.
Lars Lohndorf-Larsen
Microsoft Dynamics UK
Microsoft Customer Service and Support (CSS) EMEA
These postings are provided "AS IS" with no warranties and confer no rights. You assume all risk for your use.
Comments
Anonymous
November 02, 2008
Hi Lars. For the tables, don't forget the 2000000074 Profile Metadata table that stores the role-based personalizations that are saved when you make configurations with the -configure startup parameter. I was wondering whether you had any clues to the meaning of some of these XML files - they are a little cryptic to me.Anonymous
May 18, 2009
The comment has been removedAnonymous
May 18, 2009
Hello Dave, Yes, they are stored in PersonalizationStore.xml. If you allow something and then close RTC, then this file will get updated, and you will see a new tag like: <PersonalizationObject PersonalizationObjectId="AutomationHandler.AllowCreateComObject"> Unfortunately, the rest of this is binary, so it's not easy to see what you have allowed... To change it, you can delete this from the file (provided you can find the right place to delete it), or of course just delete the whole file. I hope this helps? LarsAnonymous
September 01, 2011
Hi Lars, if you print a classic report, and you modify the page properties of the printer, where will this be stored? i need special setup for an label printer to print labels via rtc.Anonymous
September 11, 2011
Hi Torsten, I beleive this will be stored in the .zup file. The .zup file is still in use for classic reports. Hope this helps? LarsAnonymous
January 03, 2012
I found this post doing a search for... "C:Documents and SettingsAll UsersApplication DataMicrosoftMicrosoft Dynamics NAV60Server" I have a situation at a client site where the...DomainUserTEMP child directories of this folder are holding a large number of *.tmp files, some very old, some very large. This is potentially going to become a problem with c: drive capacity at some point. Am I correct in assuming NAV should normally delete these files itself? Can I safely delete them now? By way of understanding why they persisting... if NAV closes abnormally might normal tidy up routines not run and delete these file? Any advice greatly received. Chris.Anonymous
February 06, 2013
In NAV 2009 - classic mode, there is still a ZUP file to be corrupted. I know, because when it's corrupted, NAV is useless. Given the topic of this post, I figured the OP would mention where the ZUP file is located. Silly me!Anonymous
February 06, 2013
ha ha yes, that part was not mentioned! For classic client the zup file is in this folder: %appdata% On my machine that's C:Usersuser.DOMAINAppDataRoaming Or start fin(sql).exe with shortcut id=c:xzup%username% to control where the zup is stored. Hope that helps Lars