Add my box labels .cfr back to list of legacy reports?

[jebrad]

Hello - can someone please replace my box label report back into this list? I did a search for some records, then selected Arctos Reporter, and at the bottom I followed this, as usual, because my labels are not in the new Reporter yet: "Click this to continue to the legacy reporter: http://reports.arctos.database.museum/reporter/report_printer.cfm?auth_key=9F7BD11A-2935-40C0-A1F04E5CC3EF1ADE&table_name=api%5Fjebrad%5F20230303010313906%5F199 "

Then I tried to print via the legacy Report Builder, but my report wasn't on the list. It was there the last time I tried but that was a few weeks ago. So because I found no report, I followed "Manage Reports", and in the table my report was listed but it shows Last Access as "-(- days)" so it looks like it was somehow deleted?

I tried to create a new one today by Create Handler but I have no idea what to do, but it may look like I deleted it today. I didn't!

Can someone put this .cfr file back in that list? uwbm_mammal_box.cfr.zip I realize it's down for maintenance until tonight but this is not urgent for today. Thanks.

[mkoo]

Yes, will do once back from maintenance mode

FYI, we grabbed a snapshot of all legacy reporter files here: https://github.com/ArctosDB/arctos-assets/tree/master/templates2020-09-11

UWBM mamm is not on the list which makes me think it's been missing awhile but I will add to this archive as well for future reference and access.

[jebrad]

Thanks. We made that label and added it UWBM_mammal_box in September 2021, which was after that snapshot and might explain why it disappeared. I started to ask about modifying this label and also finding a double-sided skin tag to copy, and I didn't take it anywhere after Dusty said that the label making was probably moving to something like mailmerge ("all labels need to be brought into the new system in some way"). https://github.com/ArctosDB/arctos/issues/5272#issue-1442966743 I decided to stop working on our .cfr file labels and give someone else a chance to make something in the new system that I can copy. My current need to get this .cfr back on the list of reports is to to print some draft labels so people can number some skeletons - so thanks for enabling that. - Jeff

[mkoo]

Hi Jeff, I added it back to the list. I think you did as well, however they were missing the handler so I added one in that was enabled for the UW herp labels. I'm not sure if that will work for your mammal labels as I didnt try it.

So let us know if it's functional for you. We should get your label converted to the new system. So let us know when you're ready for that with a new issue

[jebrad]

I see my .cfr back on the list once I follow "Manage Reports" - and I can download the report (and edit or clone handler), but I cannot find a way to print it. I used to print via the pull-down on Arctos Report Printer, and it's not in that pull-down.

[jebrad]

Whoops, sorry @mkoo - I now see the new reports you added back to the list (I didn't think to look under N for new!). But- they are not functioning. I select Print Report and get this (will paste error message below).

Do you think it's time for me to stop spending time on this .cfr and just file an issue to convert this label to the new system? I thought it would be a simpler ask to be able to print a handful of my old labels, but that's less important now.

Thanks for any advice!

Invalid ColdFusion expression in report.

If the expression is a string, ensure that it is within quotes. Error: LOCALITY is not a valid ColdFusion expression.   The error occurred in /usr/local/httpd/htdocs/internal/reporter/report_printer.cfm: line 173 Called from /usr/local/httpd/htdocs/internal/reporter/report_printer.cfm: line 2 Called from /usr/local/httpd/htdocs/internal/reporter/report_printer.cfm: line 1 171 : 172 : <cfreport format="#e.report_format#" 173 : template="#application.webDirectory#/reporter/templates/#e.report_template#" 174 : query="d" 175 : overwrite="true">   Resources: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser   Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/110.0 Remote Address   205.175.118.108 Referrer   http://reports.arctos.database.museum/reporter/report_printer.cfm?auth_key=B3E5CB88-F46C-4A43-8BDAEE5D4209F503&table_name=api%5Fjebrad%5F20230316040342144%5F865 Date/Time   16-Mar-23 05:00 PM | Browser | Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/110.0 | Remote Address | 205.175.118.108 | Referrer | http://reports.arctos.database.museum/reporter/report_printer.cfm?auth_key=B3E5CB88-F46C-4A43-8BDAEE5D4209F503&table_name=api%5Fjebrad%5F20230316040342144%5F865 | Date/Time | 16-Mar-23 05:00 PM Browser | Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/110.0 Remote Address | 205.175.118.108 Referrer | http://reports.arctos.database.museum/reporter/report_printer.cfm?auth_key=B3E5CB88-F46C-4A43-8BDAEE5D4209F503&table_name=api%5Fjebrad%5F20230316040342144%5F865 Date/Time | 16-Mar-23 05:00 PM

Invalid ColdFusion expression in report. If the expression is a string, ensure that it is within quotes. Error: LOCALITY is not a valid ColdFusion expression.

The error occurred in /usr/local/httpd/htdocs/internal/reporter/report_printer.cfm: line 173 Called from /usr/local/httpd/htdocs/internal/reporter/report_printer.cfm: line 2 Called from /usr/local/httpd/htdocs/internal/reporter/report_printer.cfm: line 1

171 : 172 : <cfreport format="#e.report_format#" 173 : template="#application.webDirectory#/reporter/templates/#e.report_template#" 174 : query="d" 175 : overwrite="true">

Resources:

Check the [ColdFusion documentation](http://www.adobe.com/go/prod_doc) to verify that you are using the correct syntax.
Search the [Knowledge Base](http://www.adobe.com/go/prod_support/) to find a solution to your problem.

Browser Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/110.0 Remote Address 205.175.118.108 Referrer http://reports.arctos.database.museum/reporter/report_printer.cfm?auth_key=B3E5CB88-F46C-4A43-8BDAEE5D4209F503&table_name=api%5Fjebrad%5F20230316040342144%5F865 Date/Time 16-Mar-23 05:00 PM Stack Trace at cfreport_printer2ecfm193737824._factor6(/usr/local/httpd/htdocs/internal/reporter/report_printer.cfm:173) at cfreport_printer2ecfm193737824._factor7(/usr/local/httpd/htdocs/internal/reporter/report_printer.cfm:2) at cfreport_printer2ecfm193737824.runPage(/usr/local/httpd/htdocs/internal/reporter/report_printer.cfm:1)

coldfusion.runtime.report.CFExprEvaluator$ReportInvalidCFExpressionException: Invalid ColdFusion expression in report. at coldfusion.runtime.report.CFExprEvaluator.doCfEval(CFExprEvaluator.java:227) at coldfusion.runtime.report.CFExprEvaluator.evaluate(CFExprEvaluator.java:351) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:172) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:614) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:582) at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:805) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:369) at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:356) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:274) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:411) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1311) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:649) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:209) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:109) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:786) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:713) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at coldfusion.runtime.report.Report$4.run(Report.java:1434) at java.security.AccessController.doPrivileged(Native Method) at coldfusion.runtime.report.Report.fillReport(Report.java:1430) at coldfusion.runtime.report.Report.runReport(Report.java:447) at coldfusion.tagext.lang.ReportTag.doEndTag(ReportTag.java:626) at cfreport_printer2ecfm193737824._factor6(/usr/local/httpd/htdocs/internal/reporter/report_printer.cfm:173) at cfreport_printer2ecfm193737824._factor7(/usr/local/httpd/htdocs/internal/reporter/report_printer.cfm:2) at cfreport_printer2ecfm193737824.runPage(/usr/local/httpd/htdocs/internal/reporter/report_printer.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:64) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:422) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:204) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:722)

[Jegelewicz]

@jebrad is this resolved now that you have the mail merge box label? If so, please close this. If not, let me know what else you need.

[jebrad]

Yep pleasure to close this. Thank you!