Scripting & Automation - Pick file from .xls using FTIMPORT is out of seqnc

Print Page | Close Window

Pick file from .xls using FTIMPORT is out of seqnc

Printed From: Rocket Software
Category: AccuTerm Knowledge Base (read only)
Forum Name: Scripting & Automation
Forum Description: Customize and control AccuTerm using scripts and automation
URL: https://forum.asent.com/forum_posts.asp?TID=2755
Printed Date: February 08 2023 at 12:50pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: Pick file from .xls using FTIMPORT is out of seqnc

Posted By: sbhenkel
Subject: Pick file from .xls using FTIMPORT is out of seqnc
Date 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.