HDL – Sample file to load Talent Profile data
In the enhanced profiles (Profile V2), for bulk upload, one has to use TalentProfile.dat file as earlier. However while loading profile items against a profile, a new attribute SectionId should be provided. SectionId is based on the content item being used.
Check the below post on how to get section id:
https://fusionhcmconsulting.com/2021/02/hdl-query-to-find-sectionid-for-talent-profile-item-load/
Below is the sample data for ProfileItem for language content item:
METADATA|ProfileItem|ProfileItemId|ProfileId|ProfileCode|ContentItem|ContentItemId|ContentType|ContentTypeId|CountryCountryCode|CountryGeographyCode|CountryId|DateFrom|Importance|InterestLevel|ItemClob1File|ItemClob2File|ItemClob3File|ItemClob4File|ItemClob5File|ItemDate1|ItemDate10|ItemDate2|ItemDate3|ItemDate4|ItemDate5|ItemDate6|ItemDate7|ItemDate8|ItemDate9|ItemDecimal1|ItemDecimal2|ItemDecimal3|ItemDecimal4|ItemDecimal5|ItemNumber1|ItemNumber10|ItemNumber2|ItemNumber3|ItemNumber4|ItemNumber5|ItemNumber6|ItemNumber7|ItemNumber8|ItemNumber9|ItemText20001|ItemText20002|ItemText20003|ItemText20004|ItemText20005|ItemText2401|ItemText24010|ItemText24011|ItemText24012|ItemText24013|ItemText24014|ItemText24015|ItemText2402|ItemText2403|ItemText2404|ItemText2405|ItemText2406|ItemText2407|ItemText2408|ItemText2409|ItemText301|ItemText3010|ItemText3011|ItemText3012|ItemText3013|ItemText3014|ItemText3015|ItemText302|ItemText303|ItemText304|ItemText305|ItemText306|ItemText307|ItemText308|ItemText309|Mandatory|QualifierCode1|QualifierId1|QualifierCode2|QualifierId2|QualifierSetCode1|QualifierSetCode2|RatingLevelCode1|RatingLevelId1|RatingLevelCode2|RatingLevelId2|RatingLevelCode3|RatingLevelId3|RatingModelCode1|RatingModelId1|RatingModelCode2|RatingModelId2|RatingModelCode3|RatingModelId3|SectionId|SectionName|SourceId|SourceKey1|SourceKey2|SourceKey3|SourceType|StateCountryCode|StateGeographyCode|StateProvinceId|DateTo|SourceSystemId|SourceSystemOwner
MERGE|ProfileItem|||PERS_300000002|English||LANGUAGE|||||2020/01/01|||||||||||||||||||||||||||||||||||||||||||||||||||||Y||||||||||||||||||||||3||1||2||LANGUAGE||LANGUAGE||LANGUAGE||300000001855526|||||||||||TPFPIPERS_300000002_LANG1|HRC_SQLLOADER
Hello,
I am looking for a sample file to create the Talent Profile of the employee; do you have such sample?
I am using the below and getting the error: An error occurred. To review details of the error run the HCM Data Loader Error Analysis Report diagnostic test. Message details: JBO-27014: Attribute ProfileCode in ProfileEO is required..
METADATA|TalentProfile|PersonNumber|ProfileTypeCode|SourceSystemId|SourceSystemOwner
MERGE|TalentProfile|87|PERSON|PROFILE_300000002987809|RASEP
Thanks in advance,
Best Regards,
Below should help:
Please check below sample:
METADATA|TalentProfile|Summary|Description|ProfileTypeCode|ProfileCode|ProfileStatusCode|ProfileUsageCode|PersonNumber|PartyId|OwnerPersonId|SourceSystemId|SourceSystemOwner
MERGE|TalentProfile|||PERSON|PER_102664|A|P|102664|||12748|EBS-HR
I am looking to add Learning Outcomes to the Talent Profile via HDL but note sure of the specific fields I need. The file is Used was METADATA|ProfileItem|SourceSystemOwner|SourceSystemId|ProfileId|ProfileItemId|SectionId|ContentTypeId|ContentItemId|DateFrom
it loaded successfully but I don’t see the that the Learning Outcome was added to the Talent Profile. Any guidance on the easiest template I can use with just using the User Key fields?