Jump to content

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


x509

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.

Link to comment
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

Link to comment
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.

 

  

 

Link to comment
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.

Link to comment
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

Link to comment
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

Link to comment
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.

 

 

 

Link to comment
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
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...