Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added notes on configuration of open vials and target group

...

  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.
  3. Run database insert script postUpload.sql
    1. Configures things like: target groups and open vial mappings from "regimen" to product.
    2. See: Mingle #780 and
      Jira Legacy
      serverJIRA (openlmis.atlassian.net)
      columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
      serverId448ba138-230b-3f91-a83e-16e7db1deed1
      keySELV-100

 

Problem with Editing CSV in Excel:

...