Penn State University Libraries - Connexion to Symphony WorkFlows Conversion

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

The Connexion to Symphony WorkFlows AutoIt script is used for copying data from a Connexion Client bibliographic record and pasting it into a corresponding record in the SirsiDynix Symphony 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 Symphony 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 Symphony WorkFlows bibliographic record.
• It converts all OCLC subfield delimiters (?) into pipe characters and removes spaces around the subfield delimiters that are not used in Symphony Workflows.
• It saves the converted data into the clipboard making it readily available for pasting into a Symphony WorkFlows bibliographic record.

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 CnxToSym.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 CnxToSym.exe and has a purple and green "CS" 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 Symphony 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 "CS" icon to a more visible part of the Quick Launch section with your mouse.

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 "CS" shortcut in the Quick Launch section of your Windows toolbar. The "CS" 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 Symphony WorkFlows client. Position your cursor where you want the data to go. Paste it in by pressing Ctrl+V.

• The following characters cannot be converted. The script will display an error message. You will have to manually edit these using the WorkFlows symbol table.
  
• Cannot convert N with grave (Unicode 78+768)
• Cannot convert n with grave (Unicode 110+768)
• Cannot convert y with macron (Unicode 121+772)
• Cannot convert A with superior dot (Unicode 65+775)
• Cannot convert a with superior dot (Unicode 97+775)
  
• Cannot convert O with superior dot (Unicode 79+775)
• Cannot convert o with superior dot (Unicode 111+775)
• Cannot convert e with cedilla (Unicode 101+807)
• Cannot convert S with left hook (Unicode 83+806)
• Cannot convert s with left hook (Unicode 115+806)
  
• Cannot convert T with left hook (Unicode 84+806)
• Cannot convert t with left hook (Unicode 116+806)
• Cannot convert e with cedilla and acute (Unicode 101+807+769)
• Cannot convert e with cedilla and grave (Unicode 101+807+768)
  
• There are 11 characters that are modified by the high comma off-center diacritic (Unicode 789). Symphony displays these as a high comma centered (Unicode 787). No attempt is made to convert these with this script.
• H and h with upadhmaniya (or breve below; or half circle below) is mistakenly displaying an additional diacritic (Unicode 774: breve). No attempt is made to convert these with this script.
• No attempt is made to convert the following four characters used in Marathi (and one in Vietnamese) because they don't exist in Symphony'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)

• This script will not work accurately in Unicorn Java WorkFlows. Please see: Connexion to Java WorkFlows Conversion.
• This script will not work with non-Latin scripts. Besides, our current version of Symphony WorkFlows doesn't 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.

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.