How to Export & Import Catalogue

How to Export & Import Catalogue

Notes
Catalogue Export


  1. Go to the Ksatria eHospital system.
  2. Click on the Catalogue menu.
  3. Click the More button and select Export Catalogue.
  4. The exported data will be downloaded as an Excel file and opened automatically.
  5. You may modify or update the Excel file. This file can later be used for bulk update or modification via the Import Catalogue feature.
  6. The Catalogue Export process is complete.

Notes
Catalogue Import


  1. Go to the Ksatria eHospital system.
  2. Click on the Catalogue menu.
  3. Click the More button and select Import Catalogue.
  4. To download the blank template, click the "Download Template" link.

  5. The blank Excel template will be downloaded automatically and opened with the required column structure.
  6. Fill in the Excel template with the required catalogue data to add or update.
  7. Once completed, click the More button again and select Import.
  8. Click Select File and choose the prepared Excel file.

  9. After selecting the file, a confirmation message will appear. Click Yes to proceed or No to cancel.

Alert
Import Validation Rules


  • Invalid File Format
    If the uploaded file has an incorrect format or column structure, the system will display a warning.
    The import process will not proceed.
  • Invalid Data
    The system checks the file row by row. If any data is invalid, import will fail for that row.
    The system will display a warning and provide an option to download an error report.
  • Error Report
    Click the Download Data Error button to download an Excel file containing problem data.
    An ERROR column will indicate which values need correction.
  • Successful Import
    If the file contains valid data, the import process will complete and the system will confirm success.
    Uploaded catalogue data will appear in the Catalogue table.

The Catalogue Import process is complete.

Info
Tips

  • Always use the latest system-generated template when importing to prevent column mismatch.
  • Double-check mandatory fields before uploading.
  • Keep a backup copy of your template before making changes.

    • Related Articles

    • How to Export and Import Patient Profile

      This article provides step-by-step instructions on how to export and import patient profile data in the Ksatria eHospital system. Export Patient Profile To export patient data into a CSV file: Log in to the Ksatria eHospital system. Click on the ...

    • Changelog Ksatria eHospital v2509021 (02-09-2025)

      Changelog Ksatria eHospital v2509021 (02-09-2025) Bug Fixes and Improvements: > Fixed issue related with UOM in Catalogue and Inventory Adjustment for Import and Export function > Fixed issue related with behavior and display changes in the Inventory ...

    • Navigasi Dasar di Tampilan Grid Ksatria eHospital (Fungsi Filter, Ekspor, dan Impor)

      Pada beberapa modul di Ksatria eHospital, seperti daftar pasien pada layanan tertentu (misalnya Umum atau Anak), Anda mungkin tidak langsung melihat data pasien yang baru saja didaftarkan. Hal ini terjadi karena sistem menggunakan filter bawaan ...

    • Catalogue Item Approval Process

      1. Approval via Edit Catalogue Page Perform steps 1–7 from the Create Catalogue process. Click the Edit command on the catalogue line that is currently under approval. Update the Approval Status and complete the approval remarks or related ...

    • How to Search and Edit Catalogue

      1. Search Catalogue Login to the Ksatria eHospital system. Go to the Catalogue module. Search for the catalogue item: Enter a keyword in the Search field. The system will automatically display matching results. For advanced filtering, click Filter to ...