Table of Contents

Overview

When importing data into the system for an existing data record, you have a choice to append or replace data.

Open

Key Concepts

Append to batch data: Adds all data from your import file to any existing records. Use this type for adding new attribute and parameter records or for adding supplemental measurements to existing records. All the measurement data in your input file should not have been previously uploaded into the batch.

Replace batch data: Overwrites the prior data in the batch and replaces it with the new data in the import file. No prior values are maintained in the current draft. This includes BOTH release and unit operation data.

Illustrative Scenarios

Starting Condition

For each of the scenarios below, assume that you’re starting with a batch record that contains the following records.

• FQA - Solution Volume in Container - 1 Measurement

• PP - Pump Speed - 10 measurements

• PP - Flow Rate - 10 measurements

• PP - Filteration Time - 1 measurement

Scenario #1: You have 5 additional pump speed and flow rate measurements and want to add them.

Import Type: Append to batch
Import File: pump speed and flow rate, each with five new measures.
Resulting Batch Record:

• FQA - Solution Volume in Container - 1 Measurement

• PP - Pump Speed - 15 measurements

• PP - Flow Rate - 15 measurements

• PP - Filteration Time - 1 measurement

Scenario #2: You want to update the value for filtration time.

Import Type: Replace batch data
Import File: original values for pump speed and flow rate and your new value for filtration time
Resulting Batch Record:

• PP - Pump Speed - 10 measurements

• PP - Flow Rate - 10 measurements

• PP - Filteration Time - 1 measurement

Note that FQA - Solution Volume in Container was removed. It must be re-uploaded.

Scenario #3: You want to add a measurement for Bioburden.

Import Type: Append to batch
Import File: A single measurement for bioburden
Resulting Batch:

• FQA - Solution Volume in Container - 1 Measurement

• PP - Pump Speed - 10 measurements

• PP - Flow Rate - 10 measurements

• PP - Filteration Time - 1 measurement

• PP - Bioburden - 1 measurement