Hi Thang,

What are you trying to do with the data? As you noted, the data is going into the database anyway.

You also didn't mention your version of Forms, but you should be able to do something like this:

public class ExamplePostSubmissionActor : PostSubmissionActorBase
{
	public override object Run(object input)
	{
		var submissionData = this.SubmissionData;

		// Persist the submission data as you want!

		return new SubmissionActorResult();
	}
}

Hi Jake Jones,

Actually i want to export the submmited data to csv file. I know we can export it on CMS at tab "FORM" but currenty i have the old data in csv file but i don't know how to import or merge data from old csv file into submitted data in episerver form that why i want to store submitted data form to another table wich i can easy to manage it instead of submitted data alredy store in BigTable.

Do you know how to import data from csv to episerver form? and is the any Services to get data from episerver form?

I am using EPiServer.Forms version 4.27.1.0

Regards,

Thang Le

Hi again,

I'm not sure I fully understand your requirements, I'm struggling to think of a scenario where importing already submitted form data into the CMS would be the best approach.

Regardless, there isn't a out-of-the-box way to import a CSV of data into the CMS, so you'd have to create this yourself. Despite the risk of playing around with the database tables, ff you have an existing BigTable with the data and it's a one-off task you'd probably be best off (effort wise) with an SQL migration. Otherwise, you'll want to dig into the DataSubmissionService (EPiServer.Forms.Core.Internal) and DdsPermanentStorage (EPiServer.Forms.Core.Data) and look at how form data is persisted into the DDS—things like maintining the submitted time will be more effort. Definitely not something I'd recommend.

With exporting, do you need to export the data regularly? If so, considering you're on an older version of Forms you could look into the Service API:

• https://world.optimizely.com/documentation/developer-guides/forms/using-forms-serviceapi/
• https://nuget.optimizely.com/package/?id=EPiServer.Forms.ServiceApi

If neither this or the UI export give you what you want then you'd have to build something out again. If that case, you'd be best off researching the exsiting export functionality like the DataExportingService (EPiServer.Forms.EditView.Internal).

If you're just looking to be able to get form data, you can just use the IFormDataRepository (EPiServer.Forms.Core.Data).

Hopefully something above helps. From an outside perspective, it feels like it'd be worth revisiting requirements here. You seem to have some oddly specific needs that involve a lot of work and touch internal namespaces.