Hello,
We are going to upload data to general journal about more than 5,000 record through excel even directly in server taking more than 2 - 4 hours could anyone help me to fix where the problem is?
looking for your kind support!
best wishes
*This post is locked for comments
There are many options to upload the data:
- use RapidStart (preferred option), it allows to process lots of data without problems
- use Excel Importer
- convert Excel data to text and import that through XML port
- use SQL methods of transferring data
Also, such exports are normally done within non-working hours, when database is not loaded with user interactions. The slow down might be the case of heavy database usage by users or some batch processes.
Hi Nematullah,
I have Universal Excel Import Export tool which can help you exchange data via Excel quickly.
Please take a look at mibuso.com/.../universal-excel-import-export for detail!
Please email me if you need Evaluated License!
Hi Nematullah,
It is not the database that is slow, it's the application server layer that is slow and the NAV Service that you connect through. Try breaking up the import into separate batches making smaller amounts of rows to import.
I've used RapidStart to import tens of thousands of records and it works... it's slow but it finishes... sometimes the screen hangs for a while until it finishes. If the XML method isn't working try using Rapidstart, or you can try pasting 1000 records at a time from an excel sheet right into the NAV form (this requires aligning the columns in the same order).
Most of the time data is push to database during offline period when nobody is logged in system and no transactions is happening in database
The companies which have thousands of record how they do it?
Hello Nematullah,
Use SQL Server if you have heavy records.
visit bellow link, you will get idea.
Try to import the data by using server machine and check the speed
as well as suggest to import file in parts.
Which options is faster for importing to system the data?
as this is global system should work for thousand of transaction is there any other way to fix this problem?
regards,
Would suggest check any specific validation is customized or try to reduce the rows and import
XMLPORT
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156