You can use Python scripted parameters for this, I do it quite often and it works really well.

Look at this post for some ideas: https://knowledge.safe.com/questions/34975/moving-workspaces-between-fme-installs-tips-and-tr.html

---

You can use Python scripted parameters for this, I do it quite often and it works really well.

Look at this post for some ideas: https://knowledge.safe.com/questions/34975/moving-workspaces-between-fme-installs-tips-and-tr.html

 

Thanks @david_r. I got a head start with the post you referred !

 

 

I tried the following code with the same fmw as in the post and it works perfectly fine but if I pass the same to a 'Reader' as a private parameter I get an error that says 'ConfigParser.NoSectionError: No section: 'DATA_INPUT' '

 

 

import osfrom ConfigParser import SafeConfigParser # Built-in Python moduleini_file = FME_MacroValuesa'FME_MF_DIR'] + '/config/config.ini'# Initialize parserconfig = SafeConfigParser()# Read the ini fileconfig.read(ini_file)# Return option 'PER' under section 'DATA_INPUT'# return config.get('DATA_INPUT', 'wbo')# Return file namefile_path = config.get('DATA_INPUT', 'wbo')for file in os.listdir(file_path): if file.endswith("PLACES.csv"): return file_path+'\\\\'+file

 

 

Any idea on what's wrong here.

 

 

Thanks much for your help !

 

---

 

Thanks @david_r. I got a head start with the post you referred !

 

 

I tried the following code with the same fmw as in the post and it works perfectly fine but if I pass the same to a 'Reader' as a private parameter I get an error that says 'ConfigParser.NoSectionError: No section: 'DATA_INPUT' '

 

 

import osfrom ConfigParser import SafeConfigParser # Built-in Python moduleini_file = FME_MacroValuesa'FME_MF_DIR'] + '/config/config.ini'# Initialize parserconfig = SafeConfigParser()# Read the ini fileconfig.read(ini_file)# Return option 'PER' under section 'DATA_INPUT'# return config.get('DATA_INPUT', 'wbo')# Return file namefile_path = config.get('DATA_INPUT', 'wbo')for file in os.listdir(file_path): if file.endswith("PLACES.csv"): return file_path+'\\\\'+file

 

 

Any idea on what's wrong here.

 

 

Thanks much for your help !

 

Can you please repost your code inside a code block (to retain formatting) as well as post your ini file?

---

Can you please repost your code inside a code block (to retain formatting) as well as post your ini file?

config.txt

 

 

---

config.txt

 

 

 

python-code.txt

 

---

config.txt

 

 

Sorry about the code paste. I have attached a txt file which hopefully should retain the indentation.

 

 

---

Thanks for the code and the ini-file, that helps a lot.

Two things:

1. The error mesage "No section: 'DATA_INPUT'" means that the ConfigParser couldn't find your ini-file. Since you're using the FME_MF_DIR macro which references the directory where your workspace was saved, you also have to make sure that you have saved your workspace to the right directory relative to the ini file. If your workspace is unsaved, it won't work.
2. Your function should return a string in all cases except if there is a critical error. As it is, you only return a file path if it finds a filename ending with "PLACES.csv". Ideally, you should also return something if the file wasn't found.

Here's my attempt at cleaning up the code a bit and making it a bit more robust:

import os
from ConfigParser import SafeConfigParser # Built-in Python module

ini_file = FME_MacroValuese'FME_MF_DIR'] + '/config/config.ini'
if not os.path.isfile(ini_file):
    raise Exception('INI file not found: %s' % ini_file)

# Initialize parser
config = SafeConfigParser()

# Read the ini file
config.read(ini_file)

# Return option 'PER' under section 'DATA_INPUT'
file_path = config.get('DATA_INPUT', 'wbo')

# Check that the directory exists
if not os.path.isdir(file_path):
    raise Exception('Directory not found: %s' % file_path)

# Look inside directory for places.csv    
for file in os.listdir(file_path):
    # Case-insensitive filename comparison
    if file.lower().endswith("places.csv"):
        # We found the file, return filename
        return file_path+'\\'+file

# Couldn't find the file
return 'File places.csv not found.'

Hope it works for you.

---

Thanks for the code and the ini-file, that helps a lot.

Two things:

1. The error mesage "No section: 'DATA_INPUT'" means that the ConfigParser couldn't find your ini-file. Since you're using the FME_MF_DIR macro which references the directory where your workspace was saved, you also have to make sure that you have saved your workspace to the right directory relative to the ini file. If your workspace is unsaved, it won't work.
2. Your function should return a string in all cases except if there is a critical error. As it is, you only return a file path if it finds a filename ending with "PLACES.csv". Ideally, you should also return something if the file wasn't found.

Here's my attempt at cleaning up the code a bit and making it a bit more robust:

import os
from ConfigParser import SafeConfigParser # Built-in Python module

ini_file = FME_MacroValuese'FME_MF_DIR'] + '/config/config.ini'
if not os.path.isfile(ini_file):
    raise Exception('INI file not found: %s' % ini_file)

# Initialize parser
config = SafeConfigParser()

# Read the ini file
config.read(ini_file)

# Return option 'PER' under section 'DATA_INPUT'
file_path = config.get('DATA_INPUT', 'wbo')

# Check that the directory exists
if not os.path.isdir(file_path):
    raise Exception('Directory not found: %s' % file_path)

# Look inside directory for places.csv    
for file in os.listdir(file_path):
    # Case-insensitive filename comparison
    if file.lower().endswith("places.csv"):
        # We found the file, return filename
        return file_path+'\\'+file

# Couldn't find the file
return 'File places.csv not found.'

Hope it works for you.

Oh dear..I didn't have the workbench saved at all ! Thanks @david_r

 

---