Jump to content


Photo
- - - - -

corrupted PRO-ISAM files


4 replies to this topic

#1 Chris Mackenzie

Chris Mackenzie

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 368 posts
  • Gender:Male
  • Location:Bristol, United Kingdom

Posted 02 July 2002 - 10:24 AM

Hi,

Dumping Pro-Isam data to sequential :
it mostly works but some of my datafiles do not
dump well. Instead of space padding in the fixed
length format sequential file fields, I get dodgy control
characters pushing the fields all over the place. As
far as I can see this non-printing data causes no problems
within Pro-IV and is invisible. I can re-enter data
in P4 and fix a record but don't want to do that with
everything. I tried the utility called 'PROTRACK' but
it does not pick up this corruption/invalid data.

Does anyone have any tools that might help?

I guess I will have to write some sort of cleanup
global logic to use where I check every char is
printable before writing to my seq file?
The content and views expressed in this message are those
of the poster and do not represent those of any organisation.

#2 Dan Shannon

Dan Shannon

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 374 posts
  • Gender:Male
  • Location:Australia

Posted 02 July 2002 - 11:46 AM

If anyone there knows Perl it would be easy enough to strip the dodgy characters and replace them with 0x20 (spaces) in the .seq files themselves.

Dan Shannon

#3 Chris Mackenzie

Chris Mackenzie

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 368 posts
  • Gender:Male
  • Location:Bristol, United Kingdom

Posted 02 July 2002 - 01:15 PM

Yeah,

But how to get the right number of spaces in?

Anyway - turns out there was a bug in my function
to delete FILEHDR & FILEDEF and it messed up the
data extraction function field assignments.

Fixed now and I am a happy man. Data conversion
one week ahead of schedule.
The content and views expressed in this message are those
of the poster and do not represent those of any organisation.

#4 Bryan Thompson

Bryan Thompson

    Member

  • Members
  • PipPip
  • 20 posts
  • Gender:Male
  • Location:Harrisburg, Pennsylvania

Posted 03 July 2002 - 11:25 AM

You can try reading through the data and stripping out characters based on octal values. Also these characters may be invisible if your running green screen but should show up with the GUI client


Bryan

#5 Rajesh Chavan

Rajesh Chavan

    Member

  • Members
  • PipPip
  • 10 posts
  • Gender:Male
  • Location:21/45 Soi Chawakun Rangnam Road, Rajthevi, Thailand

Posted 18 July 2002 - 11:48 AM

There is no utility in P4 to clean this junk records. To do this you have to copy the logical structure of the file. Then write a update to copy all the records using range. The range should be set before the junk records and follow the same step till you reach the EOF.



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users