Skip to content
Penn State University Libraries

Contact

Cataloging and Metadata Services
126 Paterno Library
University Park, PA 16802-1808

Staff Directory

Phone: (814) 865-1755
Fax: (814) 863-7293
ul-cataloging@lists.psu.edu

Ken Robinson
Cataloging and Metadata Services
126 Paterno Library
University Park, PA 16802-1808

Phone: (814) 867-0850
Fax: (814) 863-7293
Email: kjr106@psu.edu

Connexion to Java WorkFlows Conversion

Important: If you are using the SirsiDynix Symphony WorkFlows Staff Client, this script will not work with that software. Please see: Connextion to Symphony WorkFlows Conversion.

Warning: Penn State University Libraries upgraded their Java WorkFlows staff client to the Symphony WorkFlows staff client at the end of November 2008. Because of this, the Connexion to Java WorkFlows Conversion script is no longer supported.

 

Introduction

The Connexion to Java WorkFlows AutoIt script is used for copying data from a Connexion Client bibliographic record and pasting it into a corresponding record in the SirsiDynix Java WorkFlows client.

This script does the following:

  • It copies the data from whichever MARC tag you select to copy. It strips the MARC tag and indicators, only retaining the data of the field.
  • It converts all diacritics and special characters from those used in the Connexion Client to those used in the Java WorkFlows client, with some exceptions noted below.
  • When copying 1XX fields from an authority record, it adds a period to the end of the field if needed so that you don't need to after pasting it into a Java WorkFlows bibliographic record.
  • It converts all OCLC subfield delimiters (?) into pipe characters and removes spaces around the subfield delimiters that are not used in Java Workflows.
  • It saves the converted data into the clipboard making it readily available for pasting into a Java WorkFlows bibliographic record.
 

Installing the Script

Note: Macros available for download on this page are primarily for the use of the Cataloging and Metadata Services department of the University Libraries at the Pennsylvania State University. They are publicly available for users elsewhere, however please read the Copyright and Disclaimer Notice at the bottom of this page.

PSU Catalogers:

  1. Copy the CnxToJWF.exe file from the W drive AutoIt Scripts folder and save it in your My Documents folder.
  2. Open Windows Explorer, find the file you just downloaded, and drag it to the Quick Launch section of your Windows toolbar. The file should be called CnxToJWF.exe and has a purple "CJ" icon.

Other users:

Other users will need to compile the source code (see below in the Downloads section) into an .exe file using AutoIt. After doing this, follow step 2 above.

The Quick Launch section can be seen below with the newly installed Connexion to JWF script in the lower right corner. Your Quick Launch section may appear differently (one row instead of two, different selection of icons, and different order). You can drag the "CJ" icon to a more visible part of the Quick Launch section with your mouse.

The "CJ" Icon in the Quick Launch Area of the Windows Toolbar
Top
 

Running the Script

  1. While in the Connexion Client, place your cursor in the MARC field you want to copy. It can be anywhere in the field (MARC tag, indicators area, data area).
  2. Click on the Connexion to JWF shortcut in the Quick Launch section of your Windows toolbar. The "CJ" icon will briefly appear in your System Tray (where you computer's clock display is) and then disappear. Wait until it disappears before moving to the next step. If you're not paying attention, you may not even see it running.
  3. Move to your Java WorkFlows client. Position your cursor where you want the data to go. Paste it in by pressing Ctrl+V.
Top
 

Problematic Characters

  • r with circle below and macron (Unicode 114+805+772) is incorrectly handled in JWF where it displays as "r with dot below and macron" (Unicode 7773). This script makes the conversion even though the JWF display is incorrect.
  • u with tilde and macron (Unicode 117+771+772) is incorrectly handled in JWF where it displays as "u with macron and diaeresis" (Unicode 7803). This script makes the conversion even though the JWF display is incorrect.
  • No attempt is made to convert the following four characters used in Marathi (and one in Vietnamese) because they don't exist in JWF's symbol table:
    • a with tilde and macron (Unicode 97+771+772)
    • i with tilde and macron (Unicode 105+771+772)
    • e with tilde and circumflex (Unicode 101+771+770)
    • o with tilde and circumflex (Unicode 111+771+770)
Top
 

Notes

  • This script will not work accurately in Symphony WorkFlows. Please see: Connexion to Symphony WorkFlows Conversion.
  • This script will not work with non-Latin scripts. Our current version of Java WorkFlows doesn't even have this capability.
  • This script should NOT be used in any future UNICODE versions of WorkFlows or other UNICODE-compatible SirsiDynix product.
  • This script will not work with fixed-field data.
Top
 

Bug Fixes

July 9, 2008: The script has been updated to handle the alif character. In Connexion this is represented by Unicode 700, in WorkFlows by Unicode 702. Prior to July 9 the script failed to make any conversion. If you downloaded this script prior to July 9, 2008, please download it again and replace your existing file. The source code has also been updated

Top
 

Downloads

* CnxToJWF.au3
source code only
Top
 

Copyright and Disclaimer Notice

The AutoIt scripts on this site have been written by Ken Robinson and are owned and copyrighted by The Pennsylvania State University. They may be freely used and modified for non-commercial usages as long as the author statement in the source code of each script is retained. These scripts may not be reproduced for profit or distributed in part or as a whole with any product for which a charge is made.

The Pennsylvania State University and the University Libraries disclaim any warranties of any kind, express or implied, that these scripts are error-free or fit for a particular purpose. By downloading any of these scripts, users accept all risks for the implementation and use of these scripts.

Top