Announcements
i am trying to merging modified object from nav 2013r2 to nav 2015 using windows powershell ISE.
my question is i want to find all the conflicted object .?
*This post is locked for comments
for that you would need a "where used function" like in the OM Tools from idyn.
follow www.idyn.nl/.../object-manager-advanced
or statical prism
follow http://www.stati-cal.com/
also check out community.dynamics.com/.../34-where-used-34-as-simple-as-you-can-get-it
Hi Javed,
You can start like this -
1. Make Sure that the Language Layer is same in NAV 2013 R2 base objects (Crouns Objects) and Nav 2013 R2 Custom Objects (Customer Objects).
2. Create a object only database for both database (Cronus and Customer) and do following -
a. Create a Batch on object table (exclude tabledata) which sets these properties with below values -
> Modified - False.
> Version List - Upgrade.
> Day - Say Today.
> Time - Say 12:00:00
b. Run that batch on both the database. Once Executed export all objects from both database as text -
> Base Crouns database - Standard.txt.
> Customer Database - Custom.txt
c. Once you have both the file use Compare powershell utility with these two files.
Refer Here (Part 1 only -Compare) -
saurav-nav.blogspot.in/.../application-merge-utilities-how-to-use_15.html
d. The Result of Compare utility will be a set of delta files. No of files inside delta folder will be your object count.
Hope it clears the doubt.
Hello Saurav Sir ,
Sorry to asked but i didnt get what you mean by this
----------------------
Create a object only database for both database (Cronus and Customer) and do following -
---------------------------------------------------------------------------------------
how can i do the above things
Hey Javed,
What I meant is -
1. Creating object only database is - Instead of this step you can keep a backup of all objects as fob, as we are changing properties of the objects. Do keep FOB of both database as safe.
2. Why we need to do this is - as powershell utility (or any auto merge utility) compare everything as text comparison.
Sometime we just design and save object or change the version. It changes the Modified, version, date and Time Properties of objects. We don't want to consider those objects as actually there is no change except property.
For Skipping those we need to set the properties of all objects as same.
** Hope you understand what I meant.
You can create a Report with dataItem Object filtered for Object Type <> TableData & <> Menusuit.
IN on aftergetrecord you can set it like -
Modified := False
VersionList := 'Upgrade'
Date := Today
Time := 12:00:00
Run the Report and the changes that we wanted will happen in all objects.
Hello Saurav Sir
i am not seeing any changes in all the object';
What u did?
i taken a dataitem as object
in the DataItemTableView:=WHERE(Type=FILTER(<>TableData),Type=FILTER(<>MenuSuite))
in the onaftergetrecord
//
Modified := FALSE;
"Version List":= 'Upgrade';
Date := TODAY;
Time:=Time;
DataItem, Table View - SORTING(Type,Company Name,ID) ORDER(Ascending) WHERE(Type=FILTER(<>TableData&<>MenuSuite))
OnPreDataItem-
Object.MODIFYALL(Modified,FALSE);
Object.MODIFYALL(Date,TODAY);
Object.MODIFYALL(Time,120000T);
Object.MODIFYALL("Version List",'UPGRADE');
Sir
Microsoft Dynamics NAV
---------------------------
You cannot modify table data in the Object table. Modify the table definition instead.
OK
Getting this error
Are you using Developer License?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
