• Coded workaround to deal with currency symbols & text in "PurchasePrice" & "SRP" fields in DVD Profiler XML export being both in front of and behind numbers. Incorporated code suggestion from Tom Gaines. Tested with currency symbols front and back, decimal symbols "." or "," also inputting with one decimal regional setting and changing to another correctly shows new decimal symbol.
• Added query from pdf256, "DVDs With No Discs (Excluding Boxsets)". New query incorporates Boxed Sets info (added in version 0.70).
• Updated query "DVDs With No Disc ID".
• Updated "DVDs With No Actors" and "DVDs With No Crew" adding link to Boxed Sets table
• Fixed error when navigating menus in Main Menu form using keyboard
• Removed unnecessary error message when cancelling parameter queries
• Added more pre-built queries
• Updated screenshots in help file

• XML transform for the DVD Profiler export XML has been extended to include DVD Events. With this information events such as "Watched" and "Borrowed" can be queried. If you record this information in your DVD Profiler have a look at query "Movie Marathons"!
• Main Menu form now has button "About" - this will show the version of QDVDPDB being run.
• Added number of pre-built queries
• Enhanced "DVD and Actors" & "DVD and Crew" forms
• Changed query "qDVDLocationSlotShowDupes" used for "DVD Location and Slot Check" to use select distinct in query
• Continued code cleanup and standardisation

This minor (but important) release includes support for looking up currently defined decimal point in regional settings on computer for current user to make sure that decimal character in DVD Profiler XML export (represented as ".") is converted in QDVDPDB to whatever user has defined as decimal character in regional settings in Windows.

It supports whatever is defined in regional settings - not just "," - but whatever character is used. Then in Access database if regional settings are changed to use different decimal character i.e. from "#" to "." then number fields (PurchasePrice, SRP) still display correctly.

A number of revisions/additions/enhancements. Major points:

• XML transform for the DVD Profiler export XML has been extended to include Suggest Retail Price information. This allows queries showing value of DVD collection which can also allow reports...
• Added check on startup which looks at version of Microsoft Access being run and warns if less than Access 2003 (needed for XML support)
• Added graph report "DVDs SRP By Currency (Owned Only)". See how much you've spent on DVDs - ouch!
• The utility from "MtnMike" for checking locations and slots for DVD changers is finalised and working

A large number of revisions and enhancements. Tested on various large sample DVD import files no problems.

• The XML transform for the DVD Profiler export XML has been extended to include DVD Profiler custom user tags - these can be seen in the tags table - open via the main menu.
• Also now imported is purchase information on DVDs. This took some time as I had to work around the fact the the export file includes currency symbols - $ € and names. Have a look at query "DVD Purchases By Currency" to see how much you are spending!
• The new menu system is enhanced and items can be selected by one left mouse click or by pressing [Enter].
• Some cosmetic changes to forms from suggestions from users.
• Users can add menu items for reports, forms, queries etc. to the table and they will show on the new menu system.
• The custom online help is updated.
• Quite a number of coding changes/fixes/enhancements.
• When doing an import of the XML file the system now uses a Microsoft utility "Microsoft XML Validation" tool to check that the collection.xml file is well formed. DVD Profiler sometimes incorrectly exports the collection.xml file. If the file is not correct QDVDPDB will not be able to fully import information. If you find this issue please InterVocative LLC - they need to fix the problem.
• Changed datatype for field "slot" in "Discs" table to numeric.
• New forms and reports
• "MtnMike" has contributed a utility which analyses the location and slot information from DVD profiler to check whether DVDs are corrected recorded for location and slot. The form "DVD Location and Slot Check" is in the system and final testing is being done.

• Completely rewritten "main menu" form - not using Access switchboard any more. Menu form is dynamic table driven and provides application driven opening of all tables, queries, forms & reports. This should allow everything to be run from Access runtime.
• Updated help file
• Restored code which provides detailed information in case of errors - useful when doing imports of DVD Profiler XML file which can have XML formatting errors.

• Updated "collection.xsl" transform file - now version 2.0. Resulting in:
  • Conditional import on "CollectionNumber", if value = DVD: (used for WishList) then CollectionNumber set to 0. This means now all DVDs can be imported (WishList etc.)
  • Removed field "Events" from DVD table - should not be there.
  • Added missing fields "Location", "Slot", "LabelSideA", "DiscIDSideB", "LabelSideB" to Discs table
  • Now that value "DVD:" is not being imported field "CollectionNumber" changed back to number. This is better for sorting by CollectionNumber field.
  • Field "RunningTime" changed to number - again better for sorting & calculations
  • Added table "BoxSet" to import from DVD Profiler
• Modified forms "DVD and Actors" and "DVD and Crew" - colour fields to match style used in "Cast & Crew" for consistancy for people using both systems.
• Updated query for "DVDs By Decade" to query created by "MtnMike" - thanks Mike!
• Added query for "DVDs By Genre" and... just for the heck of it...
• Created Access chart reports which graph queries "DVDs By Decade" and "DVDs By Genre". They look nice!
• Added query "BoxedSets"

Tested on large import file - 2,000 DVDs no problems.

• Modified fields in table "DVD"
  • "CollectionNumber" changed from Integer to Text 6 - this should now allow import of all movies, not just owned, and avoid import errors.
  • "Events" changed from Text 255 to Memo - thanks for info MtnMike. This should also help to avoid import errors.
  • Put index on "Title" field to help speed up partial name searches.
• Modified "DVD and Actors" and "DVD and Crew" forms to make them come up looking better when tables are empty, and allowed addition and deletion of records.
• Added context sensitive help relevant to exporting data to "DVD and Actors" and "DVD and Crew" forms - Press [F1] while viewing form.
• Added detailed error reporting during import and export of XML data. Particularly relevant for importing of XML export from DVD Profiler (see troubleshooting in online help for information regarding possible problem with XML exports from DVD Profiler).
• Errors linked to context sensitive help in help file - press "Help" button in error message.
• Minor fixup changes.

• Changed code to make load of help file folder independent.
• Added context sensitive help for DVD and Actors, DVD and Crew & Menu forms

• Added international support to QDVDPDB so that application can be installed in international versions of Windows i.e. where program directory has name other than "C:\Program Files". System will recognise working directory. Thanks to Tom Gaines (Vielen dank Tom!) for pointing this out.

• First public release
• Redesign and rename
• Program directory now set to "C:\Program Files\QDVDPDB"
• Automated import of DVD Profiler export XML file to make easier for users (while getting around limitation in Access)
• Made custom HTML help file
• Added function to export out list of crew names and credits to DVD Profiler from form.

• Added startup code to set working directory to directory database is located in

• Added 'DVD' form for viewing DVDs and actors in movies. Also option, while viewing a movie, to export out list of actors to standard DVD Profiler XML Import for actors into cast window in DVD Profiler. Data is exported out to file named "ImportActorsSingleMovie.xml" in working folder.

• First version - Imports raw DVD Profiler XML data using XSL transform to make it useable in Microsoft Access. Needs Access 2003 or higher. Data is appended to existing tables which have field types set with database key on [ID] field in DVD table to ensure uniqueness. Relationships between all tables predefined using Access relationships feature.