The AccuTerm forum has moved. Go to community.rocketsoftware.com to register for the new Rocket forum. |
Pick file from .xls using FTIMPORT is out of seqnc |
Post Reply |
Author | |
sbhenkel
Newbie Joined: March 03 2017 Status: Offline Points: 39 |
Post Options
Thanks(0)
Posted: November 05 2021 at 4:07pm |
I use FTIMPORT to import an excel spreadsheet to a pick work file on a daily basis. The options I use are: MODE: K,G HOST.FILE: (pick file name) ATTR: * ID.START: 1 REMOTE.FILE: (path to spreadsheet) all other options are null. The spreadsheet I receive always leaves line 1 as blank. My programming expects that so it always starts processing with item "2" in my pick file. Item "1" is always empty. Well something changed today. Now the FTIMPORT process seems to skip line 1 on the spreadsheet and puts line 2 of the spreadsheet in pick file "1", line 3 in "2", and so on. It's like it ignored or deleted the always blank line 1 on the spreadsheet and shifted everything else up one line. Is there something that I can even do to cause this? Could there be something wrong with the data? I can certainly compensate in my programming, but if this is a glitch on my part or your part I'd like to correct things without making any programming changes.
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |