Data Crow 4.1

[Fixed]
- Logger not initialized error message on prompt / console.
- File launcher fixes (for all platforms).
- Indicated "run as administrator" for the data crow executable and the setup executables
- Column names in the database are no longer allowed to start with a digit. The module wizards have been updated accordingly.
- Still a Log4j not initialized message at the command prompt, argh.., fixed forever!
- Imdb.com not working.
[Changed]
- Paths for files linked to items are now handled a bit differently;
a.) if the file is located in the Data Crow installation directory a relative filename is used.
b.) if you are using drive mappings across Windows / Linux the backslashes and slashes will be corrected as well.
The original filename is stored unmodified(!)
- the user folder selector now checks for:
a.) existing folder selected, containing files (continue y/n).
b.) moving from one location to another (move files y/n).
c.) root folder not allowed as a Data Crow user folder.
- Readme.txt added for the installer (which setup executable to use..)
- Readme.txt of Data Crow updated.

_http://sourceforge.ne...r.zip/download

[New]
- The property items overview (found in the Administration menu) gained a new tool:
delete unassigned items. This will remove all properties not assigned to any other item
For example a category not used in software items will be removed.
- Another new tool for the properties module is the merge functionality.
Having many categories (for example) which actually have the same meaning? Merge them all into one property. All references to the properties will be corrected (without duplication, of course).
- The Resource Editor now has find and replace functionality.
[Changed]
- The screen is now much cleaner and it makes the application look simpler.
- The file associations setting now also allows parameters to be defined.
- New items tab has been removed.
- Online Search will now directly save the item instead of adding the item to the "new" tab.
- Chart tab has been removed. You can open the new charts dialog from the tools menu as well as from the tool bar.
- Create Multiple Items tool has been added (as a replacement for the new items tab).
- Item importer will open the new items dialog to lists the imported items before saving them.
- The module bar has been changed. Labels have been removed. Additionally the select module section has been improved. Selecting a sub module will highlight it on the main module panel.
- Improved startup time by building forms on demand instead of on startup (where possible) - 4.9 seconds on an almost empty database in 3.12 against 6.0 seconds on the same database with version 3.11.1.
- ISBNdb.com has been changed and the information is of limited use now to Data Crow.
This service has been disabled.
- Help has been updated to reflect all of the above (press F1 once in a while just for the sake of using it).
- The Find and Replace utility now also allows you to change one reference with another.
- Update all now refreshed the overview after updating the items (instead of updating one by one).
[Fixed]
- On startup Data Crow tried to modify files in the installation folder, causing problems for Windows platforms. Data Crow can now be launched without administrator permissions.
- Applying settings such as the language change was only properly applied after a restart.
- Sort order of persons has been fixed (always sorts on complete name now, takes care of rewritten names).
- Screen parts resized ever so slightly and ever so annoyingly.
- Could not really tell which module was selected.
- Fix for launching files from the Quick View Panel.
- Column order for tables not correctly applied.

_http://sourceforge.ne...r.zip/download

A minor release to include additional changes and new functionality. Much needed fixes for the references fields have finally been included.
[Fixed]
- Icons for containers not shown in trees, fields and in the quick view.
- Icon for modules disappears in the Media module.
- Error loading setting if value is erroneously empty.
[Changed]
- Merging property items will now also update the "alternative names" field, merging items returned from online searches, etc., automatically.
- In the past, due to performance issues, I had refrained from updating trees in case a property was changed. This has now been fully implemented; changing an icon will immediately be reflected on trees, multi-reference views and the quick view panel.
- Added quick filter to the related items and fixed the sorting.
- Added quick filter for the items tab of containers. Sorting cannot be fixed just yet.
- Several minor layout changes (button alignment) such as for the tool select wizard and the update all dialog.
[New]
- Added a right-click option for the related items tab of the item form to remove the selected items as a reference.

_http://sourceforge.ne...r.zip/download

[Changed]
- Updated German translation: big thanks to Ralf GeiЯ!
- Template default and name have been moved to the "Template Properties" tab.
[Fixed]
- Changes not saved using the quick filter on resource editor.
- Filter not saved when value is empty.
- Template not applied to items retrieved by the online search.
- Templates overview settings incorrect

_http://sourceforge.ne...r.zip/download

[Fixed]
- Alter module wizard: change field; maximum length always defaulted to 255.
- Potential issue for Template Name and Default field. These could conflict with the normal fields of the module.
- Exported field order is now the same each time.
- Item matching on import is now also done on the "key fields".

_http://sourceforge.ne...r.zip/download

This is a new major release. DO NOT install this version in the same location as the old version as this will cause the program to fail to start.
NOTE 1 I have found that in old installations it is possible that both books.jar and a book.jar file exists within the modules folder. Remove the books.jar file as the book.jar file is the actual file used for saving module wizard changes.
NOTE 2 All modifications made to the Music Album and the Audio CD modules will be undone by the upgrade. There was no other way to get the Music Album and Audio CD modules merged.
NOTE 3 The web version is scheduled for version 4.1 and is not part of the 4.0 version.
[New]
- Client-Server mode. Full stand alone application server is now available. See Client-Server notes for more details. This has been achieved through a complete change of the Data Crow architecture.
[Changed]
! The Audio CD module and the Music Album module have been merged together. It did no longer make sense to have them as separate modules. There is no loss of functionality.
- Italian translation has been updated. Big thanks to Marco Artioli!
- Added additional file support to the movie file import.
- Changed the tabs saving mechanism. Tabs are also no longer stored in the database but our now saved per client. This makes it possible for users to create their own form design.
- Code re-structuring; making the code and architecture future proof. This was a huge undertaking but will not be directly visible to you as a user apart from having new features released in the (near) future which would not have been possible otherwise.
- Upgraded Apache Tika to version 1.5
- Added a column selector to table views (right-click on the table header).
- The discogs.com music search has been implemented using the official API, making it more reliable and future proof.
- Added Record Label to the the Music Album Module.
- The Sourceforge.net online service has been rewritten to use the official API, making it more reliable and future proof.
- JTattoo (Look and Feel manager) has been upgraded to version 1.6.10.
- You can now place true type fonts (TTF files) in the fonts directory of the install folder. These will be loaded by Data Crow and can then be used. They will appear at the bottom of any of the font selection lists.
- PDF reports now can make use of Fonts installed (copied) to the fonts folder of the Data Crow installation folder.
- Additional settings can be done by the user by editing the "pdf_config.xml" file as located in the reports folder (of the user directory). Instructions:
- Updated the Module Creation Guide
- Updated the Create Report Guide
- Created a Client-Server Guide
[Fixed]
- One more small issue fixed when upgrading from an old version of Data Crow.
- Regex pattern for the file importer was applied after changes to the name were applied by Data Crow logic. This can cause the regex pattern to no longer match. The regex pattern will now always be applied first.
- Lent versus lend grammar mistakes.
- Avoiding null pointer exceptions in case fields no longer exists.
- Restart of the Delete Module Wizard started the Create Module Wizard
- Problems with the creation of modules due to invalid table names caused by special characters. Now the names are auto generated.
- UTF8 problems with the module.XML files has been resolved.
- Issue with user creation. Module permissions were not saved correctly on the user creation. It only worked after updating the user.
- Create multiple used the view type (table / card) based on the selected search view.
Because of this the card view was used sometimes which is not editable.
- Backup process reported missing "dc.lck" and "dc.log" files.
- Opening the form to create a new user took a long time.
- Module wizard creation module allows Picture fields to be added to property modules while this is not supported. Option has now been removed.
- The Mobygames.com online search has been fixed.
- The Sourceforge.net online search has been fixed.
- Dictionary.txt was saved in plain text instead of in UTF8 format.
- Original label in the general field settings showed the new, custom, label after the user made the translation.
- The view and quick view were not updated after performing a loan action (return / lend).
- Mismatch between the contact person module name and the module jar file.
- A white space for decimal grouping symbol is reset to "." after a restart.
- Drive Manager window settings not applied correctly.
[Client-Server Notes]
A manual has been released: Highlights:
* Clients don't have access to restore and backup functionality, regardless of their access rights. These options are solely available when running Data Crow directly on the server. Future versions might have scheduled backup routines.
* Server can be started using the server command. It's a headless server, meaning it doesn't require a monitor / has not GUI.
* Clients are thick clients. Wait for the new web GUI release for thin client access. Note that Data Crow will always support the client-server mode as currently released. The code has been optimized for client-server access. Data is pulled in small batches. For example, when scrolling in the table and list view only does items are fully retrieved from the server which are currently visible. Clients connected to a server will however always be slower than standalone clients.
* User management is available directly and has remained unchanged from previous version. You can indicate on field level if the user has access to it and what he/she can do with the field content (read/update/delete).
* Icons are cached on each client. No synchronization on icon changes has yet been implemented. Nothing else is cached on the clients. After a restart of a client the icons are retrieved from the server.
* The clients retrieve the settings, modules and value enhancers from the server. Not all settings can be done on the client due to security restraints.
* Modules, system settings and value enhancers are downloaded from the server on startup, this way the server is in control for the modules and system wide settings.

_http://sourceforge.ne...r.zip/download

This version can be safely installed on top the 4.0 version. Do not install this version in the same directory as an older version (3.12.5 and eralier); install this version into another directory.
[Fixed]
- Better error handling in case of duplication in the mapping tables for the upgrade.
- Performance bug in the quick view has been fixed.
- Query Panel did not show error messages
- Properties overview did not refresh after deleting an item.
- User mode was not applied, only after a restart.
- Errors due to existing module upgrade files. I have implemented fail safes to make sure these are skipped and Data Crow is started.
[Changed]
- On upgrading the Audio CD's are merged into the Music Album module. I have now assigned storage medium 'Audio CD' to these merged Audio CD's.

_http://sourceforge.ne...r.zip/download

A small but important bug fix was required. The bug causes a startup error, introduced by the 4.0.2 version released yesterday. I've fixed 2 additional upgrade issues which occurred for some users.
[Fixed]
- Error message; full control needed for the install directory. This message was intended for the server installation only. The client doesn't need this anymore with this version.
- Upgrade error in case the old images folder contains sub-directories.
- Fixed an error for the Audio CD and the Music Album merge.

_http://sourceforge.ne...r.zip/download

Minor release, introducing a new quick filter toolbar. It also improves the handling of startup problems.
[Changed]
- Improved Error Handling for recovery. When the database load fails due to inconsistencies Data Crow would in the past just show the user login page. Now, Data Crow will rename the database, show the correct error and close Data Crow. On a next start Data Crow is started with a clean new database. The user can now restore the last backup. The faulty database does still exists and can be send by email to analyze and fix if possible.
- Improved the handling of user folders; You can now switch between user folders without copying the data over from the existing folder. The option to copy the data has been made an option from the user folder selection dialog.
- Improved handling of old databases; it was always the idea for users to perform an restore of existing backup in the latest version. Most users however upgrade directly which is actually almost enforced by Data Crow. Data Crow will now warn the user in case the old database requires a different upgrade path, such as first upgrading to version 3.12.5. Data Crow will not allow the user to continue to avoid database corruption.
- Quick filter is now a search all field; it will search for text and numbers in all applicable and search enabled fields at once. On the quick filter bar I have now also placed an icon to quickly open the advanced filter dialog. With this change the quick filter bar is simpler to use whereas the advanced filter dialog can be used to create filters of a high complexity (and remember, these can be saved for re-use). Note; it is not possible to use regex expressions in the quick filter (not supported by the underlying HSQL database).
- Added Find & Replace to the Filter menu.
- Upgraded HSQLDB (http://hsqldb.org/) to the latest version (2.3.2).
- Added a "Create Support Package" menu item to the help menu. Creates a zip file
containing all files needed for identifying and resolving problems.
[Fixed]
- Find and Replace was not working correctly.
- Open Item from the right-click menu did not work.
- Fixed an issue in the Database Editor; first column was not shown in the query results.

_http://sourceforge.ne...r.zip/download

Maintenance release. Note that a new version of the Create Report manual has been released as well, fully updated with the changes of Data Crow 4.0.7.
[Fixed]
- GUID (internal ID) shown for Contact Person in the loan history of the Loan Information panel.
- Problem resolved for report creation. This was an old issue which was hard to simulate. An additional check has been added to check whether the file is accessible.
- Not all fields can be added to the Item Report.
- _Persist fields could be selected for the Quick View.
- Server didn't have the library jacksum added to the class path which caused failures for file hashing.
[Changed]
- The item exported now ignores system fields. Additionally the importer now only tries to match an item on import by ID in case the match and merge option has been checked.
- The Create Report manual has been updated.

_http://sourceforge.ne...r.zip/download