cancel
Showing results for 
Search instead for 
Did you mean: 

I have exported bpimage data

Hasan_Naqvi
Level 3
Partner

I have exported bpimage data to a text file and then imported into an excel sheet but when trying to sort the backup or expiry date in ascending or descending excel sees a large number approx 60% of the data as text rather than date. I have tried all sorts of formatting techniques and some from microsoft tech sites but have had no luck. I am wondering why the netbackup export has two types of formats in the data related to the dates.

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Level 6
Partner    VIP    Accredited Certified

 We have moved this to a new discussion from https://www-secure.symantec.com/connect/forums/how-can-we-export-netbackup-configuration-excel as your query is not related to that particular post. 

The 2nd post could not be moved with above post and can be seen here: https://www-secure.symantec.com/connect/forums/how-can-we-export-netbackup-configuration-excel#comme...

 

My colleage has used the Image Timestamp (column K in our spreadsheet) to calculate the backup time.
Formula in new column (row 2): 

=K2/(60*60*24)+25569
 

So, 1433614916 works out to be 06/06/2015 18:21:56
Column format is Number with Custom format: dd/mm/yyy hh:mm:ss  

 

Hope this helps.

View solution in original post

3 REPLIES 3

sdo
Moderator
Moderator
Partner    VIP    Certified

You've described the problem.  What is it that you want to achieve?

Marianne
Level 6
Partner    VIP    Accredited Certified

 We have moved this to a new discussion from https://www-secure.symantec.com/connect/forums/how-can-we-export-netbackup-configuration-excel as your query is not related to that particular post. 

The 2nd post could not be moved with above post and can be seen here: https://www-secure.symantec.com/connect/forums/how-can-we-export-netbackup-configuration-excel#comme...

 

My colleage has used the Image Timestamp (column K in our spreadsheet) to calculate the backup time.
Formula in new column (row 2): 

=K2/(60*60*24)+25569
 

So, 1433614916 works out to be 06/06/2015 18:21:56
Column format is Number with Custom format: dd/mm/yyy hh:mm:ss  

 

Hope this helps.

Nicolai
Moderator
Moderator
Partner    VIP   

Have you tried  Excel data importer function - this enables you to defined the data type upon import.

Excel - Data Tab -> "From Text"

These two links both describes how to convert from EPOCH to human readable time format:

http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps/

https://www.berezniker.com/content/pages/office/excel-convert-unix-time-excel-time