View previous topic :: View next topic |
Author |
Message |
GEMCGRAW
Joined: 29 Sep 2009 Posts: 1
|
Posted: Tue Sep 29, 2009 5:20 pm Post subject: Dataload is skipping columns. |
|
|
I'm running the same file that I ran two weeks ago. This time, it is kipping columns. I do not understand what is causing this. I even copy/pasted one line of data to a new sheet and it's still skipping. Anyone have any ideas? ![Question](images/smiles/icon_question.gif) |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
DataLoad Site Admin
Joined: 15 Nov 2005 Posts: 231 Location: Dorset, UK
|
Posted: Thu Oct 01, 2009 5:17 pm Post subject: |
|
|
Hi,
The first thing to try is to reduce the speed of the load. Increase one of the generic load delays, I suggest you use "Cell is processed", to a fairly high value so the load is really slow. You can find more details on doing that here:
http://www.dataload.net/help/macro/builtindelays.htm
Then run the load and see what happens.
If your load still skips columns then with the load going really slowly you should be able to see what the problem is.
If the load no longer skips columns then the problem was a timing issue. In that case you want to restore load performance by gradually reducing the delays so they are as low as possible but the load is still reliable. You may also find that it is just one or two areas of your load where problems occur when the delay is set low. In that case you could keep the delay low but add a *SL delay in one of the load columns to cause DataLoad to sleep at that point. That will maximise performance while ensuring reliability.
Regards,
Jonathan Stuart. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
|