Mirroring Both Ways - DDS

Vote:
 

Hi,

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?

 

#54413
Oct 13, 2011 11:22
Vote:
 

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.

#54438
Oct 14, 2011 15:25
Vote:
 

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;

ddsHandlerObj.AddToExport(externalID, storeName);

 

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.

 

#54581
Edited, Oct 21, 2011 17:45
Vote:
 
#54582
Oct 21, 2011 18:26
Vote:
 
Hi Shaun. You're barking up the wrong tree slightly. I will write a code sample for you on Monday which exports an XForm definition and all of it's posts. Cheers Paul
#54583
Oct 21, 2011 18:27
Vote:
 

Hi Shaun.

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.

#54607
Oct 24, 2011 14:21
Vote:
 

Hi Paul

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

Shaun

 

#54941
Edited, Nov 10, 2011 11:00
Vote:
 
#54942
Nov 10, 2011 11:01
Vote:
 
#54943
Nov 10, 2011 11:01
Vote:
 

Hi Shaun.

I will get the hotfix and test my solution. All being well I can post it later on today.

Paul.

#54958
Nov 11, 2011 9:43
Vote:
 

Hi Shaun.

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

Paul.

#54985
Nov 14, 2011 15:51
Vote:
 

Thanks Paul works perfectly.

#54992
Nov 14, 2011 17:04
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.