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

Duplicate Label Reports using Texxmlreplicate PowerPoint PPT Presentation


  • 42 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

Duplicate Label Reports using Texxmlreplicate

Beth L. Gamble

Senior Systems Analyst

Smithsonian – NMNH

[email protected]

NA EMu Users Group MeetingOctober 22, 2008


The problem

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 problem1

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

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.


Duplicate label reports using texxmlreplicate

[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.


Duplicate label reports using texxmlreplicate

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


Duplicate label reports using texxmlreplicate

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


Duplicate label reports using texxmlreplicate

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


Duplicate label reports using texxmlreplicate

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.


Duplicate label reports using texxmlreplicate

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.


Duplicate label reports using texxmlreplicate

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


Duplicate label reports using texxmlreplicate

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


Duplicate label reports using texxmlreplicate

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.


Duplicate label reports using texxmlreplicate

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.


Duplicate label reports using texxmlreplicate

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.


Duplicate label reports using texxmlreplicate

THE FINAL REPORT


Ke comes through again

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

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