Your explanation is a little confusing: Did you do a
synchronize in your own environment? What version of Axapta are you
using?
From: Danny Gaethofs [mailto:[EMAIL PROTECTED]
Sent: Monday, January 10, 2005 9:57 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Re: VAR/USR Layer changes and data
Dear all,
The reason for my question was that my customer made noticed after
they installed the var layer that the field values were deleted.
I did some testing in my own environment. I removed the USR layer
file axusr.aod and related files and replaced them by axvar.aod.
After logging back into axapta I saw the id's of the fields were
changed from 500001 to 300001.
The data in the fields was not deleted.
I conclude that using this approach replacing axusr.aod with
axvar.aod will not change the content of the fields in the table
being modified. Only thing that is changed are the id's.
regards,
Danny
--- In Axapta-Knowledge-Village@yahoogroups.com, "Jesper Kehlet"
<[EMAIL PROTECTED]> wrote:
> Use the SQL Administration/Tables/Synchronize -- it works just
fine, at
> least in 3.0.
>
> Another way to go about this, and if it's only a few fields
(Caution:
> Should be done in 2-tier mode with AOSs shut down, and without
anybody
> else in the system!):
>
> 1. In the SqlDictionary table, find the fields, and change
their
> field ids to the new field ids (5xxxx -> 3xxxx), then log out.
> 2. Put the new VAR/USR layer in there.
> 3. Start Axapta and perform synchronization to create other
new
> fields etc.
>
> Of course, test it in a test environment before you perform
updates in
> live environments -- you may experience some trouble that causes
it to
> go haywire, especially in heavily customized systems.
>
> ________________________________
>
> From: Danny Gaethofs [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 10, 2005 8:12 AM
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: [Axapta-Knowledge-Village] VAR/USR Layer changes and data
>
>
>
> Dear all,
>
> One of my customers has made table changes in the usr layer. They
> added new fields. These fields have been used already in their
> production database and of course values have been entered.
>
> Now I need to transfer these changes to the VAR layer.
>
> I notice when I just export the changes and import them in the var
> layer, nothing happens. Is this correct, I assume it is a way the
> software is trying to keep things consistent. As such it is not
> possible to overwrite changes made in the user layer.
>
> Am I correct that it is not possible to load these changes into
the
> var layer while they are still in the usr layer. Is this behavior
> only valid for tables?
>
> How can I get the changes transferred to the var layer without
> loosing the data already entered.
>
> regards,
> Danny Gaethofs
>
>
>
>
>
> Sharing the knowledge on Axapta.
>
>
>
> ________________________________
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/Axapta-Knowledge-Village/
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]
subject=Uns
> ubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
