tuli
06/12/2025, 1:47 PMDetails: The subrecord or sublist EMPLOYEE:ROLES does not have the correct line field value. Specify the correct sequence.
I am getting this error while deploying cSV imports throught SDF,Celigo AI
06/12/2025, 1:47 PMAI generated answer (using internal Slack threads):Based on the conversations, it seems like you are trying to import roles for employees using CSV files through SuiteCloud Development Framework (SDF). However, you are encountering an error related to the sequence of the EMPLOYEE:ROLES sublist. Here are some steps you can follow to resolve this issue: 1. Make sure you are using the "UPDATE" action instead of "ADD". This is because you want to update the Roles Sublist of the employee record, not add a new role. 2. Your CSV file should have the Internal ID of the Employee on each row and one role per row. For example:
Column1 Column2
employeeID RoleId
employeeID RoleId2
employeeID RoleId3
3. In the step where you select update, click advanced and select "Overwrite Sublist". This is how sublist updates usually work in CSV Imports in NetSuite.
4. Use "|" as the sublist delimiter for the role. Also, use the role's internal id instead of text name. During mapping, click on the small pencil icon beside your roles column (left-hand side) to open up the data type dialog box, where you should select "internal id". This will ensure proper mapping and no conflict.
5. Your CSV file should look something like this:
Employee Internal id, Role
xxx, XX|YY|ZZ
Remember, the employee internal id is the key.
Please note that if you update a record with a role that already exists, it will not break things, it will simply move onto the next record.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
06/12/2025, 1:47 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.821569204
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.819094777
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.807309091
Celigo AI
06/12/2025, 1:47 PM