Method

If you want to do a batch update of records, you can use Method's Import / Export tool  to do so instead of editing each record individually. The steps below will outline how this can be done.

NOTE: The Import / Export tool will be unable to delete data from a table. In order to do so, you would need to customize a screen to do mass deletes.

<a href="#h_58a54fea4d">Export existing records</a>

<a href="#h_26bdeafb69">Update the exported records</a>

<a href="#h_8ab0edfbab">Import the modified records</a>

- <a href="#h_58a54fea4d">Export existing records</a>
- <a href="#h_26bdeafb69">Update the exported records</a>
- <a href="#h_8ab0edfbab">Import the modified records</a>

___________________________________________________________

We always recommend exporting the latest data first. Below, we will use the example of exporting the Opportunities Stages table.

Click your profile icon in the upper right and select Integrations.

Select the table where your data is stored from the dropdown list.

Choose fields you wish to update. Note that linked fields cannot be updated, so do not bother exporting those (Unfortunately, linked fields are not marked so you have to note this ahead of time). Furthermore, you will be unable to update any record that ends in <code> _RecordID </code>, so do not export them either.

You MUST have the RecordID field as a field to export.

Click the Export button. This will download a .csv file.

1. Click your profile icon in the upper right and select Integrations.
2. Select Export Settings.
3. Select the table where your data is stored from the dropdown list. 

4. Choose fields you wish to update. Note that linked fields cannot be updated, so do not bother exporting those (Unfortunately, linked fields are not marked so you have to note this ahead of time). Furthermore, you will be unable to update any record that ends in <code> _RecordID </code>, so do not export them either. 

5. You MUST have the RecordID field as a field to export. 

6. Click the Export button. This will download a .csv file.

NOTE: You can filter what you export. For more information, see our article <a href="https://help.method.me/en/articles/1480316-using-filter-with-script-to-export">Use Filter with Script to Export</a>.

It is now time to update the file with your new data.

Open the downloaded file from above.

Update the file with the new data.

Do NOT alter the RecordID column. That identifies which records to change.

1. Open the downloaded file from above.
2. Update the file with the new data.
3. Do NOT alter the RecordID column. That identifies which records to change.
4. Save the file as a .csv or .xls.

You should now be ready to update the data back into Method. The import flow will mostly follow the <a href="https://help.method.me/en/articles/6235370-importing-a-file-into-method">Importing a File into Method</a> article, however, there are minor changes.

Click your profile icon in the upper right and choose Integrations.

Select Other for the type of data you wish to import.

For Select an import method, upload your import file and make sure you select the table you want to import into.

For What are you looking to do, make sure you choose Update records.

By default, the <code> RecordID </code> column in the import file should be mapped to the <code> RecordID </code> field in the table.

1. Click your profile icon in the upper right and choose Integrations.
2. Select Import &amp; Export.
3. Select Other for the type of data you wish to import.
4. For Select an import method, upload your import file and make sure you select the table you want to import into.
5. For What are you looking to do, make sure you choose Update records.

6. By default, the <code> RecordID </code> column in the import file should be mapped to the <code> RecordID </code> field in the table.

7. Continue with the import from here.