Open AdrienneRaniszewski opened 10 months ago
@jldunnum
@Jegelewicz have you done these?
Nope
OK thanks. (Maybe that was loans?)
@AdrienneRaniszewski can you provide a query (for each or all)? Either a saved search or parameterized URL will make this go much smoother.
Maybe that was loans
yep!
Dusty, not sure what you're asking for. A query of a few catalog numbers?
I brought over the SQL for MSB_Mamm_fluid_skin_tag, but it isn't valid, and I think uses some very old data. Are we sure that's the right report?!
Is there any desire to have any standardization in these? Eg they all seem to manipulate sex, and they all seem to do it a little differently. Intentional?
@AdrienneRaniszewski yes an example of what you might use the label for, ideally in some form that I can click here to open and then get to the label from that. Doesn't have to be perfect, just something more realistic than my default "catalog number=some smallish integer" will probably save some back-and-forth. (I'm assuming the various labels correspond with variability in data, if that's not true we can start with catnum=12...)
That is the report that we've been using. and it still works for me just now.
And no, any difference in how a report gets at the same piece of data is not intentional. Just me fumbling around trying to figure stuff out.
I'll send a list of catalog numbers.
Thank you!
here's a few MSB:Mamm catalog numbers: 123123, 346117, 300000, 212709, 192000, 321321, 341014
difference in how a report gets at the same piece of data is not intentional.
Then maybe we can focus on one of these, get it happy, and reuse it for the rest instead of starting from scratch a bunch of times. I've got MSB_Mamm_fluid_skin_tag dumping data in a couple ways. It has problems, feel free to just ignore what's there and tell me what you wish was there, make adjustments, however you want to do it to get this one working as it should be. Once you're happy with the data we can work on layout and other reports.
I'm using this as my test search - send a URL if you want us to see something else: https://arctos.database.museum/search.cfm?guid_prefix=MSB%3AMamm&cat_num=%20123123%2C%20346117%2C%20300000%2C%20212709%2C%20192000%2C%20321321%2C%20341014
then..
then...
Old report with the same data: MSB_Mamm_fluid_skin_tag.pdf
@AdrienneRaniszewski I am going to email you for a time to discuss via zoom. I have a bunch of questions to jump start these labels! thanks
Thanks all!
Jonathan L. Dunnum Ph.D. (he, him, his) Senior Collection Manager Division of Mammals, Museum of Southwestern Biology University of New Mexico Albuquerque, NM 87131 (505) 277-9262 Fax (505) 277-1351
Chair, Systematic Collections Committee, American Society of Mammalogists Latin American Fellowship Committee, ASM
MSB Mammals website: http://www.msb.unm.edu/mammals/index.html Facebook: http://www.facebook.com/MSBDivisionofMammals
Shipping Address: Museum of Southwestern Biology Division of Mammals University of New Mexico CERIA Bldg 83, Room 204 Albuquerque, NM 87131
From: Michelle Koo @.> Sent: Friday, January 12, 2024 10:53 AM To: ArctosDB/arctos @.> Cc: Jonathan Dunnum @.>; Mention @.> Subject: Re: [ArctosDB/arctos] Legacy Arctos Reporter Templates to Save (Issue #7240)
[EXTERNAL]
@AdrienneRaniszewskihttps://github.com/AdrienneRaniszewski I am going to email you for a time to discuss via zoom. I have a bunch of questions to jump start these labels! thanks
— Reply to this email directly, view it on GitHubhttps://github.com/ArctosDB/arctos/issues/7240#issuecomment-1889722013, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AED2PAYHCGCEOGSLWBMWRA3YOF2ALAVCNFSM6AAAAABBXESSQ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQOBZG4ZDEMBRGM. You are receiving this because you were mentioned.Message ID: @.***>
We're meeting next week and have prioritized the list:
update: just saw that Dusty set up the SQL so will merge and delete one of the MSB Mamm fluid tags....
Adrienne supplied the best PDF possible -- with measurements! See attached. I am working on formatting for both dry and wet tags now.... MSB_Mamm_reports.pdf
Jihyun and Daechul will start fixing formatting on the labels, starting in order:
Self-assigning small vial label: https://arctos.database.museum/Reports/reporter.cfm?action=edit&report_id=167
@Honghyejeong will work on this: MSB_Mamm_large_label - same as above but different size
Hi! Thanks for everybody's help with these. Are any of them ready for me to look over? We've got lots of fluid specimens ready for tags!
Quick update Formatting is almost complete then we’ll work on the data variables but will need you for testing and feedback
Next week?
Sent on the go
On Fri, Feb 23, 2024 at 12:55 PM AdrienneRaniszewski < @.***> wrote:
Hi! Thanks for everybody's help with these. Are any of them ready for me to look over? We've got lots of fluid specimens ready for tags!
— Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/7240#issuecomment-1961977135, or unsubscribe https://github.com/notifications/unsubscribe-auth/AATH7UPLAAU6DC3NWWSH6O3YVD63HAVCNFSM6AAAAABBXESSQ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNRRHE3TOMJTGU . You are receiving this because you were assigned.Message ID: @.***>
Next week would be fantastic! I’ll be available for feedback. Let me know when you’re ready. Thanks!
From: Michelle Koo @.> Date: Friday, February 23, 2024 at 1:59 PM To: ArctosDB/arctos @.> Cc: Adrienne Raniszewski @.>, Mention @.> Subject: Re: [ArctosDB/arctos] MSB Mamm Legacy Arctos Reporter labels to do (Issue #7240) [EXTERNAL] Quick update Formatting is almost complete then we’ll work on the data variables but will need you for testing and feedback
Next week?
Sent on the go
On Fri, Feb 23, 2024 at 12:55 PM AdrienneRaniszewski < @.***> wrote:
Hi! Thanks for everybody's help with these. Are any of them ready for me to look over? We've got lots of fluid specimens ready for tags!
— Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/7240#issuecomment-1961977135, or unsubscribe https://github.com/notifications/unsubscribe-auth/AATH7UPLAAU6DC3NWWSH6O3YVD63HAVCNFSM6AAAAABBXESSQ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNRRHE3TOMJTGU . You are receiving this because you were assigned.Message ID: @.***>
— Reply to this email directly, view it on GitHubhttps://github.com/ArctosDB/arctos/issues/7240#issuecomment-1961981987, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AFQ6G3E7KPC5BEEXHJFV4KDYVD7MTAVCNFSM6AAAAABBXESSQ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNRRHE4DCOJYG4. You are receiving this because you were mentioned.Message ID: @.***>
Hi! Checking in again. Anything ready for me to look at?
Hi All, Any update here? We really need these, can't print any labels at all at this point, and hundreds of specimens backing up. Thanks, Jon
Hello everyone,
My name is Hyejeong Hong and I am in charge of producing large vial labels. I have almost completed the HTML/CSS code, and I will send you the code file and the results when I run the code. Please check it out and let me know if there are any more changes that need to be made!
Thank you, Hyejeong Hong
On Tue, Mar 12, 2024 at 3:18 PM Jonathan Dunnum @.***> wrote:
Hi All, Any update here? We really need these, can't print any labels at all at this point, and hundreds of specimens backing up. Thanks, Jon
— Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/7240#issuecomment-1992675229, or unsubscribe https://github.com/notifications/unsubscribe-auth/A3J6WU2GOM7IE3YPMYBVSZTYX55K3AVCNFSM6AAAAABBXESSQ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSOJSGY3TKMRSHE . You are receiving this because you were mentioned.Message ID: @.***>
sorry for the slow response-- been battling a virus here but I wanted to say the formatting of the labels are done but we need to incoporate the identifiers now (MSB's NKs etc) which will require your testing help!
Let me see if I can review the sql and have you all test with your data instead of NK-less records
On Tue, Mar 12, 2024 at 3:26 PM Honghyejeong @.***> wrote:
Hello everyone,
My name is Hyejeong Hong and I am in charge of producing large vial labels. I have almost completed the HTML/CSS code, and I will send you the code file and the results when I run the code. Please check it out and let me know if there are any more changes that need to be made!
Thank you, Hyejeong Hong
On Tue, Mar 12, 2024 at 3:18 PM Jonathan Dunnum @.***> wrote:
Hi All, Any update here? We really need these, can't print any labels at all at this point, and hundreds of specimens backing up. Thanks, Jon
— Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/7240#issuecomment-1992675229,
or unsubscribe < https://github.com/notifications/unsubscribe-auth/A3J6WU2GOM7IE3YPMYBVSZTYX55K3AVCNFSM6AAAAABBXESSQ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSOJSGY3TKMRSHE>
. You are receiving this because you were mentioned.Message ID: @.***>
— Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/7240#issuecomment-1992682437, or unsubscribe https://github.com/notifications/unsubscribe-auth/AATH7UNNSHQBY4OGZV7MPT3YX56HTAVCNFSM6AAAAABBXESSQ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSOJSGY4DENBTG4 . You are receiving this because you were assigned.Message ID: @.***>
Hi, Michelle and Hyejeong.
A few label notes.
For fluid skin tags, I see three versions in the Arctos Report Printer. Only one produces any results, but the formatting is still way off.
The two sizes of vial labels are a little better, but formatting is still off from the examples I sent (label spacing and size mostly) and they’re displaying stuff they shouldn’t and not displaying stuff they should. Mostly identifiers problems, as you mentioned.
And I don’t see the regular skin tag at all.
I see quite a few issues, but don’t really want to type them all out, since much of it is already in the notes and examples I sent. Maybe once the formatting is at least looking good, then we can start testing with our MSB data.
Thanks again for helping with this! We’re looking forward to getting back to printing very soon!!
~ Adrienne
Collections Associate/Staff Coordinator MSB Division of Mammals 505-277-5369
From: Michelle Koo @.> Date: Tuesday, March 12, 2024 at 9:07 PM To: ArctosDB/arctos @.> Cc: Adrienne Raniszewski @.>, Mention @.> Subject: Re: [ArctosDB/arctos] MSB Mamm Legacy Arctos Reporter labels to do (Issue #7240) [EXTERNAL] sorry for the slow response-- been battling a virus here but I wanted to say the formatting of the labels are done but we need to incoporate the identifiers now (MSB's NKs etc) which will require your testing help!
Let me see if I can review the sql and have you all test with your data instead of NK-less records
On Tue, Mar 12, 2024 at 3:26 PM Honghyejeong @.***> wrote:
Hello everyone,
My name is Hyejeong Hong and I am in charge of producing large vial labels. I have almost completed the HTML/CSS code, and I will send you the code file and the results when I run the code. Please check it out and let me know if there are any more changes that need to be made!
Thank you, Hyejeong Hong
On Tue, Mar 12, 2024 at 3:18 PM Jonathan Dunnum @.***> wrote:
Hi All, Any update here? We really need these, can't print any labels at all at this point, and hundreds of specimens backing up. Thanks, Jon
— Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/7240#issuecomment-1992675229,
or unsubscribe < https://github.com/notifications/unsubscribe-auth/A3J6WU2GOM7IE3YPMYBVSZTYX55K3AVCNFSM6AAAAABBXESSQ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSOJSGY3TKMRSHE>
. You are receiving this because you were mentioned.Message ID: @.***>
— Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/7240#issuecomment-1992682437, or unsubscribe https://github.com/notifications/unsubscribe-auth/AATH7UNNSHQBY4OGZV7MPT3YX56HTAVCNFSM6AAAAABBXESSQ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSOJSGY4DENBTG4 . You are receiving this because you were assigned.Message ID: @.***>
— Reply to this email directly, view it on GitHubhttps://github.com/ArctosDB/arctos/issues/7240#issuecomment-1993268996, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AFQ6G3BQ7PPQUV2KDOKKOOTYX67GTAVCNFSM6AAAAABBXESSQ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSOJTGI3DQOJZGY. You are receiving this because you were mentioned.Message ID: @.***>
Thanks Michelle
Jonathan L. Dunnum Ph.D. (he, him, his) Senior Collection Manager Division of Mammals, Museum of Southwestern Biology Research Assistant Professor (LAT) Department of Biology University of New Mexico Albuquerque, NM 87131 (505) 277-9262 Fax (505) 277-1351
Chair, Systematic Collections Committee, American Society of Mammalogists Latin American Fellowship Committee, ASM
MSB Mammals website: http://www.msb.unm.edu/mammals/index.html Facebook: http://www.facebook.com/MSBDivisionofMammals
Shipping Address: Museum of Southwestern Biology Division of Mammals University of New Mexico CERIA Bldg 83, Room 204 Albuquerque, NM 87131
From: Michelle Koo @.> Sent: Tuesday, March 12, 2024 9:07 PM To: ArctosDB/arctos @.> Cc: Jonathan Dunnum @.>; Mention @.> Subject: Re: [ArctosDB/arctos] MSB Mamm Legacy Arctos Reporter labels to do (Issue #7240)
[EXTERNAL]
sorry for the slow response-- been battling a virus here but I wanted to say the formatting of the labels are done but we need to incoporate the identifiers now (MSB's NKs etc) which will require your testing help!
Let me see if I can review the sql and have you all test with your data instead of NK-less records
On Tue, Mar 12, 2024 at 3:26 PM Honghyejeong @.***> wrote:
Hello everyone,
My name is Hyejeong Hong and I am in charge of producing large vial labels. I have almost completed the HTML/CSS code, and I will send you the code file and the results when I run the code. Please check it out and let me know if there are any more changes that need to be made!
Thank you, Hyejeong Hong
On Tue, Mar 12, 2024 at 3:18 PM Jonathan Dunnum @.***> wrote:
Hi All, Any update here? We really need these, can't print any labels at all at this point, and hundreds of specimens backing up. Thanks, Jon
— Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/7240#issuecomment-1992675229,
or unsubscribe < https://github.com/notifications/unsubscribe-auth/A3J6WU2GOM7IE3YPMYBVSZTYX55K3AVCNFSM6AAAAABBXESSQ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSOJSGY3TKMRSHE>
. You are receiving this because you were mentioned.Message ID: @.***>
— Reply to this email directly, view it on GitHub https://github.com/ArctosDB/arctos/issues/7240#issuecomment-1992682437, or unsubscribe https://github.com/notifications/unsubscribe-auth/AATH7UNNSHQBY4OGZV7MPT3YX56HTAVCNFSM6AAAAABBXESSQ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSOJSGY4DENBTG4 . You are receiving this because you were assigned.Message ID: @.***>
— Reply to this email directly, view it on GitHubhttps://github.com/ArctosDB/arctos/issues/7240#issuecomment-1993268996, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AED2PA3LUGUUYCGAJERAD5TYX67GTAVCNFSM6AAAAABBXESSQ6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSOJTGI3DQOJZGY. You are receiving this because you were mentioned.Message ID: @.***>
Sorry this thread is getting so long.... @dustymc can you help with the sql line to get collecting_source ="captive"
From Adrienne's notes: if collecting_source ="captive" display if not then null
@AdrienneRaniszewski I dont understand one of the notes on the labels:
what do you mean "just say tissues etc"? what specific parts should just say "tissues"? likewise with the other values? Now you can try out the small and large vial labels as the sizing and formats were a little off, now fixed, but I need to test with MSB Mamm data! some progress....
if collecting_source ="captive" display if not then null
case flat.collecting_source when 'captive' then 'captive' else null end collecting_source
Hi, I've worked on the MSB:Mamm fluid_skin_tag and made some progress. There are still some things need to be fixed, including the measurements.
Hi, I've worked on the MSB:Mamm small vial label and made some progress. There are still things to make more progresses, but I want this to be tested before making more progresses.
Hello, I have worked on the MSD: Mamm large vial label and made some progress. There are still things to make more progress! IN progress MSB Mamm large vial label (1).csv
We will have a look, thanks!
thank you everyone! I get errors when I try to produce the large and small vial labels. So I can't comment on how they're coming along.
The fluid tag is looking a little better. lots of spacing issues still though. And it needs to produce a page that's 4x11. The maximum number of tags on a page should be 20. Attached is a screenshot of what they look like now when I attempt to print on our Datamax printer with the 4-inch wide media. Also attached a pdf of what we used to get and need to get again.
Thanks for working on this, everyone!
I’d like to get our labels finished up finally.
I started over with MSB:Bird labels and made several formatting adjustments. As well as a few (probably pretty clunky) adjustments to the info displayed. Parts and collector/preparator numbers, for example. There are still a few things that I have been unable to figure out and would love help with.
The MSB:Mamm numbers I’ve been using to test are: 100730, 120130, 120131, 142755, 145080, 160001, 160002, 212709, 300000, 321321, 325800, 325801, 330818, 336752, 341014, 346117, 348700, 348701, 349001, 349002, 123456, 234456, 300001, 123123, 23456, 216789, 50001
The report names are “MSB Mamm Small Label” and “MSB Mamm Large Label”
Thank you!!
started over with MSB:Bird labels
Does this mean that all of my work in https://github.com/ArctosDB/arctos/issues/8079 is gone?? @mkoo this doesn't seem particularly efficient....
Sex symbol
That's thoroughly addressed in the linked issue.
more than one
I'd need an example to address this.
institutional catalog numbers
That's going to be very difficult as long as the data are being entered arbitrarily https://github.com/ArctosDB/arctos/issues/7836
Mexican wolf studbook
That's in a particularly inaccessible form and my efforts to make the data accessible have not been fruitful.
UNLV
That's currently consistent, so easy.
https://github.com/ArctosDB/arctos/issues/7722
https://arctos.database.museum/guid/MVZ:Herp:275710
select formatIdentifierAndIssuedBy(collection_object_id,'https://arctos.database.museum/agent/21311462') from flat where guid='MVZ:Herp:275710';
-----------------------------
UNLV 7423
The second parameter will accept anything that can be turned into one agent, the identifier is the only guaranteed path but this particular example would work with eg...
arctosprod@arctos>> select formatIdentifierAndIssuedBy(collection_object_id,'UNLV') as UNLV from flat where guid='MVZ:Herp:275710';
unlv
-----------
UNLV 7423
No, your work is not gone. On the contrary! I just used the ones you made for Andy as a starting point for ours, since the one's that Michelle's students had been working on for us got stuck.
So the bold sex symbol is still being sorted out? We can definitely live with it this way for now.
see MSB 300001 for more than one sex printing
Those institutional catalog numbers were entered consistently, initially. They have recently become a little inconsistent from each other though. We do NEED them on our label, as that is the number we use to match the label to the specimen, which often only has the original catalog number on it. So whatever it takes would be most appreciated. Thanks!
MSB 300001
arctosprod@arctos>> select sex,split_part(sex,';',1) firstsex from flat where guid in ('MSB:Mamm:300001','MSB:Mamm:300002');
sex | firstsex
------------+------------
male; male | male
male | male
(2 rows)
whatever it takes
Consistent data. That will probably remain a struggle as long as https://github.com/ArctosDB/arctos/issues/7836 is an issue, but I can also (more or less, https://github.com/ArctosDB/arctos/issues/8129 ain't helping) expand the 'agent issues type of format...' rules if they can be laid out to avoid the complications and the data can be cleaned up to fit within them. (I was going to say UNLV looks easy, but there are integers, lots of 12822A
-type things, and MBM 6415
for some reason - I can still prevent mistyped data, but actually-their-stuff would probably involve some kind of cleanup. And I think the agent is probably grossly overloaded, which might turn out to make the cleanup easier.)
These are the report templates MSB Division of Mammals uses regularly and the ones we need saved. None of us here know html, so we need someone to rebuild these for us. They are listed here in order of priority. Thank you!
MSB_Mamm_fluid_skin_tag MSB_Mamm_small_label MSB_Mamm_large_label MSB_Mamm_skin_tags MSB_Mamm_skin_tags_special MSB_Mamm_small_label_special MSB_Mamm_fluid_skin_tag_special