[Download-List] Download problems when sending a record of a file to my PC
Bill Pizer
pizerw at sage.edu
Mon Dec 13 14:51:51 EST 2004
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"""
More information about the download-list
mailing list