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