Importing take too much time

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (13)

Answers (1)

Verified answer

Amol Salvi 18,698 on at

Like (0)

Report

Hi

How you are uploading data to general journal ? Are you using XMLPORT or copy directly from excel and paste it

Use Rapidstart to upload data .This will help you validate and import data and will be faster also

www.youtube.com/watch

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We using excel file.

Was this reply helpful? Yes No
Amol Salvi 18,698 on at

Like (0)

Report

Are you doing Copy from excel and pasting in general journals or using XMLPORT or Rapidstart ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

XMLPORT

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Would suggest check any specific validation is customized or try to reduce the rows and import

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Try to import the data by using server machine and check the speed

as well as suggest to import file in parts.

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

Hello Nematullah,

Use SQL Server if you have heavy records.

visit bellow link, you will get idea.

EXPORT DATA FROM SQL SERVER 2014 WIZARD

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The companies which have thousands of record how they do it?

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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

Was this reply helpful? Yes No