Duplicate label reports using texxmlreplicate
Sponsored Links
This presentation is the property of its rightful owner.
1 / 18

Duplicate Label Reports using Texxmlreplicate PowerPoint PPT Presentation


  • 49 Views
  • Uploaded on
  • Presentation posted in: General

Duplicate Label Reports using Texxmlreplicate. Beth L. Gamble Senior Systems Analyst Smithsonian – NMNH [email protected] NA EMu Users Group MeetingOctober 22, 2008. The Problem. Multiple labels based on a numeric field in the record itself.

Download Presentation

Duplicate Label Reports using Texxmlreplicate

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Duplicate Label Reports using Texxmlreplicate

Beth L. Gamble

Senior Systems Analyst

Smithsonian – NMNH

[email protected]

NA EMu Users Group MeetingOctober 22, 2008


The Problem

  • Multiple labels based on a numeric field in the record itself.

  • Crystal had some solutions but there were maximum number of repeats allowed and it was VERY complicated.

  • Looked at the problem from the data perspective.


The Problem

  • The solution in the data was very simple. Duplicate the row of data as many times as you need duplicates.

  • Doing this manually for every report was out of the question.

  • We called in the superheroes. Ohhhhhh KE please help!


The Solution

  • KE wrote a script called Texxmlreplicate which located the field to be used for the number of repeats and would create the repeats in the XML prior to it being converted to CSV and sent to the user’s machine.

  • KE of course wrote this in such a way that it could be easily customized for different report needs and is available with a texpress upgrade to all customers.


[email protected][25] pwd

/emu/texpress/texapi/bin

[email protected][26] ls

CVS/ texxmlctl*

standaloneimport* texxmlexport*

texcsvexport* texxmlodbc*

texhtmlctl* texxmlreplicate*

texhtmlserver* texxmlreplicate.old*

texps* texxmlserver*

texqlclient* texxmlslidewrapper*

texxmladjust* texxmlslidewrapper.old2*

texxmlbotlabelwrapper* xmlwf*

[email protected][27] more texxmlbotlabelwrapper

#!/bin/sh

texxmlreplicate -TOtherCounts -cCatOtherCountsValue –tCatOtherCounts

Type="Duplicates Collected" <$1 >texxmlwrappertemp

texxmlodbc texxmlwrappertemp

rm texxmlwrappertemp

[email protected][28]

Green is what KE provides.Red is what customer has to create.

Must notify KE about any wrapper scripts you create so they can check them into the source repository for future upgrades to your version of EMu.


Catalog module Tab view of Other Counts Kind and Value used to determine duplication.


Create a System Registry entry giving a name to your wrapper script.


Create a System Registry setting for the default file extension. This report is still a Crystal Report so .rpt is used.


Create a System Registry entry telling EMu what format the final output should be in.

This is an ODBC / CSV type of report just like other Crystal Reports.


Tell EMu what to do when this report is invoked.

Again this is still just a Crystal report so you have to run the Crystal viewer with the report name parameter.


Finally you have to give this report type a name that will appear to the users in the Report Type box.


How a user selects this new type of Report. Notice this is the name you gave it in the Registry.


When selecting the fields for the report. Put the fields that will be used by the wrapper script to determine the duplication in their own group. This makes like much simpler, TRUST ME!

Also, rename the group to something meaningful. GroupX is not recommended.


Within Crystal this is how the duplicated table is linked in the main report.

By having the OtherCou_csv linked in the main report you get the necessary duplication.

This is the Group you created in EMu with name slightly truncated. In this case the name was OtherCounts.


Within Crystal this is how the report is limited to only “Duplicates Collected”Other Counts for the Catalog Record.

This is done via the Select Expert.


THE FINAL REPORT


KE comes through again!

  • Ask and you shall receive!

  • The steps associated with writing the wrapper script and defining the registry setting is done by your system administrator or KE.

  • The use of the report type and setting up the report in EMu can be done by the users.

  • Creating the report definition could be done by users or your institution’s Crystal Reports goto person.


Thanks 

  • May seem like many steps but it really is rather straight forward once you do it a time or two.

  • I am happy to help get you started so email me if any of this isn’t Crystal clear.

  • Beth L. Gamble – [email protected]


  • Login