Wednesday, July 04, 2018 10:58 AM
DB/TextWorks has been around since the late 1990’s and we sometimes come across clients with databases that were developed almost that long ago! Two recent projects we are working on involve rationalizing older databases to modern standards. It’s amazing how old, ugly, inefficient interfaces can be spruced up through the use of one of our kits for libraries, archives and museums. We use these as a starting point, and after updating field names to be as descriptive as possible, we import our query screens, report and edit forms and adjust these to show the clients fields. If you have report designs you like, you can do this too! Under Maintain > Manage Textbase Elements you can import and export forms from one database to another. We like to color code our databases and it’s possible to open the exported forms in Notepad or other text editor and carefully edit to replace background colors.
Inevitably requirements change over the years, so we help clients review how fields are being used, and suggest adding or deleting fields to better handle their needs. We also make sure to add automatic number and date fields, appropriate validation and substitution lists and work with clients to clean up their data by batch modifying or updating values through the validation lists. After so many years working with DB/TextWorks we have a lot of tricks up our sleeves, and often export data, adjust it in other software and re-import to split or combine fields.
If you need assistance with your databases, please check out some of our past blog posts that provide various suggestions for improvements. Note that some of these reference older versions of DB/TextWorks so the location of functions may not be identical.
Spring Cleanup series:
Give your databases a new lease on life and contact us for a quote to help you love them again!