If you are interested in potentially contracting us to assist with your migration project, please fee free to contact me off-list. We have extensive documentation on CSV import here:Īll of our CSV import templates can be found on our wiki, here:Īrtefactual has performed many client migrations over the years, including from Textworks-based databases. spelling differences like behavior vs behaviour analyse vs analyze, etc) that you can clean up in advance? AtoM also maintains every name associated with a description as a separate authority record for re-use - if you have included a biographical or administrative history, you'll need a creator name to associate it with, or else you will end up with an untitled authority record in AtoM after migrating.
Data cleanup helps as well, to ensure consistency - if you have subject access points in your system, did they use a controlled vocubulary, or might there be many near-matches (e.g.
The most important thing is to make decisions in your legacy system about how to deal with non-standards-based data - custom fields that do not map to ISAD, or RAD if you are in Canada. If you do have a CSV export module, then part of the work might be to run an export in your current system, then clean up the data in the export, and add the appropriate AtoM column headers from our CSV import templates. If there is no CSV export functionality in DBTextworks, it becomes more difficult - you might require a developer who can create a transformation script to get your records into an AtoM-compatible import format - we tend to do this with CSV imports. Since I don't believe that Textworks has an EAD export, CSV might be your best bet. Generally, when we at Artefactual do migrations, we try to make use of existing export functionality in the old system, make sure that all the old data maps to a known standard supported in AtoM, and then import into AtoM either via EAD XML, or CSV. For nearly 20 years we have helped a wide range of corporations, law firms, public institutions, government organizations, non-profits, archives and museums utilize the latest information management solutions. Rose quartz with a piece of mica embedded in it.There is not, unfortunately, a magic button or command that will automatically convert your DBTextworks database into something that can be imported directly into AtoM. Andornot is an independent consulting firm incorporated in 1995 and based in Vancouver, Canada. #3 Note: Found in northern New Mexico, 1967. 1967 #3 at #1 del #1 embedded #3 found #1, #3 it #3 mexico #3 mica #3 montana #1 new #3 northern #3 obsidian #2 oro #1 perfect #1 piece #3 quartz #3 rock #1 rose #3 skipping #1 with #3 #2 Note: Obsidian.
Word Indexing Each word in the field value is separately indexed Records Index for Note field #1 Note: Found at Montana del Oro perfect skipping rock. Term Indexing Each field value is indexed as a single entry Records Index for Color field #1 Color: Dark gray Black #2 Dark brown #4 Dark gray #1 Gray #3 Pink #5 #2 Color: Black #3 Color: Gray #4 Color: Dark brown #5 Color: Pink A field can be Term indexed or Word indexed.A field must be indexed in order to be searchable.Records will be added (and sometimes updated or deleted) through the life of the database.
Must have worked on the system for at least 4-6 months.