Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: Lotus Notes "Agent" script
23 views
Skip to first unread message
§ñühwö£f
Aug 3, 2011, 5:23:00 PM8/3/11
to
Mike Yetto wrote:
> M <spam...@spambouncer.org> writes and having writ moves on.
>> I have to carryout an update to a Lotus Notes database which has many
>> thousands of entries. There is a category field with a choice of
>> approximately 60 categories, 30 or which need to be changed to an updated
>> term. I have been given a CSV file containing both the old and new term
>> that I hope to use as a lookup table. To do this I need to write an
>> "Agent", Lotus speak for there equivalent of VB Script, but do not know how
>> to do this.
>> I would be grateful for any advice or code samples.
>> Thanks
>
> If this is a serious RFP you should include a little more
> information.
>
> Mike "and send it somewhere else" Yetto
> M <spam...@spambouncer.org> writes and having writ moves on.
>> I have to carryout an update to a Lotus Notes database which has many
>> thousands of entries. There is a category field with a choice of
>> approximately 60 categories, 30 or which need to be changed to an updated
>> term. I have been given a CSV file containing both the old and new term
>> that I hope to use as a lookup table. To do this I need to write an
>> "Agent", Lotus speak for there equivalent of VB Script, but do not know how
>> to do this.
>> I would be grateful for any advice or code samples.
>> Thanks
>
> If this is a serious RFP you should include a little more
> information.
>
> Mike "and send it somewhere else" Yetto
How about we xpost it to the relevant groups?
<nods>
--
http://www.ltsaloon.org | www.extinctioncrisis.org
www.snuhwolf.9f.com|www.savewolves.org
_____ ____ ____ __ /\_/\ __ _ ______ _____
/ __/ |/ / / / / // // . . \\ \ |\ | / __ \ \ \ __\
_\ \/ / /_/ / _ / \ / \ \| \| \ \_\ \ \__\ _\
/___/_/|_/\____/_//_/ \_@_/ \__|\__|\____/\____\_\
Klaus Johannes Rusch
Jan 19, 2012, 7:57:01 PM1/19/12
to
>>> I have to carryout an update to a Lotus Notes database which has many
>>> thousands of entries. There is a category field with a choice of
>>> approximately 60 categories, 30 or which need to be changed to an
>>> updated term. I have been given a CSV file containing both the old
>>> and new term that I hope to use as a lookup table. To do this I need
>>> to write an "Agent", Lotus speak for there equivalent of VB Script,
>>> but do not know how to do this.
>>> I would be grateful for any advice or code samples.
FIELD cat :=
>>> thousands of entries. There is a category field with a choice of
>>> approximately 60 categories, 30 or which need to be changed to an
>>> updated term. I have been given a CSV file containing both the old
>>> and new term that I hope to use as a lookup table. To do this I need
>>> to write an "Agent", Lotus speak for there equivalent of VB Script,
>>> but do not know how to do this.
>>> I would be grateful for any advice or code samples.
@If(
cat = "oldvalue1"; "newvalue1";
cat = "oldvalue2"; "newvalue2";
...
cat = "oldvaluen"; "newvaluen";
cat);
SELECT @All
--
Klaus Johannes Rusch
klaus...@atmedia.net
http://klausrusch.atmedia.net/
0 new messages