CA Service Management

Expand all | Collapse all

How to create RDO from CSV file using where clause?

Jump to Best Answer
  • 1.  How to create RDO from CSV file using where clause?

    Posted 06-27-2017 08:20 AM

    Hi Team,

     

    Do we have any way to create RDO from a CSV file using where clause?

     

    Best Regards,

    Pankaj



  • 2.  Re: How to create RDO from CSV file using where clause?

    Broadcom Employee
    Posted 06-28-2017 03:52 AM

    Good Morning Pankaj.
     
    I assume the following.
    In CA Service Catalog(SC) you want to create a data object based on a CSV file.
    And then also want to have a kind of 'where clause' defined, similaro to an mssql query.
    Is this correct?
     
    When yes, I can then inform you that this kind of functionality needs is to be implemented.
        
    In general, for situations like this, where a user asks for a change of behaviour of the current release of the product, I can propose to add an Idea in the Communities.
     
    A new way to get your voice heard at CA is to suggest your Idea for review through the Service Management Global User Community.
    The CA Service Catalog Product Team is adopting the CA Community based ideation solution, which is available to you through the CA Service Management Global User Community.  
       
    The following steps will guide you to submit an Idea:
    - Logon to the CA Service Management Global User Community.
    - Select "CA Service Catalog" from the "Products Covered" menu on the right side of the page. (you might need to scroll down a little).
    - Click on the 'Ideas'(bulb-light) icon at the top to view the existing Ideas and see if your Idea has already been suggested.
      When yes, you can then vote-up on it (and add a comment).
    - If you have a new Idea, click on the "Create an Idea" link on the Actions menu at the left.  
     
    Once your Idea is submitted(publish), all members of the Community can view, comment, provide suggestions, discuss alternatives and vote on Ideas to define the highly popular features.
    All Ideas will be reviewed to see whether they can be implemented.
     
    Thanks in advance for your effort on this.
    With kind regards, Louis van Amelsfort.



  • 3.  Re: How to create RDO from CSV file using where clause?

    Posted 06-28-2017 05:01 AM

    Hi Louis,

     

    Please let me know if we can use "where" clause on RDO using CSV file.

     

    Thanks,

    Sivaranjani S



  • 4.  Re: How to create RDO from CSV file using where clause?

    Broadcom Employee
    Posted 06-28-2017 05:19 AM

    Good Morning Sivaranjani.
     
    With my apology for not being fully clear on this.
    When I wrote "this kind of functionality needs is to be implemented." I meant to say that there is no way to use or add a 'where' on a Data Object when a .csv file is being used as input/source for such.
     
    Thanks and kind regards, Louis.



  • 5.  Re: How to create RDO from CSV file using where clause?

    Posted 06-28-2017 05:36 AM

    Hi Louis,

     

    Am sorry, I didn't put across my question clearly.

     

    I intended to ask if there is a way to implement "Where" clause in Javascript at form level on RDO using .csv file 

     

    Thanks,

    Sivaranjani



  • 6.  Re: How to create RDO from CSV file using where clause?
    Best Answer

    Broadcom Employee
    Posted 06-28-2017 06:29 AM

    Hello Sivaranjani.
     

    With 'scripting' on the form, you can do a lot (almost all).

    Depending on the number of rows in the csv-file, you could read them all and skip those that do not comply.

    And then populate a 'table component' with the rows that do.

     

    Kind regards, Louis.



  • 7.  Re: How to create RDO from CSV file using where clause?

    Posted 06-28-2017 09:11 AM

    OK. Thanks!