Workspace

SoudarapuN
Tera Contributor

Hey Team ,
 I have a Requirement that i need to import the custom table records into Strategic Planning Workspace(SPW). But the fields are not same with planning item table it is totally different fields. The custom table  records also should have to available in project workspace .How can i do that.

 

#StrategicPlanningWorkspace

#workspaces

#ITBM

4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @SoudarapuN 

To import data into SN, the best practice is to use the ServiceNow-specific template. Go to the native view of the relevant table, click on any field, and then import/download the Excel format. This way, you can bring your data into the relevant fields. By doing this, it's easier to perform field mapping during the transform map.

You can also use your own format, but in that case, you'll need to manually do the field mapping during the transform map process.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

hi @Dr Atul G- LNG ,
I think u couldnt get my query .i need to see custom table data in Strategic Planning Workspace(spw) Where fields are not same as Planning item table how to do that.

Hi @SoudarapuN 

 

When you say fields are not same, mean the data types are different or what? If data types are different tehn no way to show, you need to create the same data type fields. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

field label and name are different .data types are same