Convert or Replicate Table (Accidental Activity Table)

[Sheikx800]

Hi All,

In my journey of creating an app and setting up my dataverse database, I have set up a couple of tables as 'Activity Tables' without fully understanding what they are or how they operate. Now being further down the line with the project and reaching the stage of configuring security and permissions, I now realise that you cant configure security roles individually for Activity Tables. A crushing rookie error.

My lack of knowledge and little success with searches leaves me with no other option but to delete and re-create the table. There is no data in any of these tables yet, so there is no real 'loss' other than the time it will take to re-create them (which is significant on one of them... there is a LOT of entities in one of them). With that said, I thought I would ask the brains trust before I spent 5-7hours on it.

Is it at all possible to:

A) Replicate the table entities into another table 

B) Clone the table while changing its type (from Activity to just a normal table)

C) Change the Activity table to a normal one (suspect I know the answer to this one)

D) Change the Activity table to permit the same security configuration options as a normal table

Just reiterating, this project is still in early development. There is no production app or data in the system. 

Thanks in advance!

[GuidoPreite]

you can't convert between normal and activity type after the creation.

You have two ways:

1) recreate the tables manually with all the included stuff

2) create the new table but save some time with the XrmToolBox tool called "Clone Field Definitions Plugin" that is able to copy fields from a table to another table (this tool just copy the columns, other things like scripts, form customizations are not considered)

hope it helps

[Sheikx800]

Thank you @GuidoPreite - Definitely not what I wanted to hear but certainly what I expected.

Most people would probably just get on with creating a new one, but I have over 200 fields in one of these tables so it was little crushing to consider re-doing that. That xrmToolbox plugin just might be my saving grace for that one. We often learn the hard way!

[rampprakash · Accepted solution]

Hello @Sheikx800,

As mentioned by @GuidoPreite there is no OOB behavior to achieve the same. 

But 🙂 there is an XrmToolbox plugin called the Clone Field Definitions Plugin that can copy all your columns from one Table to another.

The Attributes Factory is a similar one where you can export out the columns of an existing entity, then create them for another table.

Before doing all Operations, you need to create your TABLE first.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

[Sheikx800]

Thank you @rampprakash - Attributes Factory sounds extremely as it sounds like I could create a snapshot of the existing tables, delete them, and then re-create them. Which would be great for avoiding name changes and such. I am going to play with this in the next few days and mark a solution afterward.

[Sheikx800]

Thanks to you both for your responses. Giving the solution to @rampprakash for mentioning the Attributes Factory tool. It saved me a tremendous amount of time re-creating all those fields.