June 2004 Newsletter

Links of Interest:
FWIW Help
Efficient Entry
Realms Listserv
Realms Suite of Apps

TAO Overview
FWIW Overview
How to re-install

Errors in ROW
Drop Down List Boxes

TPBs & Reprints
Tips for tables

Realms of Wonder Newsletter, Volume II, Issue #19

Sorry for missing the May Newsletter - clearly not that much to report.

I saw Harry Potter and the Prisoner of Azkaban - thought it was, by far, the best of the HP films.  If you're like me, after seeing the film you'll decide that life cannot go on without a Hippogryph.  Anybody have one for sale?

I also assume everyone has picked up their ROTK dvd by now - looking forward to the extended version in December.

".LOG" (text) files that ROW creates There are a number of parts of ROW that create a ".log" file, which is just a text file that records what happened.  Some of these can get very large, especially the one created by the Batch Edit function on the Summary window.  

In most cases, you have the option to turn off the creation of the file (it's just informational).  The GCD download doesn't give you the option to turn it off right now, but I will add that.

You can delete them from your machine at any time as well.  The easiest way is to do a Search for "*.log" files and delete any related to ROW.

On the Utilities menu, there is a View Log /Text files option, so you can look at these files.

If FWIW runs reallllly slowly for you ... A few users have complained that FWIW runs extremely slowly when doing a large update.  Here are a few tips that may help.

Once you have updated your entire collection through FWIW, if you then update each month, all you need to do is that month's data.

First, select the current month from the As of Date dropdown on the Options window.  Also, be sure to select Show issues for matched titles only (for reasons described below).

Go to the Match window, click Display only new titles, make any necessary title matches, and then update just the one month.  Usually, this is never more than a few thousand records at the most.

You never have to do the whole database update again, as the new month is the only thing that changed.

In addition, if you make changes on the Match window, FWIW will run a process that identifies only the titles in your data that you've matched to a title in FWIW (you can also run this from the file menu - Update Matched Titles).  Let this finish.  It may take a couple of minutes, but it GREATLY reduces the update time.

Once it's complete, before running the update, make sure to select Show issues for matched titles only from the Options window.

Finally, I suggest turning the Skip Multiple Updates ON the first time.  Run the update.  Then turn that option OFF.  Click the Find button.  Enter "Please Review" in the Old Issue Data field, and press Find (and).

Then run the update again.  This will update all the ones where you have to help FWIW decide what to update.

Realms of Wonder
Version 5.6.6
The latest official version of ROW, version 5.6.6 is available.

Version 5.7.0 is available in beta.  I'll be making version 5.7.0 official this week (by June 20th).  If you already have that beta version, you won't need to update anything.

It's a good idea to always check the "What's New" section in the help (or click here for the online version) so you know what's been added/fixed in this version.

There are quite a few existing features included with any version after 5.6.0:

  • Downloading data from the Grand Comics Database on the web
  • The ability to look up and update values from FWIW while you're entering data into ROW.
  • Link to the FWIW titles so you can match those as you enter data in ROW
  • View cover images on the Explorer window
  • XP display problems resolved
  • The ability to split your collection into multiple databases. 
  • and more ...

If you're at all unsure if you have the latest version of ROW, check the About option, on the Help menu

Email me directly if you need the upgrade location. 

That's An Order (TAO) June 2004 Data available That's An Order (TAO), an application that automates the process of ordering from the Previews Catalogue each month, can be found at

www.realmsofwonder.com/orders/tao.htm

It's updated with the information from the June 2004 Previews Catalog

There are no images or item descriptions this month.  The data that I pull to create the TAO database changed.  I have to write some code to pull it from somewhere else.  I hope to have it done for July.

For What It's Worth (FWIW) through June 2004 For What It's Worth (FWIW - pronounced like Elmer Fudd saying "free"), the monthly value update program, has data through June 2004.   The application is available at

www.realmsofwonder.com/valueupd32.htm

We now have over 95,000 issues representing over 160,000 records.  Please follow the link above to the updated information.

Thanks again to Andrew and Michael for their fantastic and amazing efforts here, as well as Eric who provided updates for 800+ Valiant issues.

Demo Version:  I've added a demo version of the latest version If you are downloading the demo version to try Realms, after downloading and installing the demo version (ROW50.EXE), please download and install the LATEST_DEMO.EXE file also.  That brings the demo up to the latest version and eliminates any errors in the demo version.
Accidentally making your database Read-Only This has happened a few times recently, so I thought I'd pass this on.   Your data is held in a file called REALMS50.MDB.  It's a Microsoft Access database file (that's what the "mdb" means).  If you copy any mdb file to a CD (for backup, as an example), the database becomes read only.  If you then copy it back, and try to run ROW, you'll get error 3051.

To fix this, just turn off the Read Only flag.  Find the file in Explorer, or on your computer.   Right Click on the file.  Select Properties, and then turn off the read-only check box.
See you all next time As always, if you ever run into any problems, have any questions, suggestions, etc., please never hesitate to let me know. I'll always try to get back to you the same day. If you do send me an e-mail, and don't here back by 2 days, I probably didn't receive it, so you might want to try again. My email address is support@realmsofwonder.com

Best wishes to all,

F.X.