OCR - Teh Forum

<body> <div id="header"> <span class="left"> <span class="back"><a href="lthread_list.php?webtag=DEFAULT"><span class="image mobile_back" title="Back"></span></a></span> <span class="image mobile_logo" title="Beehive Forum Logo"></span> </span> <ul> <li> <a class="reply_all" href="lpost.php?webtag=DEFAULT&reply_to=42338.0&return_msg=42338.2"> <span class="image mobile_reply_all"></span><span class="text">Reply to All</span> </a> </li> <li> <a class="navigation" href="#"> <span class="image mobile_navigation"></span><span class="text">Show messages</span> </a> </li> <li> <a class="main" href="#"><span class="image mobile_menu" title="Menu"></span> </a> </li> </ul> </div> <div class="menu main"> <ul> <li><a href="lthread_list.php?webtag=DEFAULT">Messages</a></li> <li><a href="lpm.php?webtag=DEFAULT">Inbox</a></li> <li><a href="lsearch.php?webtag=DEFAULT">Search</a></li> <li><a href="llogon.php?webtag=DEFAULT">Login</a></li> </ul> </div> <div class="menu navigation"><a href="lmessages.php?webtag=DEFAULT&msg=42338.1">1–10</a><a href="lmessages.php?webtag=DEFAULT&msg=42338.11">11</a></div> <div id="page_content"> <h3 class="thread_title"><a href="index.php?webtag=DEFAULT&amp;msg=42338.2">OCR</a> </h3> <div id="messages" data-navigation="42338_2_11_10"> <a name="a42338_2"></a><div class="message" id="message_42338_2"> <div class="message_header"> <div class="message_from"> From: graphitone<span class="message_time"> 6 Apr 2019 09:24</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 6 Apr 2019 13:08"></span></span> <span class="message_count">2 of 11</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42338.2">42338.2</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42338.1">42338.1</a></div> <div class="message_body"> Get typing.<br /> <br /> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42338.2&return_msg=42338.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42338.2"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42338_3"></a><div class="message" id="message_42338_3"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 6 Apr 2019 10:01</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 6 Apr 2019 13:08"></span></span> <span class="message_count">3 of 11</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42338.3">42338.3</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42338.1">42338.1</a></div> <div class="message_body"> Hahahahaha, how have you ended up with that?<br /> <br /> Probably could have typed it up by now. </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42338.3&return_msg=42338.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42338.3"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42338_4"></a><div class="message" id="message_42338_4"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time"> 6 Apr 2019 14:13</span> <div class="clearer"></div> </div><div class="message_to">To: ANT_THOMAS <span><span class="image post_read" title="Read: 6 Apr 2019 14:36"></span></span> <span class="message_count">4 of 11</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42338.4">42338.4</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42338.2#a42338_3" target="_self">42338.3</a></div> <div class="message_body"> It's competition results from my climbing centre - usually they're also posted online, but the centre staff aren't given the ability to update the website, and it seems the person who does has forgotten or not bothered. <p>I could probably ask for an emailed copy, but I don't understand how detecting numerical digits can be difficult. </p><p>What's even more frustrating is that it's supposed to be possible to limit Terreract to <em>only</em> detecting digits, but it doesn't work - it turns out they removed the ability to blacklist/whitelist characters in the current version. <span class="emoticon e_angry" title=":@"><span class="e__">:@</span></span></p></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42338.4&return_msg=42338.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42338.4"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42338_5"></a><div class="message" id="message_42338_5"> <div class="message_header"> <div class="message_from"> From: ANT_THOMAS<span class="message_time"> 6 Apr 2019 17:08</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 6 Apr 2019 19:54"></span></span> <span class="message_count">5 of 11</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42338.5">42338.5</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42338.2#a42338_4" target="_self">42338.4</a></div> <div class="message_body"> I hope you've OCRed the names and typed the numbers by now. But you're right OCR software never seems accurate enough. Even trying to use it to read my electric meter was too much hassle for the time saving. And that was very regular characters. Probably could have put more effort in to find a way to give the OCR some history of characters to work with to make matching more accurate.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42338.5&return_msg=42338.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42338.5"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42338_6"></a><div class="message" id="message_42338_6"> <div class="message_header"> <div class="message_from"> From: CHYRON (DSMITHHFX)<span class="message_time"> 6 Apr 2019 17:51</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 6 Apr 2019 19:54"></span></span> <span class="message_count">6 of 11</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42338.6">42338.6</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42338.2#a42338_4" target="_self">42338.4</a></div> <div class="message_body"> Are you scanning it or taking a digital photo? Things like original print quality and typography will hugely affect accuracy. Also quality of the OCR software varies quite a bit.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42338.6&return_msg=42338.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42338.6"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42338_7"></a><div class="message" id="message_42338_7"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time"> 6 Apr 2019 20:58</span> <div class="clearer"></div> </div><div class="message_to">To: ANT_THOMAS <span><span class="image post_read" title="Read: 6 Apr 2019 22:41"></span></span> <span class="message_count">7 of 11</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42338.7">42338.7</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42338.2#a42338_5" target="_self">42338.5</a></div> <div class="message_body"> It's not urgent so I'm leaving it for now hoping someone will pop along with a miracle cure, or I'll just ask for the original file when I'm next in. <p>It is annoying it doesn't seem to have moved on in the past two decades - it should be possible to point OCR at anything, have it identify glyphs, then ask for feedback on which ones it got wrong, repeat until happy. Bleh.</p></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42338.7&return_msg=42338.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42338.7"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42338_8"></a><div class="message" id="message_42338_8"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time"> 6 Apr 2019 21:34</span> <div class="clearer"></div> </div><div class="message_to">To: CHYRON (DSMITHHFX) <span><span class="image post_read" title="Read: 6 Apr 2019 22:21"></span></span> <span class="message_count">8 of 11</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42338.8">42338.8</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42338.2#a42338_6" target="_self">42338.6</a></div> <div class="message_body"> It's a photo taken with a digital compact, so there's a degree of noise and slight gradient, but there's no reason why it shouldn't be 99% OCR-able. <p>For example, attached is a crop of the row that gave "Q 124 on eel" - on its own it produces "124 97 2el", and in the first image (fixed horizontal/verticals, but gridlines still present and no brightness/contrast changes), it came closest with "0 124 on 221".</p></div> <div class="message_attachments"> <span>Attachments:</span> <ul> <li><span class="image attach"></span><a href="get_attachment.php?webtag=DEFAULT&hash=139fe3e4a6e4ad75b2ceccf232aaed61&filename=tesseract-sucks.png" target="_blank">tesseract-sucks.png</a></li> </ul> </div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42338.8&return_msg=42338.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42338.8"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42338_9"></a><div class="message" id="message_42338_9"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time"> 6 Apr 2019 22:03</span> <div class="clearer"></div> </div><div class="message_to">To: ALL<span class="message_count">9 of 11</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42338.9">42338.9</a></div> <div class="message_body"> I had the thought of forgetting about OCR and searching for what I actually want, i.e: "image to spreadsheet conversion", which came up with this: <a href="https://online2pdf.com/convert-jpg-to-excel">https://online2pdf.com/convert-jpg-to-excel</a> <p>The formatting it produced was all over the place, but it did a good job on the numbers - a handful of mistakes, mostly with zeroes. A couple of incorrect numbers (161->151 and 77->17) which were highlighted through the totals not matching, but compared to Tesseract it was brilliant. </p><p>Happy Peter -> <span class="emoticon e_smile" title=":)"><span class="e__">:)</span></span></p></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42338.9&return_msg=42338.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42338.9"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42338_10"></a><div class="message" id="message_42338_10"> <div class="message_header"> <div class="message_from"> From: CHYRON (DSMITHHFX)<span class="message_time"> 6 Apr 2019 22:23</span> <div class="clearer"></div> </div><div class="message_to">To: Peter (BOUGHTONP) <span><span class="image post_read" title="Read: 6 Apr 2019 22:29"></span></span> <span class="message_count">10 of 11</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42338.10">42338.10</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42338.2#a42338_9" target="_self">42338.9</a></div> <div class="message_body"> I've had good luck with online OCR, though not tried for excel.</div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42338.10&return_msg=42338.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42338.10"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div><a name="a42338_11"></a><div class="message" id="message_42338_11"> <div class="message_header"> <div class="message_from"> From: Peter (BOUGHTONP)<span class="message_time"> 6 Apr 2019 22:37</span> <div class="clearer"></div> </div><div class="message_to">To: CHYRON (DSMITHHFX) <span><span class="image post_read" title="Read: 7 Apr 2019 00:00"></span></span> <span class="message_count">11 of 11</span><div class="clearer"></div> </div> </div> <div class="message_links"> <a href="lmessages.php?webtag=DEFAULT&msg=42338.11">42338.11</a> In reply to <a href="lmessages.php?webtag=DEFAULT&msg=42338.2#a42338_10" target="_self">42338.10</a></div> <div class="message_body"> I'm guessing it's mostly just regular OCR, but uses tabs if there's more than a single space, although the file I got back did have merged cells with a dozen spaces for some of the rows, suggesting buggy overcomplicated logic. <p>We need to set Stallman on them all.</p></div> <div class="message_footer"> <div class="message_footer_links"><a href="lpost.php?webtag=DEFAULT&reply_to=42338.11&return_msg=42338.2" class="reply"><span class="image post"></span>Reply</a></div> <div class="message_vote_form" data-msg="42338.11"> <span class="rating">0/0</span> <span class="image vote vote_down vote_down_off" title="Vote Down"></span> <span class="image vote vote_up vote_up_off" title="Vote Up"></span> </div> </div> </div></div> </div> </body>