> You can't restore backups! You can export your data, but there's no way to import it, because you can't set the object Id or autonumbered fields
Have you tried marking fields for user set IDs as external IDs. This field can then be used while doing upsert. But what do you mean by there is no way to import it? Apart from Dataloader there are a host of companies that offer this feature.
Suppose a bad actor has gotten full access to our Salesforce, deleted everything and emptied out the recycling bin. We need to restore everything.
Luckily, we used the weekly export feature and have all our data, we only need to get it back into Salesforce. But how do we do that?
- Dataloader can only restore one object at a time. We have 350 different objects.
- We need to restore the relationships between objects. They are saved by Id, but we can't keep the original Id. So we have to keep track of the original Id and the new Id for each inserted record, and replace them in every other object. That also means we have to insert the objects in topological order. If there are any cycles or self-relationships (like Account.ParentAccount), we have to fill in the Field with NULL first and update it later.
- Even after all this effort, we still can't recreate the values for autonumbered fields. If it's a custom field, we can change the type to text, insert the values and change it back. For standard fields, there is no practical way to do it. No company can help us, because it's just impossible to do using the Salesforce API.
Have you tried marking fields for user set IDs as external IDs. This field can then be used while doing upsert. But what do you mean by there is no way to import it? Apart from Dataloader there are a host of companies that offer this feature.