TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

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

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

Print Reply
Content-Transfer-Encoding:
quoted-printable
Sender:
"The Museum System (TMS) Users" <[log in to unmask]>
Subject:
From:
Danielle Uchitelle <[log in to unmask]>
Date:
Tue, 6 Jul 2010 15:08:37 -0400
Content-Type:
text/plain; charset="iso-8859-1"
MIME-Version:
1.0
Reply-To:
"The Museum System (TMS) Users" <[log in to unmask]>
Parts/Attachments:
text/plain (71 lines)
TMS 2010 R2, to be released shortly, includes a data importer that allows you to create new object records from spreadsheets or XML data.  The importer also creates new constituents or links to existing constituents, and automatically maintains the correct conxref relationships.  I'll be demonstrating the importer in a Webinar soon; those who attended Collective Imagination in April have seen it already.

Best,

Danielle Uchitelle


Danielle Uchitelle | Managing Director
[log in to unmask] | 646.733.2239 x264 
GallerySystems | www.gallerysystems.com



-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Smith, Jeffrey
Sent: Tuesday, July 06, 2010 2:35 PM
To: [log in to unmask]
Subject: Re: TMS SQL Backend Errors

It would be wise to run the SQL by support at Gallery Systems. They'll know what to look for.

-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Tuesday, July 06, 2010 2:09 PM
To: [log in to unmask]
Subject: Re: TMS SQL Backend Errors

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