Importing a csv file using Lotusscript......103 record limit?
Posted on 2004-04-14
Hopefully there's a simple answer to this.....I'm writing a Lotus Script procedure to open up a csv file and create a new document for each row in the file. The problem is, though, that when I run my code, Notes freezes after successfully importing 103 rows. Why does it get to 103 then give up?....it's not the file, as I've tried with different test data and it always gets to 103 then dies.
Here's the main loop in my code:
'Prompt the user for an import file
varImportFile = workspace.OpenFileDialog(False,"Please select the inventory file...","csv files|*.csv")
If Isempty(varImportFile) Then
'No file was selected
FileNum = Freefile()
Open varImportFile(0) For Input As FileNum
Do Until Eof(FileNum)
Input #FileNum, strDateScanned ,varLocationCode ,varLocationDescription,varAssetCode ,varSerialNumber ,varDescription
Set uidocInventory = workspace.ComposeDocument("","", "Vendor Inventory")
uidocInventory.FieldSetText "Vendor_ImportStatus","No Errors"