1. Update lotus notes database from text file
My boss has given me a new challenge. Learn Lotus Notes programming.
I've now been a Lotus Notes programmer for about 3 months. I've made
some views and forms, but up until now, that's about it.
Now a new chore. I need to update documents in a database from a text
file. This only occurs once a month.
The database is nothing more than records consisting of about 7
fields. Basically a standard vendor information database.
It has the usual stuff.
Vendor Number
Vendor Name
Vendor Address
Vendor City
Vendor State
Vendor Zip
Vendor Phone
Now, the text file, being obtained as comma delimited, will contain
any of the following:
1) A row with exacting information
2) A row with changes to the individual vendor
3) A new vendor
4) Special: a vendor no longer used so it has been omitted. (Hence
not in the text file)
Problem:
Need to somehow update the .nsf database with this new text file to
reflect the changes/additions/deletions.
Current solution my company has been using:
Delete ALL records and reload from the text file (Whew, I'm not real
keen on doing that anymore!)
Possible Solutions:
1) I thought about making another replica database and, when the time
comes, delete ALL the records from my newly created secondary
database, then load the text file into it, then allow replication to
go one-way only. This would update the production database with the
records. Not really sure if that would work or not.
2) Create my secondary database, delete ALL the records, upload the
new text file. Create a simple agent to copy the documents over to
the production server.
In the Agent's settings, choose the setting for which documents should
be copied >> All new and modified documents since last run
3) Create an Access database and somehow link the two up and have
Access update the Lotus Notes database. This seems a little harder to
get working though.
So,
I would appreciate any feedback that anyone could give me.
Thanks for your time,
David
2. at+a8e?
3. Updating Notes 4.1 db from text file. Options...
4. Running Matlab with Dual Xeon Processors
5. Why Error updating local ID file?
6. BUS ERROR WITH SAVING
7. os/2 file requestor update ftp
8. Teac R55S No DAO in EZCDC 3.01A ?
9. URGENT!! Updating smarticons UNIVERSE.SMI file via LotusScript
10. Error updating local ID file
11. Update Database from Input File?
12. Updating with .col files via script & agent
13. Reliable way of remotely updating ID files on Servers?