This post is related to Enabler4Excel – Review, Guide Tips. Using the DML operation options in Enabler4Excel is a much quicker way of using small – medium sized data sets than using the Data Loader or any other alternative.
DML operations: – Benefit #1:
As with many functions that the Enabler4Excel offers, the key benefit here is the combined time that you will save. Because the data you are preparing for a DML operation via the Data Loader or another tool will have to be in a .csv file anyway, it makes sense to have the capability in Excel itself to run DML operations. You can also choose to perform a DML operation on all of the data in a worksheet or a specific subset. Again, this saves time because you don’t need to prepare multiple worksheets (and therefore, multiple files when using .csv format) for batches of data.
When performing a DML operation, it is very easy to map columns to fields via the drag-and-drop UI. You can optionally choose to use an existing mapping and save a new one, too. Furtheremore, there is an option to show read-only fields too, which may be helpful in some particular use cases.
Once you selected the data (all or subset) that you wish to perform the DML operation on and mapped the columns, you can select ‘Yes’ to run.
When the operation has finished running, you can choose to return the results (either ‘success or ‘fail’ with relevant failure option) in the most right column. Again, this saves you from having to deal with an extra 2 files (success/error files) as would be the case via the Data Loader.
If you are comfortable with the Data Loader, import.io or the Jitterbit data loader then you will find the Enabler4Excel very easy to use. The only limitation that I feel this function has is that when dealing with large data sets, although there is a bulk api checkbox option, I find the Data Loader quicker.