COMMUNITY FORUM

I am trying to import a Pipe-delimited text file with a csv. extension. Every time I try to build up a Schema.ini to support it, it keeps getting reset back to a messed up copy.                         [ImageNow2GP Test.csv]

Messed up Schema.ini
***********************
[ImageNow2GP Test.csv]
ColNameHeader=True
Format=CsvDelimited
MaxScanRows=5000
CharacterSet=ANSI
Col1=VendorID_DocNumbr_DocType_DocAmnt_DocDate_VADCDTRO_PYMTRMID_DUED Char Width 255
Col2=F2 Char Width 255
Col3=F3 Char Width 255

Clean hand-created Schema.ini
***********************
[ImageNow2GP Test.csv]
ColNameHeader=True
Format=Delimited(|)
MaxScanRows=5000
CharacterSet=ANSI
Col1=VendorID Char Width 15
Col2=DocNumbr Char Width 20
Col3=DocType Char Width 15
Col4=DocAmnt Char Width 21
Col5=DocDate Char Width 25
Col6=VADCDTRO Char Width 15
Col7=PYMTRMID Char Width 20
Col8=DUEDATE Char Width 25
Col9=PRCHAMNT Char Width 21
Col10=TRXDSCRN Char Width 30
Col11=TEN99AMNT Char Width 25
Col12=PORDNMBR Char Width 20
Col13=DSTSQNUM Char Width 4
Col14=CRDTAMNT Char Width 21
Col15=DEBITAMT Char Width 21
Col16=ACTNUMST Char Width 75
Col17=ACTDESCR Char Width 75
Col18=DISTTYPE Char Width 2
Col19=DISTREF Char Width 30
Col20=GROUPID Char Width 15
Col21=CODEID Char Width 15

A few rows from the Sample Pip-delimited csv file.
VendorID|DocNumbr|DocType|DocAmnt|DocDate|VADCDTRO|PYMTRMID|DUEDATE|PRCHAMNT|TRXDSCRN|TEN99AMNT|PORDNMBR|DSTSQNUM|CRDTAMNT|DEBITAMT|ACTNUMST|ACTDESCR|DISTTYPE|DISTREF|GROUPID|CODEID
ALABAMA SOUTHER|569279|Invoice|200.00|10/30/2014|PRIMARY|Due Upon Receipt|10/30/2014|200.00|57398kdt|.00|||200|0.00|2100-20-100-00-000000|ACCTS PAY – SUBLEDGER|2||0|0
ALABAMA SOUTHER|569279|Invoice|200.00|10/30/2014|PRIMARY|Due Upon Receipt|10/30/2014|200.00|57398kdt|.00|||0.00|11.33|1610-15-000-00-000733|TEST PLATE ACCOUNT|6||PLATE|PR05