Does anyone know how to get a list of the FEX names that are in a folder in Dev Studio? Thanks.

This message has been edited. Last edited by: Michele Brooks,

  
APP QUERY IBISAMP HOLD
TABLE FILE FOCAPPQ
PRINT
    FILENAME
       COMPUTE STUD_ID/A70  = GETTOK(FILENAME,70,1,'.',70,'A70') ;
       COMPUTE FILE_EXT/A70 = GETTOK(FILENAME,70,-1,'.',70,'A70') ;
WHERE TOTAL FILE_EXT EQ 'fex';
-* ON TABLE HOLD AS PROGRAMS
END
-EXIT

Replace IBISAMP with your folder...

Great! I'll try it. Thanks. Worked like a charm. Thanks again.

This message has been edited. Last edited by: Michele Brooks,

since you're in windows, there's always old school
CMD DIR C:\IBI\APPS\IBISAMP\*.FEX
will display to your screen
CMD DIR C:\IBI\APPS\IBISAMP\*.FEX > C:\IBI\APPS\IBISAMP\DELETEME.TXT /S
will save the list into a txt file
CMD DIR C:\IBI\APPS\IBISAMP\*.*
will display to your screen and redisplay your list and show your little list file

...and what if I want the same for a MR domain?

Hi Michele,
Welcome! Glad it worked for you...

Hi Dave,
In previous versions to 8, we use MREXTRACT(run nightly via ReportCaster) and read the txt files. 8 is now a repository...

@Dave
CMD DIR C:\IBI\WEBFOCUS77\BASEDIR\untitled\app\*.fex
etc...

susannah,

first of all, I don't like saving a hardcopy .txt to the server.

What happens if more than one user runs it?

...and, how can I query the contents?

I'll explain.
We have a 'custom' tree-view that displays all available fexi per user per domain.
This is done by parsing calling ( httprequest ) the server and parsing the domain.htm

Meanwhile we've migrated the reportingserver to windows.
I'm looking for a better ( faster ) solution.

Querying would be nice.

quote:

Originally posted by Michele Brooks:
Great! I'll try it. Thanks. Worked like a charm. Thanks again.

And is it possible to search a string of characters inside every fex ? for example : to display the fex list using 'BYTOC' ?