FTIMPORT no errors and no data

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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)

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
jkristof Members Profile Find Members Posts Newbie Joined: October 14 2014 Location: United States Status: Offline Points: 3	Post Options Post Reply Quote jkristof Report Post Thanks(0) Quote Reply Topic: FTIMPORT no errors and no data 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

jkristof Members Profile Find Members Posts Newbie Joined: October 14 2014 Location: United States Status: Offline Points: 3	Post Options Post Reply Quote jkristof Report Post Thanks(0) Quote Reply Posted: October 14 2014 at 5:48am
	MODE = "KERMIT,OVERLAY,GENERATE"
	JK

jkristof Members Profile Find Members Posts Newbie Joined: October 14 2014 Location: United States Status: Offline Points: 3	Post Options Post Reply Quote jkristof Report Post Thanks(0) Quote Reply Posted: October 14 2014 at 6:03am
	Never mind. Forgot the ":" at the end of the cell.
	JK