write.line export to text file by date

[Ed Merritt]

I've searched all the messages here and while there are several about the file_pointer.write.line function, I haven't found enough to break my brain lock.

I need to export an A5 table to a text file for upload to another app. It must have certain field names. I can get the export to work, but without the field names. The other part I'm stuck on is how to filter the export to a date entered by the user. Right now, it dumps the entire table.

If anyone has a similar script or can unlock the brain cells for me, I will name my first child after you. Of course since he's now 21, he might object to changing his name......

Thanks!

[Bill Parker]

Re: write.line export to text file by date

The export operation has an option to write field names with the data, so not sure what the problem is there. That would be the easiest and fastest approach.

Here is a code sample writing to a file. You would need to do a query to filter for the records you want, and then a While loop to write each record until the end.

Creating an ascii log file.
'do your query here to select records.

'	Write log file
IF file.exists(:a5.get_path() +chr(92) +"EdxmLog.txt")
	flLog = file.open(:a5.get_path() +chr(92) +"EdxmLog.txt", FILE_RW_SHARED)
ELSE
	flLog = file.create(:a5.get_path() +chr(92) +"EdxmLog.txt", FILE_RW_SHARED)
END IF
vBytes = flLog.bytes_get()
flLog.seek(vBytes)	' position to end of file
'write the titles line here - flLog.write_line(...)
'start While loop here
flLog.write_line(DTOC(date()) +" " +time() +" - " +flList.name())

'end of while loop here

flLog.flush()
flLog.close()

Bill.

[Ed Merritt]

Re: write.line export to text file by date

Bill, the export operation exports the table field names, and I need customer field names for the external app. So when I said the "export" works, I shold have said the write.line function works but it dumps the whole table. I also need to have it write custom field labels.

I'll give your code a try, thanks!

[MikeC]

Re: write.line export to text file by date

Ed,
If you check out the xbasic behind the export operation, you will see how it writes the field names and you could substitute your own fairly easy. The same for the query.filter expression. You could also use *line_replace() to replace the first line of your export with whatever you want afterwards.