I'm just wondering what options are available for setting up a site to mirror both ways.
I've setup mirroring on my site to publish from a staging to a production server, however my site has a form which users fill out on the live site and stores information to the dynamic data store.
I would like the information to be synched back to the staging server so that editors can view the updated form data. This would be fine if using an architecture where both staging and live use the same database but the client doesn't want this.
Has anyone got any pointers on what the options are for mirroring the Dynamic Datastore back from a live to a staging server?
Start with this blog : http://world.episerver.com/Blogs/Johan-Bjornfot/Dates1/2011/3/Mirror-other-than-content/
It explains how to Mirror non-page / file data such as that in the DDS. If you have any further questions after reading this then post them here.
Hi Paul thanks for helping.
I've looked at the article you suggested, and after that this one http://world.episerver.com/Blogs/Johan-Bjornfot/Dates1/2010/1/Custom-Export--Handle-your-own-stream/. I then setup a test module, and have a question?
When using XFormData.GetStore() to retrieve the dynamic data store there is no externalid when i use store.GetIdentity()
code is below:
Guid formId = newGuid("D883EF9B-88DE-43E2-83ED-DD3D08E50215");
DynamicDataStore store = XFormData.GetStore(formId);
var externalID = store.GetIdentity().ExternalId;
var storeName = store.Name;
NB: I set up an example module similar to this one by Joshua Folkerts http://world.episerver.com/Modules/Forum/Pages/thread.aspx?id=51568.
I have written a class that exports XForm Posts as part of a Mirroring job but unfortunately when testing it we have found 2 bugs which stop this from working.
You have 2 options:
1) You can request a hotfix via our support department quoting bug number 73713. Once you have the hotfix, post again on this thread and I will upload my class
2) You can use the XForms Search Gadget (http://world.episerver.com/Blogs/Paul-Smith/Dates1/2010/8/EPiServer-CMS-XForm-Search-Gadget/) which I developed which supports export to CSV file. From there you can import to a new database table in your staging environment.
Thanks for your help so far, I've contacted support who have provided me with hotfix 73845 to address bug #73713, would you be able to post you rexample class.
Unfortunately option 2 is not what I need
I will get the hotfix and test my solution. All being well I can post it later on today.
I have uploaded my code here -> http://world.episerver.com/Code/Paul-Smith1/Exporting--Mirroring-XForm-Posts/
Please ensure you read the comments I have added about the "autoreset" parameter
Thanks Paul works perfectly.