You need to sign in to do that
Don't have an account?
Tool to extract Data model into excel
Hi
I am new to salesforce. We owned one org and we have 5 application in it. We have also a set of custom objects and relationships.
Is there any proper tool exist to extract the existing data model into an excel sheet.
Ex:- We have Existing Account object. We have created a set of custom objects that is having a look up into account object.
is there any tool exist in appexchange which helps us to extract the relationship that exist with account object to a excel sheet.
Any tool that helps us to extract an object properties to an excel or to a file.
Please help me out on this. Thanks
Hi Babi,
Dataloader is a good tool commanly used in Salesforce to extract data which is exported in a CSV format - we can open that file in EXCEL.
Try the same and let us know if you have any further questions.
See the links below for more info,
http://wiki.developerforce.com/page/Data_Loader
https://help.salesforce.com/apex/HTViewHelpDoc?id=data_loader.htm&language=en_US
https://help.salesforce.com/apex/HTViewHelpDoc?id=exporting_data.htm&language=en_US
Regards,
Ashish
You can also see this video exlpaing with a demo,
http://www.youtube.com/watch?v=_7WvNwSQ0yU
Regards,
Ashish
Hi Ashish
Thank you very much for your quick help. Data loader is a nice tool to extract data.
But i would like to extract the meta data rather than data.
Example:- Extract any object (custom/standard) meta data and all its properties and all its parent and child relationships to an excel just for document purpose.
it would be also better if i can extract a profile and all its settings just for documenting purpose
is there any tool exist for this in appexchange to extract the meta data?
Hi Babi,
You can use another tool called Force.com Metadata API which is also known as ANT, this works on command line and you can export all the metadata or only profiles as per your requirement in an XML format.
http://www.salesforce.com/us/developer/docs/api_meta/Content/meta_intro.htm
To know more about ANT,
http://wiki.developerforce.com/page/An_Introduction_to_Force.com_Metadata
You may also view the youtube video for ANT,
Deploying Salesforce.com Metadata with ANT
http://www.youtube.com/watch?v=f5UlWurQzHQ
Regards,
Ashish
Hi Babi,
I also found this app over the app exchange which can extract metadata,
https://appexchange.salesforce.com/listingDetail?listingId=a0N300000018leZEAQ
Regards,
Ashish
https://archtive-app.herokuapp.com/#services
Best thing is: Its FREE!! (Atleast for now)
Just select the Objects and Click Initiate Workbook
Hello,
I'm not able to download "Herokuapp". Can anyone please help me with that.
Is there any app through which we can download meta data of objects into spreadsheet.
Thank you
We have a free app - Field Dumper - in the Appexchange that might be of interest - It will extract out your objects and fields into to a single Excel file - each object is presented as a separate Excel tab. Api name, field types, size, help text, formula text and picklist values and more is extracted.
https://appexchange.salesforce.com/listingDetail?listingId=a0N3A00000EJg2hUAD
Let me know if it helps anyone out - interested in all feedback.
Thanks,
Sri