xTuple.com xTupleU Blog & News Customer Support

MetaSQL and xtConnect

MarketPlace
#1

I'm trying to run MetaSQL statements via xtConnect and have the results of the SQL emailed in an attachment (CSV) .  My MetaSQL is a simple SELECT statement  and will ultimately have some parameters applied.

Even though I specify the CSV output option the only attachment I get mailed is an empty txt file. 

Can someone point me in the right direction. 

#2

I should add the Preview displays exactly the output I am after.

#3

Cancel that - I’ve got it working.

You need to explicitly change the output filename and not use the default value.