Arctos Report Template Request: "Ethnology & History Catalog Report"

[AJLinn]

Description of the report - I'm looking to get help creating a report that is not too terribly different in appearance to the search results output (most importantly it includes the media thumbnail), but with the added ability to include description, remarks, value, and/or Last Part Location as a column. Required columns (in this order): GUID Media (the first of how-ever-many photos are there) Identified As Description [attribute]

Ability to add/remove these columns (after description) Creator Verbatim agent Collectors Specific Locality Verbatim Date Value [attribute] Condition Report [part attribute] Last Part Location [part attribute for object]

Ability to customize header Footer to have date and page number

Report would look something like this, with repeating column headers on each page:

Collection for which the report is needed - UAM:EH

If this is a request to upgrade from an existing ColdFusion report in Arctos complete the following:

SQL used in ColdFusion report - copy the SQl from your old report and paste it here - begin and end it with ``` or it will be invisible. Let us know if there is a prefunction to migrate.

Priority - Normal priority - no rush, but it's something I used to be able to do easily in my old database and I've wished for for a long time.

[dustymc]

I started this as https://arctos.database.museum/Reports/reporter.cfm?action=edit&report_id=109

The "sql" (sensu lato) probably needs some adjustments, I've interpreted the specifications as well as I can but some of it doesn't make much sense to me, hopefully that's all clear from the code/remarks, I think this can probably be considered "minor details."

This is a report, that's generally incompatible with highly dynamic: "Ability to customize header" and "Ability to add/remove these columns" aren't very report-like and I'm not sure what to do about that. Possibly that's an indication that something like a mailmerge would better serve this need, maybe it can be addressed in multiple reports, ??? - I'm up for whatever, if I can somehow write code to it. This probably ought to be worked out in principle before we invest too much into this.

Footer to have date and page number repeating column headers on each page

There are two ways we can address that.

1. Fix the layout and I can do something as the report is generated. Eg, each "page" gets x rows, so I have (total/x) tables on (total/x) pages (and can calculate all that before I start printing) and there's just some probably-mostly-unnecessary CSS requesting pagebreaks between the tables, or
2. We pass this off to @lkvoong and @mkoo who may or may not have some sort of dark magic capable of doing this (perhaps only if you print using IE4 from WinNT, and maybe something about moon phase!).

[AJLinn]

@mkoo was spectacular in assisting me with the clone of clone of Ethnology & History Catalog Report but I need to make some modifications and I'm not sure what to do to make the edits.

The new report (for researcher use) should take the clone of clone and make the following modifications:

1. sorted by Last Part Location
2. do not include condition report column
3. do not include value column
4. fix whatever evil thing is resulting in verbatim agents going cookoo crazy and listing the person's name anywhere from 2 to 12 times (!!!) in the column.
5. add horizontal lines separating entries like in the clone of Ethnology & History catalog report

Thank you to anyone who can show me how to make these sql updates so I don't have to keep asking every time I want to make a slight modification of these reports.

[dustymc]

@AJLinn I need two things please

• url to some data (search results)
• link to the report that needs modified

[AJLinn]

url to some data (search results)

Here you go! https://arctos.database.museum/search.cfm?archive_name=dolls_all

link to the report that needs modified

Is this what you need? https://arctos.database.museum/Reports/reporter.cfm?action=view&report_id=184&table_name=api_ajlinn1910_20240829100801368_823&transaction_id=&container_id=

[dustymc]

There you go, I left comments on what I changed.

Except for the removal stuff, I just chased down and removed

• the initial select
• the join in the where cause
• anything that refers to the value in the select

backup:

clone of clone of Ethnology and History Catalog Report.csv.zip