Uploading order files

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Thomas,

It has to store in R/3 database(DB2).

how can i proceed?

Thx for ur time.

Pradeep

[Former Member]

Hi Thomas,

I want to use Java to develop this.Can i use PDK or Visual composer.

Thx

PRadeep