RE: CPYFRMIMPF and extra columns

It works fine with the table I have now, I can get all the data to import just fine.

I added column to the file at the very end of the file I am importing records into, then run the exact same command and instead of 220 records imported, we just get 0 records imported. No errors.

Kinda missing the TextFieldParser class built in .NET framework which follows RFC 4180. This would be done in about 10 lines of code.

We'll probably end up rolling our own, or using scott klements code.

Matt

-----Original Message-----
From: Buck Calabro [mailto:kc2hiz@xxxxxxxxx]
Sent: Thursday, May 23, 2013 4:35 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: CPYFRMIMPF and extra columns

On 5/23/2013 5:03 PM, Matt Olson wrote:

It seems CPYFRMIMPF only works if the # of columns matches the number of commas in the CSV file you are trying to import.

Commas separate fields. If there's one comma, there are two fields. If your CSV has 25 commas, you need 26 fields defined.

I tried adding extra column at the very end of the destination file that I want to take the CSV file into, but then it doesn't parse any records.

The job log is somewhat helpful here. You can see which fields aren't mapping and why. ish.

Is there an option in the CPYFRMIMPF I'm overlooking?

There are lots of options and they all need to match the data you're trying to import. If none of the input rows converted, I'd guess that the end of record character is the culprit. If your file is coming from *nix, EOR is *LF. If coming from Windows, EOR is *CRLF. I've had poor luck with the default *EOR.

You need to exactly match the string delimiter (usually a double quote but sometimes nothing at all!) and the field delimiter (usually a comma but sometimes a tab). If it's a big file and it takes a long time to process, try FROMRCD(*FIRST 10) or some small number that will get your parameters tested quickly. Don't forget about RPLNULLVAL - you may need it.
--buck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.