1

Is there any automation where we can create dummy data for a newly created org. If i have a excel sheet with multiple sheets in it. Like Account, Contact, Opportunity can we import it.

  • Is this a new sandbox for an existing org or a completely new Org? If it is completely new you only have the option of importing the data from Excel by saving into .csv files for each tab then using Data Loader or the Data Import wizard to load it. – Dave Humm Apr 4 '16 at 10:56
  • And if it is for existing org how to automate it.. – hellraizer Apr 4 '16 at 11:00
  • Have a look at the Answer Mihai provided, also Full Copy sandbox automatically takes all data from production or Partial Copy sandbox can take a snapshot of some production data. Otherwise you are pretty much stuck with uploading even if you automate the upload. – Dave Humm Apr 4 '16 at 11:04
7

You could take advantage of the new feature to run a script when a sandbox is created or refreshed. You can find details about the feature in the latest release notes. I would run some apex code that will insert generic accounts or contacts or call an external system that has that spreadsheet uploaded or even a database.

  • How to use Run Script After Sandbox Creation and Refresh for creating accounts, contacts and opportunity.. Can u share some code if u hv.. – hellraizer Apr 4 '16 at 11:26
  • I don't have any example of a code. But if you look at the release notes, there is an example. You then need to create an Apex class that creates 100 Account, then 200 Contacts and link them and so on. It's basically Apex, and inserting Accounts and Contacts – Mihai Neagoe Apr 4 '16 at 11:35
  • Hi, where we need to write the interface.. – hellraizer Apr 4 '16 at 12:23
  • It will be on the class you specify in the user interface that will be run as part of the post copy event – Mihai Neagoe Apr 4 '16 at 12:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.