arctos
arctos copied to clipboard
ArctosDB
MSB Mamm Legacy Arctos Reporter labels to do
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
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.
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:
- MSB_Mamm_fluid_skin_tag
- MSB_Mamm_small_label
- MSB_Mamm_large_label
- MSB_Mamm_skin_tags
- still needs dimensions and content requirements for all but will work in this order.
- MSB_Mamm_fluid_skin_tag has this draft now, which needs CSS work for DMNS too. just in time for students returning from break!
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:
-
MSB_Mamm_fluid_skin_tag - working on report (https://arctos.database.museum/Reports/reporter.cfm?action=edit&report_id=147) -
MSB_Mamm_skin_tags - similar dimensions and format as above but print page is 8x11 -
MSB_Mamm_small_label - use Narrow box label as format basis -
MSB_Mamm_large_label - same as above but different size
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 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.
IN progress MSB_Mamm fluid_skin_tag (1).csv
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.
IN progress MSB Mamm small vial label-4.csv