Create table by importing EXCEL file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2019 07:53 AM
Do we have any good way to create a new table by importing the Excel file having the table definition? I'm going to create a new custom application to migrate an existing application to ServiceNow. I have the table schema definitions in EXCEL format and would like to create new tables based on it, because it is inefficient to manually create the field by typing on the Web GUI. Does anyone have any good idea on this?
Regards
KM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2020 09:43 AM
Hi Kark,
You can create fields via excel upload during the Application creation.
Please refer below link for detailed information:
https://docs.servicenow.com/bundle/paris-application-development/page/build/guided-app-creator/task/gac-upload-spreadsheet.html
Please mark this answer correct if it resolves your issue so that this question can be marked as closed and will be helpful for others.
Thanks,
Amit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-12-2021 08:46 PM
Not useful since we have to create app then go for table creation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-18-2020 11:06 AM
Hi Kark,
you can write an onBefore Transform Script in your Transform Map to read the table names and column names from the Excel file and then use the GlideTableCreator and GlideColumnAttributes APIs in this script to create the new tables from the code.
You can find more details about table generation from scripts here: https://community.servicenow.com/community?id=community_question&sys_id=a3cc8329db9cdbc01dcaf3231f96...
Regards,
Paul
