I am trying to find a quick way to create tables in a SQL database that mirrors the confgiuration of objects in Salesforce. It is easy enough to generate an enterprise WSDL that shows that the current object structure. Does anyone know of a tool that will convert it to a SQL create statement? Any other suggestions on how to quickly generate tables for a SQL based database so you can load a mirror of your data?
Has anyone else noticed some unexpected behavior with the latest version of the Data Loader, version 21.0? Here is a list of just some of the issues that I've come across that do not occur when using previous versions of the Data Loader:
- When attempting to update a small subset of fields contained in the .csv file but not all (ie. mapping only a few fields), the Data Loader throws an the Error: Failed to find mapping for '<one of the unmapped fields in the .csv file>'. However, if all the fields in the .csv file are mapped, it appears to work correctly. Previous versions had no problem with mapping only a subset of fields contained in the .csv file, my guess is this is a bug.
- After successfully completing an Export, the Data Loader stops responding to any action button click for Insert, Update, Upsert or Delete. However, it will let you choose Export or Export All. I cannot tell if this one is a new "feature" or a bug.
I have created a Record Type for Opportunities. I have decided against using a Record Type so I now want to delete it.
I clicked Del and it lists the profiles that are using the RT. I have edited each profile, resetting the Record Type back to Master.
This works except for Standard Platform User. This profile does not have an option to set the RT for the Opportunities object. Opportunities is not listed at all for this profile.
I am now stuck with an unwanted RT. I can't delete it as SF says the profile is using it as the default.