October 10, 201213 yr Hello Is it possible to automatically name the output file based on the value of a field? Let's say I have text field with value 4512 (which is a code) and I want to export a tab-sparated file with name m124512, where m indicates the department, 12 indicates the year, and 4512 is the value of the field. Thank you, Toni
October 10, 201213 yr You can create a variable with the path for the exported file, then use the variable in the export script step.
October 10, 201213 yr Author Thanks for pointing that option. I haven't seen that. It took a while to figure it out, but finally got it working. At first I thought that I should have specified the whole path and filename within the variable. But it wasn't working that way. So I defined only filename on the variable, and the path in the export step of the script.
October 10, 201213 yr I thought that I should have specified the whole path and filename within the variable. But it wasn't working that way. it should have.
October 11, 201213 yr Author it should have. Well it didn't, but now that I am thinking I didn't put "filewin:" in the variable calculation which probably caused the problem. I will try once more tomorrow. Thank you again.
October 12, 201213 yr Author Yes comment, you are right, it worked. I did forgot to put filewin: at the begging of the calculation. what I finally did was: "filewin:/D:/Desktop/m"&Right (ComNuovo::Data Fattura;2)&ComNuovo::Fatt nr&"."&"txt" ComNuovo is the database, Data Fattura and Fatt nr are the two fields of the database which I use to name the file. Best regards, Toni
Create an account or sign in to comment