Import and Export...more so imports
wdinzey@dpdsoftware.ca
11-3-18
Hi,

We have a client who processes a lot of transactions monthly. Last month the bank reconciliation file from one account contained over 15,000 records and this is a normal month. Their busy months run from December to March/April.

We have written a fairly powerful auto-reconciliation interface driven by rules which auto-create G/L transaction and then mark then as reconciled. Now we are importing, generating transaction and reconciling them but some of the transactions are being matched by string comparisons so the import is a bit tedious and slow (2 to 3 minutes).

When running this utility we are seeing clients on the network go dead and even the user running the import is getting the "Restart or Quit" message as the server is not responding. Of course, waiting a random amount of time the system returns to normal and processing can proceed.

We began thinking that what is needed is really to see import and export (again more so "import") moved to it's own stream within the application or something to this effect. This brought me to thinking what are other partners doing in these import heavy environments?


Is there anything existing in SERP and HAL that we can do to stop the import from hanging the system as we have a second client who moves items out (export aprox...2,000 items) for the purpose of building a catalog and they experience this issue as well. It is a small database but we are formatting the out file for them to use in their catalog builder but in any light this is not a real heavy workload.

Thanks in advance for all advise.

Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Latest Posts
Bror-Erik Kotiranta
Clients have their own cache, and then the server has the shared cache, if you want it kind of black and white. Presense should be there as far as i know...
10:55 7 July 2025
Yavuz Yigiterhan
Hello Paul, That is something only HansaWorld can do. But that would help to understand is that causing the problem and - if so - we fix the issue. Additional information is appreciated. Yavuz...
10:45 7 July 2025