How can I read .srx files and save data to database using .NET platform

Question

0.00/5 (No votes)

See more:

i have file from my client in .srx format i need to read data in those file and save this in database . i have searched in in internet for solution but i cant find any.

What I have tried:

i have googled to find out an answer. but there is no sufficient data on this topic.only found that it follow xml format

Posted 15-May-16 20:39pm

rajin kp

Updated 15-May-16 21:01pm

Add a Solution

Comments

Garth J Lancaster 16-May-16 2:56am

surely the most logical approach would be to ask the client for the xml schema/layout and work from there - else its just guesswork (and since you havent and likely cant show us what it looks like, we cant advise much)

Once you have the xml schema/layout from the client, then you can think about how best to represent the data so it can be mapped to the database schema - using things like AutoMapper, PetaPoco etc can make this easy, but at the moment, there are too many unknowns in your question.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2016-05-15T21:01:00

Start by finding out what an SRX file is - Google and Wiki can help: Segmentation Rules eXchange - Wikipedia, the free encyclopedia[^]
That says it's an XML based file, but that it's difficult to process in some languages.
It also says there is an open source app that processes them: Ratel[^]
Since it's open source, you can grab a copy of the source code, and try to modify that to fit your needs, or at least work out exactly what you need to do in your app.

Do not expect this to be trivial, and do not expect anyone to go "here is the code, just use this" - this is a specialised file format which may be unsupported since 2011, so you probably won't find that many people using it!