Adding additional tables to the extractor configuration

[Former Member]

Hi Experts,

Can you please help me adding additional tables to the SAP extractor and to configure the field data in the orgstructure to show a flag against the position.

Luke - I have tried using the option said by you from Application-wide Settings-->Data Centre --> Read SAP Table, it has properly save the added table, but not able to see it from SAP extractor configruation and not able to extract any data. Also, can you please guide me how to use the fields from this table (HRP1010) to write a small piece of logic to show a flag for a particualr position based on data.

Thanks in advance,

Purandhar

[Former Member · Accepted solution]

Hi Purandhar,

Did you start the extraction afterwards? like on page 27 of OrgChart Admin guide.

Do you receive any errors on the CDS.LOG?

Make sure that the user you are using has authorization within SAP ERP to view this table?

Hope this helps,

Kind Regards,

Matthew

[Former Member · Accepted solution]

Hi Matthew,

Thanks for your response.

Before starting the extraction, I didn't see any table which I have added in Data Centre, and I have no idea how to add additional table for extraction.

Kind Regards,

Purandhar

[lukemarson · Accepted solution]

Hi Purandhar,

I have tried using the option said by you from Application-wide Settings-->Data Centre
 --> Read SAP Table, it has properly save the added table, but not able to see it from 
SAP extractor configruation and not able to extract any data.

This has probably added a data element - I would check in the dataelementconfiguration folder in your build's .delta folder. IF so then you have the first step completed. Now you need to add the necessary configurations to use the data that comes through this data element.

Go to your orgchart/hierarchy and navigate to Views. Here select your view (or your first view if this needs to be done for more than one view - if so you'll need to repeate these steps but not the step you already did in the Data Centre), and then click the + icon next to Design Details. Here you can add a new linked detail to your view detail. Simply give it a name, select the detail to link it to (usually the top level detail which is in blue), select a link field and then select your data element that was created in the Data Centre.

Now if you try to add a section to your view inside the Design Details view designer you will see your new detail added. You can then select it and add fields from this detail.

Also, can you please guide me how to use the fields from this table (HRP1010) to write 
a small piece of logic to show a flag for a particualr position based on data.

Once you have been able to add the data in the views designer you will probably need to do some XML and XSL editing because you cannot edit XSL files in the AdminConsole and you will need to do this to get your icon/flag to show.

First of all you need to create a new XSL file and put it into a folder in your .delta\root folder. For example, My_XSL_files. Here you need to write the code to render your flag based on your variable. You can find plenty of examples in all of the pre-existing XSL files. Then you need to copy PresentationResources.xml to .delta\root\XML and add the reference to your new XSL file.

Go to your build's .delta folder and go to detailconfiguration. Find the detail you just created and open it. You'll find a section in their that you just added with a reference to an XSL file (e.g. if you added a Simple Caption section it will probably be something like SimpleCaptionXSL). Change this to the reference in the PresentationResources.xml.

Load your build in the AdminConsole and hit Publish. Once done you should see your icon. Sometimes if your XSL is invalid or the code doesn't work you won't see anything. This is not unusual as the whole process can be quite tricky - even for us with lots of experience!

Good luck!

Luke

[Former Member · Accepted solution]

Hi Luke,

You are Brilliant and thanks for your help to sort out this issue.

I am sharing some steps below, what I have done to get this functionallity worked(TVN 3.0 OrgChart).

1) Modified 'functionConfiguration.xml' in extractorSchema to add additional table and its fields

file path: /SAP/sap/TVD/J00/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__TVN_S11_1/.delta/SAPExtractor/extractorSchema

2) created new data element called 'ASL' from 'Application wide Settings->Data Centre->Read RDBMS Table' and mapped to 'POS_ASL' Oracle database table, where 'POS_ASL' is the destination table name in step1.

3) Created a new XSL file 'aslxsl.xsl' for Icon rendering and placed into the below path.

/SAP/sap/TVD/J00/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/Templates

4) Copied presentationresources.xml from the current build to it's '.delta' root folder, and then modified this file to include new presentation called 'AslXsl'.

<presentation name="AslXsl">

<file name="Templates\aslxsl.xsl"/>

</presentation>

5) Configure your Position View to add 'newly created Data element ie. ASL in step2 by clicking on Views->standard View-> Design Details.

Detail name: ASL

Select a detail to link to SAPPositionBasicViewDetailsConfiguration (which is in blue at the top)

Select a dataelement to use: ASL

with the above steps, you will be able to see the field ASL to use in the Views, add this field to the view. which creates a file in your .delta/AppResources/detailconfiguration path

Find the respective file which created newly and modify that XML file to include or replace presentation name with your custom/rendering presentation name.

eg:

changed from the below line

<presentation>SimpleValueXSL</presentation>

to the below

<presentation>AslXsl</presentation>

6) Once, the above steps are done, open your build from admin console then 'Save' and 'Publish'

7) Then Open your orgchart to see Icon/Flag as required for a particular additional/custom field.

Thanks and Regards

Purandhar