EUBFR ETL documentation | Documentation:

2014tc16i5cb005CsvTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getCodeByCountry

Parameters

countryName (String) The name of the country

Returns

String : The ISO 3166-1 country code

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

formatDate

Parameters

date (Date) Date in DD.MM.YYYY format

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "01.01.2009"
output => "2009-01-01T00:00:00.000Z"

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

2014tc16i5cb006CsvTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getCodeByCountry

Parameters

countryName (String) The name of the country

Returns

String : The ISO 3166-1 country code

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

formatDate

Parameters

date (Date) Date in DD.MM.YYYY format

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "01.01.2009"
output => "2009-01-01T00:00:00.000Z"

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

2014tc16i5cb007CsvTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getCodeByCountry

Parameters

countryName (String) The name of the country

Returns

String : The ISO 3166-1 country code

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

formatDate

Parameters

date (Date) Date in DD.MM.YYYY format

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "01.01.2009"
output => "2009-01-01T00:00:00.000Z"

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

2014tc16m4tn001XlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getCodeByCountry

Parameters

countryName (String) The name of the country

Returns

String : The ISO 3166-1 country code

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

getTypes

Parameters

record (Object) The row received from parsed file

Returns

String :

2014tc16m4tn002XlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getThemes

Parameters

record (Object) The row received from parsed file

Returns

Array<String> :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

2014tc16m6tn001XlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

Array :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getThemes

Parameters

record (Object) The row received from parsed file

Returns

Array :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

formatDate

Parameters

date (Date) Date
Supported formats:
- DD/MM/YYYY

Returns

Date : The date formatted into an ISO 8601 date format

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

2014tc16rfcb014CsvTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getPriorities

Parameters

record (Object) The row received from parsed file

Returns

Array<String> :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getSubProgramme

Parameters

record (Object) The row received from parsed file

Returns

String :

getThemes

Parameters

record (Object) The row received from parsed file

Returns

Array<String> :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

formatDate

Parameters

date (Date) Date in DD.MM.YYYY format

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "01.01.2009"
output => "2009-01-01T00:00:00.000Z"

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

2014tc16rfcb021XlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getCodeByCountry

Parameters

countryName (String) The name of the country

Returns

String : The ISO 3166-1 country code

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getStatus

Parameters

record (Object) The row received from parsed file

Returns

String :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

formatDate

Parameters

date (Date) Date in DD.MM.YYYY format

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "01.01.2009"
output => "2009-01-01T00:00:00.000Z"

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

2014tc16rfcb047XlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getCodeByCountry

Parameters

countryName (String) The name of the country

Returns

String : The ISO 3166-1 country code

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getStatus

Parameters

record (Object) The row received from parsed file

Returns

String :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

formatDate

Parameters

date (Date) Date in ready Date() object or DD.MM.YYYY as a fallback.

Returns

Date : The date formatted into an ISO 8601 date format

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

2014tc16rfcb050XlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getPriorities

Parameters

record (Object) The row received from parsed file

Returns

Array<String> :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getCodeByCountry

Parameters

countryName (String) The name of the country

Returns

String : The ISO 3166-1 country code

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

formatDate

Parameters

date (Date) Date in YYYY-MM-DD format

Returns

Date : The date formatted into an ISO 8601 date format

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

2014tc16rfir001XlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getPriorities

Parameters

record (Object) The row received from parsed file

Returns

Array<String> :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

2014tc16rfpc001XlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getStatus

Parameters

record (Object) The row received from parsed file

Returns

String :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

formatDate

Parameters

date (Date) Date in DD/MM/YYYY format

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "01/01/2009"
output => "2009-01-01T00:00:00.000Z"

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

2014tc16rftn002XlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getCodeByCountry

Parameters

countryName (String) The name of the country

Returns

String : The ISO 3166-1 country code

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getThemes

Parameters

record (Object) The row received from parsed file

Returns

Array<String> :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

2014tc16rftn003XlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getNutsCodeLevel

Parameters

code (String) The NUTS code

Returns

Number : The level of NUTS or null if one can't be extracted

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getThemes

Parameters

record (Object) The row received from parsed file

Returns

Array<String> :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

formatDate

Parameters

date (Date) Date
Supported formats:
- DD/MM/YYYY

Returns

Date : The date formatted into an ISO 8601 date format

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

2014tc16rftn004XlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getNutsCodeLevel

Parameters

code (String) The NUTS code

Returns

Number : The level of NUTS or null if one can't be extracted

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getThemes

Parameters

record (Object) The row received from parsed file

Returns

Array<String> :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

formatDate

Parameters

date (Date) Date
Supported formats:
- DD/MM/YYYY

Returns

Date : The date formatted into an ISO 8601 date format

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

BulgariaXlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getProjectDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

formatDate

Parameters

date (Date) Date in DD.MM.YYYY format

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "01.01.2009"
output => "2009-01-01T00:00:00.000Z"

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getProjectTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

CordisCsvTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getFundingArea

Parameters

record (Object) The row received from parsed file

Returns

Array :

getTotalCost

Parameters

record (Object) The row received from parsed file

Returns

String :

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getFrameworkProgramme

Parameters

record (Object) The row received from parsed file

Returns

String :

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array : List of {Location} objects for project_locations field

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array : List of {ThirdParty} objects

formatDate

Parameters

date (Date) Date in YYYY-MM-DD or DD/MM/YYYY formats.

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "2018-12-31"
output => "2018-12-31T00:00:00.000Z"

input => "01/01/1986"
output => '1986-01-01T00:00:00.000Z'

getProjectWebsite

Parameters

record (Object) The row received from parsed file

Returns

String :

getStatus

Parameters

record (Object) The row received from parsed file

Returns

String :

getThemes

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

getStartDate

Parameters

record (Object) The row received from parsed file

Returns

String :

getEndDate

Parameters

record (Object) The row received from parsed file

Returns

String :

DevcoXlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

getCodeByCountry

Parameters

countryName (String) The name of the country

Returns

String : The ISO 3166-1 country code

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array :

getResults

Parameters

record (Object) The row received from parsed file

Returns

Result :

getType

Parameters

record (Object) The row received from parsed file

Returns

Array : Project types

getBudget

Parameters

record (any)

EacCsvTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getAction

Parameters

record (Object) The row received from parsed file

Returns

String :

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getCallYear

Parameters

record (Object) The row received from parsed file

Returns

String :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getProgramme

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array : List of {Location} objects for project_locations field

getProjectWebsite

Parameters

record (Object) The row received from parsed file

Returns

String :

getResults

Parameters

record (Object) The row received from parsed file

Returns

Result :

getProjectStatus

Parameters

record (Object) The row received from parsed file

Returns

String :

getSubProgramme

Parameters

record (Object) The row received from parsed file

Returns

String :

getSuccessStory

Parameters

record (Object) The row received from parsed file

Returns

String :

getThemes

Parameters

record (Object) The row received from parsed file

Returns

String :

getCoordinators

Parameters

record (Object) The row received from harmonized storage

Returns

Array : A list with a single {Coordinator} object

getPartners

Parameters

record (Object) The row received from harmonized storage

Returns

Array : A list of {Partner} objects

formatDate

Parameters

date (Date) Date
Supported formats:
- DD/MM/YYYY
- YYYY-MM-DD

Returns

Date : The date formatted into an ISO 8601 date format

getStartDate

Parameters

record (Object) The row received from parsed file

Returns

String :

getEndDate

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectTitle

Parameters

record (Object) The row received from harmonized storage

Returns

String :

getTypes

Parameters

record (Object) The row received from harmonized storage

Returns

Array : List of activity types

Example

input => "foo, bar, baz"
output => ["foo", "bar", "baz"]

EuInvestCSVTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getMedia

Parameters

record (Object) The row received from parsed file

Returns

Array<Media> :

getId

Parameters

record (Object) The row received from parsed file

Returns

String :

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getLinks

Parameters

record (Object) The row received from parsed file

Returns

Array<RelatedLink> :

getThemes

Parameters

record (Object) The row received from parsed file

Returns

Array :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

formatDate

Parameters

date (Date) Date in DD/MM/YYYY format

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "01/01/2009"
output => "2009-01-01T00:00:00.000Z"

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

euResultsCsvTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getFundingArea

Parameters

record (Object) The row received from parsed file

Returns

Array :

Example

input => "Research & innovation; Investment for growth; Transport"
output => ["Research & innovation", "Investment for growth", "Transport"]

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getPriorities

Parameters

record (Object) The row received from parsed file

Returns

String :

getMedia

Parameters

record (Object) The row received from parsed file

Returns

Array<Media> :

getProgramme

Parameters

record (Object) The row received from parsed file

Returns

String :

getId

Parameters

record (Object) The row received from parsed file

Returns

String :

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getWebsite

Parameters

record (Object) The row received from parsed file

Returns

String :

getRelatedLinks

Parameters

record (Object) The row received from parsed file

Returns

Array : List of {RelatedLink}

Example

input => "<a href=\"https://ec.europa.eu/inea/en/ten-t/ten-t-projects/projects-by-country/multi-country/2013-eu-92069-s\">INEA</a>;<a href=\"https://europa.eu/investeu/projects/central-european-green-corridors_en\">InvestEU</a>"
output => [
   { label: "INEA", url: "https://ec.europa.eu/inea/en/ten-t/ten-t-projects/projects-by-country/multi-country/2013-eu-92069-s" }
   { label: "InvestEU", url: "https://europa.eu/investeu/projects/central-european-green-corridors_en" }
 ]

getReportingOrganisation

Parameters

record (Object) The row received from parsed file

Returns

String :

getResults

Parameters

record (Object) The row received from parsed file

Returns

Result :

getCoordinators

Parameters

record (Object) The row received from parsed file

Returns

Array<Coordinator> :

getPartners

Parameters

record (Object) The row received from parsed file

Returns

Array<Partner> :

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array<ThirdParty> :

formatDate

Parameters

date (Date) Date in timestamp

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "1388530800"
output => "2013-12-31T23:00:00.000Z"

getTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

FtsXlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getCodeByCountry

Parameters

countryName (String) The name of the country

Returns

String : The ISO 3166-1 country code

getNutsCodeLevel

Parameters

code (String) The NUTS code

Returns

Number : The level of NUTS or null if one can't be extracted

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array : List of {Location} objects for project_locations field

getThirdParties

Parameters

record (Object) The row received from parsed file

Returns

Array : List of {ThirdParty} objects for third_parties field

HomeXlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getFundingArea

Parameters

record (Object) The row received from harmonized storage

Returns

Array : List of string values for funding_area field

getBudget

Parameters

record (Object) The row received from harmonized storage

Returns

Budget :

getDescription

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

String : The project description

getProgrammeName

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Array : List of abbreviations

getProjectLocations

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Array : List of {Location}

getThirdParties

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Array : List of {ThirdParty}

formatDate

Parameters

date (Date) Date in "10/9/14" (MM/DD/YY) or "10/9/2014" (MM/DD/YYYY) format

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "10/9/2014"
output => "2014-10-09T00:00:00.000Z"

IatiCsvTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget : Field containing {BudgetItem}

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getReportingOrganizations

Parameters

record (Object) The row received from parsed file

Returns

String : Abbreviation a given reporting DG.

formatDate

Parameters

date (Date) Date in YYYY-MM-DD (ISO) format

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "2018-12-31"
output => "2018-12-31T00:00:00.000Z"

InforegioJsonTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getFundingArea

Parameters

record (Object) The row received from parsed file

Returns

Array : List of string values for funding_area field

Example

input => "Research & innovation; Investment for growth; Transport"
output => ["Research & innovation", "Investment for growth", "Transport"]

formatDate

Parameters

date (Date) Date in "10/9/2014" (DD/MM/YYYY) format

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "01/01/2009"
output => "2009-01-01T00:00:00.000Z"

getAddress

Parameters

record (Object) The row received from parsed file

Returns

Array : A list of {Partner} objects

getBeneficiaries

Parameters

record (Object) The row received from harmonized storage

Returns

Array : A list of a single {Beneficiary} object

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array : List of {Location} objects for project_locations field

getProjectWebsite

Parameters

record (Object) The row received from parsed file

Returns

string :

formatBudget

Parameters

budget (string) String containing numeric data

Returns

BudgetItem :

inforegioXmlTransform

Parameters

record (Object) The row received from parsed file

Returns

Project : JSON matching the type fields

getNutsCodeLevel

Parameters

code (String) The NUTS code

Returns

Number : The level of NUTS or null if one can't be extracted

getNutsCodeLevel

Parameters

code (String) The NUTS code

Returns

Number : The level of NUTS or null if one can't be extracted

checkData

Parameters

data ((Object | string)) The input piece of data

Returns

string : The string value of the input data

Example

input => ['foo']
output => 'foo'

formatDate

Parameters

date (Date) Date in DD/MM/YYYY format

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "02/02/2018"
output => '2018-02-02T00:00:00.000Z'

getAddress

Parameters

record (Object) The row received from parsed file

Returns

string : The address as consumed by {Partner}

formatBudget

Parameters

budget (string) Prefixed currency value

Returns

BudgetItem : The formatted budget

getFundingArea

Parameters

record (Object) The row received from parsed file

Returns

Array : List of values for funding area

Example

input => 'foo;bar;baz'
output => ['foo', 'bar', 'baz']

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array : List of {Location}

getThemes

Parameters

record (Object) The row received from parsed file

Returns

Array : List of values for themes

Example

input => 'foo; bar; baz'
output => ['foo', 'bar', 'baz']

getBeneficiaries

Parameters

record (Object) The row received from harmonized storage

Returns

Array : List of a single {Beneficiary}

JustCsvTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array : List of {Location} objects for project_locations field

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getRelatedLinks

Parameters

record (Object) The row received from parsed file

Returns

Array : List of {RelatedLink}

Example

input => "<a href=\"https://ec.europa.eu/inea/en/ten-t/ten-t-projects/projects-by-country/multi-country/2013-eu-92069-s\">INEA</a>;<a href=\"https://europa.eu/investeu/projects/central-european-green-corridors_en\">InvestEU</a>"
output => [
   { label: "INEA", url: "https://ec.europa.eu/inea/en/ten-t/ten-t-projects/projects-by-country/multi-country/2013-eu-92069-s" }
   { label: "InvestEU", url: "https://europa.eu/investeu/projects/central-european-green-corridors_en" }
 ]

Wifi4EuXlsTransform

Parameters

record (Object) Piece of data to transform before going to harmonized storage.

Returns

Project : JSON matching the type fields.

getBudget

Parameters

record (Object) The row received from parsed file

Returns

Budget :

getCallYear

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectDescription

Parameters

record (Object) The row received from parsed file

Returns

String :

getBeneficieries

Parameters

record (Object) The row received from parsed file

Returns

String :

getProjectId

Parameters

record (Object) The row received from parsed file

Returns

String :

getLocations

Parameters

record (Object) The row received from parsed file

Returns

Array<Location> :

getProjectWebsite

Parameters

record (Object) The row received from parsed file

Returns

String :

formatDate

Parameters

date (Date) Date in "10/9/14" (MM/DD/YY) or "10/9/2014" (MM/DD/YYYY) format

Returns

Date : The date formatted into an ISO 8601 date format

Example

input => "10/9/2014"
output => "2014-10-09T00:00:00.000Z"

getProjectTimeframe

Parameters

record (Object) The row received from parsed file

Returns

Timeframe :

getProjectTitle

Parameters

record (Object) The row received from parsed file

Returns

String :

getCountryCode(country)

Parameters

country (Object) Country in the form of 'БЪЛГАРИЯ (BULGARIA)', 'ΕΛΛΑΔΑ (ELLADA)' and similar.

Returns

String : ISO ALPHA-2 code used by i18n-iso-countries in the enrichment manager.

getAddress(record)

Parameters

record (Object) The row received from parsed file

Returns

String : The address

BudgetItem

Properties

currency (string)
raw (string)
value (number)
_original ({currency: string, raw: string, value: number}?)

Budget

Properties

eu_contrib (BudgetItem)
funding_area (Array<string>)
mmf_heading (string)
other_contrib (BudgetItem)
private_fund (BudgetItem)
public_fund (BudgetItem)
total_cost (BudgetItem)

ThirdParty

Properties

address (string)
country (string)
email (string)
name (string)
phone (string)
region (string)
role (string)
type (string)
website (string)

Coordinates

Properties

lat (number)
lon (number)

Nuts

Properties

code (string)
name (string)
level ((number | null))
year ((number | null))

Location

Properties

address (string)
centroid ((Coordinates | null))
country_code (string)
location ((GeoJSON | null))
nuts ((Array<Nuts> | null))
postal_code (string)
region (string)
town (string)

MediaFileMeta

Properties

description (string)
mime_type (string)
type (string)

Media

Properties

meta (MediaFileMeta)
name (string)
url (string)

RelatedLink

Properties

label (string)
url (string)

Result

Properties

available (string)
result (string)

TimePrecision

Timeframe

Properties

from ((string | null))
from_precision (TimePrecision)
to ((string | null))
to_precision (TimePrecision)

Project

Properties

action (string)
budget (Budget)
call_year (string)
description (string)
ec_priorities (Array<string>)
media (Array<Media>)
programme_name (string)
project_id (string)
project_locations (Array<Location>)
project_website (string)
complete (boolean)
related_links (Array<RelatedLink>)
reporting_organisation (string)
results (Result)
status (string)
sub_programme_name (string)
success_story (string)
themes (Array<string>)
third_parties (Array<ThirdParty>)
timeframe (Timeframe)
title (string)
type (Array<string>)