New to xMII - help

[Former Member]

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

[Former Member]

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

[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

[Former Member]

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

[Former Member]

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.