function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
kimberlymkimberlym 

Schema Extract Tool

Hi,

 

Does anyone know where to get the schema extract tool?  I am actually just trying to do an extract of all field name, data types and API names and was told that this tool was what I was looking for.  Any ideas?

 

Thank you!

 

Kimberly

Best Answer chosen by Admin (Salesforce Developers) 
AduciAduci

Kimberly,

 

This may help or not.  I am not familiar with the schema extraction tool.  But you can retrieve this information a couple different ways depending on your specific need.

 

1) For Standard Objects : http://www.salesforce.com/us/developer/docs/api/index.htm

2) for an Enterprise's objects (including custom)

   a) Force.com IDE - there is a full schema tool inside and you can even do SOQL queries on it http://wiki.developerforce.com/index.php/Tools

   b)Workbench - web based (same tools link as 2a above)

   c) Direct API call from php or another platform using describeGlobal and describeSObject to see the entire schema and all the details.  Here are some samples.  We have a combined php example if you are interested - http://wiki.developerforce.com/index.php/PHP_Toolkit_13.0_Samples

 

 

Message Edited by Aduci on 04-23-2009 09:54 AM

All Answers

JonPJonP

I wrote that 4 years ago, but I don't even know where to find it today.  The schema extract tool was an internal tool that AFAIK was never publicly distributed, but it might have made its way into an API/integration class.  Sorry.

 

Jon

salesforce.com

AduciAduci

Kimberly,

 

This may help or not.  I am not familiar with the schema extraction tool.  But you can retrieve this information a couple different ways depending on your specific need.

 

1) For Standard Objects : http://www.salesforce.com/us/developer/docs/api/index.htm

2) for an Enterprise's objects (including custom)

   a) Force.com IDE - there is a full schema tool inside and you can even do SOQL queries on it http://wiki.developerforce.com/index.php/Tools

   b)Workbench - web based (same tools link as 2a above)

   c) Direct API call from php or another platform using describeGlobal and describeSObject to see the entire schema and all the details.  Here are some samples.  We have a combined php example if you are interested - http://wiki.developerforce.com/index.php/PHP_Toolkit_13.0_Samples

 

 

Message Edited by Aduci on 04-23-2009 09:54 AM
This was selected as the best answer
kimberlymkimberlym

Thanks for those responses.  I used the Eclipse tool and was able to get the extract.

Kimberly

RedwoodRedwood

hi there ..

 

I am looking to do the same , can you please let me know which with Eclipse tool did you use?

 

thanks