Page 1 of 1

Import bug

Posted: Fri Nov 19, 2004 8:13 am
by JF Mous
Hi,

When I try to import stock table items in POS (from a CSV file), I get an illegal function call on line 0 in module CF4. Both from POS (6.18) and PosConfg.
I admit that I'm trying to copy 11650 lines, but I've done it before in previous versions and it always worked fine.

Grtz,

J Mous

Posted: Fri Nov 19, 2004 9:26 am
by Dale Harris
Most likely it is an error in your data. A missing comma or extra commo or quote in a description or vendor stock number.

Send your data file to me and I will check it.

Posted: Fri Nov 19, 2004 4:17 pm
by JF Mous
I guess if there was a problem with the file, the copying into the POS clipboard would fail.
That part went fine and the data on the clipboard looked OK.
Only when trying to paste the current clipboard into the stocktable, the problem occured. I failed to mention that in my previous post. I knew I was forgetting something.
Anyway, I sent you the file.

With kind regards,


J Mous

Posted: Wed Nov 24, 2004 2:51 am
by barryh
dale,

i can confirm this happens with my 10440 item stock table.

It does crash, but when I go back and return to POS.exe it seems to loaded in correctly.

I've just ignored it since ~June because i thought it only happens to a large stock table, but I get the table in anyway.

Barry.

Fixed

Posted: Wed Nov 24, 2004 5:17 am
by Dale Harris
Actually it was a bug in the program. When I changed the program at the begining of this year to increase the maximum number of lines in the stock table from 5000 to 13,000 I did not change one of the many parts of the program than formatted the index that is used to quickly find any item in the stock table.

The old index used 4 bytes for each item so 5000 items would require an index of 20,000 bytes. The new index requires only 2 bytes per item so the program would work fine until you tried to store more than 10,000 different items. This error only occured when importing the clipboard into the stock table because all other parts of the program properly formatted the index.

I fixed this and sent the new file to J Mous yesterday but I forgot that it was also posted here so I did not post here until today. Since this was such a minor bug and people would rarely encounter it I did not change the version number. Use this link to download the update...

<center> http://keyhut.com/pos.zip </center>