08-04-2019 10:34 PM - edited 08-04-2019 10:40 PM
Hello,
We will change many diagrams in a batch (Add a title + change of Shapes Version).
However, we don't want the diagram' properties Modifier & Modification Date to change as this won't be a change in the content as per our definition.
We tried the following:
- Export Tool (xls): Export all diagram with the properties Modifier & Modification Date
- Batch change
- Import Tool (xls): Reimport all diagram with the properties Modifier & Modification Date
However, it came back as an error (red columns for Modifier & Modification Date).
We then tried to change the CRUD for the profile doing to change (Hopex Customizer) from *RU to RU. It came back as an error aswell.
Do you have any idea on how we could accomplish that ?
Thanks,
Raphael.
09-04-2019 06:10 PM - edited 09-04-2019 06:11 PM
Thank you both for your answers.
We will go to the MGR route then.
Can you point the dangers of using such a method ?
We have tried with one Value Stream Diagram.
1. Export one diagram as a MGR file (4887 lines)
2. Change only the .update in formation
3. Reimport the diagram.
==> SUCCESS
We then tried the following:
1. Export one diagram as a MGR file (4887 lines)
2. Remove everything except the Diagram Update part (-> 5lines) . We also removed the dash at th end.
- "Diagram" "B204C3A84FAA5A06" .Update ."~KekPBSs3iS10[Diagram]" "B204C3A84FAA5A06" - .CHK "wHWieEigFPWM" - ."~610000000P00[Modification Date]" "2017/10/15 20:10:23" - ."~b10000000L20[Modifier]" "Vi(rUYD7OPIJ"
3. Reimport the diagram.
==> SUCCESS
Would the latest method considered as safe/efficient ?
It would allow us to combine Excel export and some VBA to generate the needed MGR file to restore the Modifier and Modification dates easilly. (In this ex, B204C3A84FAA5A06 being the Hexa id, wHWieEigFPWM the absolute id, and Vi(rUYD7OPIJ that we would cross-red with Users export)
Thanks again !
09-04-2019 10:14 AM
Hello,
I confirm Jérôme answer and I can add that some column cannot be imported with Excel no matter the access rights you give.
Should you need to keep the modifier name and date, as Jérôme said, you should manage it with export/import of MGR file. Nevertheless this is very advance technics of managing MGR file that I would not recommend.
Regards
09-04-2019 09:00 AM
Hello
Such properties (modifier...) are properties managed by the system.
They can be updated in interactive mode because a control is implemented to update the values.
As such they cannot be updated using Excel import.
You can try to update the values using MGR command files.