Corrupt FPT?

[superdan54]

Hi,

Using Foxpro 6 here. Due to 2GB related bugs, we were forced to archive our employee attachments table(PDF scans of Driver's license etc,SSN card etc..) into identical yet separate tables. We made a program that allows our HR staff to access all archived tables.

This has worked well except for one problem. Several of the PDF's either do not show up or show up corrupted. I've ran a FoxProRecover (3rd party software we purchased) error check and also rebuilt the indexes on the DBF, but I confess that I really don't know much about FoxPro so I'm not sure what else I can do. Any Ideas?

Thanks!

 

[Mike Lewis]

Superdan,

Several of the PDF's either do not show up or show up corrupted.

Are you sure you meant PDFs? These have nothing to do with FoxPro.

You mentioned FPTs in the message header. Is that what you meant? If so, what do you mean by "do not show up"? Are you getting an error message? If so, what, and where?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[superdan54]

Sorry I wasn't more clear...

Ok so the program displays a list of all the given attachments for a particular employee (taken from the DBF). When the user selects a particular attachment, the program will load whatever PDF data is stored in the corresponding FPT file.

This works for most of the attachments, but some of the attachments return 0 bytes, and some return a "Acrobat could not open '[filename].pdf' because it is either not a supported file type or because the file has been damaged..." However, I know they should be there and that they are all PDF scans.

thanks again!

 

[superdan54]

Ok so I found out that I can open up the "corrupted" attachments within FoxPro itself. I just click on the BLOB field, and the corresponding attachment will show. So it may not be a PDF after all, but I have no idea what it is supposed to be!

 

[superdan54]

Well maybe I shouldn't have panicked and posted so quickly, as I have figured out the problem. That said, I have a different problem now related to this, but since it is not related to the FPT, I will start a new topic.

 

[superdan54]

OK so maybe I won't start a new topic (man I wish they had an edit button here :-D)

Anyway the problem is that somewhere along the lines, a different form of PDF was attached in the FPT. Older attachments all work and newer attachments don't, I compared the binary data between the two, and while they are both PDF, the structure is different. The following describes my scenario:

1. (works) If I click on older attachments directly in Foxpro, it will bring up an icon that links to an actual PDF file, clicking on the icon will open up acrobat and a temporary file is created on my PC.

2. (doesn't work) On newer attachments, if I click an attachment w/in Foxpro, the document will open w/in Foxpro itself. If I wan't to open the document in Acrobat I can choose Edit -> Open Acrobat Document Object. (This option is not available in the other.

Any ideas??

 

[superdan54]

thanks for the reply.

Unfortunately, the database structure is out of our control. The Foxpro tables are used & created by ABRA HR software. The reason we had to create this program was ABRA was crashing repeatedly due to the attachment FPT's being over 2GB. Unfortunately, ABRA is not coming out with a SQL version for awhile, so we had to come up with this solution instead for the meantime.