cancel
Showing results for 
Search instead for 
Did you mean: 

Has anyone had issues with Administration\Data Import/Export\Data Import???

0 Kudos

Has anyone had issues with Administration\Data Import/Export\Data Import???

I have a client who has recently upgraded from V2007 to V8.81. They were succesfuly using this standard function to import supplier prices to their master price list, but now it has failed?

I have looked at the file they are importing and it appears to be fine.

On closer inspection, it did contain approx 46,000 entries, so I took the first 1,000 and created a test file, which imported fine.

The only issue I found was Speed, with the test file of 1,000 records taking about 30 Mins to import. This appeared to get slower and slower the further through the file it got!

Based on this, I have estimated that the whole file would takle about 13 hours to import. The client say that when they used to run it on version 2007 it was far quicker?

In practice, it does appear to run, but the speed is the issue. Having said this, I set the whole file to run last night (over night)and this morning it had appeared to hang after about 2,307 rows, with nothing else being updated.

Has anyone any ideas or is aware of performance issues like this?

Thanks,

Ian

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Ian,

For 46,000 entries, it would a tough job for any versions. Your client may not upload such amount of data before. I would always give a question mark before I got concrete fact.

You may try DTW on your copied db first to check the speed.

Thanks,

Gordon

jeff_craig
Participant
0 Kudos

Is DTW an option?

0 Kudos

Always an option, but would you give your clients access to this tool?

Not sure really.

I have uploaded a copy of their database onto my test system and run the same routine. Its equally as SLOW

I can't gauage if its an issue with 8.81 that 2007 didn't have, as I only have the client's word on it, however I have no reason to disbelieve them.

Kind regards,

Ian