Skip to Content
author's profile photo Former Member
Former Member

Uploading order files

Hi All,

My customer will place(upload) orders in a particular folder, and it gets stored in Portal repository. they will place orders in excel file. this is mandatory. They have their own Plan codes.

My question is:

I need a program that picks a file from a particular folder and store it in DB.

How can i start with it.

Pl explain me.

Thx

PRAdeep

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 28, 2005 at 01:52 PM

    This is how I would do it, but it not the only way.

    1. Create a .NET Service application to scan constantly scan the directory that users are uploading to.

    2. When my .NET Service finds a new file, then I'd save the file in a binary object.

    3. I'd save the binanry object to an MS SQL database with a field type of binary.

    4. Delete the file from the upload directory.

    I'm not sure what technologies your using (oracle/sql, java/.net) but either way, the algorithm is similar.

    Regards,

    Thomas Ficker

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.