Hello All,
I am looking at alternatives to a current integration process that
uses external .CSV files and Remedy Import called by runmacro. (We
have had some issues with file permissions and runmacro.)
I have set up a View form to a table with the data and added some
display only fields to it for translation and workflow, the principal
one being a zTmpProcess field (Yes/No). I have one filter that pushes
a value of "Yes" to this field on the form for all entries (~40,000),
and a set of filters that fire off of Modify to translate some of the
information (set other temp fields to mapped values) before pushing it
to SHR:People.
The process works fine when I run it manually for 1,000 or so entries,
but when I let the workflow kick off a change to all 40K, I get a
database timeout. I'm considering some chunking strategies like using
an SQL statement to set another flag and loop through, processing
1,000 at a time, but I thought I'd check to see if anyone else has
done something similar, or if there's a simpler strategy that may be
eluding me at the moment.
Thanks in advance for your time,
Kelly Logan
Cybernetic Solutions, Inc.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
