Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Unfortunately, I did not working with java and you have to implement it in java code by yourself. Now I'll tell you, how finally I did it:</p> <p><strong>1)</strong> I took the file by your link. PHP is doing it by <a href="http://www.php.net/manual/en/wrappers.php" rel="nofollow">@fopen("http://...")</a>.</p> <p><strong>2)</strong> I opened it as a <strong>binary</strong> (it is important) and extracted two parts:</p> <p><strong>2.1)</strong> Data 3 0 obj part, which represents creation and modification dates. I did it by <a href="http://www.php.net/manual/en/ref.pcre.php" rel="nofollow">regex</a>. It was simple and I mention it above.</p> <p><strong>2.1)</strong> Data stream from 5 0 obj, which represents the deflated data. IMPORTANT! Microsoft Excel inserts two bytes <code>0D 0A</code> as a line break. Do not forget it, when you filtering the content by regexp. This bytes in the start and in the end have not to be included in extracted string.</p> <p><strong>3)</strong> I inflate a coded stuff by function <a href="http://php.net/manual/en/function.gzuncompress.php" rel="nofollow">$uncompressed = @gzuncompress($compressed)</a> and put it in external file. You can see results <a href="https://docs.google.com/open?id=0B1YEM-11PerqVEFRSXM0M1ZVZG8" rel="nofollow">there</a> </p> <p><strong>4)</strong> Funniest part. The raw data inside the file in textual format. It looks like <code>[(V)-4(RI)16(J)] TJ</code>, and means <code>VRIJ</code>. You can read about texts in PDF in the <a href="http://www.google.com/search?client=safari&amp;rls=en&amp;q=PDF+Reference+v1.7&amp;ie=UTF-8&amp;oe=UTF-8#hl=ru&amp;safe=off&amp;client=safari&amp;rls=en&amp;sclient=psy-ab&amp;q=PDF+Reference+v1.7+file%3Apdf&amp;oq=PDF+Reference+v1.7+file%3apdf&amp;gs_l=serp.3...7017.13704.0.14310.11.10.1.0.0.0.132.1000.6j4.10.0...0.0...1c.7e0s-Abrluo&amp;pbx=1&amp;bav=on.2,or.r_gc.r_pw.r_qf.,cf.osb&amp;fp=c5c0acba9dbab366&amp;biw=774&amp;bih=694" rel="nofollow">PDF Reference v1.7</a>, part 5.</p> <p><strong>5)</strong> I believe, the regular expressions can help you extract or/and transform the data.</p> <p>IMPORTANT: I said "data stream from 5 0 obj", but number of the object "is subject of change". You must control the reference to the object from dictionary->pages->page->content chain. Description of the "bread crumbs" you can find in the manual I mentioned above.</p> <p>Unfortunately, Excel do not embed any table structure in the PDF, but you can find the coordinates of the text portions and interprete it. Anyway it is a mess.</p> <p>Do you think, dear Merlin, it is hard? No, dear, it is not. It is not hard, because there is no unicode symbols. The unicode in the PDF is THE REAL SUCK!</p> <p>Good luck! </p>
    singulars
    1. This table or related slice is empty.
    1. POExtract text from PDF in code
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRuben Kazumov
    1. USRuben Kazumov
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POExtract text from PDF in code
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThank you so much for your time once again. But I already did it using iText library. I'm so sorry that I wasn't clearer that I already solved my problem. Hopefully it didn't cost you to much time, I'm so sorry. But anyway, if later on, iText doesn't provide enough options, this will be really useful. Bye.
      singulars
      1. PO
      1. USXander
    2. CODear Merlin! It was not problem. I trying to solve one big problem with PDF-generating from scratch, and there is not any "prefabricated" solution for my case. Inflating-deflating is one small part, I should have solved for myself. My global task is creation in PHP a class, which will interprete handwritten, human-law-contracts-oriented plaie-text, and build the document. Enumerators, references and cross-references, footnotes, title-pages, page-numbers, inline sum(), count(), min(), max() functions, and super important - in-text-parameters-definitions and extracting.
      singulars
      1. PO
      1. USRuben Kazumov
    3. COPretty much I can do with regexp, but typography, unicode symbols substitution and muli-language support – hardest part. But I very close to the understanding of this nightmare stuff. The most helpful for me is reading inflated parts of existing PDF files byte by byte.
      singulars
      1. PO
      1. USRuben Kazumov
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload