Data load import issue

[SuneerS]

Hi,

We are trying to load a set of data into Idea portal - ServiceNow SPM module.

The load data and transformation shows successful and the "Import Set Rows" shows the rows are successfully created. 

However, the imported data is not showing up on the idea portal. Can you help on how to resolve this? 

Target table selected is "idea". Is this the correct table to load data into?

[SuneerS]

I can see them  in the idea screen (see attached) if this is what you meant by native view. 

However, these loaded data doesn't show up on the idea portal? 

[Ankur Bawiskar]

@SuneerS 

are you sure the table is correct?

Did you check the idea portal the data is fetched from which backend table?

Use the same to load the data.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[SuneerS]

@Ankur Bawiskar I am not sure, we used the "idea" as the target table. Can you advise which table to use? 

[Bhuvan]

@SuneerS 

Check below thread that could point you in the right direction. Transform map for idea table is not straightforward and has dependencies and pre-requisites mapping before it shows up in Idea Portal

https://www.servicenow.com/community/spm-forum/idea-record-migration-to-new-idea-portal/m-p/993267

Try to create a manual idea to understand the pre-requisites to populate it in idea portal and replicate the same for transform map.

If this helped to answer your query, please mark it helpful & accept the solution. 

Thanks,

Bhuvan

[Bhuvan]

@SuneerS 

Did you get a chance to review this ?

If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan