+ Start a Discussion
terry.young1.3909318881316929E12terry.young1.3909318881316929E12 

Export Objects Field Definition

Hi,

Is there a way to export the objects' field definition (name, label, type, length etc...) to xls?

Thanks,
Terry
Satish_SFDCSatish_SFDC
You can use the Force.com IDE or the Force.com Migration tool to get the metadata of the various fields in the objects.
These metadata files are in the XML format.
You can then open these files in excel and you will have all of the metadata files in an excel format.

Hope this helps.

Regards,
Satish Kumar
terry.young1.3909318881316929E12terry.young1.3909318881316929E12
Thanks Satish.

Are you referring to the object files (objectName.object) in the src\objects folder from IDE export?  Maybe I missed a step or two or did it incorrectly. I open the Account.object file, I got a warning "file format different than file extension". Continuing with opening the file, pick "As an XML table" from the 3 options. There are total of 119 lines, I assume column D "ns1:fullName" is the column name and only see a handful of fields (AccountSource, CreatedById, Industry, lastModifiedById, OnwerId, Ownership, ParentId, Rating, and Type). 

I have a good feeling that I am doing something wrong. Theoritically, it should not be that diffcult.

Thanks,
Terry
Satish_SFDCSatish_SFDC
If you open the xml file in a text editor like notepad or notepad++ and you see all the fields then you should also see them in the excel file.
The excel file is just a different way of presenting the same xml information (in columns and rows format).

Can you please check the xml file if you see all the fields.

Regards,
Satish Kumar
terry.young1.3909318881316929E12terry.young1.3909318881316929E12
Yeah same. I don't see all the fields. It's same as opening with excel.

Thanks,
Terry
Satish_SFDCSatish_SFDC
If its not there in the metadata file, it should not be in the excel file.

We should then check why the fields are not coming up in the metadata file.
What fields do you think are missing? Can you check in Salesforce if you have access to them? Are you using a System Administrator login to download the metadata files?

Regards,
Satish Kumar
terry.young1.3909318881316929E12terry.young1.3909318881316929E12
The majority of the fiels (Account Name, Account Site, Description etc..). It's a Developer Edition org that I am testing in. I can see those fields in Eclipse and Force.com. The API WSDL has most of the definition but not all. It's missing Length and Option Values for the PickList fields.
terry.young1.3909318881316929E12terry.young1.3909318881316929E12
Actually I take it back. The Account.object in Eclipse doesn't have the other fields. I was mistaken with the schema.

Thanks,
Terry
terry.young1.3909318881316929E12terry.young1.3909318881316929E12
Looks like "Object Metadata Snapshot" app is what I am looking for. Works great. Thanks for your help.
Jon SnowJon Snow
Use Salesforce DevTools, seconds to export Objects Field Definition as Excel xlsx file.

https://www.xgeek.net/salesforce/tesforce-for-google-chrome/