How to Design and Build the Solution Manager Process Tree – Part 2

[odedd]

Hi Guys!

Now that we have an Excel file representing our processes we can build an equivalent excel file that is in the format needed to upload to SOLMAN 7.2.

Suppose we want to upload the content of the first excel example I gave in Part1: Scenario AAA, Process XXX etc. You can use the following steps to transform this file to the correct import format:

1. Create an Excel file with two Tabs named “DRAFT” and “IMPORT”.

       2. Paste the first example file into the DRAFT Tab.

       3. In the IMPORT Tab enter these 3 lines:

       4. In the next line copy these Excel Functions into each Cell from Column B to H:

B4 –

=IF(DRAFT!A2>"","Create a Scenario",IF(DRAFT!B2>"","Create a Process",IF(DRAFT!C2>"","Create a Process Step",IF(DRAFT!D2>"","Create an executable element. Name will be determined from system found in logical component group.","DUM"))))

C4 –

=IF(DRAFT!A2>"","1",IF(DRAFT!B2>"","2",IF(DRAFT!C2>””,”3”,IF(DRAFT!D2>””,”4”,”DUM”))))

D4 –

=IF(DRAFT!A2>"","SCN",IF(DRAFT!B2>"","PROC",IF(DRAFT!C2>"","REF_PROCSTEP",IF(DRAFT!D2>"","REF_EXECTRANLOGCOMP","DUM"))))

E4 –

=IF(DRAFT!A2>"",DRAFT!A2,IF(DRAFT!B2>"",DRAFT!B2,IF(DRAFT!C2>"",DRAFT!C2,"")))

F4 –

=IF(DRAFT!D2>"","TRANID","")

G4 –

=IF(DRAFT!D2>"",DRAFT!D2,"")

H4 –

=IF(DRAFT!D2>"","ECC","")

In the last column, H, enter the Logical Component Group name of the system your are documenting instead of “ECC”.

       5. Now you will have this appearance where the first scenario line, AAA, was copied

           from the DRAFT Tab (according to the Import format).

      6. Drag line 4 down to line 14 and you will transfer the entire DRAFT Tab to the IMPORT

          Tab:

      7. To perform this transformation of an actual Process tree you have prepared simply

           count the number of lines in your file, paste into the DRAFT Tab and drag line 4 of

            the IMPORT Tab down to the number of lines you have.

      8. You can Import this file to the Solution Documentation:

      9. Save the IMPORT Tab in to a Text(Tab delimited) file , Tools --> Web Options -->

          Encoding --> Save This Document as (Unicode - UTF-8)

      10. Run SOLADM in SOLMAN.

      11. Go to Import Tab.

      12. Pick Import from file. And pick this file.

Note that in this example the first Scenario will be directly placed under Business Processes. You can add any number of Folders to the left of it.

Additional Executables – In my example I dealt only with Transactions. If you need other kinds either add them manually to the Tree if they are few or add additional Excel functions in the import file for this.

Good Luck and Good Health!

Oded Dagan