Contents Now Platform Administration Previous Topic Next Topic Retrieving data from a CSV formatted file Subscribe Log in to subscribe to topics and get notified when content changes. ... SAVE AS PDF Selected Topic Topic & Subtopics All Topics in Contents Share Retrieving data from a CSV formatted file In this method, you import data from another instance using an HTTPS data source to return a CSV formatted file containing the rows to be imported. About this task This approach uses the Import Sets application to retrieve the data from the source and import it to the destination.Figure 1. HTTPS Data Sources Procedure Create a new data source by navigating to Import Sets > Data Sources on the destination instance. Provide the following field values: Import set table name: Select a table. Type:File Format:CSV File retrieval method:HTTPSNote: If the Server, File path, Username, and Password fields are not visible when you select HTTPS, change the file retrieval method temporarily to SCP and enter this information. Remember to reset the File retrieval method to HTTPS after you enter these fields. File path:incident.do?CSVNote: To import specific change records, you can add qualifiers to the path. For example, the following path would return all active change records: incident.do ?CSV & ;sysparm_query =active = true " User name and Password: Enter the user name and password for a valid user on the destination instance. Click the Test load 20 records related link to verify that the import is configured correctly. After setting up the data source, configure a standard transform map. On this page Send Feedback Previous Topic Next Topic
Retrieving data from a CSV formatted file In this method, you import data from another instance using an HTTPS data source to return a CSV formatted file containing the rows to be imported. About this task This approach uses the Import Sets application to retrieve the data from the source and import it to the destination.Figure 1. HTTPS Data Sources Procedure Create a new data source by navigating to Import Sets > Data Sources on the destination instance. Provide the following field values: Import set table name: Select a table. Type:File Format:CSV File retrieval method:HTTPSNote: If the Server, File path, Username, and Password fields are not visible when you select HTTPS, change the file retrieval method temporarily to SCP and enter this information. Remember to reset the File retrieval method to HTTPS after you enter these fields. File path:incident.do?CSVNote: To import specific change records, you can add qualifiers to the path. For example, the following path would return all active change records: incident.do ?CSV & ;sysparm_query =active = true " User name and Password: Enter the user name and password for a valid user on the destination instance. Click the Test load 20 records related link to verify that the import is configured correctly. After setting up the data source, configure a standard transform map.
Retrieving data from a CSV formatted file In this method, you import data from another instance using an HTTPS data source to return a CSV formatted file containing the rows to be imported. About this task This approach uses the Import Sets application to retrieve the data from the source and import it to the destination.Figure 1. HTTPS Data Sources Procedure Create a new data source by navigating to Import Sets > Data Sources on the destination instance. Provide the following field values: Import set table name: Select a table. Type:File Format:CSV File retrieval method:HTTPSNote: If the Server, File path, Username, and Password fields are not visible when you select HTTPS, change the file retrieval method temporarily to SCP and enter this information. Remember to reset the File retrieval method to HTTPS after you enter these fields. File path:incident.do?CSVNote: To import specific change records, you can add qualifiers to the path. For example, the following path would return all active change records: incident.do ?CSV & ;sysparm_query =active = true " User name and Password: Enter the user name and password for a valid user on the destination instance. Click the Test load 20 records related link to verify that the import is configured correctly. After setting up the data source, configure a standard transform map.