You are here: Primavera Unifier User Mode > Cost Manager > Cash Flow > Import cash flow data

Import cash flow data

You can import cash flow data via CSV file. This includes curve setup data (From and To dates, Profile and Total columns), and curve distribution data (distribution values of the Total amount entered in the date period columns). It is important to observe the order of curve operations: import the setup values first, then import the distribution values.

•

Manual entry generally allows data import, but depends upon the curve set up.

•

Auto-distribution precludes data import.

•

Fields that display data from other sources (schedule sheet, cost column, business process record), cannot be edited via CSV import.

You can change curve distribution settings; however, Primavera Unifier will replace your data with data collected by the new distribution method. For example, if you change a manual entry field to auto, all manually entered data will be lost and replaced with the auto-generated data.

To import curve setup data into the Cash Flow Worksheet by CSV import

Open the Cash Flow Worksheet. Select a row and click Open to open the Details window.

If you are importing both setup and distribution data, then import the setup data first to establish the distribution time period.

Click Export to export the CSV template. The CSV opens in Microsoft Excel^®. You can Save the CSV file to your desktop first, or Open it directly.

Note: Cash flow data exports the currency and the values to the CSV template.

Add the Curve Distribution data to the CSV file.

•

From Date, To Date: use the date format.

•

Profile: If using auto-profile, enter the name of the default profile you want to use. This is from the Distribution Profiles list maintained in Administration Mode.

•

Total: Enter a value to use as the cost total.

•

Save the CSV file.

Import the CSV file.

•

In the Details sheet, click Import > Curve Setup. The File Upload window opens.

•

Locate the CSV file and click OK. The data will populate edited fields on the Details sheet.

Save the Details window.

To import curve distribution data into the Cash Flow Worksheet by CSV import

Open the Cash Flow Worksheet. Select a row and click Open to open the Details window.

If you are importing both setup and distribution data, then import the setup data first to establish the distribution time period.

Click Export to export the CSV template. You can Save the CSV file to your desktop first, or Open it directly.

Add the Curve Distribution data to the CSV file.

•

Enter values in the time period distribution fields. Do not exceed the amount for Unassigned.

•

The Currency field must have the currency listed.

•

Save the CSV file.

Import the CSV file.

•

In the Details sheet, click Import > Curve Distribution. The File Upload window opens.

•

Locate the CSV file and click OK. The data will populate edited fields on the Details sheet.

Save the Details window.

Note: You can import data into cash flow by commitment curves in either transaction or project currencies. If you try to import data in an incorrect currency, you will be notified. For example, if the transaction currency is in Yen and the project currency is in USD, and you try to import in Euro, you will get an error message in the CSV file. You will need to correct the errors in the CSV before re-importing.

Oracle Corporation