UNSOLVED
D
damian_nastala
5 Posts
0
623
August 13th, 2015 02:00
avamar reports
I have another problem with reports. It's generating start and end time of the backup in anusual format, for egsample:
Sun Aug 09 19:00:00 BST 2015. Exel can't read it properly, I can't use it in any function. Is there any way to change it? Can the report extract start/end time in same format like in the Activity Monitor? There is another problem in reports recieved on the mailbox. I was expecting attatched file of report in .csv file. Insted I've got it as a text in e-mail. Is it possible to make it separate file? If not is there a way to cells be separated from each other by "," or "." or "tab"? It would be much easier to separate the collumns in excel. I want to make it easiest to have a time for another activities.
359
0
Posted August 20th, 2015 08:00
I've managed to list attachments in the mail earlier but many thanks, It is correct answer for this issue:)
I wish it would be so easy in excel, I may described this in wrong way. It would be easy if date and time was separated like in the example above. But sadly it's not:/
The cells looks like this:
I can't separate them this way, no defoult format is reading this. I've tried to wrote a new one but with no success. I know how to translate it in the bash but I would have to know where the Avamar is keeping report scripts to add one line of code to it.
Avamar Exorcist
462 Posts
359
0
Posted August 20th, 2015 04:00
The date format is strange because it is a US format. Have you tried altering the locale in the Excel cell format date settings. Perhaps something like this?
With regards to the report attachments, make sure you don't have 'inline attachments' set in the profile
And make sure to configure the attachments tab to set the report with a csv attachment as shown below