Thursday, February 14, 2008

Generate MS CRM Entity Schema.


Hi,
"GenerateEntitySchema" tool generates a MS CRM Entity Schema.
Example "account": it generates the schema for all the attributes including (picklist values).
Have a look at this tool. (See screenshot)





you can download Generate MS CRM Entity Schema from http://www.codeplex.com/GenerateEntitySchema

As I'm working on this tool i'll release the source code soon.

All feedbacks are most welcome. !!!


Happy MS CRM Development.

23 comments:

Anonymous said...

Does it work with MS CRM 3.0?

Ranjitsingh Raghuwanshi said...

Yes, it is compatible with MS CRM 3.0 and 4.0.

Livros e Revistas said...

Hello. This post is likeable, and your blog is very interesting, congratulations :-). I will add in my blogroll =). If possible gives a last there on my blog, it is about the Livros e Revistas, I hope you enjoy. The address is http://livros-e-revistas.blogspot.com. A hug.

DVD e CD said...

Hello. This post is likeable, and your blog is very interesting, congratulations :-). I will add in my blogroll =). If possible gives a last there on my blog, it is about the DVD e CD, I hope you enjoy. The address is http://dvd-e-cd.blogspot.com. A hug.

Anonymous said...

Thanks a lot. Exactly what I needed to generate the schemas. Erwin.

Anonymous said...

Hello,
I tried to download your tool MS CRM Entity Schema but couldn't find it on codeplex.
Where can I download it ?

Thank your for your answer,

Julien

Ranjit said...

please reply with your email address. I'll send exe of the project.

I think codeplex removed the link.. they are very bad people, without notification they removed.... its really bad.

Cheers,
Ranjit

Ranjitsingh Raghuwanshi said...

Hey,

Now you can download the file please visit the link "http://www.codeplex.com/GenerateEntitySchema/Release/ProjectReleases.aspx?ReleaseId=19738"

Please let me know if you need further information.

Thanks,
Ranjit

Juliendichter@yahoo.fr said...

Thank you for your quick answer.
I downloaded your tool today.
Great work !

Julien

Anonymous said...

Hi Ranjit,

Currently i am working on Ms CRM 3.0.Its new for me. i need to generate the schema of CRM entity and read it through .net.can u please help me out ?
I found your tool similar so thought to ask u.

Thanks !

Ranjitsingh Raghuwanshi said...

Hey, what exactly you need from me?Please let me know, if i can be of any help.

thanks,
Ranjit

Anonymous said...

Hi Ranjit,

If u can let me know the way how i can read the MS CRM form and generate the RDL files dynamically based on that entity schema.
It will be great help for me...
Thanks for quick reply

physicist said...

Hi,

I tried obtaining schemas for entities using http://crmappserver/sdk/xsd/entity.aspx?entity=entityname
but i can find the folder "XSD"in crm 4.0 ny clue on why it is not there ?

Ranjitsingh Raghuwanshi said...

Hi physicist,
I didn't understand your problem.
CAn you please brief it clearly?

Thanks,
Ranjit.

Ranjitsingh Raghuwanshi said...

Hi Physicist,

In MS CRM 4.o, you can use below url to obtain entity schema:

http://localhost:5555/Sdk/MDBrowser/Entity.aspx?entity=account


please let me know if you have any more questions.

Thanks,
Ranjit

physicist said...

Hi Ranjit,

Thanks 4 your swift response.Appreciate it!

Actually am attempting to get the XSD Schema for individual CRM entities..when i was searching for it i saw an article stating that i could get the XSD schema of individual entities-For Instance if i need to obtain the XSD schema for account entity,i could do it with the url -"http://localhost/sdk/xsd/entity.aspx?entity=account"......but no go as i could not find the Directory ??XSD ..so i was wondering if it is available only in CRM 3.0..Hope this helps

Ranjitsingh Raghuwanshi said...

Hi Physicist,

In MS CRM 4.o, you can use below url to obtain entity schema:

http://localhost:5555/Sdk/MDBrowser/Entity.aspx?entity=account


please let me know if you have any more questions.

Thanks,
Ranjit.

physicist said...

Hi Ranjit,

It takes me to the metadata browser,where the the entity metadata is displayed in an Aspx page but i need the XSD for an entity.


Essentially speaking,
It is available as a huge chunk(i.e for all the entites) in the metadatadata service.wsdl file..but am thinking if there is any way to do retrieve the XSD file for a particular entity.


could you pleasetake a look at this url :"http://customerfx.com/pages/crmdeveloper/2006/02/17/getting-xsd-schema-for-crm-entities.aspx"

and

http://customerfx.com/pages/crmdeveloper/2006/02/15/16480.aspx


The First url describs an aritcle where we can obtain the XSD schema

and the later one represents the metadata Browser through which we can drill down on seperate entities.

My Ambiquity floats around the article that is described in the first URL

physicist said...

Hi Ranjit,
I am using ur Schema generator Tool..what is the significance of method Insert and Update that u've added?

Ranjitsingh Raghuwanshi said...

Hi,

The advantage of the tool is that, it genereates the metadata for each and every entity. If you look at the MS CRM EntityMetadata XSD Generator, it won't give you the complex type of data, such as:

Picklist(all Values).
Boolean (True, False Values)

and so on.

And you can easily PARSE this XSD.

Thanks,
Ranjit

physicist said...

Hi Rantjit,

What is the difference between the InsertDynamicSchema.xsd and UpdateDynamicSchema.xsd that the Application is generating?

Ranjitsingh Raghuwanshi said...

There are some fields which are applicable for Insert and Update.
There are some fields which comes in picture when updating an enityt record.

Thanks,
Ranjit

Anonymous said...

hi ranjit!!
i need to badly badly generate xml scheme for custom entities in my ms crm system. it is an ifd deployment...can ur tool work on that? plz help me..i have to do this as part of my job project and i hav never worked with xml or crm before ..plz help me ranjit!!