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?

[Dr Atul G- LNG]

Hi @SuneerS To display some data on the portal, you'll need a data source or reference.
Do you have any kind of widget that can fetch and display the data on the portal?
Also, I believe the data is only visible to the user who is logged in.

[SuneerS]

Hi Atul,

Thank you for your response.

Not sure what you meant by "data source or reference".

We are loading the data using the admin user.

I thought the idea portal will display all the ideas loaded for others to view and vote / comment? 

After we load the data using the "System Import set -> Load data" screen, the loaded data doesn't show up on the idea portal. I can see that the ideas have been successfully loaded into the target table ("idea" table) via the "Transform History" screens.

Are we missing anything? 

[SuneerS]

Hi Atul,

Thank you for your response.

Not sure what you meant by "data source or reference".

We are loading the idea data using the admin user from an excel spreadsheet by mapping the data items from the spreadsheet into a staging table and then transforming to the target table ("idea").

I thought the idea portal will display the loaded idea data for any user to view and vote/ comment. 

However, the idea portal doesn't show any of the new data items even though I can see that the data load using "System Import Set -> Load data" is successful. 

Are we missing anything here? 

[Dr Atul G- LNG]

Hi @SuneerS 

Could you please check if the data is showing in the native view, meaning in the Ideas table?
If yes, it means the data has been successfully loaded in ServiceNow.
If there’s no question about it, can either users see these ideas in the portal so that they can vote on them?

https://www.servicenow.com/community/spm-forum/can-you-limit-the-idea-portal-to-certain-user-groups/...