Bulkloader Documentation

How to use SQL to update multiple records simultaneously in the bulkloader

Go to Browse and Edit

Screen Shot 2019-04-19 at 8 29 53 AM

Select the recordset that contains the records of interest

Screen Shot 2019-04-19 at 8 30 13 AM

Choose the SQL option.

Read this; it’s important.

Screen Shot 2019-04-19 at 8 31 55 AM

If you need additional filters, use the top pane.

Screen Shot 2019-04-19 at 8 33 05 AM

After clicking “filter” and waiting for the reload, records are now filtered for MVZ:Mamm (from the initial selection) AND a particular user (copied from the data).

Use the bottom pane to update individual fields. This will update ALL records in the view below. You must choose a column and provide a value.

Screen Shot 2019-04-19 at 8 35 15 AM

Doublecheck, triplecheck, click “update.”

Screen Shot 2019-04-19 at 8 35 58 AM

All records have been updated.

Edit this Documentation

If you see something that needs to be edited in this document, you can create an issue using the link under the search widget at the top left side of this page, or you can edit directly here.