Hi allI need import CSV file to my nsf database that contain about 600000 records and its size is about 50 MB
What is the most efficient way to do this task ?
Thank you in advance
Subject: I have done this before by first bringing to Excel, than saving as a 1-2-3 file
I think you need the wk3 extension. Then I create a .col file that can be used to further refine the import. Read the help for the Notes client on the col file for examples.
Howard
Subject: Me too… until MS Excel 2007
MS Excel 2007 dropped saving as any wks format which makes simple imports a pain.
Subject: Frustrating
This is a big issue for me. I am often requested to import data from excel into notes which seems to be so difficult to achieve as it doesn’t support the common formats of spreadsheet files.
Subject: Frustrated here too
It is near embarassing to tell the users we cannot import from Excel.
Subject: Frustrated here also
When is IBM going to stop renaming all their products every 5 minutes and fix something as basic as this ???
Subject: But it’s so easy to do!
Just set up a col file and import awayLook in the hrpl file for “Writing a COL file for a worksheet”
Subject: Absolutely
This is perhaps the greatest mystery about Notes in my eyes: Why does IBM refuse proper integration with state-of-the-art desktop productivity tools? Even with their own Symphony suite they never managed to really achieve a decent integration, let alone with the market leader MS Office.
Subject: You can import CSV easily.
Using a COL file.
More details here:
But as an example.
Simon O’Doherty, 555-12345, 1 Main Street
Your COL file might look like:
FirstName: UNTIL " ";
LastName: UNTIL “,”;
PhoneNumber: UNTIL “,”;
AddressLine1: UNTIL “”;
After you have your COL File created, you just do a “file->Import”, then select Tabular Text and your CSV file. After that select your COL file.
Other then this you can also write LotusScript or Java to read the file and import.
For things like Excel you can use VBA and COM to transfer the data to a Notes Database.