Import rate lines into a rate model

Use the import rate lines function to quickly add multiple rate lines from an export file into a rate model.

시작하기 전에

Set the glide.import_set_row.dynamically_add_fields system property to true.

Role required: pps_admin or it_rate_model_admin

이 태스크 정보

After adding or updating rate lines in a file created using the export function, you can import the rate lines from the file into the rate model.

주:

Rate lines fail to import in the following circumstances:

• Overlapping effective dates for the same set of criteria values.
• Criteria values with no matching data in the system. For example, a rate line might have Business Analyst as the Role criteria but that role does not exist in the system.
• Rates in non-functional (non-default) currency but no corresponding budget reference rates for the required period exist in the system.

프로시저

1. Import rate lines from an import file into the rate model in one of the following ways:
   • Navigate to All > Project Administration > Rate Model > Import Rate Line.
   • Navigate to All > Time Sheets > Rate Model > Import Rate Line.
   • Navigate to All > Time Sheets > Rate Model > All, open a rate model record, and click the Import Rate Line related link.
2. Click Choose File to select the import file.
3. 옵션: If you are importing from an Excel file containing multiple sheets, enter the sheet number that contains the data to import in the Sheet number field.
   주:

   If you are importing from a CSV file, then the data from the last saved CSV file is considered for import irrespective of the specified sheet number.
4. 옵션: If the import file has a header row, enter the row number that has the header information in the Header row field.
5. Click Submit.
6. Click Run Transform to import the data.
   For more information, see Run an import.

결과

• New rate lines are appended to the rate lines list in the rate model.
• Existing rate lines in the rate model are updated with the latest values.