Hello,

I'm using the UniData product from Datatel with the wIntegrate
interface.

When transferring large files with 'Import File' I'm finding that
large files are truncated. For example, my original data file consists
of 14700 records, but my imported file only consists of 13786 records,
the last record appearing to have been truncated.

Could this possible be a configuration issue? I can't use FTP, SFTP,
Kermit, SCP, and I don't have this problem with shorter files.

Thanks, CC.

This is a great forum for HowTo's with software, but it looks like you
have found a problem that's specific to a product/release. Datatel
should be your first line of support for a bug like this. They will
probably ask which release of wIntegrate you are using. If it's an
older version they will probably ask you to upgrade. If it's more
recent then they will need to contact whomever is maintaining
wIntegrate these days, so that they can report the bug and get a fix.
(They should do this on your behalf rather than forcing you to chase
after another vendor.)

In the interim, with a bit of coding, large records can be split on
one side, transferred with wIntegrate, then re-assembled on the other
side. So the problem is not unresolvable, but if there isn't an
updated release with a fix immediately available, it will cost someone
some time and/or money to get it resolved.

HTH
Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Nebula R&D sells mv.NET and other Pick/MultiValue products
worldwide, and provides related development services
remove.pleaseNebula-RnD.com/blog
Visit PickWiki.com! Contribute!
http://Twitter.com/TonyGravagno


CC wrote:

On Mar 11, 3:14*pm, Tony Gravagno <tony_grava... (AT) nospam (DOT) invalid>
wrote:
Two other possibilities - you may have timed out or if it there are
missing items before the trucated item you may have read or write
errors that are not being logged, or the log may not be immediately
visible to you. Files from jBase may have ID longer than permitted or
may have null ID which I think is also refused.

On 11/03/2011 18:34, ccc31807 wrote:
Do you have a WIN.PROGS file? There should be several programs (used by
different flavours of Pick) with names starting WIN.PARAM. By default
these programs set R.PARAM<1> = 32000 (IIRC). You might need to change
the program(s) to increase the size of R.PARAM<1>. It's worked for me
in the past, anyway.

--
Danny Colyer <http://www.redpedals.co.uk>
"I'm riding a unicycle with my pants down. This should be every boy's
dream." - Bartholomew J Simpson

"Robert Joslyn" wrote
You should 'get a second opinion' by trying the same transfer with another
terminal emulator program, if at all possible, to see if your telnet settings or
maybe some odd router settings are the culprit instead of anything specific to
your winbox / wIntegrate. Don't bust a gut trying to arrange this, but if it's handy,
do not forget this stage of testing... Conversely, try doing the same transfer with
same wIntegrate from another winbox in the office, just to see if you get
lucky and one desk has 'some' better settings than the other. It's all grist for
the mill, and lack of imagination in testing can be even more crippling than
ignorance of the technical subjects involved.

Other possible causes of whole items missing from a transfer:
-- items in source file not properly hashed, as for example when pulled
from a file-save tape with wrong frame size for restoring machine?
{ check this by doing a local copy into a scratch file, then count
that scratch file's items... }
-- item ids on source machine are case sensitive, but not on dest. machine
so only one of Abc and aBc items in source survive in dest file...
{ sorry, I dunno enough UniData to confirm this is possible or howto
check }