Import question

[Don Coleman]

Beginning of code up to where the problem occurs follows:

Mar 20, 2006  16:03           File Name: CONTROL                   Page   1
                             Processing: Qs1work

   1 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: qu eq "1"
       Then: goto start
   2 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then: putenv "PFADDWP","OFF"
   3 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then: ZZ(30,*,g)="E:\QS1\TODO\QS1DATA.TXT";qu(1,.0,g)="0"
   4 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
start    If: 
       Then: import ascii dgc=(ZZ) r=\n f=:
   5 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: not dgc
       Then: goto prtpull
   6 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then: DIM NAM(63)(50,*):AA
   7 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then: AA=dgc(1)
   8 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: qu eq "0"
       Then: goto clear
   9 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: AA eq "06914995"
       Then: debug on
  10 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then: AB=dgc(2);AC=dgc(3);AD=dgc(4);AE=dgc(5);AF=dgc(6)
  11 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: AE ne "#"
       Then: AE=""
  12 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then: AG=dgc(7);AH=dgc(8);AI=dgc(9);AJ=dgc(10);AK=dgc(11);AL=dgc(12)
  13 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then:
AM=dgc(13);AN=dgc(14);AO=dgc(15);AP=dgc(16);AQ=dgc(17);AR=dgc(18)
  14 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then:
AS=dgc(19);AT=dgc(20);AU=dgc(21);AV=dgc(22);AW=dgc(23);AX=dgc(24)
  15 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then:
AY=dgc(25);AZ=dgc(26);BA=dgc(27);BB=dgc(28);BC=dgc(29);BD=dgc(30)
  16 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then:
BE=dgc(31);BF=dgc(32);BG=dgc(33);BH=dgc(34);BI=dgc(35);BJ=dgc(36)
  17 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
         If: 
       Then: BK=dgc(37);BL=dgc(38);BM=dgc(39);BN=dgc(40);BP=dgc(42)


Note the variable containing the suspect character is AE.  The three
variables before AE (AB,AC,AD) contain the time this order was updated.
Since this is a colon-delimited file I put each segment of the time field
into a separate variable and then put them back together.


Don Coleman
Donald G. Coleman, Consultant
402 Andrew Circle
Indiana, PA 15701
dcoleman at dgcreact.com
(724) 349-6302

-----Original Message-----
From: GCC Consulting [mailto:gccconsulting at comcast.net] 
Sent: Monday, March 20, 2006 3:58 PM
To: 'Don Coleman'; 'filePro Mailing List'
Subject: RE: Import question

 

> -----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