AS_STRING(CURRENT_TIMESTAMP) conversion issue

Bryan

I am trying to give a report that is exported from AwareIM a file name that contains a date time stamp as part of the name. The issue is that the AS_STRING(CURRENT_TIMESTAMP) does not work properly. I can get the file to output named with a date stamp as part of the name but not the date and time.

If I use CURRENT_DATE instead of CURRENT_TIMESTAMP the process will export the report without errors.

This works:
EXPORT DOCUMENT DailyReport TO File 'C:\Temp\DailyReport'+(AS_STRING(CURRENT_DATE))+'.xls' as xls

This does not:
EXPORT DOCUMENT DailyReport TO File 'C:\Temp\DailyReport'+(AS_STRING(CURRENT_TIMESTAMP))+'.xls' as xls

Here is the error that is generated when the process is kicked off:
'Exception exporting document. The parameter is incorrect'

SystemLog information:
08:44:53,390 ERROR test#admin -Execution Exception after starting process ExportDailyReport1 message Exception exporting document The parameter is incorrect

tford

Bryan,

As a workaround, have you tried putting AS_STRING(CURRENT_TIMESTAMP) in an attribute & using that attribute in EXPORT DOCUMENT?

Bryan

I added an additional attribute of type timestamp and still could not get it to convert with the AS_STRING function. I also tried making the attribute of type plain text and settings it value to a timestamp and that did not work either.

I am hoping I just missed something simple.

bartthefish

Bryan, the problem is not with Aware but with the OS.

TimeStamp has the following format for eg. MM/dd/YYYY hh:mm

Now the problem with this that ':' is not allowed in a file name (\ / : * ? " < > |) are all reserved by windows, as they are interpreted by the OS to mean specific things.

To solve your problem use the following rule:

EXPORT DOCUMENT DailyReport TO File 'C:\Temp\DailyReport '+(AS_STRING(CURRENT_DATE) +' '+AS_STRING(CURRENT_HOUR)+'h'+AS_STRING(CURRENT_MINUTE))+'.xls' as xls

This will output a file for eg. DailyReport 03/25/2010 10h33.xls for 10:33AM on the 25th of March 2010

Hope this workaround helps you.

Bryan

Thanks for the insight Bart.

I totally missed the fact that I was trying to place : in the filename.

I originally when for the CURRENT_HOUR + CURRENT_MINUTE solution but found that the CURRENT_MINUTE function does not pad a 0 to the begining of the value when it is below ten.

For example if it was 8:05pm the CURRENT_MINUTE function would just return 5.

I did end up with a similar solution the one you mentioned.

Thanks again for the assistance.

bartthefish

You could always add a PAD_LEFT(CURRENT_MINUTE),2,'0') to make it add the 0 to the 5

Bryan

Awesome, Thanks for the help.