Import File Using FTP 
You can define a Data Manager package to import a file from an FTP server by using the process chain /CPMB/IMPORT_USING_FTP. The file is transferred from an FTP site to the application.
Activities
Create a Data Manager package by using the corresponding process chains (see Package Usage).
Run the Data Manager package as follows:
Log on to the Planning and Consolidation Office module.
On the action pane, choose
Manage data 
Run a package 
.Choose the package created in step 1 and choose Run.
Enter the FTP user and password.
Enter the complete FTP file path.
Choose a transformation file.
Choose the name of the destination dimension.
Select the method to insert the data:
Merge — Joins the data values
Replace — Clears existing data values and replaces them
To run the default logic after import, choose Yes, then choose Next.
To check the work status when importing the data, choose Yes.
Choose one of the following options:
Run now
Schedule
Run now & schedule
Choose Finish.
You can change the default package instructions (see Modifying the Dynamic Script of a Package).
Dynamic script task parameters
Task |
Parameter |
Default Value |
Description |
|---|---|---|---|
/CPMB/CONVERT |
CLEARDATA |
0 |
Delete data before writing 0 = NO 1= YES |
/CPMB/CONVERT |
FILE |
File name |
|
/CPMB/CONVERT |
SPACKAGE_SIZE |
40.000 |
Package size |
/CPMB/CONVERT |
TRANSFORMATIONFILEPATH |
Transformation file |
|
/CPMB/FTP |
FTP_DESTINATION |
FTP address |
|
/CPMB/FTP |
FTP_DOCNAME |
Document name |
|
/CPMB/FTP |
FTP_PASSWORD |
FTP password |
|
/CPMB/FTP |
FTP_USER |
FTP user |
|
/CPMB/LOAD |
CHCKCK |
0 |
Check work status 1 = YES 0 = NO |
/CPMB/LOAD |
CLEARDATA |
0 |
Delete data before writing 0 = NO 1= YES |
/CPMB/LOAD |
RUNLOGIC |
0 |
Run logic after process 0 = NO 1 = YES |