Hello,

when a baan report is generated ,very huge data is retrieved which cannot fit onto excel , hence I would like to set up a device which will output to a csv file.

details are attached .
when I run the report, I am getting error message "Cannot create /home/jlopickt.csv" . Can you tell me whats wrong inmy device setup ?

Is there anything wrong in the arguement or path ?

regards
nansat

I would expect it to look like ${HOME}/${LOGNAME}.csv. It looks like you are trying to write directly to /home and not your home directy. Not sure if the {}'s are needed.

hi mark,

I tried with "${HOME}/${LOGNAME}.csv" . Still same error message is shown. Is there any thing needs to be setupin arguement field in device data ?

thanks
nansat

Try setting your device like the attached. I am going to test mine to use logname$.

Okay - the attached created a file called hollanma.csv in my home directory. We are on Baan 4c4 using sun solaris boxes.

I tried by setting as attached. And got error message. We are using baan 5c onsolaris.

can you help me out ?

Notice that my "LOGNAME" is in caps. When I used ${logname}.csv it created a file called $logname.csv. Check and make sure you have permissions to create files in your home directory. I am not seeing anything else that could be causing the problem - maybe it could be something in 5c or the tools version. Also try removing the : after ascii - don't think that is it.

I tried with $LOGNAME.. when I tab through the path on select device session, I am gettign error "$HOMe" doesnot exists..

Try removing "${HOME}/" - on my system it defaults to your home directory.

Remove the ":" after ascii - this caused my system to actually download and launch the notepad. The set-up in your last post works but only if I delete the ":" after ascii. Make sure ${HOME} is defined on your system.

thank you mark and others..it isworking for me..

Hello,

I use a specific device for opening my document with word.

4GL : ttstpconv
argument : RTF:winword.exe
path : ??? I know ${LOGNAME} but another parameters exists ? and where I will find them ?

I would like knowing wich parameters the path is able to read in Maintain data device (ttaad3100m000) ?

Regards.

Otools

When I see ${} I think of my UNIX shell environment variables. I just run csh and do setenv and view them. You can actually create your own environment variables with your BWC login. We use -- -set SITE=comp# to tell our exchange schemes were the data files are located - the path has ${SITE}. So I assume NT has something equivalent.

I know ${LOGNAME} but another parameters exists?

Maybe its much clearer to use the term "environment variables" instead of "parameters"? UNIX enivironment is case sensitive, i.e. $HOME is different to $home (which is quite unusual).

To see the defined environment variables, you can use a UNIX window an use the command 'env'. You can also run the baan terminal emulator (e.g. from the menu browser, use File / Run Program ... / Program Session = "sh", Run External Program [x]) as well.

To define additional environment variables, you can use "-- -set VARIABLE=VALUE" from bw client; and you can also setup additional variables on the server side.

Günther