Parsing a text file.

I apologize in advance for this question.  I'm sure you get it constantly and you probably cringed when you read the question title.

I am working with a Silverlight application (C#).  My application gathers information from my clients, quite a few server-side calculations are done, and then the analysis is delivered back to my clients.

My clients upload raw data files (usually fixed width or delimited text files) with vast amounts of information in them, most of which I don't need, to my server.  There I parse the files and send the data back to the client to be displayed in a datagrid for validation purposes, essentially making sure the files are mapped appropriately.

I am looking for a way to eliminate the trip to the server before data validation.  I would like to handle the parsing of the text file client side.

For what it is worth, I have access to ComponentOne's C1Data product for Silverlight, which basically gives me a subset of the System.Data namespace.

Thank you very much for your time.
CharlesMartel732Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DarrenSenior Software EngineerCommented:
Hi,

I am just wondering why you feel the need to validate this client-side.

Personally, I would keep this on the server side for a couple of reasons
1) because the server does all the work
2) if you changed from silverlight to web pages or winclient you would not have to re-wite the client code

These are just two and I'm sure there are more....

Obviously if the files are large then this may impact parsing as you have the overhead of uploading the file first. But I would still prefer parsing on the server.

This is my two cents....

Cheers,

Darren
0
CharlesMartel732Author Commented:
Thanks for taking the time to reply.

The vast majority of the time clients are using data files that contain sensitive information and they don't have the ability to remove that information themselves.  

Even though I can take precautions to secure the data when it is transmitted to my end, I think it will give them peace of mind if I can remove all unnecessary, and sometimes sensitive, information client-side.

For what it is worth, I am not an expert in these matters so if you think I am off-base here, your comments would be very much appreciated.

Thank you.
0
DarrenSenior Software EngineerCommented:
Hi again,

Where security is concerned, it will be a case of keeping the client happy. If they do not wish to have something transmitted that you will have to take precautions on the client side.

As you said you could secure the data both before transmission and during transmission, however, if the client does not want it sent over the wire for whatever reasons then you have little choice but to remove this before it is sent.

Hope this helps,

Darren
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.