Importing a Text File

Vic DiFranco vjdif at prodigy.net
Sat Jul 26 13:33:40 PDT 2008


Hello Everyone,

	A procedure which imports and appends a text file into a Panorama  
database, and which has worked for years, has suddenly stopped  
behaving. Can someone tell me what's wrong? The procedure stops at  
the second line.

	The first line of the procedure is an "importusing" command, which  
makes sure the order of the import is correct. The next line, which  
is the line that fails, is:

	openfile "&Transactions_Download.txt"

	There IS a text file called "Transactions_Download.txt", which I  
download from a web site every month. The file is a proper text file,  
and in fact, I can MANUALLY open the file in Panorama with "File-Open  
File-Enable Text Files, then select "Replace Current Database" and de- 
activate "Match Fields by Name". The file properly opens in Panorama,  
and Panorama has no problems with it. The only problem is that the  
field order is wrong. In fact, I can manually use openfile with  
Enable Text Files but NOT appending the file. Panorama correctly  
opens a new database of the text file, called "Untitled". So the text  
file is obviously OK.

	But when the procedure runs, I get an error message at the openfile  
line which says "Sorry, only Panorama, OverVUE, or TEXT files may be  
appended". I even tried using the macro recorder when manually  
opening the file, and the recorder records the exact line as above.  
But when the procedure runs, I get the error message.

	What has happened to make the procedure stop running?

	I am running Panorama 5.5 on a Macintosh Powerbook G4 under OS 10.4.11.

	Best regards,
	Vic DiFranco


More information about the Qna mailing list