File Transfer - FTIMPORT no errors and no data

Print Page | Close Window

FTIMPORT no errors and no data

Printed From: Rocket Software
Category: AccuTerm Knowledge Base (read only)
Forum Name: File Transfer
Forum Description: Help with uploading & downloading database and document files
URL: https://forum.asent.com/forum_posts.asp?TID=2457
Printed Date: March 26 2026 at 8:51pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: FTIMPORT no errors and no data

Posted By: jkristof
Subject: FTIMPORT no errors and no data
Date Posted: October 14 2014 at 5:47am

I'm using FTIMPORT to import an Excel 2010 spreadsheet. I'm using the complete path the to spreadsheet. I get this output when I call the routine
Converting TB.xls!!A3 from Excel format for upload... done.
But nothing is loaded. I tried with .csv and it works fine. I'd rather update the .xls directly. I only used the range of A3 as that is the upper left cell of the range I want to import. I do not know before hand how many rows I'm going to need to import.
Here is my code:
REMOTE.FILE = FNAME:"!!A3"
HOST.FILE = "RE-AUTO.INPUT"
ATTRS = "-,-,-,-,1,-,-,-,-,-,2,4,3"
CONVERT "," TO @VM IN ATTRS
HDR.SKIP = 2
ID.PREFIX = ""
ID.START = 1
ITEM.COUNT = 0
BYTE.COUNT = 0
STAT = ""
PRINT @(0,22):
CALL FTIMPORT(MODE,REMOTE.FILE,HOST.FILE,ATTRS,HDR.SKIP,ID.PREFIX,ID.START,ITEM.COUNT,BYTE.COUNT,STAT)

-------------
JK

Replies:

Posted By: jkristof
Date Posted: October 14 2014 at 5:48am

MODE = "KERMIT,OVERLAY,GENERATE"

-------------
JK

Posted By: jkristof
Date Posted: October 14 2014 at 6:03am

Never mind. Forgot the ":" at the end of the cell.

-------------
JK