 
| Subject: | |
| From: | |
| Reply To: | The Museum System (TMS) Users |
| Date: | Tue, 6 Jul 2010 18:09:16 +0000 |
| Content-Type: | text/plain |
| Parts/Attachments: |
|
|
I have imported data into the backend of TMS using SQL. It's not something I recommend, since it is fraught with issues (as you've discovered) - however, sometimes it is the only way to get massive amounts of information into TMS, especially if the data is elsewhere.
Could you post an example of the SQL that you used? It's hard to diagnose the problem, unless we can see what you used, what values you inserted and where.
Chad Petrovay | Collections Database Administrator
MIM-Musical Instrument Museum | 4725 E. Mayo Boulevard | Phoenix, AZ 85050
480.478.6000 main | 480.478.6058 direct | 480.471.8690 fax | www.themim.org
Blog: www.petrovay.com/tmsblog
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Grace Chiu
Sent: Tuesday, July 06, 2010 10:24 AM
To: [log in to unmask]
Subject: TMS SQL Backend Errors
Hello TMS Users,
I was wondering if any of you are importing data into TMS on the backend?
I have run into a problem with trying to import data from the backend into
TMS using SQL. I'm doing some test runs and was able to update the Objects,
ObjTitles, Constituents, and ConXrefs tables on the database. However when
I check in TMS to see if the updates have taken I get an error message:
Invalid procedure call or argument [Error: 5]
[CConXrefTypes.GetConXrefTypes]. The record still show up but I get this
little error message tag and no Constituent information on the screen. I've
combed through the data schemes, tables, and looked at the stored
procedures and I can't seem to find what I did wrong or what needs to be
adjusted. Any help or pointing in the right direction would be greatly
appreciated.
Thanks!
Grace Chiu
Summer OTI Intern
The John and Mable Ringling Museum of Art
5401 Bay Shore Rd.
Sarasota, FL 34243
[log in to unmask]
|
|
|
