Workflow Soluiton

 View Only
  • 1.  How to Write data to CSV File

    Posted Jan 28, 2010 03:48 PM


    Hello, I would like to accomplish the following using workflow.

    1. A user fills out a form with different types of inputs such as dropdowns, text boxes, checkboxes, ect...
    2. Once that information is filled out, it goes to approval via e-mail.
    3. If approved then I would like to either add this data to a custom resource within the CMDB.

    I cannot figure out how to create a CI from workflow so I'm thinking that I could write this data to a CSV file then import that information into Altiris via connector solution. I've been looking through these posts and have figured out how to add data to a CSV file, but this data is over written every time the form is filled out. Does anyone know how to create a separate line after the form is filled out? I was thinking if there is some way to parse the file to find a blank “A” column to write the data it would work.

    Any ideas?



  • 2.  RE: How to Write data to CSV File

    Posted Jan 29, 2010 08:10 AM
    To create a resource in the CMDB, you can do the following:

    1. Add a Create NS Credentials component
    2. Add a Create Resource component (for NS 6) or a Create Resource For NS 7 component (for, well, you know) and add your data mapping.

    If you can't find the specified resource type in the create resource dropdown, you'll have to "regenerate" the Generated.Resource DLL against your particular NS to pick it up. Afterwards, the type should appear in the list.


  • 3.  RE: How to Write data to CSV File

    Posted Jan 29, 2010 03:17 PM
    Thanks for the reply, I followed the instructions from the Workflow 7.0 manual although I'm using 6.0, but it still is not pulling up my custom resource or any custom resources for that matter. To generate libraries with the Symantec Management Platform generators 1 In the Workflow Designer loading window, click New. 2 Select the Integration project type. 3 Type a name for your library and click OK. 4 Select the Workflow generator you want to use and click OK. A pop up appears for Resource, ASDK, and Task generators that indicates they are singleton generators. Only one project is allowed for these types of generators, and running these generators overwrites the existing project. 5 If you chose the Report Component generator, select the configuration you want to find the reports you want to generate. 6 Click Compile and Close. 7 Repeat the above steps for each generator that you want to run. The components generated by component generators are placed in custom libraries. You add these libraries to your projects to use the generated components. To import custom libraries of the Symantec Management Platform components into the component toolbox 1 In Workflow Designer, open a project. 2 Click Import Components. 3 In the Add Library to Project dialog box, click the Custom Libraries tab. Workflow 7.0 and the Symantec Management Platform 117 How to prepare for your first use of Workflow Designer on the Symantec platform 4 Select the library that was generated by the component generator. 5 Click Add, and then OK. The new components show up under the Symantec branch and any branch with an orange star appearing in the component toolbox. Importing Symantec components When Workflow Designer is installed, a Symantec branch appears in the component list. This branch contains some of the Symantec components. You can import more Symantec components as needed. To import Symantec components 1 In Workflow Designer, open a project. 2 Under the component toolbox, click Import Components. 3 Click the Custom Libraries tab. 4 Select the libraries you want to import. 5 Click Add, and then OK. The Symantec components show up under the Symantec branch and any branch with an orange star appearing in the Component Toolbox.


  • 4.  RE: How to Write data to CSV File

    Posted Jan 29, 2010 03:36 PM
    I see one step that looks like it's been missed here... after the initial run through of contacting the resource service, you need to click "Adjust Definitions" to see what has been discovered. I usually check Select All and OK/Next out of this page. Then, once you're back on the Compile + Close popup, you should compile and close.

    I should contact someone about this so it gets updated. This applies to the Task generator as well. The ASDK/Report stuff doesn't behave in this manner.


  • 5.  RE: How to Write data to CSV File

    Posted Jan 29, 2010 04:24 PM
    I made the change there but I still don't see my custom resource.


  • 6.  RE: How to Write data to CSV File

    Posted Feb 03, 2010 09:09 AM
    The generator collects all resources from the NS6 via a web service call to the ResourceModel's GetResourceStructureList. This web service is basically a wrapper for the spSVCGetResourceTypes stored proc in the CMDB. If neither of these methods expose your type, it won't be exposed in the generator.

    I would assume that your resource type would have to be at least based on the Resource type to come back.


  • 7.  RE: How to Write data to CSV File

    Posted Mar 03, 2010 11:12 AM
    I checked it again and my custom resource is based on the resource type, but still didn't work. To "workaround" this I created a new database and populated it with the same tables and columns as my custom resource. I then created a custom component that will write data to these tables based on a form I created. Once it writes to my temp database, I use the Altiris connector solution to pull that data from the temp database into Altiris and my custom resource. It adds a few steps, but does the trick.