Creating a csv file in cache directory

[edanb]

I'm creating a custom report and want to put an excel version of the file in the cache/csv directory.

Is there a variable or function that will give me the sugarcrm root directory, so that I can put the file in say $sugar_root/cache/csv?

Thanks!

[mvngti]

The sugar_root is always the current directory in any action in SugarCRM so simply accessing "cache/csv/filename.csv" will work. Just make sure that sugar_root/cache/csv exists.

M

[mvngti]

PS: You can get the actual sugar_root folder with this but it really is not needed.

 $sugar_root = dirname($_SERVER["SCRIPT_FILENAME"]);