Problem solve Get help with specific problems with your technologies, process and projects.

Importing and exporting data from the .csv file on the Web

How can I import data from the .csv file and export data to the .csv file on Web. Would you provide sample code?
This is done quite often and can work well, but requires Lotus Script or Java to accomplish this via a browser or ftp. You will need to have the file uploaded via the upload control in a browser or enable ftp to Drop the file on the server. Once the file is there you can use a scheduled Lotus Script agent to import or parse the data and post each row into a form. You may also easily write document data out to a .csv file using the "write" statement in Lotus Script.

Reading a .csv

Open ifileName For Input As ifileNum

Do While Not Eof(ifileNum)
Input #ifileNum, string1$, string2$, maybe_a_number%
Doc.string1 = string1
Doc.string2 = string2
Doc.maybe_a_number = maybe_a_number%
Call Doc.save(false, false)
Close ifileName

Dig Deeper on Domino Resources - Part 7



  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...