Skip to Content
author's profile photo Former Member
Former Member

New to xMII - help

Hi,

I am trying to build a small interface -

1. Get data from database with several rows and columns

2. Each column is has a where clause and hence I have built a query template that will accept parameters.

3. Put all the columns together to build a resultant recordset.

4. Put the resultset into excel and save the file.

I would like to know how to perform these steps in xMII. Can someone please help?

I greatly appreciate your response.

Thanks.

Vijayshankaran

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 29, 2007 at 10:30 AM

    Hi Vijay,

    In xMII you can save the output result set into a CSV file (Comma seperated values). For this thing you can generate the excel sheet by accessing the query template using the URL as follows

    http://<server name>/Lighthammer/Illuminator?QueryTemplate=< QT>&Content-type=text/csv.

    For this you need to pass the username and password as well.

    Thanks,

    Rajesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 31, 2007 at 04:10 AM

    Hi Vijayshankaran

    As the initial step of getting the data , i hope you have already built a query template with the conditions for columns as params.

    using the URL as posted by rajesh along with the inputs to be mapped included in the URL itself you can directly get the data into a xsl file . To save the file you will have to make a transaction which would have a xml query and a write file action block.

    The xml query would be the URL as stated and then write file would be the saving the output of the query as *.xls in the desired destination.

    For detailed information about the same refer to the help with the search words " Query Construction"

    regards,

    Rajeev

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 31, 2007 at 01:05 PM

    I am not able to follow the steps. Where in the xml query should I give the URL?

    Also, I haveseveral queries that I need to run with different imput paramters. But the result from all these queries needs to be put together into one spread sheet. How can I do this?

    I greatly appreciate your response.

    Thank you.

    Vijayshankaran

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Vijayshankaran,

      You have to create a BLS Transaction.

      In addition to creating the input parameters required for your queries create an output transaction parameter say"output".

      Add all the queries to a sequence with their respective parameters.

      In the next sequence add a XML joiner Action block.map the query templates accordingly in the incoming tab links.

      In the next sequence add a XML Saver action block.In the incoming tab of this action, map the output of the joiner.In the outgoing tab of this action map the reult xml to the "output" transaction param.

      Save this Transcation.

      Now Create a xAcute Query template and map the above transaction.

      Save this query Template.

      Now use the url given by Rajesh pointing to this xacute query template and save the file as *.xls.

      Hope this helps,

      Ram

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.