Help & Support
Elevate Your Agents with AgentExchange Solutions
Easily enhance Agentforce with pre-built AI solutions from AgentExchange. Browse, install, and deploy agents, actions, and apps directly into your environment. Tell Me More
Have Questions?
Custom Metadata Type Data Loader
Data Loader for Custom Metadata Type Records
- Business Need
- IT & Administration
- Requires
- Sales Cloud
- Compatible With
- Sales CloudService CloudMarketing Cloud Engagement
This application helps to load multiple Custom Metadata Type records easily from single screen. It provides following features: 1) Import Custom Metadata Type Records 2) Export the existing Custom Metadata Type Records
Rating
Reputation
MVP
Recognized by Salesforce for their leadership, expertise, and generosity
Top Reviewer
Contribute reviews that encourage conversation and help others make informed decisions
Ranger
Lifelong learners who have earned the Ranger rank or higher on Trailhead
Showing 10 of 13 Reviews
Did not insert records
I'm trying to import records and followed the directions. I was able to preview records to be inserted, after save got a message that it would notify me when completed but I never received the message and no records inserted. I've tried a handful of times and never worked. I would not recommend using this app, waste of time !
Unable to Be Used
Every attempt at loading even with just developername and masterlabel results in the same Error: script-thrown exception with no ability to troubleshoot
Very Helpful
Firstly, Thank you! Thank you for creating a native app to update Custom Meta Data. I just tried it in the Sandbox and after a few failed tries, I took some time and read instructions and the feedback from "Sercante Admin" and it works like a charm!! Secondly, I recommend to update your support document to ensure that everyone understands that the "developername" column must stay in column A. Though your image shows this, I am used to having only the 18 digit ID field in my data loader uploads be required. Thank you so much. Katleen
Very useful, but here are some TIPS!
I had a very hard time getting this to work, but I figured out what I was doing wrong. Firstly, your upload file must start with these columns: developername and masterlabel, followed by your custom field data for the metadata type. The other place I got messed up was when you upload the data you will see a NEXT button, this is ONLY to preview your upload. I thought it meant "go to the next step"... lol. After uploading your file click on SAVE! Lastly, go to Deployment Status in Setup to review deployment to make sure it worked.
Hi Sercante, Thank you for sharing your experience! It’s great that you were able to figure it out. Just a quick note: please refer to the provided documentation for detailed steps and best practices. Also, the "Next" and "Previous" buttons are part of the pagination functionality to help you review records easily — they aren't related to the data upload process. We truly appreciate your feedback, and we’re happy to share that improvements based on such inputs will be included in coming version of the tool. Thanks, Tarun Earle
Time waster, not a time saver
You would think that you could use this tool to export custom metadata from one org and import into another, and the tool would create a compatible file that would work. But, no. After wasting 30 minutes editing my file, with nothing but failure, I've decided this is a time wasting tool, not a time saving tool. There are easier methods that work.
Very Difficult to Use
Bug: - Imported first 100 records successfully, but subsequent imports did not add new records, despite success message. Limitations: - No mapping. - Must be CSV Delimited, not CSV UTF-8, even though UTF-8 is the standard CSV format. - Can't handle special characters. - Can't handle over 400 records at a time. - Very difficult to figure out how to use.
Success message but nothing happens
I managed to get through multiple errors and finally my file was accepted. Finally I see the green pop-up saying that 183 records were inserted successfully but in reality there is none. Repeated the exercise 3 times, no luck. Double-checked that it is the same org, performed a query, nope, no records... Did anybody have the same problem?
Very Good tool errors can be better denoted
The reason for 5 stars, Its a free tool, Save you time when loading 20+ values in custom metadata . There was someone available from support when i had issues even when the tool is free. Only downside was that there were special characters in my file and the error it was throwing me was File not found so that could have been better i had to spend a lot of time to figure out what was the error with the csv. Also the csv format is limited and does not support all csv formats so i think i has some issues there as well. But considering overall after putting in some hours of efforts to figure out the issue i was able to load my file in few batches.
Headers need to be correct but works
I used this to load a large group of custom metadata I didn't want to manually create. I encountered errors the first few times I attempted the load, so commenting for folks to avoid them. You must include "masterlabel" (not label) and "developername" columns, then columns for each API field after that. Note - there's no mapping step - it uploads your file & notes how many rows, then you click and it runs it. Super simple but saving a ton of work!
I was going to ask what is considered a special character but I found a workaround. I created an import file with just two columns, "MasterLabel", and "DeveloperName". I imported place holder records with no other fields. Then I used Salesforce Inspector to export all of those new records with the below query, added my values back into the field columns then upserted (insert and update are not options) them with inspector and it worked! SELECT MasterLabel, DeveloperName from Example_Table__mdt
Hi Eddie, Glad it worked that way. It means it is an issue similar to i had. It is not about numbers. Some of your row has special character which then the tool is unable to read and throws error of file not found. I was able to do 20-40 a time once i realised which special characters are causing issues. I removed those rows and then imported. For example i had a country like this which was causing issue "Nuevo León"
masterlabel | developername | test_field__c 1 | X1 | Test value. this is what i have as my columns, and below is what i've confirmed: 1) my system admin has access to the custom metadata type 2) I've selected the correct custom metadata type from the dropdown 3) I've tried both versions of CSV files 4) I have less than 500 rows and this is the error message I'm getting, any suggestions? Thanks! Error:masterlabel is not a valid API Name of Selected Metadata Type. Please use a valid Field API Name for CSV file headers
Very helpful and user friendly
This package is very easy to use and also has very detailed documentation which will guide you to import the metadata records.
Hi Charlie, I hope you went through the documentation provided under the AppExchange product. If not, could you please go through it once? Thanks. Vinay