Differences between revisions 5 and 6
Deletions are marked like this. Additions are marked like this.
Line 25: Line 25:
    * [[http://rath.ca/Misc/Perl_CSV|rath.ca/Misc/Perl_CSV]]
    * [[http://rath.ca/Misc/Perl_CSV/CSV-2.0.html|rath.ca/Misc/Perl_CSV/CSV-2.0.html]]
    * [[http://rath.ca/Misc/Perl_CSV|rath.ca/Misc/Perl_CSV]] - Description and instructions
    * [[http://rath.ca/Misc/Perl_CSV/CSV-2.0.html|rath.ca/Misc/Perl_CSV/CSV-2.0.html]] - Perl documentation for the module
    * [[http://rath.ca/Misc/Perl_CSV/CSV-2.0.tar.gz|rath.ca/Misc/Perl_CSV/CSV-2.0.tar.gz]] - Source file

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

MigrationTools (last edited 2009-12-01 10:57:28 by softxs)

Copyright 2008-2014, SoftXS GmbH, Switzerland