I can’t get this to working guys…Any help would be appreciated.

I’m working in MRE and I wanted to generate a report out of simple test.csv file. Copied this test.csv file into “other’ folder.
---TEST.CSV --
column_A,column_B,column_C,column_D
A1,B1,C1,D1
A2,B2,C2,D2
A3,B3,C3,D3

My Fex looks like this……..
-*

  
FILE=TEST, SUFFIX=COMT, DATASET='app/test.csv'
SEGNAME=ROOT_SEG, SEGTYPE=S1, $
FIELD=EMP_NAME, ALIAS=EMP_NAME, USAGE=A50, ACTUAL=A50, $
FIELD=EMP_NO, ALIAS=EMP_NO, USAGE=A50, ACTUAL=A50, $
FIELD=EMP_NAME1, ALIAS=EMP_NAME1, USAGE=A50, ACTUAL=A50, $
FIELD=EMP_NAME2, ALIAS=EMP_NAME2, USAGE=A50, ACTUAL=A50, $

TABLE FILE TEST
PRINT *
END

This message has been edited. Last edited by: Kerry,

What is the error ?

I am not sure what happens when your data file is in MRE.

You'll have to read the documentation about the "Other" folder.

FILE=TEST, SUFFIX=COMT, DATASET='app/test.csv'

does not point to MRE.

quote:

to MRE.

In DATASET give the full path of the csc file .
and check the master file is located at correct location .

Thanks
Gobinath Velusamy

Francis - Can you please point to Documentation link about "Other" Folder.

I tried placing this test.csv file in Standard reports folder too...But doesn't seem to work.

Waz-
Error: Can not find the test.csv file

Any suggestions would helpful.

Hi,

Try FILEDEF to the path to the file of your CSV.

EG. I have CSV file called ABC.csv with PIN (A9).

ABC.mas:
FILENAME=ABC, SUFFIX=COM , $
FIELDNAME=PIN, ALIAS=ID, FORMAT=A9, INDEX=I,
DESC='Personnel ID Number', TITLE='Employee ID', $

runABC.fex:
SET PCOMMA = ON
FILEDEF ABC DISK C:\ibi\apps\Work\ABC.csv

-* File runABC.fex
TABLE FILE ABC
PRINT
PIN
END

See if that works.

WF Novice,
I think you may be having a problem because your synonym is not finding the dataset.
If you have DevStudio, here are the steps to create the synonym - MRE is on an AIX box and I created the synonym in our test environment.
First you will have to make sure there is an adapter available for the .csv file.

1. FTP the .csv file to the baseapp folder - it will be dsiplayed under other.
2. Right mouse click on Master File folder. Select New Synonym
3. Click on Configure Adapters
4. Click on Add Adapter Configuration
5. Click on Sequential Indexed
6. Click on Delimited Flat File
7. Click on the Configure button to your right
8.Click on Configure button at the bottom of the screen
9. When created, dialog box will appear. Click on the Close button. You will be returned to the DevStudio main page.
10. Repeat the first steps, right-mouse click on Master, New, Synonym. Delimited Flat File will display as an option. Select that option & click OK
11. Double-click on the input boxes to enter information. Make sure the directory path begins and ends with a ‘/’. Click on Select Files.
12. Click in check box next to file you desire, add delimiter value ‘,’ - .csv is comma-delimited file. Chose application folder for the synonym creation. Click on Create Synonym button at the bottom of the dialog box.
13. Click on the Close button at the bottom of the dialog box.
14. You will see the synonym has been created under the baseapp folder.
15.16. Right-mouse click on the master and edit with the test editor. You will see that inside of the master just created it has the path to where the .csv file resides. Make changes fieldnames as desired. Save and file the changes.

FILENAME=MFDCSV1, SUFFIX=DFIX , DATASET=/dir1/dirapp/ibi/apps_test71/baseapp/mfdcsv1.csv, $
SEGMENT=MFDCSV1, SEGTYPE=S0, $

Hope this helps.

As indicated by others, you should not have the CSV in MRE. If you move it to an App Directory under the WF Server, it should work, assuming the master is available in the path and the DATASET is pointing to the right location.

You can have the file in MRE if your WF deployment is on the same machine as the Web server, but this is not an ideal environment.

My rule of thumb for MRE:

MRE is for Launch programs and some Web files.

Any other files, Masters, Data files, core programs should be on the WF server.