Atrium Navigation Menu and User setup movement across environments

[arora.saurabh]

Hello,

We have a scenario wherein we need to copy/create the Menu's/User's in different environments (ports). We have different ProfoundUI environments for Test/Stage/Prod. We create the menu's and add authorities to it in Test environment and as the changes move to stage, we need to setup the same menu's/authorities in the stage environment. To reduce the re-work and avoid any issues in setting the menu's, we planned on creating a program to copy the ATNAVP and other related files. But there are some ID's (e.g. ANITEM in file ATNAVP) which are assigned to each record. We are facing problem in assigning these ID's in this process.

-- > Are these ID's assigned by incrementing the last ID assigned in the table or is there any data area/file which specify the next ID number available.
-- > Will you suggest taking this approach for creating the menu's/user's or if you have an alternate way to automate this.

Thanks in advance !!

Thanks,
Saurabh

[matt.denninghoff]

This documentation page describes the Atrium database:
http://www.profoundlogic.com/docs/displ ... m+Database

I added a couple things to help clarify: see ATUIDSP and ANSEQ under ATNAVP.

The ANITEM values are not automatically incremented. Rather there is a file ATUIDSP, which holds the next ANITEM value that should be used.

We don't have an alternate way to automate merging items between two different Atrium databases. Using a program to do it should be fine if you follow the conventions we use in the database.