Skip to Content
avatar image
Former Member

Updating Database From csv File in Web Dynpro Java

Hi Gurus,

I'd like to write an WDJ where the (super-)user can upload a csv file and delta-update the content of this file witch an external database.

Could you please give some me hints & examples.

Thanks in advance,

Farid

ps. answers will be rewarded with points, of cource.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 08, 2008 at 07:23 AM

    Hi Farid:

    From your question it seems like you want to write a WDJ application which writes a CSV file after connecting to a database and everytime you do so, updates the file with the new record from the DB.

    For this, I wouldnt think to write an application in WebDynpro since its an over kill, unless you want to host this appln in a portal environment and want it accessible for a set of people.

    Ideally you could use the JDK api to open a connection to the database and then then file api to write to files. You would need to use an identifier somewhere to know the last record read and written to the file.

    Incase you put in the type of db you want to connect to, i could be of more help

    Thanks,

    LioneL

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi LioneL,

      actually its the other way around. I want to read a csv file (containing new information) and update the database from this csv.

      Since the application should run in EP, I was thinking of WDJ. Maybe it's possible to do it with Visual Composer, also?

      kind regards