Function documentationImport Drugs into Internal Drug Catalog

 

You can import drugs and basic drug information (for example classification systems and codes, dosage forms, agents) from an external catalog into the i.s.h.med Medication component.

Integration

Using the import tool you can import the content of an external catalog of drug information in its entirety or update already imported content from an external catalog.

Prerequisites

The data in the external catalog must exist in the XML structure predefined by the i.s.h.med Medication module, in order for the system to be able to process it. You can find the format structure on the i.s.h.med service site under Start of the navigation path http://service.ishmed.de/homepage/siemensInformation published on non-SAP site Next navigation step Software & Program Components Next navigation step Medication End of the navigation path. Note that access to the download area is protected by password. You can find information on how to request a user and password on the i.s.h.med service site.

Note Note

Units used for drugs in the import file must first be manually created as units of measure in Customizing under Start of the navigation path SAP NetWeaver Next navigation step General Settings Next navigation step Check Units of Measure End of the navigation path. Units which are missing in the system prevent the import of external data which require these units.

End of the note.

In order to be able to upload import packages you must be assigned the corresponding authorizations in the following authorization objects:

  • N_1FORMUPL

  • N_1FORMIMP

  • N_1AGENT (for importing agents into the system)

  • N_1FORMU

    To be able to import drug information into the system you must have authorization for the Add or Create, Change and Deactivate activities.

    To be able to automatically activate drugs during the import process, you must have the authorization for the Activate activity.

Features

You can import the following content from external catalogs with drug information into the Medication module:

  • Drug information

  • External catalogs (catalog names)

  • Agents

  • Administration routes

  • Administration devices

  • Medical localizations

  • Dosage forms

  • General drug parameters

  • Price types

  • Classification systems and codes

Activities

Upload Import File as Import Package

You use the transaction N1ME_UPLOAD to first load the external catalog information into a multi-client import package pool.

You can upload files with drug information in ZIP format.

Note Note

You should note that an unpacked ZIP file may not be larger than 2 GB. The maximum size of the unpacked ZIP file that can be processed is reduced in relation to the main memory available.

End of the note.

You can load the external catalog data from the local GUI or the application server into the system. The file to be loaded into the system must have the XML file extension. The ZIP file can be divided into several XML files, whereby the first file part should have the extension XML. If the ZIP file does not contain a file with this extension, the system sorts all files by ascending order of file name and processes these files sequentially. Moreover, you can pack a split XML file in individual ZIP files. All subsequent file names must end with a sequential 3-digit number starting with 001.

Note Note

Note that it is not possible to upload a ZIP file split among several individual files.

End of the note.

Note Note

Two XML formats are available for the master data import. You can find the format definition on the i.s.h.med service site under Start of the navigation path http://service.ishmed.de/homepage/siemensInformation published on non-SAP site Next navigation step Software & Program Components Next navigation step Medication End of the navigation path. Note that access to the download area is protected by password. You can find information on how to request a user and password on the i.s.h.med service site.

End of the note.

The import file may be UTF8 or UTF16-coded and must contain the corresponding information as the byte order mark (BOM) at the beginning of the import file. UTF32 coding is not supported. For non-unicode coding you can specify the coding information in the "encoding" attribute at the beginning of the file.

If you maintain a code page in system parameter N1MEIPCP, coding information in the import file is ignored and the system uses the code page of the system parameter to load the import file.

See System Parameters for Medication

Importing Import Package Contents

Before you import drug data you must assign the external units of measure of the import file and the internal units of measure to each other. The following new IMG activities are available for this in Customizing under Start of the navigation path Industry-Specific Component Clinical System Next navigation step Medication Next navigation step Drug Catalog End of the navigation path:

  • Assign External Units of Measurement to Internal Units

  • Assign External Currency Units to Internal Units

You can use transaction N1ME_IMPORT to transfer the import packages available in the system into individual clients.

Once you have selected the import package you can select, in the Selection of Sections to Be Imported group box, individual or all contents in the package for import. If sections have already been imported into the same client, the system will display the date and time of the last import behind the corresponding checkbox.

You can control the import of drug information using the following additional entries:

  • In the Target Formulary list field you must select a catalog into which the system should import the drug data. If there has already been an import into this catalog, the system will display the import date and import time.

  • You can use the Save Hierarchy checkbox to control whether the hierarchical assignment contained within the import package should be applied by the system.

    Note Note

    If you also select the Change Hierarchy checkbox, the system will correct any existing hierarchical drug assignments in the target formulary according to the import package information. If you do not select this checkbox, existing hierarchical drug assignments will remain unchanged, even if another assignment exists in the import package.

    End of the note.

  • You can use the Activate Drug checkbox to determine that imported drugs should automatically be activated during the import. You must enter a valid activation date in the Activation Date field.

    Caution Caution

    If the drugs to be imported contain errors or the Manual Check Necessary is set, these will not be automatically activated during the import. You must manually activate these drugs later.

    End of the caution.

  • For drugs which are flagged for deletion in the import package, you must enter a deactivation reason and a valid deactivation date.

    Note Note

    The system will delete drugs which have not been used in the system for orders or order templates and are flagged for deletion in the import package, during the import.

    If a drug has already been used and is flagged for deletion in the import package, it will only be deactivated during the import. If automatic deactivation is not possible, the system will add a drug message to the drug which informs the user of the necessary deactivation, and sets the Manual Check Necessary indicator.

    End of the note.

  • In the Import Message Texts group frame you can select which message texts for drugs should be transferred from the import package into the system.

  • In the Conflict Resolution Behavior group box you can control how the system behaves if changes cannot be made to a drug. You can select from the following options:

    • If you do not select the Create Copy checkbox, the system will display a corresponding error message in the import results lists if changes cannot be made, and will not apply the changes to be made.

    • If you select the Create Copycheckbox, but do not select the Replace Originalcheckbox, the system will copy the original drug and makes the changes required due to the import package to the copy of the original drug. The original drug remains active. However, the system will add a drug message to the original drug which informs of the need for deactivation and the new drug to be used, and sets the Manual Check Necessary indicator.

    • If you select the Create Copy checkbox and also select the Replace Original checkbox you must enter a deactivation reason in the Deactivation Reason for Original list field.

      The system will copy the original drug and make the changes required by the import package to this copy.

      The system deactivates the original drug and adds a drug message informing users of the necessary deactivation and the new drug to be used. The system will also set the Manual Check Necessary indicator in the original drug. The copy of the original drug is activated.

      Caution Caution

      If it is not possible to activate the copy or deactivate the original drug the original drug will remain activated and is not replaced by the copy.

      End of the caution.