To import data from a table into one or more
packages
Context
When you import the data contained in a table
into a package, only the data sources defined on the application server is
accessed.
Procedure
Do one of the following:
To import data from a file into one package, open the
package, and in the
Schedules tab click
Package
import.
To import data from a file into several packages, in the
home page click
Open data entry
package, then in the
Packages tab, click
Multi-package
import.
From the
Source
type list, select
Table.
Click
Go.
From the
Select data
source list, select the data source.
Click
Go.
The
Connection dialog box
appears.
Enter your user name and password
to connect to the selected data source.
From the
Select
table list, select the data table.
In
Import
amounts, define:
if the imported data should be added to
the existing data or replace it.
if amounts in the package should be
deleted before the import.
if zero balances should be imported.
In
Import
comments, define whether comments should be erased before the
import begins.
In the
After the
import section, define:
if a file containing the rejected data
should be generated after the import.
if rules should be run at the end of the
import.
Do one of the following:
If you are importing data from a file into one package,
click
Import.
If you are importing data from a file into several
packages, click
Next.
In the
Package
selection page, activate the boxes indicating the packages into
which you want to import data. Click
Import.
Results
The
Import
result page appears.
The amount of data imported and any errors
generated are listed on this page.
