Retrieve Folder or Directory list in Xacute

[Former Member]

In Xacute, it is pretty simple to use the getFile action block, but is there a way to "getDirectory" so I can retrieve a list of folders?

[Former Member]

How would you get a list of folders not under the transactions or any of the lighthammer directories?

Edited by: Christian Libich on Feb 29, 2008 3:43 PM

[jcgood25]

v12 replaces the FileSystemBrowser and TemplateService with the Catalog service (handles all of the DB ins and outs).

Directory list:

http://localhost/Lighthammer/Illuminator?Service=FileSystemBrowser&Mode=DirectoryList&Base=%2Finetpub%2Fwwwroot&Folder=Illuminator

File list:

http://localhost/Lighthammer/Illuminator?Service=FileSystemBrowser&Mode=FileList&Base=%2Finetpub%2Fwwwroot&Folder=Illuminator&Mask=*.irpt

[Former Member]

Thanks Jeremy! I owe you one!

[Former Member]

Standard warning applies, though: Avoid designing anything relating to the physical file system into a scenario where you will be needing/leveraging MII redundancy...either use the "virtual file system" in MII or use FTP.

[Former Member]

Does v12 support secure FTP?

[Former Member]

File I/O --> Get File List, mask = "*"

[jcgood25]

In 12.0 the TRX's are in the DB, so File I/O will not work like it does in 11.5.

http://localhost/Lighthammer/Illuminator?Server=XacuteConnector&Mode=TransactionList&Folder=XYZ/ABC&...

In BLS if you embedd an XML query template with the previous URL post or these requests you will get the desired info:

http://localhost/Lighthammer/Illuminator?QueryTemplate=Predefined/TransactionFolderListQuery&Content...

http://localhost/Lighthammer/Illuminator?QueryTemplate=Predefined/TransactionListQuery&Folder=[Param...

(a nice linkable Param.1 will be the Folder path, such as: Project or Project/FolderA/FolderB)

Regards,

Jeremy

[Former Member]

I guess I am not understanding how to set this up.

Do I create a new xml query and place this in the url source

http://localhost/Lighthammer/Illuminator?Server=XacuteConnector&Mode=TransactionList&Folder=XYZ/ABC&...

Then open xacute create an xml transaction and pick the xml query I just created?

[jcgood25]

Yes, that's correct (did you try it out?).

I would recommend the query template route I shared in my second post. With the Param.1 in the string it makes it very easy to extend.

Regards,

Jeremy

Edited by: Jeremy Good on Feb 22, 2008 1:18 PM

[Former Member]

This is the error I get from the BLS

<?xml version="1.0" encoding="utf-8"?>

<Rowsets DateCreated="2008-02-22T13:22:35" EndDate="2008-02-22T13:22:35" StartDate="2008-02-22T13:22:35" Version="11.5.2">

<FatalError>Premature end of file.</FatalError>

</Rowsets>

[jcgood25]

The forum mixed up the URL path, apparently it doesn't like the square bracket and wants to http prefix them.

Based upon your xml error you are on version 11.5, so if you create a new XML query and then provide a default value for Param.1 (any of your current root folder names should work):

http://localhost/Lighthammer/Illuminator?QueryTemplate=Predefined/TransactionListQuery&Folder=[Param.1]&Content-Type=text/xml

If the template test results work and you save it, I don't see why you should have problems inside BLS.

Regards,

Jeremy

[Former Member]

I am still getting a blank screen when I hit the test in the query editor. What should I do next?

[jcgood25]

With 133 posts and 0 points - are you an xMII trainer or 'in training' on xMII?

Try taking the Folder and parameter out of the URL and see if that XMLQuery works.

[Former Member]

I am not an instructor if that is what you are asking.

[Former Member]

The XMLQuery still does not work with the Param.1 removed.

[jcgood25]

Take a look in the General log for an error message that might shed some light on the issue.

[Former Member]

2008-02-22 14:39:39,984 ERROR Connector Error Processing XMLQuery Status (400): Bad Request

[jcgood25]

http://localhost/Lighthammer/Illuminator?Server=XacuteConnector&Mode=TransactionFolderList&Content-T...