Can this be done & are you interested?
Posted: Thu Nov 11, 2010 12:16 pm
I need a quote for the following bits of code.
---------------------------------------------------------------------------------------------------
MOCKUP OF REPORT SUMMARY
Design stage | As Built stage
|
Text field 1 | text field 2
|
Many other fields, tick boxes graphics and text follow, but this is the essence
---------------------------------------------------------------------------------------------------
The objective is to have a standardised summary sheet like the example above, but with many different fields, tick boxes etc.
The user will have calculation sheets from potentially several sources in pdf or possibly xps format. Typically these will contain human readable and selectable text and not images of text.
Although the sheets may vary in layout and content, it is proposed they all have a consistent cluster of data in a prescribed format. This cluster of information will have a header so the report summary knows it has got the right part of the document to start reading in the data. This header and data cluster could be anywhere on the document.
How it should work
I want to be able to drag the document to the report and drop it. The report will be searched for the header and if OK the data read and the fields on the report populated.
Next, the document in its entirety is saved in compressed format in a specific slot or location in a compressed file.
The important thing to remember, there may be many different documents contributing to the specific fields on the mock report summary. Example calculation type 1 might go to fields 1 to 5 and 8 to 13 and document 2 might go to field 7, another document might go to field 6 and so on.
If document 2 for example needs to be replaced, perhaps because the content had changed, by dragging and dropping again, the correct field is over written and the document replaces the existing in the compressed file.
There will be a need to click on the field of interest and trigger the original document to launch in the appropriate external viewer so the user can see more detail or even print the original document.
This facility of a fixed location in the compressed master file will also enable a totally different user to merge his own master compressed file to a single file, adding where the other is missing info or updating if the identical locations contain data.
Task 1
How to search the pdf or xps file, because the structure of the document means it cannot be searched directly. It is a jumble of characters. (The decoding must be available to LiveCode because it does this when it displays in a browser and this can be manually selected, copied and pasted.)
Task 2
How to make the compressed file so the data slots into is right location. A bit like monthly journals in a library.
I look forward to your reply
s a p . s b e m @ a j p e r k s . c o . u k
---------------------------------------------------------------------------------------------------
MOCKUP OF REPORT SUMMARY
Design stage | As Built stage
|
Text field 1 | text field 2
|
Many other fields, tick boxes graphics and text follow, but this is the essence
---------------------------------------------------------------------------------------------------
The objective is to have a standardised summary sheet like the example above, but with many different fields, tick boxes etc.
The user will have calculation sheets from potentially several sources in pdf or possibly xps format. Typically these will contain human readable and selectable text and not images of text.
Although the sheets may vary in layout and content, it is proposed they all have a consistent cluster of data in a prescribed format. This cluster of information will have a header so the report summary knows it has got the right part of the document to start reading in the data. This header and data cluster could be anywhere on the document.
How it should work
I want to be able to drag the document to the report and drop it. The report will be searched for the header and if OK the data read and the fields on the report populated.
Next, the document in its entirety is saved in compressed format in a specific slot or location in a compressed file.
The important thing to remember, there may be many different documents contributing to the specific fields on the mock report summary. Example calculation type 1 might go to fields 1 to 5 and 8 to 13 and document 2 might go to field 7, another document might go to field 6 and so on.
If document 2 for example needs to be replaced, perhaps because the content had changed, by dragging and dropping again, the correct field is over written and the document replaces the existing in the compressed file.
There will be a need to click on the field of interest and trigger the original document to launch in the appropriate external viewer so the user can see more detail or even print the original document.
This facility of a fixed location in the compressed master file will also enable a totally different user to merge his own master compressed file to a single file, adding where the other is missing info or updating if the identical locations contain data.
Task 1
How to search the pdf or xps file, because the structure of the document means it cannot be searched directly. It is a jumble of characters. (The decoding must be available to LiveCode because it does this when it displays in a browser and this can be manually selected, copied and pasted.)
Task 2
How to make the compressed file so the data slots into is right location. A bit like monthly journals in a library.
I look forward to your reply
s a p . s b e m @ a j p e r k s . c o . u k