Currently Being Moderated

As part of Duet Enterprise Feature Pack 1.0 we have shipped two features for Time Management scenarios on SharePoint. They are the Profile Based Forms & Aggregated Business Calendar. In this blog I would take you through the various configurations needed to get your Time Management scenarios up and running. We would proceed with the understanding that all the BCS model files and SharePoint solutions are deployed without any issues.

 

For profile based forms to work, all the user accessing the site should have their Active Directory profile synced into SharePoint user profile. Once this is done, the next job would be to sync the ERP CATS profile to be synced onto the SharePoint. That can be achieved by following the below mentioned steps:

 

 

  1. Go to the User Profile service in Central Administration by following the below links

Image1.jpg

 

     And then

 

Image2.jpg

 

 

 

     2.  Select “Configure Synchronization Connections” options as shown below.

      Image3.jpg


      3. Click on the create new connection and select a BCS connection option.

      Image4.jpg

 

 

 

 

     4. Setup the BCS connection as shown below.

    Image5.jpg   

   

Click on “OK”

 

 

     5. Now we need to create a custom user profile property to store the profile value. For this again navigate the User Profile services as shown in Step 1      and select Manage User Property.

     Image6.jpg

 

       6. Click on New Property

           Image7.jpg

     7. Please setup the new property as shown below.

     Image8.jpg

 

 

   Contd...

 

Image9.jpg

          With this our Sync setup is complete.

 

  

                         The next step would be to annotate the TIME BCS model to tell the UserProfile feature which hide for which profile. This had to be done in TIME           model alone and that too for specific finder method only.

 

 

                         Let me walk you through the annotation:

 

 

  1. Profile Field that we created in the above step to hold the cats profile value should be mentioned in the model at the entity level. This would tell UserProfile feature the name of the property to check in the UserProfile store for the cats profiles

      Image10.jpg


    2. In specific finder method we need to annotate every field that we need to hide for a particular profile as shown

     Image11.jpg

 

     There are couple of point worth mentioning here:

 

 

    1. We can annotate the fields with <Key>=<Value> pair. In the example above my profile key CVR has the value ESS_01 , ESS , ESS_02 . Both Key and value together become the annotation.
    2. We can simultaneously annotate the field with multiple key=value pair as shown. Each combination needs to be separated by semicolon (;).

 

 

     We can annotate as many fields as we want in the specific finder. If a field is not annotated, then by default that field will be shown for every profile.

 

     Now, to make the above mentioned activity of annotating the models little easier we have already shipped a report that will do this job for you. To run this      ABAP report logon to the Gateway system and follow the following steps.

 

 

    1. Go to SE80 transaction
    2. Open the package “/IWTNG/TIME_SERVICES”.
    3. Navigate to the report “/IWTNG/RP_UPDATE_TIMA_BDC”
      Image12.jpg

    4. Run the Report. It will ask you the Custom Property name that you created on SharePoint. In our example we used the name “TIMAProfile” so our screen would look like
      Image13.jpg

 

 

           Please note it would change the TIME model that is stored in the MIME. So it would ask you to create some transport request. So you should have             rights  to create transport request on the gateway system.

 

      Once this is done you can download the model from the BDC Browser tool (T Code:: /iwtng/bdc_browser) and deploy it onto the SharePoint

 

      

      Now we need to logon to the SharePoint site with Admin Credentials follow the below mentioned steps::

 

 

1.         1.  Activate Features

 

           a. Activate Aggregate Business Calendar Feature

 

 

    1. Open the site collection under the webapp on which you deployed the OBAExtensions.wsp Activate Aggregate calendar feature under site
      location
    2. Click Site Actions -> Site Settings 
    3. Click Site Collection Administration -> Site collection features

 

                     Image14.jpg

         Activate Aggregated Business Calendar feature Feature.

           Image15.jpg

 

     b. Activate Profile Based Forms Feature

       If you have deployed obaextensionsSDK.wsp, “Sample Profile based” feature will be installed in MOSS farm. This feature defines new list schema for                Time Management Virtual List and customizes Create, Edit and View forms for Time Management. To activate this sample feature,

     Go to your site where you have created Time Management Virtual List.

    1. Click Site Actions -> Site Settings
    2. Click Site Collection Administration -> Manage Site features

                   Image16.jpg

 

b.            Activate Sample profile based list feature

Image17.jpg

 

 

 

 

 

        If you want to do user profile based form customizations on VirtualLists other than Time Management, you have to create new list schema and list instance for you Virtual List and write your own custom feature to deploy custom list template. Steps to write your feature and to install it can be found here.

    

        Follow the step as mentioned above to activate your feature.

 

 

  2.   Add Aggregate Calendar Webpart to the page

 

 

     Create a site under site collection or you can use an existing site as well.

 

     Add a web part Page to the site Click Site Actions -> More Options...

 

     Select Web Part Page and create the web part page from one of the templates

    

     Click Add a Web Part in one of the zones in web part page

 

Image18.jpg         

      Select Aggregated Business Calendar Webpart under Business Data category and click Add

      Image19.jpg

 

 

3.       Add Data Sources

 

 

  1. Go the site where ‘Aggregate Business Calendar’ is stapled

           Image20.jpg

 

    ii.  Open web part editor control settings, by clicking over ‘Edit Webpart’. 

         

            https://cw.sdn.sap.com/cw/servlet/JiveServlet/downloadBody/149029-102-1-319817/Image21.jpg

 

 

 

 

     iii. Check 2 drop down lists – One showing already existing calendars and other one showing available types of calendar which can be added.

     iv. There are 3 types of data sources which can be added to the Webpart and a maximum of 4 data sources can be added.

      v. To add Time Management first we need to create an external list. If we have activated the profile bases feature, it would create an external list for us.

     vi. Once we have the external list ready we can choose a new “Business Calendar” as shown below
         
           https://cw.sdn.sap.com/cw/servlet/JiveServlet/downloadBody/149030-102-1-319818/Image22.jpg

     vii. After clicking the add button , please fill in the title , description and colour coding as per your wish and from the drop down select the Time Management list  (from previous steps) as shown below.
           https://cw.sdn.sap.com/cw/servlet/JiveServlet/downloadBody/149031-102-1-319819/Image23.jpg

     viii. Choose the view if you multiple views defined on the list and then click on “Save” button.

 

 

With this our Profile Based forms and Aggregated Business Calendar should be ready. Please note any external content type which is mapped to Outlook “Appointment” type would be available for mash up on the Aggregated Business Calendar but the profile based forms are built for only Time Management scenario.

 

 

Hope this blog helps you configure your Time Management scenario.

 

   

Cheers, Oyshik

Comments

Actions

Filter Blog

By author:
By date:
By tag: