How to set Partylist in a CSV file for migration

(0) Share

Report

Posted on by Victor Onyebuchi

410

Hi All,

I am currently migrating data into D365 from CSV files using kingswaysoft, but I have hit a road block migration PartyList entities in the various activity entity. E.g for organisers field in the Appoint entity, I use the below Json format(looked it up) in the organisar's column in my CSV File, but it is still failing;

[
{
"PartyId": "aafe05a4-d47a-e911-a81d-111d3a0b5de0",
"Name":"Rob vic",
"Type":"systemuser"
},
]

I still get the error; "Error: Failed to set field 'organizer' value to 'Rob stag' for entity 'appointment' (field type: PartyList, value type: String). System.Exception: Failed to process party list values for 'organizer' field, the input value does not appear to be in a valid JSON or delimited text format: 'Rob stag'. (SSIS Integration Toolkit for Microsoft Dynamics 365, v11.0.0.7160 - DtsDebugHost, v13.0.4495.10)".

Someone please come to my aid.

Thanks

Arun Vinoth pls look at this. Cheers

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Kokulan 18,054 on at

Like (0)

Report

Hi

Please see below and follow the link below and see that helps to resolve your issue.

Delimited Text: As an alternative option of the JSON format input, you can use delimited text as the input for activityparty field. The Delimited Text input needs to be constructed using semicolon(;) and colon(:) delimiters. The following is a sample value that you can provide for an activityparty field.

1

www.kingswaysoft.com/.../faq

Was this reply helpful? Yes No
Victor Onyebuchi 410 on at

Like (0)

Report

Thanks @Kokulan

Was this reply helpful? Yes No