Import Projects into ServiceNow PPM from an excel sheet.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-10-2018 11:04 AM
I know it is possible to import a Project from Microsoft Project but is it possible to import a list of say 100 projects from an excel sheet? The excel sheet has the following columns Project name, Project Description, Start Date, End Date and Division. Would it be possible to map these fields to fields on Project form?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-10-2018 11:11 AM
You could use a transform map to import the data into the table. Since you have specific columns/fields defined and are aren't trying to import Project Tasks as well, I'd use a transform map to import that many records directly into the table.
Richelle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-10-2018 11:16 AM
Sorry, but what is a transform map?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-10-2018 11:27 AM
are you referring to API?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-10-2018 11:29 AM
Here is the Product Documentation on it: https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/import-sets/reference/import-sets-landing-page.html
It's a way to let you take external data and import it (as records) into a table in ServiceNow. It works in versions before Jakarta as well. I've been using it since Calgary.
Richelle
