Oracle PL/SQL - Maintenance routines
4907
£25/hr(approx. $31/hr)
- Posted:
- Proposals: 2
- Remote
- #46820
- Archived
Description
Experience Level: Expert
We have data in spreadsheets that need to be loaded into tables then used to maintain a few tables.
There are two spreadsheets which look like this...
Spreadsheet 1 has two columns like this...
MENU1 ROLE1, ROLE2, ROLE3
MENU1->MENU2 ROLE1, ROLE2
MENU1->MENU2->MENU3
From this spreadsheet data we need to ensure our table checks to see whether MENU1 exists and if not, it adds it to the table.
It then needs to make sure ROLE1, ROLE2 and ROLE3 have access to MENU1. If it doesn\'t it should add them. If MENU1 currently has more roles than shown, a warning message should be displayed.
This is the first part of the process - checking that the menu structure specified is in place. The next part of the process is making sure reports are attached to the correct menu.
Spreadsheet 2 has two columns too.
source_report target_report
Source report is in the format MENU1->MENU2->REPORT1
target report is in the same format but may have a different report name e.g. MENU3->MENU4->REPORT8
This routine is letting our staff specify reports they want copied to other menus and often with other names. Essentially the system is supplied with standard reports and we would love to have virtual folders so that users could pick and choose reports of importance to them but this feature is not available.
Therefore, the next best thing is to copy the existing reports into a more user-friendly report structure. We want to automate this task with these routines so that when upgrades happen, we can re-run this routine to copy the updated reports to the appropriate places.
Clearly I will need to supply table structures and sample spreadsheets but hopefully this is enough to get us started.
There are two spreadsheets which look like this...
Spreadsheet 1 has two columns like this...
MENU1 ROLE1, ROLE2, ROLE3
MENU1->MENU2 ROLE1, ROLE2
MENU1->MENU2->MENU3
From this spreadsheet data we need to ensure our table checks to see whether MENU1 exists and if not, it adds it to the table.
It then needs to make sure ROLE1, ROLE2 and ROLE3 have access to MENU1. If it doesn\'t it should add them. If MENU1 currently has more roles than shown, a warning message should be displayed.
This is the first part of the process - checking that the menu structure specified is in place. The next part of the process is making sure reports are attached to the correct menu.
Spreadsheet 2 has two columns too.
source_report target_report
Source report is in the format MENU1->MENU2->REPORT1
target report is in the same format but may have a different report name e.g. MENU3->MENU4->REPORT8
This routine is letting our staff specify reports they want copied to other menus and often with other names. Essentially the system is supplied with standard reports and we would love to have virtual folders so that users could pick and choose reports of importance to them but this feature is not available.
Therefore, the next best thing is to copy the existing reports into a more user-friendly report structure. We want to automate this task with these routines so that when upgrades happen, we can re-run this routine to copy the updated reports to the appropriate places.
Clearly I will need to supply table structures and sample spreadsheets but hopefully this is enough to get us started.
Steve P.
0% (0)Projects Completed
2
Freelancers worked with
2
Projects awarded
100%
Last project
21 Mar 2011
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies