On 6/22/2017 3:40 PM, Paul H. Tarver wrote:
My first thought when I read this was that I would create temporary
cursors (CREATE CURSOR) to import the data initially and then add the
new records to
[snip]
Agreed with temp cursors. It gives you incredible flexibility if you
need it. No worries about table locks etc.
As another option, you could use Excel automation. But I would not
recommend that if the import has a performance requirement (e.g. get it
loaded within 30 sec). Another downside is the computer performing the
data load would have to have Excel installed.
In both the above cases, you can do the record inserts one at a time,
removing the worry about long "table locks", etc. And you could even
give a progress bar as you do the inserts.
HTH,
-Charlie
-----Original Message----- From: ProfoxTech
[mailto:[email protected]] On Behalf Of Ken Dibble
[snip]
I've been given the task of importing data from a spreadsheet into my
multi-user system. I have not done any testing on this but it is
possible that the import process, run every week or every two weeks,
will create thousands of records that will be "children" of a few
hundred "parent" records. The system is in near constant use by
somewhere around a half-dozen people, and much larger numbers use it
occasionally. Some of the half-dozen intensive users are quite likely
to be accessing the parent records at the time the bulk import process
is creating the child records. I am concerned about creating massive
access conflicts leading to race conditions, freezing of the system,
and/or data corruption. Should I just block everybody from saving any
data while the import
[snip]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
