Import question
GCC Consulting
gccconsulting at comcast.net
Mon Mar 20 12:58:03 PST 2006
> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com] On Behalf
> Of Don Coleman
> Sent: Monday, March 20, 2006 3:36 PM
> To: 'filePro Mailing List'
> Subject: Import question
>
> I have an import process that imports a text file via Windows
> Task scheduler every 4 minutes. Following is the beginning
> of one line copied from that text file which will not import.
>
> 06914995:02:47:42 PM: :SMC: (copied/pasted from the
> imported text file)
>
> This is a colon field-delimited file. My filePro import
> process stops reading data after the apparent blank space
> after the "PM:". My hex editor says this field contains a
> hex 00 NUL and each variable after this field shows as a
> blank value. The import process then continues as expected
> beginning with the next record (NL). This problem arose
> after a software update to the alien application creating the
> file. They have been unable to explain or correct the issue
> on their end so it looks like I have to program around it.
> This happens in a limited number of random records (1-10/day)
> out of up to 25,000 records in the file. Any suggestions on
> how to program around this so the file does not have to be
> manually edited. In order to fix presently you must open the
> file with a text editor and delete that "invisible"
> character. It then imports correctly.
>
> Thanks you for any advice
>
> Don Coleman
> Donald G. Coleman, Consultant
> 402 Andrew Circle
> Indiana, PA 15701
> dcoleman at dgcreact.com
> (724) 349-6302
Before anyone can accurately answer you question, I would suggest that you
post the code you are using for your import.
Richard Kreiss
GCC Consulting
More information about the Filepro-list
mailing list