1 Reply Latest reply: Nov 4, 2016 6:05 AM by MelaSarenas _ RSS

    Setting up template for folders rpts with sub folders rpts ets

    Mark Holzweiss

      Hello,

       

      I need to setup a trap to list the Profile group the folders reports in the folders.  Now the problem there are sub folders and rpt is them, more sub folders with or without files in them. The way the report outputs is spaces in front of the data (added a underscore to show you).The output would be the Profile group, the folders, files, folders, files, which could also be folder, file, folder (no files), folder, files. By the name I know if it is a folder or a report in the folder

       

      ___User Name    Dusan

      ___Profile      HelpDesk

      ___FOLDERS AND REPORTS:

      ____Folder Helpdesk A at 5

      _____**REPORTS:** at 6

      _____Report HD 1 in folder HD A at 6

      _____Report HD 2 in folder HD A at 6

      ____Folder Helpdesk B at 5

      _____**REPORTS:** at 6

      _____Report HD 3 in folder HD B at 6

      _____Report HD 4 in folder HD B at 6

      ______Folder HD C at 7

      _______**REPORTS:** at 8

      _______Report HD 5 in folder B & C at 8

      ______Folder HD D at 7

      _______**REPORTS:**

      _______Report HD 6 in folder B & D at 8

      _______Report HD 7 in folder B & D at 8

       

       

       

      ___User Name    Bill

      ___Profile      Building Group

      ___FOLDERS AND REPORTS:

      ____Folder BG 1 at 5

      _____**REPORTS:**

      _____Report aa BG 1 in Folder BG 1 at 6

      _____Report bb BG 1 in Folder BG 1 at 6

      ____Folder BG 2 at 5

      ____Folder BG 3 at 6

            **REPORTS:** at 7

            Report cc BG 2 in Folder BG 2 & 3 at 6

            Report dd BG 2 in Folder BG 2 & 3 at 6

          Folder BG 4

           **REPORTS:**

           Report ee BG 4

          Folder BG 5

          Folder BG 6 at 5

           Folder BG 7 at 6

            **REPORTS:** at 7

            Reports ff in Folder BG 6 & 7 at 7

      _____Folder BG 8 at 6

      ______Reports at 7

      ______Folder BG 9

      _______**REPORTS:** at 8

             Report gg in Folder 6 8 9

            Folder BG 10 at 7

             **REPORTS:**

             Report hh in Folder 6 8 10

             Report ii in Folder 6 8 10

       

      without the lines

         User Name    Dusan

         Profile      HelpDesk

         FOLDERS AND REPORTS:

          Folder Helpdesk A at 5

           **REPORTS:** at 6

           Report HD 1 in folder HD A at 6

           Report HD 2 in folder HD A at 6

          Folder Helpdesk B at 5

           **REPORTS:** at 6

           Report HD 3 in folder HD B at 6

           Report HD 4 in folder HD B at 6

            Folder HD C at 7

             **REPORTS:** at 8

             Report HD 5 in folder B & C at 8

            Folder HD D at 7

             **REPORTS:**

             Report HD 6 in folder B & D at 8

             Report HD 7 in folder B & D at 8

       

         User Name    Bill

         Profile      Building Group

         FOLDERS AND REPORTS:

          Folder BG 1 at 5

           **REPORTS:**

           Report aa BG 1 in Folder BG 1 at 6

           Report bb BG 1 in Folder BG 1 at 6

          Folder BG 2 at 5

           Folder BG 3 at 6

            **REPORTS:** at 7

            Report cc BG 2 in Folder BG 2 & 3 at 6

            Report dd BG 2 in Folder BG 2 & 3 at 6

          Folder BG 4

           **REPORTS:**

           Report ee BG 4

          Folder BG 5

          Folder BG 6 at 5

           Folder BG 7 at 6

            **REPORTS:** at 7

            Reports ff in Folder BG 6 & 7 at 7

           Folder BG 8 at 6

            Reports at 7

            Folder BG 9

             **REPORTS:** at 8

             Report gg in Folder 6 8 9

            Folder BG 10 at 7

             **REPORTS:**

             Report hh in Folder 6 8 10

             Report ii in Folder 6 8 10

        • Re: Setting up template for folders rpts with sub folders rpts ets
          MelaSarenas _

          Hi Mark,

           

          Based on your sample report, would it be possible to give us what you need as an output?

           

          Is it something like this?

           

          Profile group, the folders, files, folders, files, which could also be folder, file, folder (no files), folder, files.

          'Helpdesk', 'Folder Helpdesk A at 5', 'Report HD 1 in folder HD A at 6', '', '', '', ''

          'Helpdesk', 'Folder Helpdesk A at 5', 'Report HD 2 in folder HD A at 6', '', '', '', ''

          'Helpdesk', 'Folder Helpdesk B at 5', 'Report HD 3 in folder HD B at 6', '', '', '', ''

          'Helpdesk', 'Folder Helpdesk B at 5', 'Report HD 4 in folder HD B at 6', '', '', '', ''

          'Helpdesk', 'Folder Helpdesk B at 5', '', 'Folder HD C at 7', 'Report HD 5 in folder B & C at 8', '', ''

          'Helpdesk', 'Folder Helpdesk B at 5', '', 'Folder HD D at 7', 'Report HD 6 in folder B & D at 8', '', ''

          'Helpdesk', 'Folder Helpdesk B at 5', '', 'Folder HD D at 7', 'Report HD 7 in folder B & D at 8', '', ''

          'Building Group', 'Folder BG 1 at 5', 'Report aa BG 1 in folder BG 1 at 6', '', '', '', ''

          'Building Group', 'Folder BG 1 at 5', 'Report bb BG 1 in folder BG 1 at 6', '', '', '', ''

          'Building Group', 'Folder BG 2 at 5', '', '', '', '', ''

          'Building Group', 'Folder BG 3 at 6', 'Report cc BG2 in Folder BG 2 & 3 at 6, '', '', '', ''

          'Building Group', 'Folder BG 3 at 6', 'Report dd BG2 in Folder BG 2 & 3 at 6, '', '', '', ''

          'Building Group', 'Folder BG 4', 'Report ee BG 4', '', '', '', ''

          'Building Group', 'Folder BG 5', '', '', '', '', ''

          'Building Group', 'Folder BG 6 at 5', '', 'Folder BG 7 at 6', 'Reports ff in Folder BG 6 & 7 at 7', '', ''

          'Building Group', 'Folder BG 8 at 6', 'Reports at 7', 'Folder BG 9', 'Report gg in Folder 6 8 9', 'Folder BG 10 at 7', 'Report hh in Folder 6 8 10'

          'Building Group', 'Folder BG 8 at 6', 'Reports at 7', 'Folder BG 9', 'Report gg in Folder 6 8 9', 'Folder BG 10 at 7', 'Report ii in Folder 6 8 10'

           

          Regards,

          Mela