Import set

[Shaik22]

Hello,

1.How to import data from a table

2.How to export data from a table

3.What are the limitations of direct export and import?

[SwarnadeepNandy]

Hello @Shaik22,

1. To import data from a table, you need to create a data source that specifies the connection details and the table name. Then, you need to load the data from the data source into an import set table, which is a staging table for the imported data. Finally, you need to create a transform map that defines how to map the fields from the import set table to the target table. You can also use transform scripts to modify the data before transforming it. For more details, please refer to this article or this video.
2. To export data from a table, you can use different methods depending on your needs. You can export a single record as a PDF or XML file by right-clicking on the form header and selecting Export. You can export multiple records as CSV, XML, JSON, Excel, PDF or Export Sets by right-clicking on the list header and selecting Export. You can also export data by appending a query parameter to the URL of the table or list, such as &CSV, &XML, &JSON, &PDF or &XLS. For more details, please refer to this article or this article.
3. The limitations of direct export and import in ServiceNow are mainly related to the size and number of records that can be processed at a time. Each processor (CSV, XML, etc.) has its own lower and upper limit with the maximum being 50,000 records. If you exceed this limit, you may encounter errors or performance issues. You can adjust these limits by modifying some system properties, but you should be careful and test the impact before doing so. For more details, please refer to this article or this article. Another limitation of direct export and import is that they may not preserve all the data integrity and relationships that exist in ServiceNow. For example, if you export and import reference fields, you may lose the link between the records if the sys_id values are different. You may also lose some metadata or attachments that are associated with the records. Therefore, you should always backup your data and verify the results before and after exporting and importing data. For more details, please refer to this article.

Hope this helps.

Kind Regards,

Swarnadeep Nandy

[Harish Bainsla]

steps to import data

1. go to system import sets-->load data module
2. enter table name..chose file(.xls file) make sure 1st row in excel match fields in your destination table.so it will automap.
3. then click on create transform link
4. give it a name,select destination table(table in which u want to upload data)
5. click on auto map matching fields..if required fields do not match then click on mapping assist and match fields.
6. set colesce true to any one field from related list. it will be your unique field
7. click transform

https://youtu.be/MZlqauVaAzg?si=gabdCmZaDavl8sj5

steps to export data

You can export a list of records in a variety of formats. The Export option is available in the column heading context menu in List v2. In List v3, it is available in the list title menu. Note: To export records in an embedded list, export the record containing the list

https://youtu.be/piU87h1Eh_o?si=ThANMRSUnM5bhJpn