Announcement

Collapse
No announcement yet.

Save Orphans to Spreadsheet

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Save Orphans to Spreadsheet

    Here is a trick I use to create a file of orphan records from BC3 (exist in one file but not the other). Do a Data compare in BC3 and show just the desired orphan records (left or right side). Then from the Session menu, create a Data Compare report, side by side, HTML format, Save as file. Open the html file in Excel and delete out the empty columns (left or right side). Delete out the extra headings and leave just the column names. Save the file as .csv or desired file format.

  • #2
    Thanks for posting this tip. I'm sure some of the community will find it very useful.
    Aaron P Scooter Software

    Comment


    • #3
      This might result in fewer conversion hops

      If it's data for which you want only exact matches be sure to first do this:
      Session, Session Settings, Alignment tab, Check "Never align differences"

      Then:
      Check Show Differences, Uncheck Show Context

      Click in the Left Panel
      CTRL-A (Select All)
      CTRL-C (Copy)
      Paste into your favorite editor or spreadsheet

      Click in the Right Panel
      CTRL-A (Select All)
      CTRL-C (Copy)
      Paste into your favorite editor or spreadsheet

      If you want the Left and Right Orphan list comingled, your favorite editor or spreadsheet program should be able to sort them and even eliminate duplicates, if any exist, with the click of a few buttons. I'm a TextPad junkie, but I'm sure there are equally additive and useful freebies.

      Comment

      Working...
      X