[Download-List] Download problems when sending a record of a file to my PC

[David L. Rotman]

BIll--

On my PC, the import.wis script is a generic one (from 1993)
that fetches data from a customer database...it does not use
any results of a prior DOWNLOAD run.  I found the script
under c:\datatel\ui\filetran.  Is that where yours is located?
If you could fetch a copy of the file, that might help identify
the problem.  I'll insert a copy of my script below.

Typically, users would have DOWNLOAD write to a shared
network drive or write to a directory on the Unidata host and
then ftp the file to the local PC.  Neither of these methods
would introduce the extraneous quotation marks.


Dave Rotman

======================================
Here is what my 'import.wis' script looks like:
* Import of host CUST file for mailmerge
* Saved on Mon May 31 16:24:15 1993
Dialog RunImportFile
Configure
Account=""
File="CUST"
Items="SSELECT CUST BY NAME"
Fields="CONTACT NAME STREET CITY ZIP SAL"
DosFile="C:\WINTEG\CUSTLET.MRG"
Format="MRG"
Inform="0"
Timeout="5"
Retries="3"
AutoExit="0"
Translate="Ascii"
Translation="\255,\r\n\f\r\n,\254,\r\n"
Overwrite="Yes"
SuppressId="1"
Mode="Normal"
FieldDescriptions="0"
Update


>>> pizerw at sage.edu 12/15/2004 8:55:58 AM >>>
The wIntegrate feature of Run->Import that is built into UI.  

---------------------------------------
Original Email
From: "David L. Rotman" <rotmand at cedarville.edu>
Sent: Dec 15, 2004 07:41 AM
To: download-list at cedarville.edu 
Subject: Re: [Download-List] Download problems when sending a record
of
	a file to my PC

Bill--

I'm wondering if your comment on "Run->Import" may give a clue.  What
kind of software are you using to transfer the file from the Unidata
host to your PC?



>>> pizerw at sage.edu 12/13/2004 2:51:51 PM >>>
The statement below works and sends the correct information into the
HOLD file but when I use Run->Import to pull the resultant record to
my
PC, I get double-quotes around my fields. Any ideas? This just started
happening
about 2 weeks ago - no changes have been made to Download in that
time.

I have even attempted to pull it using the TAB Separator but the same
thing happens.  The only patches that have been installed are
C11924-63_UT and c11868-19_UT. Any thoughts?

012: DOWNLOAD TX.ARCHV @ID R90.UNIQUE.DONORS R90.STAFF.ASSIGNED
R90.DONOR.REUNION.CLASS R90.CURRENT.SOURCE LFM.NAME  FUND.DESC FMT
"35L"
TOTAL PLEDGE.AMOUNT FMT "12R" TOTAL R90.GIFT.AMOUNT TXA.CODE FMT "2L"
TXA.CREDIT.DATE FMT "10R" CNV "D4/" TOTAL TXA.PLEDGE.BALANCE FMT "12R"
TOTAL R90.LAST.YR.GF.PP.MG.AMT TOTAL R90.MD.COMMITTED.MATCH
R90.TXA.PREF.SEASONAL.ADDR1 R90.TXA.PREF.SEASONAL.ADDR2
R90.TXA.PREF.SEASONAL.CSZ R90.TXA.JHN.SALUTATION FIRST.NAME
R90.TXA.IND.LABEL.NAME R90.TXA.CYR.GIVING.TOTAL AFCA.VOLUNTEER HEADING
FIELD.NAMES FORMAT QUOTE FILE _HOLD_ ACKNOWLEDGEMENTS OVERWRITING

Resultant _HOLD_ file:

001:
"@ID","R90.UNIQUE.DONORS","R90.STAFF.ASSIGNED","R90.DONOR.REUNION.CLASS","R90.CURRENT.SOURCE","LFM.NAME","FUND.DESC","PLEDGE.AMOUNT","R90.GIFT.AMOUNT","TXA.CODE","TXA.CREDIT.DATE","TXA.PLEDGE.BALANCE","R90.LAST.YR.GF.PP.MG.AMT","R90.MD.COMMITTED.MATCH","R90.TXA.PREF.SEASONAL.ADDR1","R90.TXA.PREF.SEASONAL.ADDR2","R90.TXA.PREF.SEASONAL.CSZ","R90.TXA.JHN.SALUTATION","FIRST.NAME","R90.TXA.IND.LABEL.NAME","R90.TXA.CYR.GIVING.TOTAL","AFCA.VOLUNTEER"
                           
File pulled to my PC:

"ACKNOWLEDGEMENTS","""@ID"",""R90.UNIQUE.DONORS"",""R90.STAFF.ASSIGNED"""

_______________________________________________
download-list mailing list
download-list at cedarville.edu 
http://mail.cedarville.edu/mailman/listinfo/download-list 

Dave Rotman
Director of Computer Services
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu 
voice 937-766-7905
fax 937-766-8819
_______________________________________________
download-list mailing list
download-list at cedarville.edu 
http://mail.cedarville.edu/mailman/listinfo/download-list