cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Modifier & Modification Date properties => Restore

RGenin
Trusted Contributor

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.

 

Snag_f37ea01.png

 

 

Do you have any idea on how we could accomplish that ?

 

Thanks, 

Raphael.

3 Replies

RGenin
Trusted Contributor

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 !

oguimard
Retired

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

jhorber
MEGA
MEGA

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.

Jerome