TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Chad Petrovay <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Tue, 6 Jul 2010 18:09:16 +0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (44 lines)
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]
  

ATOM RSS1 RSS2