Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Configuration of OpenLMIS to be SELV initially has two steps.  From a blank slate (clean DB in current OpenLMIS schema):

  1. Load the database seed files.
    1. For convenience there is a director type loading file named seed.sql.  This file is generated by running the python script generateSeed.py within the directory.
    2. Order of the loading is important and is determined by the sequence the files "appear" in.  The naming convention 01_, 02_, 03_, etc... accomplishes this.
    3. Loading into the database can then be done by running: 

      psql open_lmis -f seed.sql

  2. Upload the reference files.
    1. Order of the loading is important and is determined by the sequence the files "appear" in.  The naming convention 01_, 02_, 03_, etc...  accomplishes this.
    2. The name of the file suggests which option in the select box on the upload screen (upload type) to select.

 

Problem with Editing CSV in Excel:

I've had problems with editing CSV's in Excel:

  1. Excel does not handle unicode characters in CSV format and will not adequatly warn you about this.  This will result in corruption of the CSVs and render them unable to be used.
  2. Excel on OS X handles line ending's poorly.  It will place a carriage return at the end of the lines instead of the windows convention of a carriage return followed by a new line or the unix/linux/osx convention of a single newline character.  This will render the CSVs unable to be used.

Do not use Excel to edit CSV files!!!  Instead use Calc that comes as a part of the LibreOffice suite of office tools.

  • No labels