How can I merge two Readerware databases?

< Back to Knowledge Base Home

Last Updated: July 23, 2014
Keywords: merge, import, export

Readerware does not have a merge feature as such, but you can merge two databases using Readerware Import/Export. First you need to export from your source database. You can export the entire database or only selected items. To export an entire database:

  1. Open your source database, the database you are merging from
  2. Select File->Export to launch the Readerware Export Wizard
  3. From the drop down list, select the tab delimited  format
  4. Make sure the Output header line option is checked and that the Escape new lines option is not checked. Click Next.
  5. Enter or select the name of the export file, Click Next.
  6. Select the All items radio button, Click Next.
  7. Select the Selected Database Columns radio button. Ensure that all columns are selected. If a column has a green check mark next to it, it is selected. If it has a red X, it is not selected. Double click on any column to toggle its status. Click Next.
  8. Review your choices and Click Next.
  9. When the export completes, Click Next. Readerware will display a count of the items exported.
  10. Click Finish to close the  wizard.

Now that you have created your export file, you can import it into your target database:

  1. Open your target database, the database you are merging to.
  2. Although not required if you are merging into an existing database it is a good idea to backup your database before the merge. Select File->Backup Database.
  3. Select File->Import to launch the Readerware Import Wizard.
  4. From the drop down list, select the tab delimited  format, Click Next.
  5. Click on the Browse button to select the file you exported earlier, Click Next.
  6. Review your choices and Click Next.
  7. When the import completes, Click Next. Readerware will display a count of the items imported.
  8. Click Finish to close the  wizard.

If there are any errors on the import, you can review the Readerware log file, rwuser.log for a full description of the errors.

Your target Readerware database will now contain all the items  imported from your source database. But export/import does not handle images or ReaderwareAW track information. Fortunately auto-update has the ability to search for images and tracks and add them to existing items. You can use auto-update to add the images and tracks to your merged database.

You now have a fully merged database.

If you only want to do a partial merge, the export procedure  is as follows:

  1. Open your source database, the database you are merging from
  2. Search for the items you want to export. You can search by date entered, category, author etc. The results displayed will be the items exported.
  3. Select File->Export to launch the Readerware Export Wizard
  4. From the drop down list, select the tab delimited  format
  5. Make sure the Output header line option is checked and that the Escape new lines option is not checked. Click Next.
  6. Enter or select the name of the export file, Click Next.
  7. Select the Current Search Results radio button, Click Next.
  8. Select the Selected Database Columns radio button. Ensure that all columns are selected. If a column has a green check mark next to it, it is selected. If it has a red X, it is not selected. Double click on any column to toggle its status. Click Next.
  9. Review your choices and Click Next
  10. When the export completes, Click Next. Readerware will display a count of the items exported.
  11. Click Finish to close the  wizard.

Once you have created your partial export file, continue with the import as described above.