Hello,
we are doing regular imports from access databases. These databases are specially designed so that each column in one of the tables of the database represents a specific field in the TMS database. The number of tables in these databases depends on the department, it can be only one, if no list fields are relevant, or more, if terms from the Thesaurus for example are in use. We use external access databases mainly in our archeology departments. They are used right on the excavation sites and are easier and faster to handle, as well as independent from our institutions IT network.
I think it is important to have them designed beforehand, to define which fields are necessary, which data is needed and how the available data can be adopted/adjusted to fit into TMS and its structure, in order to have the right information placed in the right fields and displays in the end.
Actually, its works quite well, but you have to be familiar with the TMS database structure and basic sql commands, as you will need to chose the right tables, tableIDs and query types to import the data, for example, if you add rows to a table, you will always have to add a login otherwise the access query is not working successfully. Sometimes more than one table or query is necessary for correctly importing data. I am usually creating a work database with links to the relevant tables in the TMS database and a list of queries needed to get the data into the right places which I can reuse each time I receive a copy with new data to import.
After the data has been imported, it is important to run the DB configuration maintenance procedures (to update sortnumbers, statistics etc.).
Greetings,
Katharina Szlezak
MMag. Katharina Szlezak
TMS-Administratorin
Provenienzforschung
Abteilung Kultur und Wissenschaft
Amt der NÖ Landesregierung
Landhausplatz 1
A-3109 St. Pölten
T 0043-2742-9005-15916
F 0043-2742-9005-13029
E [log in to unmask]
Von: The Museum System (TMS) Users [mailto:[log in to unmask]] Im Auftrag von Michelle Grindberg
Gesendet: Samstag, 02. April 2011 16:34
An: [log in to unmask]
Betreff: Re: Access to TMS?
Sent from my Samsung Epic(tm) 4G
Chad Petrovay wrote:
Yes and no. I have successfully imported data from an Excel spreadsheet into TMS 9.35.
These were 200 odd objects comprising a gamelan - and none had existing records in TMS. Additionally, almost all of the pieces shared similar attributes (such as maker and context), which made their import easier.
To aid in the import, I created a stored procedure that handled all of the heavy lifting. I then used the mail merge function in Microsoft Word to create a list of SQL commands with the values supplied by the spreadsheet, which I executed in the SQL console. Run some DB Config functions to rebuild search indexes, update statistics, etc, etc. And Bob's your uncle...
It's not very pretty, but it worked.
~Chad Petrovay
Cultural Heritage Data Solutions | 602.400.7826
On Fri, Apr 1, 2011 at 7:23 AM, Diane Lee <[log in to unmask]<mailto:[log in to unmask]>> wrote:
I would be interested in any replies as well.
==========================================
Diane Lee, Collections Manager 860-236-5621 x242
Connecticut Historical Society
________________________________
From: The Museum System (TMS) Users [mailto:[log in to unmask]<mailto:[log in to unmask]>] On Behalf Of Christine Droll
Sent: Friday, April 01, 2011 10:15 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Access to TMS?
Good morning, all,
Has anyone successfully imported data from a Microsoft Access database to TMS9.35?
Any thoughts, suggestions, comments, or how-to's would be greatly appreciated.
Christine
Christine Droll
Collections Database Administrator
The Nelson-Atkins Museum of Art
4525 Oak Street
Kansas City, MO 64111-1873
t: 816.751.1333
f: 816.751.0499
[log in to unmask]<mailto:[log in to unmask]>
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.