Skip to main content

Section 14. Annex 5: PipeLine Program Import

In certain cases, users will be granted a special set of credentials that can import PipeLine databases if they desire to set up their program this way (see Setting up a new program in Annex 1).

14.A. Step 1: Convert the .accdb file into a JSON file:​

14.A.1. About the PipeLine Access DB to JSON conversion tool:​

Since the QAT system is only able to import program data in JSON format and PipeLine databases are in .accdb format, QAT has a downloadable tool for converting the .accdb file into a JSON file, thus allowing importation into QAT. Once installed, this tool does not require internet access to run. Also, this tool allows the user to choose their preferred language.

  1. Confirm that you have the appropriate System Configuration Requirements:

    • Operating System: Windows / Linux / Ubuntu
    • Other Software: Java JDK 1.8 and above.

  2. Confirm that your PipeLine data is fully updated:

    • The database cannot have negative inventory values.
    • All the shipment, stock, consumption data must be updated.

  3. Go to “Program Management” and click on “PipeLine Program Import”.

  4. On the top right corner click on the “Add” button. It will lead to a file input screen.

  5. Click on the downward arrow button on the top right corner.

  6. Click the “Download PipeLine Converter” on the screen, then select your computer’s operating system (Windows or Linux). The converter will be downloaded in a zip file.

  7. Open the converter file and run the tool (.exe file / .java executable file).

14.B. Step 2: Upload the JSON file into QAT:​

  1. In QAT go to “Program Management” > “PipeLine Program Import” menu item.
  2. Click on the “Add” button, and a new screen will be opened. Browse to find the converted JSON file (from Step 1) from the local machine. Click on “Submit”.
  3. After completing the process, the user will get a message that the program is successfully imported.
  4. This program will be shown as a row in the program list. Click on that row to continue to Step 3.
    • Note: While doing the program setup the QAT user can select multiple technical areas from the technical area dropdown list.

14.C. Step 3: Configure data for import into QAT​

After importing PipeLine data, the user will navigate through a series of screens where there will be prompts to enter data. After editing data on one screen, the user should click “Next” to move to the following data entry screen. If needed, navigate to previous screens by clicking “Back”. The user should navigate through the following screens: Program Info, Planning Units, Data Source, Funding Source, Procurement Agent, Consumption, Inventory, and Shipments.

Each of these major screens have sub-screens where users need to enter data and map current PipeLine data to QAT realm-level master data; for example, the PipeLine products need to be mapped to QAT’s planning units. At the last step (Shipment screen) a pop-up will be displayed if any program contains negative inventory.

14.C.1. After the file is successfully imported to QAT:​

  1. The users can go to “Program Management”.
  2. Click on the “Programs” menu item.
  3. The program list will show the imported program.
  4. Now the user can “Download”, “Import” and “Export” that program.