DrawMGT Data Migration and Configuration Tools

Message Catalog Merging

Use the tool: lib/etc/mergeMessageCatalog.pl

This replaces all messages in a specific language in a message catalog file.

Example: In this case the Message-ABT.txt file is a new file with new French messages in it.

•  cd app/config 
   ../../lib/etc/mergeMessageCatalog.pl -c Messages.txt -l fr_FR Message-ABT.txt > Messages-New.txt
   diff Messages.txt Messages-New.txt

CSV File Parsing

1. CSV and tab-separated files created by Excel can have carriage returns in individual cells.
2. There is a perl module: CSV, which is able to parse this.

   • rath.ca/Misc/Perl_CSV

   • rath.ca/Misc/Perl_CSV/CSV-2.0.html

3. Installation of the module: As root on a Unix/Linux system:

   •      cd /tmp
          tar xvf CSV-2.tar
          perl Makefile.PL
          make
          make test
          make install

4. Test to make sure it works: The following could should not output any error messages:

   •      perl -e 'use CSV;'

To Do

Module location and installation instruction Notes for updating upload file