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



Just thought id say that this is an issue for us also, and agree it is the network speed, mainly. Very interested in any solutions from the perspective of file naming and automatic upload.

Just thought id say that this is an issue for us also, and agree it is the network speed, mainly. Very interested in any solutions from the perspective of file naming and automatic upload.


I am currently attempting to reverse engineer a legacy gallery ICT interactive. Having migrated the data into EMu I would like to get EMu to export xml in the format required by the legacy flash software. is this possible without using another application to reformat the xml?

This is the format I am trying to create, from the Narratives module:


  <h1>What is it?</h1>
  <p>This is a statue of the god Horus</p>
  <h1>How old is it?</h1>
  <p>It is over 3,000 years old, dating to the 19th or 20th Dynasty (1295-1069 BCE) in the New Kingdom.</p>
  <h1>What is it made from?</h1>
  <p>It is made from stone.</p>
  <h1>What is it used for?</h1>
- <p>
  Horus was depicted as a hawk or as a man with the head of a hawk. He was god of the sky, the embodiment of divine kingship and protector of the reigning pharaoh. Ra-Harakhte (Horus of the two horizons) was another version of Horus, identified with Ra and the daily voyage of the sun from horizon to horizon. The two deities combined to become Ra-Harakhte. He was represented as a falcon or a falcon-headed man wearing the solar disk and double crown or the ...
  and the
  <p>This votive statue has the inscription 'Horakhty Lord of Kemwet [Tell Atrib] for the life, prosperity and health of the Custodian Nebu-nakhte', the donor.</p>
  <p>Museum Register Number H 108</p>
  Given by Mr. G.O. Spafford in 1916.
  <p>It is from Tell Atrib.</p>


We probably wont use this as a final solution, but it would be really handy for allowing curators to check their amendments after the migration. I just wondered if there is anything EMu can do from the reports / exports function or if I will need to use IMu for this?

Just found out what the problem was - I had included a pivot chart in the report based on the external .csv files. When I removed the pivot chart from the report there was no error message. what I think happened was that the pivot chart was storing the erroneous path somewhere and in contrast to query tables, excel does not let you change the SQL behind the pivot chart. I overcame this by creating a query table to import the data into the report and then created a new pivot chart based on the imported data.

I have found that when using MS query to create an SQL string sometimes and without warning Excel/ M Query may insert the entire path into the .csv file including the user's path (C:\Documents and Settings\[Your username]\Local Settings\....)  into the SQL.  It is possible to manually delete this by checking the SQL and deleting the path so just the table name is left.

Ok Back for more on this one I am afraid.. and all was going so well! 

So... for the most part my excel reports are running fine and multiple users can run them with no problems. However recently another user develped a report and when I downloaded the report and refreshed the query I got the attached error message

This is an Excel/MS Query problem rather than something to do with EMu, but I need to sort it in order for different users to run the reports. No VBA code is involved this time, just the background query running from within the Excel file. Somewhere along the line the good old users path gets encoded into the file rather than a dynamic multi user bit of code, and it causes the query to fail to refresh when a different users runs the report. Many of my reports dont have this issue, so I know there is a fix but I cant work it out, I have a suspision that it can be resolved by a particular setting in the query properties settings.. but I have not resolved this yet.

24-Jun-11 21:12:42
Column of scientific references - geological type specimens
Forum: Bibliography


I have an Excel spreadsheet with various catalogue related data, however it includes a column of scietific references to publications of type and figured fossils. I understand how the bibliography module works, and so given data in the followign format:

Hill, D., 1940: A monograph on the Carboniferous rugose corals of Scotland (Palaeontographical Society) pt.3 p.121. (As Palaeosmilia regia Phillips)

I understand the process needed to manually create the tree of bibliography records needed to document this in the way EMu intended.

However - The string of data as it has been recorded above seems to give me all the information any researcher would need in a nice and tidy way. Would I be forgiven for importing all of this into a text field and leaving it at that?

.....any comments would be greatfully received.



23-Jun-11 00:31:02
help needed with images from EMu in report format
Category: Using EMu

ok another question - I cant see how this method would allow multimple images to display properly? When I set the reports properties to 'all images' they all seem to be stuck on top of each other - is there a way around this?



Hi Thomas

I have developed an Excel report that will export the images to the C:\drive. It renames the images and creates a new folder directory depending on the multimedia attachments of each record.

We are currently using this to export batches of multimedia records for use as display case graphics: each multiemdia record is attached to a display case in the locations module. As the report is run the excel program takes the  'Data\KESoftware\Cache\...' path and copies images from here to a new path that is created based on data from emu. The images are renamed to their irn numbers and saved in a folder that corresponds to level 3 in the locations module fields.



I have seen this happen to a few multimedia records created from jpegs from a low spec digital camera. The images view normally in Microsoft image viewer but not in thumbnail view in eMu. Google's picassa also displays the images in a strange RGB colours.

11-Mar-11 00:47:24
Category: Using EMu

Hi Christelle,

I have set a maximum resolution - but when the report runs it still downloads the original tifs , rather than the '......250x250.jpg's.



10-Mar-11 04:57:59
Category: Using EMu


I am having trouble getting some images to display in a page view that I am designing. Some images work and some dont appear - I cant quite work out why, but so far it seems that .tifs are causing the problem. Also I would like to display all images attached to a record, not just the chosen thumbnail. Does anyone have some xlst code that works for this? So far I have used the code posted by Warren but when I uncomment the loop part the images dont load.





13-Jan-11 00:06:26
help needed with images from EMu in report format
Category: Using EMu

Hi Mark
Thanks so much  - that worked perfectly!

12-Jan-11 03:37:24
help needed with images from EMu in report format
Category: Using EMu


Can anyone tell me how in crystal reports it is possible to resise images exported from EMu to fit into a certain size on a report whilst maintaining the original proportions?

Looking at the picture resize and 'can grow' options in the format box it seems there might be a way to create a formula that works based on image width / height meta data, but I cant see how.

All I need is for images to appear slightly larger than thumbnails withought aspect ratio distortion, irrispecive of the original image size.



Problem Solved, and it was a simple solution in the end,thanks Bern! -  please accept my apologies for the reams of useless code posted earler.  All that was needed for the reports to successfully retrieve data from the .csv files was two lines of code in the format.....


Range("b2").QueryTable.Connection = "ODBC;DSN=EMu Catalogue;"

all problems are now fixed and the report runs fine, with multiple tables connected via MS Query. I think the issue may have been that when the connection code was wrong, the program simply ignored it and looked for the original query file on my PC, which then only worked when I ran the report and failed with other users.

ok, back for more on this. ...

The problem occurs when more than one query tables are specified and joined using MS query, from within Excel.  As it is only possible to save one report file, the Excel report, to the EMu server, the link to the .dqy query file is lost once the report is run from another pc, but works from the pc of the report designer.

So the solution might be to specify the table joins using Visual Basic entirely and not MS Query, which by the looks of things will be  tricky.
Alternativelty each table could be imported seperately into the excel file and the report generated using a sequence of Vlookups, which I dont trust much.


I thought I should flag up that I still have not resolved the above issue.  When the  DBQ is not specified in the VB code, and the report is run from another login / user - the report fails with the same error message. The query definition still 'remembers' the path to the computer that created the report, not the current user.

When I create simple excel reports that only use one worksheet/query table this problem does not happen.

My only guess as to the solution might be that I need to specify the entire connection and sql string for each query table rather than relying on those embedded in the worksheet.

Crystal reports is not an option due to specifications of the designers, and the report does look rather nice when it works, however at the moment I am the only one that can run the report. Perhaps this is not a bad thing.

I hope I am wrong?

Hi Rowena, Ben, David and Alex,

At Bristol Museum and Art gallery we are now also planning a Parties clean up, and have been through the same steps as mentioned in this thread. We have found the reporting function more useful than 'reverse attachments' by using Excel formulae to detect obvious duplicate records and highlight them.

I have linked an example Excel report to this post, that might work as is, or could be adapted to work with a different EMu system, - in conjunction with a screenshot of the report fields needed - for highlighting duplicates in the Accession Lots module: Accession Lot parties report: highlight duplicates

We have also decided to use the Column Attach registry setting to restrict various sets of Parties records to different fields in the catalogue and other modules. We are considering the use of the Roles field to act as the search function for the registry setting, but wondered if any other institutions had made progress with this and if so what terms and which attachments fields have they done it for?

We are at present looking into possible terms, and deciding which fields to do this for. Although theoretically possible, I think it would seem a little far-fetched and impractical to have a separate registry setting and search term for every Possible parties attachment throughout EMu - so where would you draw the line? Also we are concerned that the use of the Roles field in this way could confuse EMu users, as there are other roles fields in the catalogue. Perhaps restricting the availability of the Parties>Roles field may help, but again this would also have implications for users creating new parties records.

At present we have only used the Column Attach registry setting for Parties records attached to the fields Parenthetic/Basionym Authors. I have used the term 'Taxonomic Authority' in the Parties Role field, and thus the value of the registry setting is 'NamRoles_tab=Taxonomic Authority'

We would be most interested to hear of any updates from people undertaking similar parties clean ups, comments, advice etc.

Mark Pajak
Documentation Assistant
Bristol Museum and Art Gallery


I am trying to create a dynamic group that will capture all Parties records that are attached to Taxonomy as Authorities via AutBasionymAuthors_tab or AutCombAuthors_tab. This is to begin cleanup of all duplicate records created during the initial migration and current data imports.

I believe this is possible using a TexQL query statement from the groups module but I have not so far cracked it.

Does anyone have the code for this?



Hello Bern,

Thanks for your reply - I agree that it would be simpler not to specify the path, and doing it that way (as per the EMu help notes) did work initially but only on my PC. When the report was run by another user on another computer the code came up with the following error message:

ODBC Text Driver Login Failed
'C:\Documents and settings\BRLSAD2\Local Settings\Application Data\KESoftware\Reports\ecatalogue' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

...where BRLSAD2 was the login name of the user that created the report and not the login of the person running the report.

so.... After looking through all of the code and not finding any reference to my personal foler, I used the macro recorder to re-run one of the queries and the resulting code DID have my login details:

ActiveWindow.SelectedSheets.Visible = False
Sheets("AllData").Visible = True
With Selection.QueryTable
.Connection = Array(Array( _
"ODBC;DSN=EMu Catalogue;DBQ=C:\Documents and Settings\BRLSMP4\Local Settings\Application Data\KESoftware\Reports\ecatalogue;DefaultDi" _
), Array( _
"r=C:\Documents and Settings\BRLSMP4\Local Settings\Application Data\KESoftware\Reports\ecatalogue;DriverId=27;MaxBufferSize=204" _
), Array(";PageTimeout=5;"))...................etc

So that was when i decided to create a dynamic pathe to the home folder. It seems that by creating the links in MS Query for the report there somewhere lies a hidden link back to the users PC that does not change when another report is run.

If I am wrong and there is a simpler way then I would definitely use it, perhaps this might be as our museum runs Escel 2000 or something?


Mark Pajak

Ok i have updated my original code to find the path to the [username]\Local Settings\application data folder.

It is working so far but I am not convinced that this fully resolves the problem of the .csv files getting exported to strange places with suffixes.

I think there is still a chance that EMu exported the .csvs to the weird folder but the report looked in a different folder and opened a previous export that had gone to the right place. It looks like the only way to check is to run around the museum logging on to different PCs as different people and running the report.

I used this to retrive the path to the folder:
Public Declare Function SHGetSpecialFolderLocation _
Lib "shell32" (ByVal hWnd As Long, _
ByVal nFolder As Long, ppidl As Long) As Long

Public Declare Function SHGetPathFromIDList _
Lib "shell32" Alias "SHGetPathFromIDListA" _
(ByVal Pidl As Long, ByVal pszPath As String) As Long

Public Declare Sub CoTaskMemFree Lib "ole32" (ByVal pvoid As Long)

Public Const CSIDL_PERSONAL = &H5
Public Const MAX_PATH = 260
Public Const CSIDL_LOCAL_APPDATA As Long = &H1C

Public Const NOERROR = 0

Public Function SpecFolder(ByVal lngFolder As Long) As String
Dim lngPidlFound As Long
Dim lngFolderFound As Long
Dim lngPidl As Long
Dim strPath As String

strPath = Space(MAX_PATH)
lngPidlFound = SHGetSpecialFolderLocation(0, lngFolder, lngPidl)
If lngPidlFound = NOERROR Then
lngFolderFound = SHGetPathFromIDList(lngPidl, strPath)
If lngFolderFound Then
SpecFolder = Left$(strPath, _
InStr(1, strPath, vbNullChar) - 1)
End If
End If
CoTaskMemFree lngPidl
End Function

Thanks again for the help.
Mark Pajak

Thanks for getting back to me - that certainly looks like the answer, but I dont think I am using VB.Net, or at least I dont know how.

This is what I have currently:

Querypath1 = "ODBC;DSN=EMu Catalogue;DBQ=C:\Documents and Settings\"

Querypath2 = "\Local Settings\Application Data\KESoftware\Reports\ecatalogue;DefaultDir=C:\Documents and Settings\"

Querypath3 = "\Local Settings\Application Data\KESoftware\Reports\ecatalogue;DriverId=27;MaxBufferSize=204, " & _

'Debug.Print Querypath1 & UserNameOffice & Querypath2

Dim QueryPath As String

QueryPath = Querypath1 & UserNameOffice & Querypath2 & UserNameOffice & Querypath3

Debug.Print QueryPath

Worksheets("AllData").QueryTables(1).Connection = QueryPath

Function UserNameOffice() As String
UserNameOffice = Application.UserName
End Function


Any ideas as to how to convert the above to use (Environment.SpecialFolder.LocalApplicationData) ??

Thanks again,

Mark Pajak


I work for the Natural History department of Bristol Museum, UK. I have just finished writing a fairly complex report in VB to extract specimen dimensions and info from the events module into a list in excel to email to the case designers.

I have created a vba report that uses data from several .csv files liked using two seperate queries in Excel. It works fine when I run the report from my computer, and usually from others on the network. The problem is that when another user runs the report it doesnt always find the latest export of the .csv fiels to report on.

The report uses a dynamic file path string to insert the user login into the filepath (C:\Documents and Settings\[Your username]\Local Settings\Application Data\KESoftware\Reports\ecatalogue)

The problem is that the .csv files are not always exported here - sometimes they go into strange places like temporary personal folders or something - these useually have the user name but with a suffix .AD or ~AD there a way to consistently retrive the filepath to the .csv files to locate the most recent .csv exports?



Mark Pajak


Having recenty aquired EMu and imported all data from our natural history collections I am beggining to come to terms with the full functionality of the Taxonomy module. I would like to know how useful other people find the parent-child relationships within the module?

Our data has been migrated with no parent attachment links so they would all need creating from scratch, and I guess a record created for each higher rank, such as Phylum: Arthropoda. This could quite possibily take forever, (unless the appropriate import file can be created), given the amount of fields, so I would like to know what is accomplished by having such a structure to the data, when the fields in the higher classification tab are already populated and searchable - does this make sense?

Although our collections are moderately large they are not regularly accessed by taxonomists and identification to species is not always possible (or perhaps even necessary). Is there any enhanced functionality in terms of web access that can be gained by building the hierarchy?

Also I currently have all tabs turned on, as is the default. What is the simplest way of making the module more user friendly, i.e. hiding tabs when they are not needed. I think I am going to reduce the tab visibility quite a bit but I do not want to hide something that turns out to be vital.


Bristol Museum

  • Index
  • » Users
  • » MarkPajak
  • » Profile

Board Info

Board Stats
Total Topics:
Total Polls:
Total Posts:
Posts this week:
User Info
Total Users:
Newest User:
Members Online:
Guests Online: