New call-to-action
Results 1 to 7 of 7

Thread: how to recover a previous version of a report from backup?

  1. #1
    Member alfatrading's Avatar
    Real Name
    Fabio M. Mantovani
    Join Date
    May 2009
    Location
    Milan, Italiy
    Posts
    75

    Default how to recover a previous version of a report from backup?

    Today I was fine tuning a report of mine.. As usually happens, after last edit, save, publish (it is a webapp, but since report are on the desktop control panel I posted it here) and run I noticed I completely lost footer (two text boxes, of which one dinamically populated, plus a pair of fields.
    With reference to the attached image
    backups.jpg
    1. you can see the report i need back: Rep_RichiestaBrevetto
    2. In the project folder there is not any filename with rep_richiesta*.* name
    3. in the <projectfolder>\backup\sets\<nameofmyset>\Report\ there's a list of zip files,
    4. ..each one containing Rep_RichiesteBrevetto.a5bak

    BUT no other instance of Rep_RichiesteBrevetto.* in the computer folders

    I tried to extract the a5bak file from the 15th zip file, looked inside with a text editor and verified it contains my lost section. But don't know where to put it for substituting the current, incomplete report

    5. Also have a lot of previous backup onto a dropbox folder, should it be of any help
    Last edited by alfatrading; 06-04-2013 at 05:09 PM.
    Hourly rate: 50 - If you look: 60 - If you laugh: 70 - If you tried yourself before: 100

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: how to recover a previous version of a report from backup?

    Right click on the report name in the control panel. If a prior version is available the last item in the right click menu will be Restore Prior Version.
    There can be only one.

  3. #3
    Member alfatrading's Avatar
    Real Name
    Fabio M. Mantovani
    Join Date
    May 2009
    Location
    Milan, Italiy
    Posts
    75

    Default Re: how to recover a previous version of a report from backup?

    Great! Thank you very much.
    As you see I lost a lot of time editing and attaching my post with all data I have..
    Should I knew you already answered...
    Got my previous version back..

    Only for my curiosity, where is this report stored? Into some kind of AEX file?
    Should I want to publish a new version of such a report, how do I have to proceed? Until now I republished "all files"
    Thank you again
    Hourly rate: 50 - If you look: 60 - If you laugh: 70 - If you tried yourself before: 100

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: how to recover a previous version of a report from backup?

    Only for my curiosity, where is this report stored?

    path to your database \backup\Tables\tablename_upon_which_report_is_based\Report\
    or
    path to your database \backup\Sets\setname_upon_which_report_is_based\Report\
    There can be only one.

  5. #5
    Member alfatrading's Avatar
    Real Name
    Fabio M. Mantovani
    Join Date
    May 2009
    Location
    Milan, Italiy
    Posts
    75

    Default Re: how to recover a previous version of a report from backup?

    That's the backup. And there are only zip files with my report inside. nothing with that name outside.

    I meant the actual report.. because I can't se any Rep_RichiestaBrevetto.<anything> anywhere (that's the name of my actual report)
    Hourly rate: 50 - If you look: 60 - If you laugh: 70 - If you tried yourself before: 100

  6. #6
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: how to recover a previous version of a report from backup?

    Reports aren't stored as separate files. Nor are any other layouts. See the documentation for Alpha Five File Types.

    Data Dictionary
    .DDD
    The table's data dictionary, which contains lists of additional table objects such as Layouts (forms, browses, etc.), report designs, saved operations, field rules, and field names longer than 10 characters.
    Dictionary Methods, Reading From and Writing To the Data Dictionary

    .DDM
    Stores additional table objects such as Layouts (forms, browses, etc.), report designs, and saved operations in memo format.

    .DDX
    Contains the dictionary's index(es). Alpha Five uses the .ddx to find a specific form name or field rule or whatever is needed.

    .DBP
    Contains the definition for an active-link table? or mapped table.
    There can be only one.

  7. #7
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: how to recover a previous version of a report from backup?

    Quote Originally Posted by alfatrading View Post
    That's the backup. And there are only zip files with my report inside. nothing with that name outside.

    I meant the actual report.. because I can't se any Rep_RichiestaBrevetto.<anything> anywhere (that's the name of my actual report)
    the older versions are stored as zipfiles and alpha unzips them when you want to revert to older version.
    to see the location and to actually see the zipped file of your report:

    look into the place of your workspace/database/backup/library/database/report.
    to get there easily
    right click on a report, select the last item on the pop up dialog- restore to prior version
    then another dialog will pop up with all the prior versions. on that dialog look at the bottom there is a blue link that says open in the folder or something - click on that.
    the folder i mentioned above will materialize.
    and you will see your report listed as a zip file.
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

Similar Threads

  1. Wrong (previous) version of form appearing...
    By RevMK in forum Alpha Five Version 10 - Desktop Applications
    Replies: 7
    Last Post: 03-06-2012, 12:47 PM
  2. v10 still has some of the same quirks as every previous version
    By gkeramidas in forum Alpha Five Version 10 - Desktop Applications
    Replies: 1
    Last Post: 11-13-2009, 12:34 PM
  3. using previous function in a report calc field
    By Richard Kosick in forum Alpha Five Version 8
    Replies: 4
    Last Post: 04-15-2009, 12:24 AM
  4. Alpha Five Version 8 Editor on previous versions
    By Nancy Eisenberg in forum Alpha Five Version 8
    Replies: 3
    Last Post: 05-22-2008, 03:13 PM
  5. Ref. previous topic bug report
    By dcorcoran in forum Alpha Five Version 6
    Replies: 2
    Last Post: 07-01-2005, 03:04 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •