Jump to content
x509

creating plain-text report of a catalog or backup session?

Recommended Posts

I used to know how to create plain-text reports of all files in a catalog or session (not sure which), because I have a lot of such reports in my Retrospect folder.  But that was 8-10 years ago, and I can't seem to do such reports today.

My retrospect server is on a system running Win 10 64 Pro, but not yet upgraded to 1803.

Share this post


Link to post
Share on other sites

If you highlight a Session Content (Under "Reports") ... then you can select File ... Export ... out to a text file.

The result will be a pretty "ugly" text file however ...

Share this post


Link to post
Share on other sites

Lucky_Phil

You are right about the "ugly" text file.  Previously, I got a nice line-by-line listing of all files, inclujding full path names.  Those earlier text files were probably produced with Retrospect 6.  So, for all the old-timers,  what happened to that nice functionality?

 

x509

Share this post


Link to post
Share on other sites

Hi x509,

It is actually line by line ... but it is a very long line ...  you might need to change the resolution of the screen to see it all in Notepad.

Alternatively ... If you open the .txt file in Excel and choose tab delineated during the import step, you could then clear out all the extra guff in the middle columns within Excel to make better sense of the filenames.

 

  

 

Share this post


Link to post
Share on other sites
16 hours ago, Lucky_Phil said:

Hi x509,

It is actually line by line ... but it is a very long line ...  you might need to change the resolution of the screen to see it all in Notepad.

Alternatively ... If you open the .txt file in Excel and choose tab delineated during the import step, you could then clear out all the extra guff in the middle columns within Excel to make better sense of the filenames.

 

  

 

Lucky_Phil

This is a sample line from the txt file, AFTER I imported it into Excel.

image.png.3cd570dcf8cb928045106d55478fe770.png

With the txt files from Retrospect 6, I was able to do a drag-and-drop right into Excel, widen columns, and have a very useable report.  Too bad Retrospect crippled this feature.

Share this post


Link to post
Share on other sites

Hmm ... something odd going on? ...  I get a text file that is OK in my older version on Windows 10 (Retrospect 10.5.0.10) ... I have a more recent version on another pc ... (not the latest though) ... I'll see what I get on that one.

 

 

Share this post


Link to post
Share on other sites

I'm also using 12.6.1.101.  I would be most happy if you could point out to me what I'm doing wrong.  Also, could you post a snip from one of your txt files with 12.6.

Using these old text files, I kind of like the idea of producing text files for some of my current backups.

 

x509

Share this post


Link to post
Share on other sites

I wish I could point out where the issue is - but I'm just a fellow long-suffering customer of Retrospect ;)

Maybe someone who is expert will jump in with some ideas...

 

Happy to bung up some screen captures of what I am getting ... also just a quick look at the steps I'm doing in case you are doing something different (though I very much doubt that you are.)

 

So, a look at the Retrospect screen where I select a session in reports and then File ... Export the backup set to a text file ... a look at the top of that text file ... and how it looks in Excel with a drag and drop ... attached.

 

 

Retro_report1.jpg

Retro_report2.jpg

Retro_report3.jpg

Share this post


Link to post
Share on other sites

Your report in Excel is exactly what I used to be able to do but forgot and want to do again.

You have definitely taken a different approach than me, but I can't quite reproduce your approach and get the kind of report I need.  I tried to follow your steps, but there is something missing.  First I selected Session Contents from the Reports on the left-bar menu.  This window popped up:

image.png.7ad0dc2789d55379ac594fda336d9bd2.png

So I selected 2018 PROGRAMS (which is the C: drive on my various systems) and selected one session.

image.png.31041038bb1a0be4191d73f77029eb9d.png

When I do a Print to a TEXT file, I get only a summary of the sessions, and it's in that ugly format with each entry entirely within the first column of the XLS spreadsheet.

image.png.5666ab2704d17be008afaee9fbbd980a.png

If I open up the selected session, I get this window.

image.png.f17b8944125871e86176a1c7f7d27b4e.png

But, if I then click on SESSION CONTENTS, this window disappears and I'm back to this window.

image.png.31041038bb1a0be4191d73f77029eb9d.png

So near, but so far.

 

 

 

Share this post


Link to post
Share on other sites

On Retrospect 15.1.0 I get the same results (I'm viewing the output in Notepad++ instead of Excel) as Lucky_Phil.

What I did was:

  1. Reports > Session Contents
  2. Select Backup Set then select Session
  3. File menu then Export...
  4. For Select which data to export: choose the Backup Set and click OK
  5. In the Export Sessions dialog enter a filename and click Save
  • Like 1

Share this post


Link to post
Share on other sites

Scillonian has listed in a clearer way the steps needed. Thanks Scillonian for setting out the steps far more clearly than I did.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×