Forgot password? | Forgot username? | Register
  • Index
  • » Users
  • » realw
  • » Profile



20-Jul-11 04:02:19
consolidate thousands of multiple narratives: best and fastest way
Category: EMu Administration
Forum: EMu Admin

I have a ton of narrative records that are identical except for the object references. My aim is to take, for example, 4 narrative records, each linked to one object record, and end up with one narrative record linked to all 4 objects, and also to the images of each object. And do the same thing at the same time for hundreds of other narratives that relate to multiple object records.

I can't figure out how to do this efficiently, without having to do a lot of manual work either within emu or on csv export files. It would be cool if the Merge command would do this, but apparently it does not.

I'm on version 4.0.01 by the way.

Thanks for your ideas.


30-Mar-11 08:24:41
Web editing of EMu data, especially for Macintosh platform

We are running emu on Macs using a virtual pc application; I don't recall which but can find out from IT if you want. It works quite well; so far the most noticeable loss of functionality is that keyboard shortcuts don't seem to work.

30-Mar-11 08:18:36
anyone implemented zoomify on web site using images from emu?
Category: EMu Administration
Forum: EMu Admin

We're interested in providing our web users with zoomable images. One option suggested by our developer is Zoomify. I assume we would have to export and process images from EMu to accomplish this. Has anyone done this or something similar who would be willing to share their experience?

23-Sep-10 00:48:47
Looking for a script that enables logging of number of licenses used
Category: EMu Administration
Forum: EMu Admin

Some years ago there was a presentation at an emu users meeting in which a method was described to enable logging of the number of licenses in use at various points in time throughout the day. I think there was also a way to determine if a log in was not active and could be terminated after a certain period of time. I think it might have been Larry Gall from Yale Peabody Museum.  Does anyone remember, and/or does anyone use these tools besides Larry? (Larry if you are out there, would these tools be available for others to use?).


10-Aug-10 05:14:43
a way to enable access to hi-res image files without importing them
Forum: Multimedia

Several years ago I heard some EMu user talking about "tucking in" large image files in a multimedia record, so that they show up on the Resolutions tab but are not the primary image for the record. Does this ring a bell for anyone? If you are doing this, can you explain how you do it, and its advantages and drawbacks in your experience?


We would also welcome the multivalue notes tab as standard in all modules.

Will Real
Carnegie Museum of Art

Hi everyone,

Here are some scenarios that come up regularly:

1. Several permanent collection galleries have been deinstalled for a temporary exhibition. Later, when the galleries are to be reinstalled, someone asks, "can we have a list of objects that were in those galleries right before we deinstalled them?"

2. The Director wants to know: how many works of art were on view at any point during the year 2009? Compared to 2008?

I can sort of imagine the logic required to perform these queries, but I can't fathom how one would put it together in emu. I am guessing one would have to construct a TexQL query using EditQuery. I have written fairly simple TexQL queries but nothing this complex.

Does anyone know how to do this?



25-Nov-09 11:00:00
Category: Using EMu

Hi Joanna,

Here is a link with some useful info

We use a couple of the free/shareware Code 3of9 fonts. I think we got them through this web site or something similar.

You need to include the start/stop character which for Code 3of9 is "*".

We use a formula in the crystal report like this

"*" & {elocatio_csv.LocBarcode} & "*"

We find it is very useful to have a font that includes human-readable characters.

The hardest part, we found, is formatting the report so the barcodes and whatever text we want print in the center the actual labels. Lots of trial and error, I'm afraid. In theory you should be able to set it up in the Layout tab of the Section Expert, which allows you to set up multiple columns. But we found that entering the actual measurements does not always work, so we fiddled and tweaked the numbers and section sizes until it worked.

I could send you any of the reports we use if that would help.

Will Real
Carnegie Museum of Art

Hi Will,

I meant to chime in on this earlier. We probably do not require as many levels as the university you describe, but we definitely have at least 3 levels of access that we want to implement, at least for multimedia. We would like to hear from other users--if this functionality became part of the standard client, would it be a benefit to you?


29-Sep-09 09:00:00
Category: Using EMu

Hi everyone,
I have been asked to develop a report that shows one image on a page at the largest possible size, with Summary Data as a caption. What I envision is setting the page as landscape or portrait orientation based upon the image metrics. I doubt this can be done, but just in case, does anyone know how to do this? Or am I not thinking about this in the right way?

As it stands, I can't make the OLE object any larger than a square that fits within the width of the page, minus margins--around 6 inches square. It would be ideal to be able to get an image to print at about 9 inches on the longest dimension.


will real
Carnegie Museum of Art

29-Aug-09 09:00:00
Category: Using EMu

Hi everyone,

I have a project that requires a large volume of images to be imported and linked to the associated catalogue records. For each catalogue record there are anywhere from 3 to 15 images. In addition, many of the catalogue records already have 1 or more multimedia records attached.

Is there a manageable way to do this using the Import Tool? If so can someone outline the process?


Will Real
Carnegie Museum of Art
Pittsburgh PA

The Audit tab in the catalogue appears to display a reverse-reference table. In display mode you can click the blue arrow icon to open the linked audit trail records in the Audit Trails module.

But in query mode, there is no linked field like there is for all of the other reverse-reference tabs.

For example, if I want to do a search in the catalogue for records in which a particular value was changed in a particular field, I am out of luck.

Or if I had to assemble a disparate group of Audit Trail records and then view the associated catalogue records, I cannot drag and drop the audit records into a catalogue linked query box the way I am accustomed to doing with other modules.

Would any others find this useful, or has anyone found another way to do this sort of thing?

A somewhat less beneficial alternative would be to provide unlinked query boxes for all of the primary columns in the audit trail, such as column name, old value, and new value. I doubt these columns could be displayed in the catalogue Audit tab, however, since in many cases they would contain multiple values.

Will Real
Carnegie Museum of Art

19-May-09 09:00:00
Category: Using EMu

Is anyone writing crystal reports on emu data using the JDBC data source listed in the CR "Available Data Sources" window in the new report wizard? If so, what do I need to do to get set up for this? Or is it even possible?


Will Real
Carnegie Museum of Art

I think I am having a similar issue. The date format in the csv's definitely do not match the emu system registry setting.

Following Bern's instructions I located the.profile-local and it is absolutely blank (just says "client cma"). Am I supposed to paste in the code Bern provided and modify it to suit our circumstances?

Joanna, did you get your problem resolved in this way?

Will Real
Carnegie Museum of Art

Hi everyone, we are trying to figure out why some of our images appear differently when imported into emu than they do when we finish preparing the files in Photoshop. We know the appearance change is not just in emu; it also happens in various other image viewers such as Windows Picture and Fax Viewer, Quicktime PictureViewer, Microsoft Paint, and so on.

Our working theory is that all of the applications where the appearance changes are not "color-management-aware". But we would like to understand what is going on in case we need to tweak our image editing workflow.

All of the images we load into emu are jpegs derived from master TIFFs. The TIFFs are color-corrected in the Adobe RGB (1998) color space. When the jpegs are created, we embed the sRGB color profile, with the rationale that sRGB is sort of the safe, standard, internet default, lowest-common-denominator, color space. We have thought that embedding the sRGB profile should prevent any really weird appearance changes like we have observed when a non-color aware application tries to display an image with a color profile like Adobe RGB (1998).

We know that this is strictly a display issue, because when we take the image round-trip from Photoshop to emu and then save it out of emu and open it again in Photoshop, the original Photoshop appearance is unchanged.

We tried several variations, including saving the jpeg with no color management at all, converting the profile rather than assigning it, etc., and the same thing happened.

Does anyone know what emu is doing when displaying an image that might explain this? Any other ideas of what we should be investigating?

24-Apr-08 09:00:00
Forum: Parties


At CMA we use Other Names when a separate record is not needed to link the party to a catalogue record (or loan etc.) with the name they were known by at that particular time. This is a search aid for users. We do use the Also Search registry settings so that regardless of which field is used to perform the search, the Other Names table is also searched. We do not enter Other Names systematically, only when the opportunity arises in the course of business.

If a separate record is required so that the module record to which the party is linked displays the correct name for the period of time involved, we do use Synonymy. So far we have not had a case where we've needed more than one synonym for a party so we've not thought thru your question of whether there ought to be a parent record. But I believe that each synonymous record has to be linked to the others if you want all synonyms to be searched in a query by any one of the names. In other words, if record A is synonymous with records B and C, but B and C are not synonymous with eachother, then a search on B or C would bring up records linked to 2 of the 3 synonyms, not all 3. There would probably be a way to catch them all by editing the query in TexQL (if you are Forbes or someone of similar mastery), but this wouldn't be of much help to the average user.

Good luck


Janeen, thanks for moving this along. I'm getting in under the wire with some input.

1. We would like to see an alternative to Book Series to accommodate instances where one is cataloguing local holdings and the holdings do not include the entire series of which a book is a part. A field in the Book tab corresponding to the MARC field for series information for incompletely held series would be useful.

2. We would like to see a field on at least the Book tab that corresponds to the MARC 300 field for Collation (a string of various descriptive attributes about the publication's size, binding, etc. that is standard in bibliographic records).

3. Subject Headings: Ideally there would be a way to record Library of Congress Subject Headings, each part of which could be designated as a particular type of heading, as is done in MARC records. The subtypes would be geographical, chronological, topical, and form.

4. We love the proposed Notes tab and the idea of allowing automatic or manual author strings.

5. I am not sure I understand what is being proposed for Citations. It sounds like a simplification of the current practice. Would it accommodate references to reproductions of items in the catalogue, which would typically include the page and figure or plate number and whether the reproduction is monochrome, duotone, color, etc., and might also include a way to enter text from the caption of the reproduction.

6. This might be asking for the moon, but for the sake of future interoperability and interchange of data in our bibliography modules, it would be highly desirable to have a canned XML export report that maps to MARC fields.

Thanks for considering our thoughts.


Perian, I feel your pain. I have succeeded in doing what you are trying to do with much effort and help from people who are much smarter than me!

The first problem, I think, will be solved in the EMu Report dialogue box. When you have a field with the same name in different contexts you have to change the names of the fields in the field dialogue box. Then Crystal will be able to recognize each as a unique field.

The second problem is where the real pain happens. What I had to do was write formulas and variables that split the multi-value fields and then strung them back together again with a delimiter like a semicolon. For example here is a formula that splits up and restrings multiple subjects:

Local StringVar Array values;
Local StringVar semivalues := "";
Local NumberVar elems;
Local NumberVar i;

if NOT IsNull({ecatalog_csv.CatSubject_tab}) then
values := Split({ecatalog_csv.CatSubject_tab},chr(10));
elems := Count(values);
for i := 1 to elems do
if( i > 1) then
semivalues := semivalues + ";";
semivalues := semivalues + values[i]


You also have to set those multi-value tables in the EMu report field dialogue box to export as text (the Table as Text button on the toolbar).

If you want me to send you the report I finally wound up with that worked, I can do that, maybe you can figure yours out from my example.

Of course someone else might chime in with a much simpler way to do this.

Will Real
Carnegie Museum of Art

12-Mar-08 11:00:00
Category: Using EMu

Hi, I would like to know more too. We have had it turned on since mid-January and have racked up 540 MB of data (more than our entire catalogue). So far I have used it only informally to check up on certain projects and new users. I'd like to be able to archive the data periodically so if anyone has developed a system for that, would you post it?

Will Real
Carnegie Museum of Art

Many of our users would be in favor of a much simpler Bibliography functionality.

As an admin I can see the advantages of the hierarchical design of the module, though there are some things that are missing (for example, there is not a good way yet to cite published photographic reproductions of works of art, etc.).

As it stands, the module's biggest headaches for me are that in the various Field dialogue boxes (like reports, List View, Sort, etc.) one sees multiple instances of the same field name (one for each possible instance of the field, for book, journal, article, etc.) and there is no way to distinguish one from the other, aside from selecting them all for your report or list view and figuring out from there which is which, and then going back to remove the irrelevant ones.

I have always told users not to worry so much about the way bibliographic references appear within emu because we can output them any way we like using Crystal Reports or other tools. Having tried to illustrate this in practice, I found the multiple field instances to be prohibitively confusing.


31-Oct-07 11:00:00
Category: Using EMu

Hi Mark, the way I do this is by setting the Sort Order attribute in the EMu Reports properties to sort by the Creator field (for example, Creator Name>Cited Name). EMu will sort the records before exporting the data for the report. In the report itself I don't set any other sorting instructions. I can use groups in the report and the records within the groups will maintain the original sort by Creator.

I know there is another way to do this by passing a shared variable from the subreport to the main report but I always have trouble remembering exactly how to do that, so the pre-sort in EMu seems easier.

Will Real
Carnegie Museum of Art

Hi everyone, actually this is just a test to see if emails in this forum (Events) are getting through.

Will Real

Hi everyone, now a year later, we asked KE for a quote to add the Object Event Number as a column in the Objects tab grid.

The cost, though relatively modest, is nonetheless beyond our budget, so it occurred to us that other EMu clients who are interested in having this functionality might want to share the development costs with us.

If any of you out there have not already had this incorporated into your Events module, and you think you might want to, please contact me as soon as possible (offlist OK)


We are about to do an EMu version upgrade on the server and at the same time install a new client (we had some custom design work done). Compared to some institutions we have relatively few seats (about 50) but still it is alot of clients to install one by one.

We tried developing a script based on Forbes's instructions and found that the unattended installation stops at a certain point because the local users do not have Administrator permissions (we have a Windows network). We get a message to the effect that the installer wants to install Jet 4.0 and cannot because the user is not an administrator, and then it aborts the installation. This happens even when the computer already has Jet 4.0 installed.

My IT guy says that most applications provide an .msi installer file for remote, unattended installations. Apparently this installation takes place entirely under the System user login and does not require the local user to be an administrator. He says this installation method is extremely common, nearly universal among applications that claim to be supported by Windows.

So I suppose I have two questions: 1) can anyone think of a way around our immediate dilemma? and/or 2) is there any hope that KE will develop an .msi installer in the future, or do we Windows shops have too little clout?


19-Jan-07 11:00:00
Category: Using EMu

I have a situation that seems to keep coming up in my crystal report design.

I typically create a subreport for Creator information for at least 3 reasons: 1) it allows me to display multiple creators in the same details section of the main report 2) an object with multiple creators shows up only once in the main report, whereas it would print multiple times if the Creator data were contained in the main report, and 3) it makes it easier to string together Creator-related data such as nationality and life dates.

But when I need to sort the report by Creator name, I run into a problem because the Creator data is not available to the main report for sorting, since it is in the subreport.

I've gotten around this somewhat by assigning the sorting criteria within the EMu report properties. In other words, the data is sorted in EMu before it is exported, taking the sorting away from Crystal reports itself. When I do this I can still use groups in the report and have the items within each group still sorted by Creator name.

But what if I want to group by a field (such as Category or Section), then sort by Creator name, and then sort by a third field in the main report, such as Series title. Adding the additional sort criteria (beyond the grouping) messes up the "original" creator name sort.

It seems like I have to create a variable based on the name in the Creator subreport, and pass it to the main report to be used for sorting. I've tried this and cannot seem to get it right. Anyone know how?

The only other alternative I can think of is to add the Creator table to the main report, and then find a way to suppress the repeated records of items with multiple creators. Anyone know how to do that?


I hope one of you CR gurus out there can point me in the right direction.

I have a report that groups records by the Nationality of the Creator. I have the Nationality nested table in the main report, to which the Catalogue table is linked with a Left Outer join. The Creator data is otherwise in a Creator subreport.

It works fine when an item has only one creator. The problem is when there are multiple creators, the record appears multiple times. If the nationalities of the creators are all the same, then it appears multiple times under the same group heading, otherwise it appears multiple times under multiple group headings. For example if an item has 4 creators all with the nationality "British" then that item appears 4 times under the British group heading.

How do I ensure that an item will appear only once? Do I have to put the Nationality table in a subreport (e.g. the Creator subreport) and create a shared variable that passes between the subreport and the main report? Can I use that variable in the Group Heading of the main report? (I get confused regarding when various components of the report are processed).

Thanks in advance for any help.

30-Jun-06 09:00:00
Category: EMu Administration
Forum: EMu Admin

Hi everyone,

Do any of your institutions have an imaging policy that governs standards and procedures for creating, storing, and using images--particularly digital images?

Or more specifically, do you have a policy regarding images added to EMu--who can add, what quality is required, what metadata is required, what are the maximum (or minimum) file sizes, pixel dimensions, jpeg compression levels; what is publishable on the internet and who decides, and so on? Some of these things can be controlled to a degree in the registry, but much of it is more about staff procedure and day to day use.

If your institution does have documentation like this, would you be willing to share it?

Will Real
Carnegie Museum of Art

Hi everyone,

I am in way over my head and wonder if someone out there can point me in the right direction. We are trying to figure out how to present a series of photographic works by Duane Michals on our online collections database. Typically a Michals work consists of several individual photographs mounted in sequence, forming a sort of pictorial narrative. What I have in mind (and have seen on various digital library and a few museum web sites) is a page turning application that allows the user to navigate frame by frame through the item in sequence.

What I am hoping is to be able to write a METS object that includes a structural map defining the sequence and the location of the component images, as well as a Behavior section that would tell the browser to launch some script or application that would provide the navigation functionality to the user. I envision attaching this document to the EMu record, and export it as the record's primary multimedia. So when the user clicks on the multimedia for this item, the browser somehow reads the METS document, launches the required scripts, and presents the user with the first image in the sequence and navigation buttons to advance to the subsequent images in the sequence.

We've considered creating Adobe PDF documents but find that they turn out to be very large files. We also considered just stitching all of the images together in sequence and allowing the user to scroll thru the sequence in an image window, but again this makes for a relatively gigantic file, if you want to maintain any quality. These composites also look really silly as thumbnails.

Any advice out there?


Will Real
Carnegie Museum of Art

Thanks Barbara,

At CMA subclassing Events is not going to be an option in the foreseeable future, so we are hoping the generic Events Objects tab can give us at least most of what we want. We like that there is a field for the Event Number for the object. This allows us to ascribe unique ids to objects in a particular exhibition. But not having the field also appear as a column in the grid is limiting. We want to be able to see at a glance what those event numbers are, without having to click thru a long list to scan the numbers one at a time.

We are hoping that other KE sites would agree that having this field included in the object grid would be useful, as part of the standard package.


17-Mar-06 11:00:00
Category: Using EMu

(I have a somewhat related post in the internal movements/locations development forum)

We want to be able to create a report that groups objects hierarchically by location. This is not so difficult when all of one's objects are linked to a standard location record (as opposed to a holder). But if some of the items are linked to holders, the situation gets quite complex and I have not figured out how you would do it.

As an example consider a report on objects in the following 5 locations:

Print Room - Case 5
Print Room - Case 9
(holder) Box 1 - Print Room - Case 9
(holder) Box 2 - Print Room
(holder within a holder) Negative box 1 - Box 1 - Print Room - Case 9

What we'd like to see is a group on the highest-level location (Print Room). Beneath that we would want a group on any location entity that is next in the sequence. There would in this case be three groups at the second level: Case 5, Case 9, and Box 2. Beneath that we would want, within each of those groups, the next level applicable. So under the group heading Case 9, there would be a group heading for Box 1. Similarly, under the group heading for Box 1, there would be a heading for Negative Box 1. Under each grouping, as applicable, would be a listing of the objects at that location.

As you can see, each group level refers to potentially several fields of information--any of the location levels, or the Current Location of the Holder, or the Holder name, etc. There are multiple hierarchies involved--the location levels, and the relationships among holders and their current locations.

I am hoping that someone much smarter than me has figured out a formula to group on that does essentially the same thing. I've tried to wrap my brain around the logic and I quickly flame out (if the object's location is a holder, and the holder is located within a holder, and the holder is located in a static location Level 1, then display the holder's holders' current location as the group heading, else, if the location is a holder, and the holder is located in a static location, then...forget about it).

Or is there some other way to do this?

Would it make sense to construct a report like this from the point of view of the catalogue (report on objects) or locations (report on locations)?

If (see my other post in EMu development forum) the holder summary data strings were formatted in the same manner as the location strings, that is, from largest location entity to smallest, one could quite easily produce a workable report that is simply grouped by location summary data. The groupings would not be hierarchical as in the illustrated example, but at least they would be in correct order, and I think our users could live with that.

Thanks for any tips anyone might offer.


Up until recently all of the reports we had that used images were displaying only a thumbnail-sized image. Then I had to develop a report that was essentially one page per object, with a larger (ca. 6") image and a caption drawn from the data. We discovered that the image in the report is not the actual image from the multimedia repository, nor does it appear to be the thumbnail image or any other derivative from the database either. It is a file of something like 250 pixels or so. It does not hold up to being enlarged to the full size desired by the user.

Is there any way to control the resolution of the image file in the report? If not can anyone think of a quick way to accomplish the same thing through other means? (that is, perhaps not using Crystal reports as the reporter).



I know I've posted this before in the distant past, so just in case it has gotten lost in the shuffle:

We want to see, in the table of Objects on the Objects tab, a column for the Object's Event number, in addition to the other columns (Object, section, notes) that are there. And of course it should be possible to sort the table by that column as well.



Perhaps this has been brought up before but if not:

The way EMu constructs the summary data strings for normal locations (in hierarchical order, from highest level to lowest level) is different from the way it constructs summary data strings for holders (smallest holder first, then next largest, etc., followed by the static location of the last holder in the sequence).

This has been confusing for our users. For one thing, when you sort a group of records on the current location field, your records do not group neatly by the location level hierarchy, as one might wish.

Is there any way KE could have locations and holders display the same format of summary data--starting with the highest level entity and working to the lowest?

(I have a related post I am about to make in the Reports forum)



In our case I don't think the version of photoshop we are using is in play--we use Photoshop CS2 which as far as I know is the latest version available.

The progressive option is not limited to jpeg 2000 file format. I believe it was introduced to the jpeg format sometime in the late 1990s to enable progressive loading of an image over slow internet connections. Apparently it is only noticeably faster with quite slow connections.

In any case we are not saving our files as jpeg 2000, at least not yet.



>>1) I need to make into a parameter a selection on a date field, but Crystal seems to want to make it a date/time field, meaning that my user needs to type in some arbitrary time '12:00:00' as well, making it not very friendly. Do you think exporting it as text would make the parameter/selection user interface better? Do-able?

I think if you temporarily put the actual date field you are referencing into the report, then right click it, and choose Format Field, then in the ensuing dialog box you can select from any number of date formats; if necessary you can get rid of the time portion by choosing the Customize option in the dialog box and editing the settings so that no time components appear. I believe that once the underlying field is formatted, you can select on it, via parameters, using the same formatting. I think you can also specify the formatting in the parameter field settings, if you choose the right field type from the Value Type drop down list. After you have formatted the underlying date field, you can suppress it if need be.

There is also a way to set properties for all Date/Time fields but I admit I rarely do this, even tho it might be easier. Click File>Options>Fields and then Date/Time. There you can globally set the format for any Date Time field that comes into the report.

The problem with exporting the date time as text, I think, is that the data can no longer be interpreted in terms of ranges, the way a date field can, so I'm not sure the parameter field would work on the date range selection.

>>2) I have a text block in a section with several lines of address text, and when a part of the address is absent, I'd like to suppress the blank line. None of my twiddles to put it in its own text box, and suppress on null seem to work.

Right click on the text box, select Format Text, click on the Common tab, and choose the option Suppress Embedded Field Blank Lines

>>3) I have two subreports in the body of the report, and I'd like the amount of text each subreport takes up to be fluid - the 'can grow' idea, but the first subreport results are flowing all over the second when the text expands. I don't know how much room each subreport will need to print.

Put each subreport in its own Details section, then they will not overlap

>>4) I have a multi-page invoice to produce, with each page being a different report. I'd like to combine each of these reports as subreports into one report, thus saving the user time, but the bottom treatment of each report gets truncated, and they do not flow out as distinct (as created) pages. The bottom parts end up in the middle of the page, instead of at the bottom.

I think for this you will have to play with the Section Expert for each of the sections that you want to have printed on their own page. There are check boxes for "New Page Before" and "New Page After" which would force page breaks where you want them. To get the top part of each report to print, you might need two Page Headers--one for page one and one for page two, and conditionally suppress the one that does not belong on each page using a formula based on PageNumber. If you send me a copy of the report I could play with it.


Andy, this is exactly the trick I had been looking for. Never knew this technique existed! Thanks.


Thanks for the information--what had been happening was I was getting error messages when trying to attach pdf's and mistakenly concluded that the file type was not supported.

I'm curious if others get this message when trying to attach files other than image files: it appears that EMu is trying to make a thumbnail, as if the file is an image file, and reports an error when I cannot do that. I believe my multimedia registry settings for automatic file derivation are correct--they specify that the incoming file should be JPG--so it seems that EMu should not be trying to make a derivative of a pdf or other type of non-image file.

Hi everyone, I had a problem recently with certain images not appearing in Crystal Reports, in the crystal viewer. I tried to figure out why and came up with a hypothesis. I believe that jpeg images that had been saved in Photoshop with the Progressive option selected in the JPEG Format section were not printing, whereas jpegs saved with the Standard option selected were printing.

I could not find anything related to this in the Crystal Reports Knowledge Base.

Would anyone be willing to see if this happens to them?

Save a jpeg in photoshop
in the jpeg properties dialogue box click the Progressive option and select 3 in the Scan field.
Import the image into EMu and try printing it in a report
(We have a canned report in Multimedia called Dublin Core Summary with Image, I was using that one).

Then try saving the same image out of EMu, opening it in photoshop, resaving it with the Standard format option selected, and reimport it into EMu, and see if it prints.



I am hoping someone knows a way to quickly retrieve Parties records that are attached to a particular linked field in the Catalogue, or even Parties records attached to any linked field in the Catalogue.

What I do with most other attached modules is use the Objects field in the query mode of the attached module. I pull up a group of the relevant catalogue records, select them, drag and drop them into the attached module's Objects field, and run the query in the attached module.

Since there are no attached modules tabs in Parties like there are in Multimedia, Accession Lots, Conservation, etc., this method is not available.

Another option for most attached modules is the View Attachements routine in the Catalogue (View>Attachments>Current or Selected), but the Parties module is not included in the list of attached modules.

So how else to do it? I was wondering, for instance, if there is a way to write the query using the Edit Query function (either in the catalogue or in Parties).

Will Real
Carnegie Museum of Art

Multimedia should support more file types. I discovered with a shock recently that a format as common as .pdf is not supported, for instance.

Will Real
Carnegie Museum of Art, Pittsburgh PA

Dear kling et al.,

[...In the catalogue, we have the parent-child which, I believe, should carry over into the conservation module, yes? A related question is, does one necessarily have to cut and paste the batch treatment procedures for each item in the collection, or can one report be associated with the collection as a whole?]

Currently, attributes of a parent record in the catalogue cannot be "inherited" by the child records (except for location, if you have the "independently moveable" box unchecked in the child records, which would typically only apply if the child objects are attached or mounted together).

Conceptually this is part of a bigger question: what types of information should be recorded at the parent level, which at the child level, and which at both levels? In the batch treatment scenario, I think you want the information at both levels--so that whether looking at the catalogue record of the parent, or at the individual child records, you would be able to see a reference to the conservation treatment record. The way the database currently works, you would in this case attach the records of all the children, as well as the parent, to a single conservation record--if you have the possibility of 1:many in the conservation module, that is...

It's probably a long shot, but it would be nice if KE could somehow make it possible to designate attributes that would be inheritable from parent to child. I suppose this could look something like the existing Bibliography model, in which you see a read-only tab representing the parent (e.g book), from within the record of the child (e.g. article in book). This might be harder to develop in the catalogue, where the nature of parent-child relationships is much more variable and complex than for bibliographic records, and the way various institutions use parent-child relationships can differ so widely. But this is probably a subject for one of the other forums...

Carnegie Museum of Art

JP et al.,

[The more I think about it, the more I think that if we go 1:many, then we have to use the 'materials' and 'dimensions' from the catalog. I also think going 1:many will make reporting a huge pain (but I'm open to counter-argument). ]

OK, I'll take the bait [Smile]
When the details of a treatment, including requirements for conservation-specific meansurements and materials, vary from one object to another, it would not make sense to use a single conservation record for multiple objects. It only makes sense to do that if the details of the treatment are literally identical for all of the attached objects.

As an example: In my institution there are certain materials or objects that are routinely fumigated before they are brought into the building for a temporary exhibition. The conservators plan, supervise, and document this "treatment". This treatment does not require conservation-specific measurements or materials descriptions, or an elaboration of the condition of each object. The proposed treatment and actual treatment are going to be identical for each object. There is not going to be any PhotoDoc. So this, I think, is a case where having the possibility of a 1:many would be helpful. OTOH, without 1:many functionality, one could simply ditto the same cons. record for each object treated. Not that big of an inconvenience.

Reporting: without knowing what kinds of reports are needed at other institutions it is not easy to respond, but at CMA, for the above example, there would be a single treatment proposal and a single treatment report, each listing all of the objects, and copies of each would go into the appropriate files for each of the objects involved.

Where the reporting gets complex with 1:many is when you wind up, say, with the objects in a subreport, but you want to report on nested tables or linked fields from the catalogue, within the subreport. You cannot have a subreport within a subreport. The only way around this is to export the nested table as text. Then depending on how you want to output the data, you might have to create complex formulas to split apart multiple values from the nested table and put them back together. So I guess the complexity of reporting would depend upon how much and what kind of data from the catalogue is to be included in the report. If it is lots of data of various kinds, then a 1:many report from the conservation record would indeed be a pain. With 1:1, you don't have to put the catalogue data in a subreport so things are much more straightforward.

Thanks for all the good work and collaborative spirit.

Carnegie Museum of Art


Thanks for the reply, which confirms for me that in most cases the issues I raised have to do more with usage than structure, and are to be resolved by laying out very clear instructions for the users to avoid any confusion about what kind of information goes where, and why.

[Once you get into 1:many it is not clear how you deal with, e.g., writing the condition report for multiple objects.]

Right; the only reason you would ever create a single conservation record for multiple items is if the condition, treatment, etc. are literally identical for all objects attached. While rare, this does happen occasionally; in such cases a condition report/treatment proposal is written for the group, rather than one by one. So I don't think you want multiple condition details for multiple objects in the same conservation record--only a way to apply identical condition/treatment data to more than one object, in those unusual cases.

[I do not want to lose the information that the object was cataloged as 'German silver' because that gives us either provenience of chronology information, and may be important for technological searches; OTOH, I do want a correct chemical description of the object for conservation purposes. What we gain in having two fields is clarity of meaning (at least in the conservation module)]

Right, I'd not considered that. I think this is an instance of clarifying usage--so the conservators know that they need not replicate materials that are already sufficiently described in the catalogue, but rather to use this field to elaborate on materials insofar as they bear upon the preservation or treatment of the object.

[measurements of parts]

At CMA, we catalogue to the part level in most cases, and store measurements of parts in the part-level catalogue records. This is probably nuts, but that is what we set out to do. Also our measurements tab in the catalogue, which is far from ideal, does nonetheless allow the entry of multiple measurement sets, including, I would imagine, mount measurements (though in our case this particular issue has not come up yet). But as you pointed out, if the conservation measurements are really so specific perhaps they ought not be recorded in the catalogue. And again, the key would be to clarify for the conservators that this field is not meant to replicate basic object measurements that are already in the catalogue.

['Conservation.Handling Instructions' as data that goes in the printed report that accompanies an object on loan. These requirements are similar to, but distinct from, the requirements for handling an object in-house]

I can see the logic behind this. On the other hand in my experience (at least for the types of objects in our collection) the handling instructions for loans are fairly static. That is, if an object is loaned more than once, its handling instructions would most likely be the same, or nearly so, in each loan. If that is so, I am thinking that an additional tab in the catalogue, similar to the canned Display, Storage, Illumination etc. tabs, called something like "Loan requirements", might be useful. Where this approach would fail is if the institution wants to retain in the database the specific instructions made for every loan in an object's history. If keeping this level of detail for posterity is not important, then tweaking/updating the loan handling instructions from time to time would work. Just a thought mind you from someone who is working too late [Smile]


this whole conundrum relates very much to the discussion of the multimedia/media asset data model discussion that is underway in another forum. It would be nice if we could have a better sense of where that is headed so it could be incorporated into our thinking re: the conservation design. I'd weigh in on that but I cannot quite get my head around it just yet...

OK, I'm done, thank goodness


Thanks to Ducky, JP, et al. for undertaking this effort.

Just a few observations/comments:

1:1 or 1:many? I favor retaining the possibility of 1:many, even if in practice there is most always only one object record attached. To display catalogue data in the conservation module for one or more attached objects, I picture something like a cross between the multimedia tab and the objects tabs of the management modules (particularly Events). At the top of the tab you would have a window displaying the specified catalogue fields (read-only), much as the multimedia tab in the catalogue displays some of the multimedia module fields to the right of the media window. Below that there would be a table listing the one or several objects attached to the record. The read only data displayed at the top of the tab would change based on which object is highlighted in the table below, much as the read-only data for attached multimedia records changes as you click on one multimedia icon or another. If there is only one object attached, then there is only one set of data to display.

It seems to me that if this scenario is possible, one can have it both ways--there can be only one object attached, and its information could be displayed just as it would if no more than one object could be attached, as in the prototype; or, there could be multiple objects attached, in which case the conservator would have access to the key catalogue data for each item without having to open the catalogue itself.

On the other hand, if using the 1:1 structure is simpler and less troublesome, I think it is fine, and appropriate for 90% of cases at least. I would just prefer (all other things being equal) to be able to choose how to use the module rather than being forced to use it for one object at a time.

Redundant fields: I have a strong bias against storing essentially the same kinds of data in more than one place. In the conservation module prototype, the fields that strike me as repeating information stored elsewhere are the handling instructions, measurements, and materials. To my mind, these are attributes of the object, not of the conservation treatment (I am assuming here that "Materials" in the prototype means not conservation materials but materials used to create the object--correct?).

Including a place to enter measurements invites the conservator to create another set of measurements for the object that may already be available in the catalogue. Depending on how the measurements are made, there could be slight variations in the data. Then the user has to wonder, which set of measurements is more accurate? (if like me they have great respect for conservators, they would naturally go with the conservation module set, but then, shouldn't those measurements be entered in the catalogue in the first place?)

Similarly materials and handling instructions. As someone at our sidebar meeting in Chicago mentioned, it is hard enough to get staff to look in one place for important information. If they have to look in the catalogue for handling instructions, but also check conservation in case there is something different there, they will probably end up asking for a hard copy report specifying which handling instructions to follow. It is potentially too confusing. Future staff will be confused about which set of instructions is to be considered the primary set.

Instead, I could imagine the handling data from the catalogue displayed read-only in the conservation record, while providing the conservators access to edit the handling instructions in the catalogue, if they are not sufficient or non-existent. Or the inverse of that: storing the handling data in the conservation module and displaying it read-only in the catalogue (the downside to that approach is that there has to be a conservation module record for every object requiring handling instructions, whether or not it is undergoing any conservation treatment).

Tracking: I understand that the management layer is not the primary focus of this design. However I do think that being able to keep track of when a request was made, when the work is due, and when it is actually finished, are important to include. It shouldn't take up too much space, perhaps on the Proposal tab.

PhotoDoc: I think this is a good way to deal with the vexing problem of referencing both digitized (multimedia module) assets and off-line analogue assets. Institutions who catalogue all of their media assets in the catalogue might opt for a linked field here instead of text.

Authorization: From the notes I see there has already been discussion about the problem of denied proposals etc. I agree with the point made by JEK about partial treatment approval, or approval of treatment options offered in the proposal. I don't know how one would handle this, but it is a valid point and something that happens more frequently than one might imagine.

Thanks for offering me the opportunity to comment and thanks for all of your work on this module.

Will Real
Carnegie Museum of Art

14-Oct-05 09:00:00
Category: Using EMu

>When EMu reports are mentioned, it seems everybody always talks about Crystal reports. But what exactly are the advantages of Crystal over the other output formats?

At CMA, few users actually develop reports of any kind. Crystal is complicated, but the real difficulty, regardless of the output format, is that the users do not sufficiently understand the data structure in EMu. Even selecting the fields to include in the report can be a challenge that most users cannot overcome, even if they know how to work with Crystal.

I've somewhat solved the problem by creating reports that the user can tweak at the time they run the report. Using parameter fields in Crystal, the reports are set up to prompt the user to accept default fields included in the report, or select/deselect fields from the report. They can also type in report titles on the fly using this functionality. In some cases they can select how the report is sorted.

It takes quite a bit of time to develop these reports but it saves infinite amounts of time that I used to spend responding to requests like "I really like report xyz, but I don't want the location field included, and I want to add credit line, and could I have the medium before the measurements, and could it be sorted by number instead of by artist name?" [My fellow report developers must be smiling and nodding as they read this!]

Another distinct advantage to Crystal is being able to massage the data in various ways using formulas, applying conditional formatting to call attention to records meeting certain criteria, and perhaps most of all, grouping objects in as many levels as you want. When a Crystal Report has groups, the user will be able to navigate the report by groups, using the little group tree that is available in the Crystal Report Viewer. Once users discover this feature they wonder how they ever lived without it.

The biggest limitation of Crystal is when one needs to export the data to other formats. In particular, exporting to Word, you have to decide between using the Crystal 8 format (which exports to Word with all of the line spacing and indentation preserved but does not support certain functions such as using memo type fields for grouping, sorting, and formulas) or Crystal 9 and beyond format (which has the memo field functionality but exports to Word using an annoying frames format that makes it all but impossible to edit the document, unless you eliminate the frames and thus lose all of your line spacing and formatting).

I have developed a report that sort of gets around this--when the user runs the report, they get a parameter field prompt asking if the report is destined for Word export, if they say yes, the report inserts a pipe character at key locations in the report; when the user exports the report to Word, they run a macro that eliminates the hideous frames and replaces the pipes with line breaks to quickly restore the formatting. They end up with an easily editable Word document that retains the formatting of the original Crystal report. Perhaps there is an easier way to accomplish this--if you know one, please post it!


Will Real
Carnegie Museum of Art

10-Dec-04 11:00:00
Category: Archive
Forum: Archive

Beth, thanks from us at CMA as well for your detailed post. I'm on it!


09-Dec-04 11:00:00
Category: Archive
Forum: Archive

Has anyone figured out how to write a report in Excel that includes the Creator field and displays items only once, whether they have only one or more than one Creator? It seems that ours will display the record twice if there are two creators--once for each creator--and three times if three creators, etc. I have tried fiddling with the table join types in the Microsoft SQL Wizard, and none of the options seemed to resolve this.

Reporting in Crystal and then exporting does not always work so well either because often to get the creator data to print properly you have to put it in a subreport, and subreports do not seem to export well or consistently from Crystal. So you wind up with a gap where you want the creator data to appear.

Any advice appreciated.

Will Real
Carnegie Museum of Art

We agree it would be good if the client could have some control over the
summary data strings. I wonder how complicated it would be, though, to
implement some of the conditionals--for example our catalogue summary shows
number, artist, title, date, separated by semicolons, but if any of the last
three fields are null, the summary does not display the semicolon or blank
space where an actual value would have appeared. We have the same kind of
thing in locations--if it is a holder record, the bar code is displayed
after the holder name; if not a holder, the bar code is not displayed.
Depending on how complicated the programming is in the back end, these kinds
of summary string rules might be hard for the user to create and/or edit. If
KE allows admins to configure summary strings, I would not want to lose the
possibility of conditional text strings.


We'd love to hear other users' comments one way or the other on these ideas.
Any takers?

1. We think it would be helpful if the following linked fields could contain
multiple links:

In Loans: Loan Conditions: we think it would be more useful to have
boilerplate Rights records that are often invoked for outgoing Loans,
then attach one or more of these to each Loan record, as appropriate for
that loan.

In Movements: Associated Loan: we are discovering that sometimes a
will involve more than one Loan and being able to link all relevant
loans to
the movement would be useful.

2. In Movements, we wonder if there could be another field or tab called
"Itinerary," or something like that. We find there are cases when a
movement has 2 or more stops along the way (for consolidated shipments,
example, or when an item is picked up and taken to another location for
packing, then shipped from there). It would be useful to link the
to the multiple Parties along the way and even be able to date them,
to the Venues function in the Events module.

3. On the Multimedia tabs of the various modules, we are finding that
and more attachments are being made. The filenames on thumbnail icons for
attachments are hard to read. If the icon does not display the full filename
you have to click on each icon to view its name in the Resource Title field
to the right. Could there be an option, such as in
Explorer, where the user (or the admin) could choose a list format or an
icon format for the display of attachments? For multiple attachments we
think the list would be much more legible. A user could see at a glance all
of the filenames and more easily identify the desired attachment.

Do others agree? Are there potential downsides to these that you are


William Real
Director of Technology Initiatives
Carnegie Museum of Art

  • Index
  • » Users
  • » realw
  • » Profile