×

Warning

JUser: :_load: Unable to load user with ID: 1

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

Posts

Posts

For those attending the 2012 Australasian EMu User Conference, the agenda and a map of Melbourne Museum with visitor information are included below.

Registration, tea and coffee will take place between 9:00am and 9:50am. As the Museum does not open until 10:00am, please make your way to the entrance and security staff will show you the way to the registration area.

Look forward to seeing you all there.

Melbourne-Museum-Map-and-Information.pdf

Programme.pdf

Hi all,

KE Software and Museum Victoria are pleased to invite you to the 10th Annual Australasian EMu User Conference that is to be held at Museum Victoria Melbourne Australia, September 11 - 12, 2012.

Full details about the meeting can be found here. If you would like to present and/or host a discussion group, please email me.

You will need to register on-line via the following link if you would like to attend.

Hope to see you all in September!

15-Jun-12 09:48:06
Looking for management tools for EMu/Texpress
Category: EMu Administration
Forum: EMu Admin

Hi Steve,

As you have already figure out, you can't interrogate EMu using SQL Management Studio. Depending on what exactly it is you are trying to do there are a number of different options available to you.

Please give me a call on 9347 8844 or send me an email so we can discuss further and I'll be able to point you in the right direction.

24-Aug-11 01:19:38
Initial view of the Chenhall Nomenclature
Forum: Thesaurus

Hi All,

The EMu thesaurus hierarchy view (the tree of all the thesaurus terms) will order the records alphabetically. The only way to keep those 10 Categories in a specific order is to add something to the terms to make them sort into their assigned place. A number prefix would work. A constant string prefix, like "Category", followed by a number prefix would also work. However, cutting "Category #" off the term will not work.

Aaron

29-Apr-11 22:31:21
Category: Using EMu

Hi April,

There's just one more piece of the puzzle you need.

You are both right about that xml file being the data that EMu uses to create the Page View. To turn that xml data into html, EMu uses an XSLT file (what is XSLT?) that is stored in a similar location:
C:\Documents and Settings\[UserName]\Local Settings\Application Data\KESoftware\Cache\[Table][gt] and [lt] symbols I've posted with actual greater-than and less-than symbols. I hope that makes sense.

The steps are:

    1: bring the two files together. Copy them into the same folder, somewhere on your computer. If they are right next to each other, the modification to the xml file is simple.

    2: add the following line of text just after the first line of the xml file:

    Code:

    [lt]?xml-stylesheet type="text/xsl" href="something.xsl"?[gt]

    3: Open the xml file with your web browser.
    4: Save the generated html.



The first few lines of your xml file should look like:

Code:

[lt]?xml version="1.0" encoding="ISO-8859-1" ?[gt]

[lt]?xml-stylesheet type="text/xsl" href="something.xsl"?[gt]
[lt]!DOCTYPE table
[
  [lt]!ELEMENT table    (tuple)*[gt]
  [lt]!ATTLIST table
            name    CDATA #REQUIRED
  [gt]

If the files are in separate locations, just make sure that you add the full path to the xsl file when you reference it in the xml file.

Hope that helps,
Aaron Jarecki
KESoftware Canada

24-Jan-11 10:01:43
storing species profile data for web use
Forum: Taxonomy

At Museum Victoria we are about to begin redeveloping our Natural Sciences web site. Data enhancement is required (in particular enhancement of species profile information is required) and writing contextual narratives.  Has anybody modified the Taxonomy Module to store this type of data?  If so, I would be very interested in seeing some screen shots or hearing about how you have attempted to store this type of data.

Regards,
Donna Fothergill

18-Aug-10 09:59:13
University of Queensland Art Museum, 21-22 July 2010
Category: Announcements

Hi everyone,

Presentations and photos from the 2010 Australasian EMu user group meeting are now available via the following page.

As there was a high number of attendees that didn't fill in their evaluation survey, If you did attend can you please complete our online evaluation survey to let us know what we're doing right, or how we can improve the experience and usefulness of future meetings.

Thank you to all those that contributed and attended and looking forward to seeing you again next year.

04-Aug-10 09:18:58
Category: Announcements

Welcome to the new EMu Users Forum.

It has taken us a while but we have finally finished moving across all the content from EMuUsers.org including all the forums. Forbes has done an excellent job in maintaining the EMuUsers.org site and we thank him for all his hard work.

The new EMu Users Forum is now part of the KE Software website and can be accessed via the following link: http://emu.kesoftware.com/support/emu-users-forum

If you were a member of EMuUsers.Org your account has been migrated here and your password has probably been reset (it won't have been reset if you also had an account with KE Software's website). If your password does not work, try: keguest

<strong>Everyone has been subscribed to "Forum Announcements" - please read "Start here" for some general information about subscribing to certain topics within a forum.</strong>

If you continue to have problems logging in please send an email to Gerard (Gerard.Wood@kesoftware.com)

16-Jun-10 09:00:00
University of Queensland Art Museum, 21-22 July 2010
Category: Announcements

Hi everyone,

A reminder that the meeting is now only 5 weeks away, so for those of you thinking of attending please register and start making arrangements soon. We have also updated the web site to include a number of different accommodation options.

There are still plenty of free slots open for presentations, for those interested please contact me via email or by calling +61 3 9347 8844.

18-May-10 19:00:00
University of Queensland Art Museum, 21-22 July 2010
Category: Announcements

It has come to our attention that registration emails for the 9th Australasian EMu User Group meeting have not been received by KE. There was a technical issue with one of the mail servers which prevented the emails going through to Hannah and/or Nick.

For those who have registered and have not received a confirmation of their registration, would you please resend your email. You can register by emailing UserGroupMeetings@kesoftware.com with a subject of 9th Australasian UGM Registration

We apologise for any confusion this may have caused.

10-May-10 09:00:00
University of Queensland Art Museum, 21-22 July 2010
Category: Announcements

Hi everyone,

A reminder that the meeting is now only 2.5 months away, so for those of you thinking of attending please register and start making arrangements soon. We have also updated the web site to include a number of different accommodation options.

There are still plenty of free slots open for presentations, for those interested please contact me via email or by calling +61 3 9347 8844.

06-May-10 09:00:00
Museum Victoria, Australia - Manager Collection Information Systems
Category: Announcements

Museum Victoria has a Job Vacancy available as follows: MV/6216 - Manager, Collection Information Systems Grade 5, Value Range 1 This vacancy is Full-time and Ongoing. Applications close Wednesday 19 May 2010 COB. For a role statement and further information applicants are advised to refer to the Museum Victoria webiste link: http://www.museumvictoria.com.au/About/ … mployment/ or contact Maryanne McCubbin on (03) 8341 7379.

I just RTM for VB, and it looks like, if the folder is on the local machine
Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) & @"\KESoftware\Reports\ecatalogue"

would be neater.

http://msdn.microsoft.com/en-us/library … older.aspx

Cheers

JP

Dear Mark

1. The weird suffixes are typically because a user's login domain has been changed.

2. How are you getting the path? In VB .NET I'm guessing it would look something like this:
Dim path as string = Environment.GetFolderPath(Environment.SpecialFolder.Personal) & @"\Local Settings\Application Data\KESoftware\Reports\ecatalogue"

Best

JP

That would be a nice feature, Stephen. And along similar lines, perhaps a check when entering lat/long so that a user is notified when coordinates are entered outside the bounds of a country.

Tony Kirchgessner
The New York Botanical Garden

I'm curious if there is an automated way to populate latitude-longitude by entering a locality. We have many specimens that can be georeferenced to the province/state/territory level but no further. I'd like for the lat-long - say for the centroid of the province - to be filled in automatically for these specimens that can only be georeferenced to province/state/territory.

Thanks,
Stephen Gottschalk

John

You say "nor can we create 20 catalogue records with the same duplicate number". Why not? If you have set this field to be unique, you might consider changing it in order to accommodate precisely this situation of independently movable parts. And that would match the physical documentation practice that the museum has been using.

(With some initial reluctance - from our anxiety about not enforcing uniqueness for our inventory numbers - that's what we've done. The benefits so far seem to outweigh any potential drawbacks.)

Stephen Johnston
Museum of the History of Science
University of Oxford

25-Nov-09 11:00:00
University of Queensland Art Museum, 21-22 July 2010
Category: Announcements

A quick update to let everyone know that further information about the meeting (venue & accommodation details) has been posted on the User Group Meeting section of our website.

http://www.kesoftware.com/content/view/1178/437/lang,en/

16-Nov-09 11:00:00
University of Queensland Art Museum, 21-22 July 2010
Category: Announcements

The University of Queensland Art Museum and KE Software are pleased to invite you to the 9th Australasian EMu User Group Meeting, which will take place at the University of Queensland Art Museum, on 21-22 July 2010, St Lucia Campus (appx 7km from Brisbane), Queensland Australia. 

The University of Queensland's St Lucia campus is considered by many to be Australia's most attractive. Located seven kilometres from the city's heart on a magnificent 114-hectare site in a bend of the Brisbane River, the campus has expansive landscaped grounds and many playing fields. Its hub is a semi-circle of cloistered buildings enclosing the National Trust-listed Great Court.

This event is supported by the University of Queensland Art Museum and KE Software and there is no registration fee to attend. More details will be posted shortly via our website.

To register, please email UserGroupMeetings@kesoftware.com no later than 18 June 2010.

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

Yes, it's the same here. The keystrokes won't copy the text, you have to right mouse click the selected text and choose copy to get it onto the clipboard. There are some similar behaviors when copying list views in the client.

Tom H.

Hi All,

When importing Latitude and Longitude data into the Sites module, I find it very difficult to assign System-generated centroid values to the records. Assigning a value to the "Derive Centroid - System" does not actually populate the centroid fields. Nor, for that matter, does using the "Derive Centroid - User" along with explicit centroid values. Has anyone had similar troubles and found a way to get EMu to generate the centroid values automatically?

Thanks,
Tony Kirchgessner
The New York Botanical Garden
tkirchgessner@nybg.org

Hi all,

I need to filter records on a department, specified in SecDepartment_tab, however I can't seem to get the Texql right.

For example, I have a record IRN 11 and I'm querying the associated narratives like so:

$query->Select("irn_1");
$query->Table = "enarratives";
$query->Where = "irn_1 = 11"

What I need to do is filter the department so I prevent users from seeing IRNs (by way of injection in the URL).

The first value in "SecDepartment_tab" array in the query result is "Fake Department", however I don't know how to add this value in the query or specify it in a WHERE clause.

I tried to add SecDepartment_tab->egroups->GroupName to the query, but the query crashes saying "Unable to resolve 'Fake'. No such file or directory (2)" (or some such)...

e.g. $query->Select("SecDepartment_tab->egroups->GroupName");

Is it because there's a space in the value? Are departments in egroups?


ps. I use "Fake Department" here, but the department is really another two worded value.

Thank you to everyone who posted a reply to my question. Of particular interest is the solution Te Papa have chosen (thanks Adrian!). It seems that narratives provide the most flexibility when it comes to publishing this type of content on the web. I'm thinking that creating a separate department for 'Historical Bios' that can be searched separately from the other narratives and displayed accordingly may be the best work around for the task at hand.

Cheers

Gavin Thiesfield
Communication Designer
Old Government House / William Robinson Gallery
Queensland University of Technology, Brisbane, Australia.

Was wondering if anyone has an opinion on the preferred module for managing web delivered social history bios. Another related question: does the parties module have a field or tab that allows you to paste in a lengthy bio - or is this kind of content best entered as a narrative?

Thanks in advance.

Gavin
Gavin Thiesfield
Communication Designer
Old Government House / William Robinson Gallery
Queensland University of Technology, Brisbane, Australia.

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

Hi, Will

I hate to say this, but it looks as though conditional page layout changes in mid report are impossible in CR XI. See this thread: http://www.crystalreportsbook.com/Forum … ?TID=5328. (I'd love to be proved wrong, though).

However, I read in 'Crystal Reports 2008: The Complete Reference' by George Peck, p.173, that it *is* possible to change orientation from landscape to portrait in mid report in CR2008.

A kludge-around would be to reformat the pictures (e.g., rotate the landscape orientation photos by 90°), but I'm guessing you already thought of that and decided it was stupid.

Best

JP

Hi Maureen,

We were having the same conversation in our operations meeting this morning as to the pros and cons of using the narratives module to manage the presentation of exhibition documentation for our soon to be launched website.

I too would be keen to hear what the benefits are of using narratives to manage events style content for the web.

Gavin Thiesfield
Communications Designer
Old Government House - Interpretative Centre / William Robinson Gallery
Queensland Univeristy of Technology (QUT)
Brisbane, Australia

1. Whoops! Should have written "EXIF datetime tag (1:306)" - the problem is not being caused by an incorrect Registry setting.

2. Current system data format is English-style dd/mm/yyyyy

Dear All

We are trying to use EXIF datetime tag (1:302) to auto-populate the DetDate0 field in the Multimedia module when attaching JPEGs. However, the format of the raw EXIF field data (YYYY:MM:DD HH:MM:DD) seems to be giving EMu a headache. Has anyone successfully used embedded metadata dates (whether EXIF or otherwise) to populate this field?
Best
JP

Hi,
Here's some feedback that may help- (sourced from a reputable digital imaging scholar).
All the applications mentioned are simply not colour savvy - that is they do not have any means of interpreting the embedded profile, therefore they are not colour managed, so you can not expect to see the same colour on screen as you would when viewing the same image in a colour managed application like Photoshop. It is no more complicated than that. In other words, the vast majority of applications on Macs and PCs are not colour savvy, so we can not trust the colour they display even on a calibrated monitor, because they have no way of transforming the image's RGB numbers to those required by the monitor's profile so as to be able to display correct(ed) colour on screen.

Our museum is in the configuration stages of adopting KE Emu for our collections management system, and are in the research stages of figuring out a complementary digital asset management system, particularly for our non-object related archival materials. If your institution uses CONTENTdm, DSpace, or anything else to manage images, please fill out this survey to give us a sense of your satisfaction with its features.

http://www.surveymonkey.com/s.aspx?sm=H … q3GA_3d_3d

I plan to aggregate the results and post them to the archives and archivists' listserv and elsewhere.

Thanks,
Maureen

Hi Bernard,

I took a look at the emuhelpdump script in our current installation. I got the Ref and Ref_ fields to show up in efieldhelp by commenting out the line "#next if ($field =~ /Ref$/ || $field =~ /Ref_/);". (I realize that this is probably similar to what you did for EMu 4.0.01-0908211, but I was eager to test the changes).

The weird thing is that the records for those fields in efieldhelp are quite a bit more barren than I expected. Basically, the only structurally descriptive fields that are given back are these: (ColColumnType: dtInteger, ColColumnKind: dkTable, ColColumnModule: ecatalogue, ColColumnField: IdeTaxonRef_tab)

Maybe my expectations are just incorrect, but shouldn't IdeTaxonRef_tab know that it holds a reference to etaxonomy? It seems strange to have to use the ColReferenceLink field from one of the other efieldhelp records to get that information. There are, for example, 26 fields in ecatalogue that have IdeTaxonRef_tab as a ColReferenceLink, and I can learn from each of those records that IdeTaxonRef_tab holds references to records in etaxonomy. At the moment, I'm just picking the first of those fields since they all have the same information, but it feels like that shouldn't be the correct approach.

Thanks for your help!
@ The Field Museum of Natural History

Thanks for the response Forbes!

I have been working on implementing your suggestion for the past few days and I haven't come across any real roadblocks yet. The real test will come when I have someone who is more familiar with the types and range of fields that will be used in the final application play around with the resultant interface to see whether or not the fields can be properly referenced.

efieldhelp is being used as a data source for a combination validator/autocomplete field that generates paths to fields in other tables. For instance, ecatalogue.IdeTaxonRef_tab contains references to records in etaxonomy. If the user types in IdeTaxonRef_tab, I want my application to know that the records referenced will be in etaxonomy so that I can do autocomplete on a subsequent field. The subsequent field is only generated because efieldhelp also tells me that IdeTaxonRef_tab is a table with references to etaxonomy. If the user had typed in an atom-type field, an addition field wouldn't be generated since they can't burrow down further by hopping to referenced tables.

A strange thing that I noticed is that fields like IdeTaxonRef_tab aren't listed as their own records in efieldhelp, even though they have their own entries in the output of 'describe'. Is that because they are 'hidden' fields? I've only heard that term used in conversation, so I don't know if it's an actual property of a field or if it's just a term used to describe fields that don't show up everywhere that other fields do in EMu. I was able to work around that shortcoming by gleaning information about those fields from the ColReferenceLink XML record element.

Anyway, thanks again for the information that you've provided so far. Any more input that you or anyone else has is still appreciated!
@ The Field Museum of Natural History

Hello,

I'm working on a web application where the output of the 'describe' Texql command would be immensely useful for the dynamic construction of certain queries.

Basically, there are a few ways that a particular field in a record can specify data in another table. The ends of the field names usually describe the relationship like '_tab', '_nesttab', 'Ref', 'Ref_tab'. 'describe' generates a nicely formatted version of the same data. For example:

describe ecatalog;:
IdeTaxonRef_tab[
IdeTaxonRef integer
],
IdeIdentifiedByRef_nesttab[
IdeIdentifiedByRef_tab[
IdeIdentifiedByRef integer
]
]

I want to parse this data structure and be able to use it to populate lists of the database fields in a given table that fit into a given type, such as an integer reference in etaxonomy. However, it seems that an HTTP GET request (such as "GET texql=/?texql=(describe%20emultimedia)") does not work properly. Of course, regular select-from-where queries do work using the same server, so I think that it's an issue of an incapability or misconfiguration of server itself.

The response that I get from the texxmlserver is XML with an element that contains 'results status="failed" error="Syntax error."'.

I included some rationale in this post so that anyone who might know of a way to glean something of the database structure without using 'describe' could still chime in, since I'm not set on using it.

In short, though, I'm just wondering whether or not it's possible to have 'describe' work through the texxmlserver or a similar service that a regular EMu setup would have installed already.
@ The Field Museum of Natural History

I guess it depends on the complexity of your integration. Assuming that, in essence, you are just forming queries and formatting the resultant records and record sets in different ways, I would say that 6 months would be quite enough time. Given that it will be your web developer's top priority, it seems quite likely that it would take even less time. I believe that our plan is to have the bulk (if not all) of the work done by the end of the summer, which is a bit less than three months away.

Jana,

My institution will be integrating our EMu installation with Drupal 6 this summer (starting very soon) and I'm one of the web developers who will be working on it. Were there any potential roadblocks that you had identified or were worried about?
@ The Field Museum of Natural History

Hi Sharon

If you mean you want to start a VM with a web server and some pages that access a currently licenced EMu database then you wont need a new licence. If you mean you want to create a new test install of an EMu database on your VM then you will need to obtain at least one licence from KE to run the test EMu database. If you can spare any licences on your production server you might be able to get KE to move one or two of these to your test environment. I'd contact KE and see what they can do for you.

Simon

Hi Jason,

Are you working with the PHP 5 classes for EmuWeb provided by KE?
Let me know as I've done a fair bit of work with them and can give you some pointers. Attached is some doco on the PHP 5 classes I got a while back which might help. Possibly contact KE as it may have been updated seen I've received it.

Regards,
Simon

Attachment: PHP_5_Query_and_Media_classes.pdf

27-Apr-09 09:00:00
Category: Using EMu

See attached for a pdf of the most recent Society of Museum Archaeologists newsletter, where I discuss our recent project implementing EMu, and specifically, the new tabs we developed in the Catalogue module to manage our bulk site archives, that also have the flexibility to deal with individual small finds in a hierarchical parent/child relationship.

Best wishes,
Laura

Attachment: SMA Newsletter 46 - Spring 2009-1.pdf

31-Mar-09 11:00:00
Category: EMu Administration
Forum: EMu Admin

Hi Ducky,

An RSS feed has been set-up. There is a small RSS icon on the bottom of the page which can be activated by clicking on it (this will use your browser as your RSS reader). Alternatively, you could use an RSS Reader of your choice.
Regards,

Nick Margiolakis
KE Software (Australia)

23-Mar-09 11:00:00
Category: EMu Administration
Forum: EMu Admin

Hi Ducky,

Apologies for the very late reply. We are currently in the process of reviewing this and as you suggest an RSS feed will most likely be the way we decide to go. I'll keep you posted.
Regards,

Nick Margiolakis
KE Software (Australia)

02-Dec-08 11:00:00
Category: EMu Administration
Forum: EMu Admin

Are there any museums out there running EMu on a Windows server using SFU (Services for Unix)? We are hung up on a problem upgrading EMu (actually in upgrading PERL beforehand) and would be very grateful if anyone has experience with Windows server running SFU and PERL to share with us. Please contact me off-list at:
CSawdey@mdhs.org

Cathy Sawdey

25-Oct-08 11:00:00
Forum: Wishlist

Hi Bern (all),

I knew there was something else I wanted to ask you about at the meeting...

Now that the import tool has graced our lives, we all are importing images in batches larger than available space in the default cache. While you can up the size of your cache in Options, the amount of space required is often still larger than the size of many people's C:Drive.

Two part question/request/wish:

1)As I understand it, EMu currently transfers all files into the local cache before uploading them to the server - even if the files reside on the user's local computer. Would it dramatically affect performance if EMu could "trust" certain types of external connections? Maybe by a registry setting saying specific non-C internal hard drives and/or networked drives can be considered "local" and don't have to be duplicated in the cache? If the connection was dropped, the import would stop and an error log generated as per usual.

-or-

2)Barring the above, I was wondering it there could be a way to specify a different location for the default cache (C:\Documents and Settings\username\Local Settings\Application Data\KESoftware\Cache). This way a second internal hard drive in the user's machine - pretty common - could provide a larger playing field for the image load. That said, would a location outside of the D&S area of Windows still provide the necessary cache clean up? Is that action set by Microsoft or deep within EMu?

You're the best Bern, thanks :)

-Rebecca, NMNH

For those who haven't yet seen it come through the various listserves, a consortium called the Metadata Working Group released a Specification Document attempting to standardize the use of embedded metadata fields across the industry. If they succeed, it will potentially impact how many of us map fields within EMu. Considering companies like Adobe, Apple and Microsoft are heavily involved, it seems quite possible they will manage it.

You can download the specification from their website: http://www.metadataworkinggroup.org

-Rebecca, NMNH

04-Jul-08 09:00:00
Category: EMu Administration
Forum: EMu Admin

Hi Jean

You need to add a column access registry entry for each fields you
want to greyed-out (aka read only). Example below.

Key 1: Group
Key 2: Volunteers
Key 3: Table
Key 4: ecatalogue
Key 5: Column Access
Key 6: TitObjectName (this is the name of the field to be greyed out)

Value: dvQuery;duQuery;dvDisplay;dvInsert;dvEdit

The above means the members of the group Volunteers can query on the field in Search mode and view the field in Display, Edit and Insert mode but not edit the field. If you want to give them edit and insert permissions to the field you'd add the duEdit and duInsert permission to the value above.

FYI: dv = Data view and du = Data update

Regards,
Simon

NMA

04-Jul-08 09:00:00
Category: EMu Administration
Forum: EMu Admin

Hello,
I'm certain this is a simple tasks and a bit of a silly question, but wondering if anyone can offer some advice. I am working on our registry settings for volunteers and would like certain fields to be 'greyed out'so that the volunteer would be unable to enter information. I am able to create the registry settings for the mandatory fields without a problem, but obviously the opposite has posed some difficulties. Any suggestions would be greatly appreciated.
Cheers,
Jill MacKenzie
History Trust of South Australia

Hi Alan,

Apologies for the late response but I thought I should mention that we received your support request on Monday night at approximately 9:30 pm which of course is outside our working hours. Tuesday was Canada day and a public holiday and thus we were unable to respond.

Someone from the Vancouver office will be contacting you shortly to organise the installation of the latest TexAPI.
Regards,

Nick Margiolakis
KE Software (Australia)

Hi Alan,

Yeah the emuweb texxmlserver interface is pretty pokey. Plenty of things freak it out and cause it to freeze/run at massive CPU utilisation forever. I've seen the 'texxmlserver is probably already running' error but I don't know the exact cause, could be that the texxmlserver.pid file isn't cleared correctly on a hang or maybe you are running mutiple copies of Emuweb on one server which can cause that prob.

I've found the best way to stop these hangs from happening is to add a timeout limit to the texxmlserver.conf file. When the timeout limit is reached the texxmlserver process will be killed so no more hangs. Adjust the limit to however long you desire (it's in seconds).

Texxmlserver.conf file location:
/your_emu_database_DIR/etc/texxmlserver.conf

Add the following lines (30 second timeout in example):
timeout=30
timeouthandler=error

Search the Emu application help (press F1) for 'timeout' and it'll give you a brief rundown on the setting and the associated timeouthandler setting. Check out the 'matchlimit' setting too to limit the number of records returned, might be useful to you.

Later,
Simon

02-Jul-08 09:00:00
Category: EMu Administration
Forum: Texpress

Alan

The old Texql doco and examples aren't particularly good for figuring these things out (has it ever been updated since the 90s?). I couldn't make head nor tail out of the join operator but you don't need it to get what you want. You need the following:

select ecatalogue.ObjObjectID, emultimedia.Multimedia
from ecatalogue, emultimedia
where exists
(
ecatalogue.MulMultiMediaRef_tab
where MulMultiMediaRef_tab=emultimedia.irn
)
and ecatalogue.ObjObjectID='1992.0038.0028'


I haven't tested this with the XML http server but it works cool
with the commandline texql interface.

Later,
Simon

25-Jun-08 09:00:00
Category: Using EMu

I'm new to both KE EMu and the NHM (Natural History Museum).

We have a need to produce some fairly simple reports (cross matching data from KE to other sources). Usually I would ODBC link one source to the other in MS Access and make exclusion comparisons through Access (Unmatched queries). I find that there is no ODBC link directly into KE. Has anyone got any leads on if there is a way to link or if there is an ODBC driver i can use?

  • Index
  • » Users
  • »
  • » Profile

Board Info

Board Stats
 
Total Topics:
598
Total Polls:
0
Total Posts:
1358
User Info
 
Total Users:
830
Newest User:
Erica Scarpitti
Members Online:
2
Guests Online:
147