Map fields for 2014tc16rftn002 producer, XLS file types
Example input data: stub
Transform function: implementation details
recordObject Piece of data to transform before going to harmonized storage.
Returns Project JSON matching the type fields.
Preprocess budget.
Input fields taken from the record are:
Total of eligible expenditureERDF expenditure allocated
recordObject The row received from parsed file
Returns Budget
Preprocess description.
Input fields taken from the record are:
AcronymSummary
recordObject The row received from parsed file
Returns String
Preprocess project_id.
Input fields taken from the record are:
Operation code nr.
recordObject The row received from parsed file
Returns String
Gets country code from a country name.
countryNameString The name of the country
Returns String The ISO 3166-1 country code
Preprocess project_locations.
Input fields taken from the record are:
Country
recordObject The row received from parsed file
Preprocess themes.
Input fields taken from the record are:
Programme specific objective
recordObject The row received from parsed file
Preprocess third_parties.
Input fields taken from the record are:
Lead partner nameLead partner location regionCountry
recordObject The row received from parsed file
Returns Array<ThirdParty>
Preprocess timeframe.
Input fields taken from the record are:
Start dateEnd date
recordObject The row received from parsed file
Returns Timeframe
Preprocess title.
Input fields taken from the record are:
Operation name
recordObject The row received from parsed file
Returns String