Warning: require_once(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/WebStart.php on line 134
Warning: require_once(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/WebStart.php on line 150
Warning: require_once(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/WebStart.php on line 157
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require_once(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/Setup.php on line 381
Warning: require_once(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/Setup.php on line 382
Warning: require_once(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/Setup.php on line 383
Warning: require_once(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/Setup.php on line 384
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require_once(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/languages/Language.php on line 20
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: Cannot modify header information - headers already sent by (output started at /usr/local/www/mediawiki/includes/WebStart.php:134) in /usr/local/www/mediawiki/includes/Feed.php on line 229
Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: Cannot modify header information - headers already sent by (output started at /usr/local/www/mediawiki/includes/WebStart.php:134) in /usr/local/www/mediawiki/includes/WebResponse.php on line 38
Warning: Cannot modify header information - headers already sent by (output started at /usr/local/www/mediawiki/includes/WebStart.php:134) in /usr/local/www/mediawiki/includes/WebResponse.php on line 38
Warning: Cannot modify header information - headers already sent by (output started at /usr/local/www/mediawiki/includes/WebStart.php:134) in /usr/local/www/mediawiki/includes/WebResponse.php on line 38
Warning: Cannot modify header information - headers already sent by (output started at /usr/local/www/mediawiki/includes/WebStart.php:134) in /usr/local/www/mediawiki/includes/WebResponse.php on line 38 http://fileformats.archiveteam.org/index.php?action=history&feed=atom&title=LemonLemon - Revision history2025-04-25T07:50:49ZRevision history for this page on the wikiMediaWiki 1.19.2 Warning: require(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/AutoLoader.php on line 1007
Warning: require_once(): Unable to allocate memory for pool. in /usr/local/www/mediawiki/includes/normal/UtfNormal.php on line 193 http://fileformats.archiveteam.org/index.php?title=Lemon&diff=40180&oldid=prevDan Tobias: /* Exported data format */2021-07-11T17:33:22Z<p>‎<span dir="auto"><span class="autocomment">Exported data format</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">↠Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 17:33, 11 July 2021</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 28:</td>
<td colspan="2" class="diff-lineno">Line 28:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Oddly, the street address, state, zip code, and country are included, but not the city.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Oddly, the street address, state, zip code, and country are included, but not the city.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Image URLs are within the host ''repl1.lemon.com'', and lead to pictures of the scanned receipts. There appears to be no security to them beyond the "security-by-obscurity" of the cryptic pathnames within the URL; it might be possible to figure out how to see other people's receipts by tweaking the URLs (though people have been [http://www.dailydot.com/news/andrew-weev-auernheimer-sentenced-41-months/ prosecuted] before for exploiting such vulnerabilities in other companies' systems; it's considered "hacking" even if it's done with a browser address bar). One also never knows how long Lemon will choose to leave those images online; the URLs could break any time.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Image URLs are within the host ''repl1.lemon.com'', and lead to pictures of the scanned receipts. There appears to be no security to them beyond the "security-by-obscurity" of the cryptic pathnames within the URL; it might be possible to figure out how to see other people's receipts by tweaking the URLs (though people have been [http://www.dailydot.com/news/andrew-weev-auernheimer-sentenced-41-months/ prosecuted] before for exploiting such vulnerabilities in other companies' systems; it's considered "hacking" even if it's done with a browser address bar). One also never knows how long Lemon will choose to leave those images online; the URLs could break any time. <ins class="diffchange diffchange-inline">(SPOILER WARNING: As of 2021 they're "404 Not Found".)</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Links ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Links ==</div></td></tr>
</table>Dan Tobiashttp://fileformats.archiveteam.org/index.php?title=Lemon&diff=25516&oldid=prevDan Tobias at 00:14, 27 April 20162016-04-27T00:14:27Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">↠Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 00:14, 27 April 2016</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 8:</td>
<td colspan="2" class="diff-lineno">Line 8:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>They encouraged you to store all your receipts on Lemon's cloud of servers, then toss the originals; one of Lemon's blog postings mentioned how some study or other determined that the chemicals in receipt paper were hazardous to your health, so the sooner you dump all of your receipt hoard the better! What could ''possibly'' go wrong with that?</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>They encouraged you to store all your receipts on Lemon's cloud of servers, then toss the originals; one of Lemon's blog postings mentioned how some study or other determined that the chemicals in receipt paper were hazardous to your health, so the sooner you dump all of your receipt hoard the better! What could ''possibly'' go wrong with that?</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>As it turned out, the businessperson-and-packrat market apparently wasn't the basis of a sufficiently lucrative business model, so they executed a sharp turn in their app's functionality. After introducing "Lemon wallet" functionality where your credit cards, loyalty cards, and other stuff in your wallet is stored (if you trust them enough to give them all your card numbers), they steadily shifted their efforts to this new feature, letting the classic receipt functions wither away. Each successive update removed more functionality; by 2013 they were terminating the web interface to see your spending history in favor of a bare-bones site that only <del class="diffchange diffchange-inline">lets </del>you get at basic account info like your name and e-mail address; you <del class="diffchange diffchange-inline">can </del>only get at the receipt data on the app <del class="diffchange diffchange-inline">now</del>, and that <del class="diffchange diffchange-inline">seems </del>to only show you the last two years of receipts (tough luck, <del class="diffchange diffchange-inline">packrat </del>who scanned in all <del class="diffchange diffchange-inline">his </del>receipts from 1954). <del class="diffchange diffchange-inline">Now </del>they <del class="diffchange diffchange-inline">don't even import </del>information from receipts any more (which was their primary feature when they started); they just <del class="diffchange diffchange-inline">scan </del>in an image and <del class="diffchange diffchange-inline">make </del>you do the work of entering the amount and merchant name and category.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>As it turned out, the businessperson-and-packrat market apparently wasn't the basis of a sufficiently lucrative business model, so they executed a sharp turn in their app's functionality. After introducing "Lemon wallet" functionality where your credit cards, loyalty cards, and other stuff in your wallet is stored (if you trust them enough to give them all your card numbers), they steadily shifted their efforts to this new feature, letting the classic receipt functions wither away. Each successive update removed more functionality; by 2013 they were terminating the web interface to see your spending history in favor of a bare-bones site that only <ins class="diffchange diffchange-inline">let </ins>you get at basic account info like your name and e-mail address; you <ins class="diffchange diffchange-inline">could </ins>only get at the receipt data on the app <ins class="diffchange diffchange-inline">then</ins>, and that <ins class="diffchange diffchange-inline">seemed </ins>to only show you the last two years of receipts (tough luck, <ins class="diffchange diffchange-inline">packrats </ins>who scanned in all <ins class="diffchange diffchange-inline">their </ins>receipts from 1954). <ins class="diffchange diffchange-inline">Then </ins>they <ins class="diffchange diffchange-inline">stopped importing </ins>information from receipts any more (which was their primary feature when they started); they just <ins class="diffchange diffchange-inline">scanned </ins>in an image and <ins class="diffchange diffchange-inline">made </ins>you do the work of entering the amount and merchant name and category.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>So it<del class="diffchange diffchange-inline">'s </del>a good idea, if you <del class="diffchange diffchange-inline">have </del>any receipt data stored in their system, to export whatever you can of it while it<del class="diffchange diffchange-inline">'s </del>possible. Unfortunately, the export feature was one of the features only available to paid accounts, but there was a "free trial" you could sign up for on the app. (Apparently the export <del class="diffchange diffchange-inline">is now </del>available to free customers, however.) If you <del class="diffchange diffchange-inline">do </del>that, you <del class="diffchange diffchange-inline">can </del>go through and get Lemon to export data as a [[CSV]] e-mail attachement, or save it to your account in one of several other services. You <del class="diffchange diffchange-inline">have </del>to do this month by month by selecting dates in a pulldown (there<del class="diffchange diffchange-inline">'s </del>no "export all" feature), and this <del class="diffchange diffchange-inline">seems </del>to only go back two years no matter how many earlier receipts you may have imported. The exported data includes only the totals of each receipt, no line items (even if you had a paid account in the past when they stored line items for such users).</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>So it <ins class="diffchange diffchange-inline">was </ins>a good idea, if you <ins class="diffchange diffchange-inline">had </ins>any receipt data stored in their system, to export whatever you can of it while it <ins class="diffchange diffchange-inline">was </ins>possible. Unfortunately, the export feature was one of the features only available to paid accounts, but there was a "free trial" you could sign up for on the app. (Apparently the export <ins class="diffchange diffchange-inline">was later </ins>available to free customers, however.) If you <ins class="diffchange diffchange-inline">did </ins>that, you <ins class="diffchange diffchange-inline">could </ins>go through and get Lemon to export data as a [[CSV]] e-mail attachement, or save it to your account in one of several other services. You <ins class="diffchange diffchange-inline">had </ins>to do this month by month by selecting dates in a pulldown (there <ins class="diffchange diffchange-inline">was </ins>no "export all" feature), and this <ins class="diffchange diffchange-inline">seemed </ins>to only go back two years no matter how many earlier receipts you may have imported. The exported data includes only the totals of each receipt, no line items (even if you had a paid account in the past when they stored line items for such users).</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>In the web dashboard interface (which went away in June 2013), there was also an export feature, and receipts over 2 years old were visible, but it told you that it's a "paid account feature" even after you signed up for a trial account, so you <del class="diffchange diffchange-inline">can</del>'t export from there, apparently. It's gone, anyway.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>In the web dashboard interface (which went away in June 2013), there was also an export feature, and receipts over 2 years old were visible, but it told you that it's a "paid account feature" even after you signed up for a trial account, so you <ins class="diffchange diffchange-inline">couldn</ins>'t export from there, apparently. It's gone, anyway.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>As of late 2013, it morphed once again into "LifeLock". And then in 2014 it [http://arstechnica.com/tech-policy/2014/05/id-theft-protector-lifelock-deletes-user-data-over-concerns-that-app-isnt-safe/ deleted all customer data] after deciding it wasn't sufficiently secure.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>As of late 2013, it morphed once again into "LifeLock". And then in 2014 it [http://arstechnica.com/tech-policy/2014/05/id-theft-protector-lifelock-deletes-user-data-over-concerns-that-app-isnt-safe/ deleted all customer data] after deciding it wasn't sufficiently secure.</div></td></tr>
</table>Dan Tobiashttp://fileformats.archiveteam.org/index.php?title=Lemon&diff=17539&oldid=prevDan Tobias at 03:27, 21 May 20142014-05-21T03:27:33Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">↠Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 03:27, 21 May 2014</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 14:</td>
<td colspan="2" class="diff-lineno">Line 14:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>In the web dashboard interface (which went away in June 2013), there was also an export feature, and receipts over 2 years old were visible, but it told you that it's a "paid account feature" even after you signed up for a trial account, so you can't export from there, apparently. It's gone, anyway.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>In the web dashboard interface (which went away in June 2013), there was also an export feature, and receipts over 2 years old were visible, but it told you that it's a "paid account feature" even after you signed up for a trial account, so you can't export from there, apparently. It's gone, anyway.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>As of late 2013, it morphed once again into "LifeLock".</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>As of late 2013, it morphed once again into "LifeLock"<ins class="diffchange diffchange-inline">. And then in 2014 it [http://arstechnica.com/tech-policy/2014/05/id-theft-protector-lifelock-deletes-user-data-over-concerns-that-app-isnt-safe/ deleted all customer data] after deciding it wasn't sufficiently secure</ins>.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Exported data format ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Exported data format ==</div></td></tr>
</table>Dan Tobiashttp://fileformats.archiveteam.org/index.php?title=Lemon&diff=16008&oldid=prevDan Tobias at 00:51, 2 February 20142014-02-02T00:51:11Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">↠Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 00:51, 2 February 2014</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 10:</td>
<td colspan="2" class="diff-lineno">Line 10:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>As it turned out, the businessperson-and-packrat market apparently wasn't the basis of a sufficiently lucrative business model, so they executed a sharp turn in their app's functionality. After introducing "Lemon wallet" functionality where your credit cards, loyalty cards, and other stuff in your wallet is stored (if you trust them enough to give them all your card numbers), they steadily shifted their efforts to this new feature, letting the classic receipt functions wither away. Each successive update removed more functionality; by 2013 they were terminating the web interface to see your spending history in favor of a bare-bones site that only lets you get at basic account info like your name and e-mail address; you can only get at the receipt data on the app now, and that seems to only show you the last two years of receipts (tough luck, packrat who scanned in all his receipts from 1954). Now they don't even import information from receipts any more (which was their primary feature when they started); they just scan in an image and make you do the work of entering the amount and merchant name and category.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>As it turned out, the businessperson-and-packrat market apparently wasn't the basis of a sufficiently lucrative business model, so they executed a sharp turn in their app's functionality. After introducing "Lemon wallet" functionality where your credit cards, loyalty cards, and other stuff in your wallet is stored (if you trust them enough to give them all your card numbers), they steadily shifted their efforts to this new feature, letting the classic receipt functions wither away. Each successive update removed more functionality; by 2013 they were terminating the web interface to see your spending history in favor of a bare-bones site that only lets you get at basic account info like your name and e-mail address; you can only get at the receipt data on the app now, and that seems to only show you the last two years of receipts (tough luck, packrat who scanned in all his receipts from 1954). Now they don't even import information from receipts any more (which was their primary feature when they started); they just scan in an image and make you do the work of entering the amount and merchant name and category.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>So it's a good idea, if you have any receipt data stored in their system, to export whatever you can of it while it's possible. Unfortunately, the export feature <del class="diffchange diffchange-inline">is </del>one of the features only available to paid accounts, but there <del class="diffchange diffchange-inline">is </del>a "free trial" you <del class="diffchange diffchange-inline">can </del>sign up for on the app. If you do that, you can go through and get Lemon to export data as a [[CSV]] e-mail attachement, or save it to your account in one of several other services. You have to do this month by month by selecting dates in a pulldown (there's no "export all" feature), and this seems to only go back two years no matter how many earlier receipts you may have imported. The exported data includes only the totals of each receipt, no line items (even if you had a paid account in the past when they stored line items for such users).</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>So it's a good idea, if you have any receipt data stored in their system, to export whatever you can of it while it's possible. Unfortunately, the export feature <ins class="diffchange diffchange-inline">was </ins>one of the features only available to paid accounts, but there <ins class="diffchange diffchange-inline">was </ins>a "free trial" you <ins class="diffchange diffchange-inline">could </ins>sign up for on the app. <ins class="diffchange diffchange-inline">(Apparently the export is now available to free customers, however.) </ins>If you do that, you can go through and get Lemon to export data as a [[CSV]] e-mail attachement, or save it to your account in one of several other services. You have to do this month by month by selecting dates in a pulldown (there's no "export all" feature), and this seems to only go back two years no matter how many earlier receipts you may have imported. The exported data includes only the totals of each receipt, no line items (even if you had a paid account in the past when they stored line items for such users).</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>In the web dashboard interface (which <del class="diffchange diffchange-inline">is going </del>away in June 2013<del class="diffchange diffchange-inline">, but is temporarily accessible until then</del>), there<del class="diffchange diffchange-inline">'s </del>also an export feature, and receipts over 2 years old <del class="diffchange diffchange-inline">are </del>visible, but it <del class="diffchange diffchange-inline">tells </del>you that it's a "paid account feature" even after you<del class="diffchange diffchange-inline">'ve </del>signed up for a trial account, so you can't export from there, apparently.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>In the web dashboard interface (which <ins class="diffchange diffchange-inline">went </ins>away in June 2013), there <ins class="diffchange diffchange-inline">was </ins>also an export feature, and receipts over 2 years old <ins class="diffchange diffchange-inline">were </ins>visible, but it <ins class="diffchange diffchange-inline">told </ins>you that it's a "paid account feature" even after you signed up for a trial account, so you can't export from there, apparently<ins class="diffchange diffchange-inline">. It's gone, anyway.</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">As of late 2013, it morphed once again into "LifeLock"</ins>.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Exported data format ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Exported data format ==</div></td></tr>
</table>Dan Tobiashttp://fileformats.archiveteam.org/index.php?title=Lemon&diff=13395&oldid=prevDan Tobias: /* Links */2013-09-20T12:07:09Z<p>‎<span dir="auto"><span class="autocomment">Links</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">↠Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 12:07, 20 September 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 30:</td>
<td colspan="2" class="diff-lineno">Line 30:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Links ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Links ==</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [http://www.lemon.com/ Lemon site]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [http://www.lemon.com/ Lemon site]</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* [http://developers.lemon.com/ Lemon SDK developer info]</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [http://www.badappreviews.com/iosapps/36577/lemon-wallet Bad app reviews for Lemon Wallet]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [http://www.badappreviews.com/iosapps/36577/lemon-wallet Bad app reviews for Lemon Wallet]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [http://www.accountingweb.co.uk/article/app-review-lemon-ios/523265 A positive review (from back when the app still actually processed receipts)]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [http://www.accountingweb.co.uk/article/app-review-lemon-ios/523265 A positive review (from back when the app still actually processed receipts)]</div></td></tr>
</table>Dan Tobiashttp://fileformats.archiveteam.org/index.php?title=Lemon&diff=11537&oldid=prevDan Tobias: /* Exported data format */2013-05-13T13:07:07Z<p>‎<span dir="auto"><span class="autocomment">Exported data format</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">↠Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 13:07, 13 May 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 26:</td>
<td colspan="2" class="diff-lineno">Line 26:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Oddly, the street address, state, zip code, and country are included, but not the city.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Oddly, the street address, state, zip code, and country are included, but not the city.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Image URLs are within the host ''repl1.lemon.com'', and lead to pictures of the scanned receipts. There appears to be no security to them beyond the "security-by-obscurity" of the cryptic pathnames within the URL; it might be possible to figure out how to see other people's receipts by tweaking the URLs (though people have been prosecuted before for exploiting such vulnerabilities in other companies' systems; it's considered "hacking" even if it's done with a browser address bar). One also never knows how long Lemon will choose to leave those images online; the URLs could break any time.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Image URLs are within the host ''repl1.lemon.com'', and lead to pictures of the scanned receipts. There appears to be no security to them beyond the "security-by-obscurity" of the cryptic pathnames within the URL; it might be possible to figure out how to see other people's receipts by tweaking the URLs (though people have been <ins class="diffchange diffchange-inline">[http://www.dailydot.com/news/andrew-weev-auernheimer-sentenced-41-months/ </ins>prosecuted<ins class="diffchange diffchange-inline">] </ins>before for exploiting such vulnerabilities in other companies' systems; it's considered "hacking" even if it's done with a browser address bar). One also never knows how long Lemon will choose to leave those images online; the URLs could break any time.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Links ==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>== Links ==</div></td></tr>
</table>Dan Tobiashttp://fileformats.archiveteam.org/index.php?title=Lemon&diff=11526&oldid=prevDan Tobias: /* Links */2013-05-12T19:37:19Z<p>‎<span dir="auto"><span class="autocomment">Links</span></span></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">↠Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 19:37, 12 May 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 31:</td>
<td colspan="2" class="diff-lineno">Line 31:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [http://www.lemon.com/ Lemon site]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [http://www.lemon.com/ Lemon site]</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [http://www.badappreviews.com/iosapps/36577/lemon-wallet Bad app reviews for Lemon Wallet]</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>* [http://www.badappreviews.com/iosapps/36577/lemon-wallet Bad app reviews for Lemon Wallet]</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* [http://www.accountingweb.co.uk/article/app-review-lemon-ios/523265 A positive review (from back when the app still actually processed receipts)]</ins></div></td></tr>
</table>Dan Tobiashttp://fileformats.archiveteam.org/index.php?title=Lemon&diff=11525&oldid=prevDan Tobias at 19:35, 12 May 20132013-05-12T19:35:58Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">↠Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 19:35, 12 May 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 27:</td>
<td colspan="2" class="diff-lineno">Line 27:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Image URLs are within the host ''repl1.lemon.com'', and lead to pictures of the scanned receipts. There appears to be no security to them beyond the "security-by-obscurity" of the cryptic pathnames within the URL; it might be possible to figure out how to see other people's receipts by tweaking the URLs (though people have been prosecuted before for exploiting such vulnerabilities in other companies' systems; it's considered "hacking" even if it's done with a browser address bar). One also never knows how long Lemon will choose to leave those images online; the URLs could break any time.</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Image URLs are within the host ''repl1.lemon.com'', and lead to pictures of the scanned receipts. There appears to be no security to them beyond the "security-by-obscurity" of the cryptic pathnames within the URL; it might be possible to figure out how to see other people's receipts by tweaking the URLs (though people have been prosecuted before for exploiting such vulnerabilities in other companies' systems; it's considered "hacking" even if it's done with a browser address bar). One also never knows how long Lemon will choose to leave those images online; the URLs could break any time.</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">== Links ==</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* [http://www.lemon.com/ Lemon site]</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">* [http://www.badappreviews.com/iosapps/36577/lemon-wallet Bad app reviews for Lemon Wallet]</ins></div></td></tr>
</table>Dan Tobiashttp://fileformats.archiveteam.org/index.php?title=Lemon&diff=11524&oldid=prevDan Tobias at 19:25, 12 May 20132013-05-12T19:25:42Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">↠Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 19:25, 12 May 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 4:</td>
<td colspan="2" class="diff-lineno">Line 4:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>}}</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>}}</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>'''Lemon''' started in 2011 as an app to scan sales receipts, which were then read, interpreted, and categorized for you by their back-end server software and made available for you to see, individually and in totals by category, on the app and on the web. It was a pretty neat idea, for everybody from businesspeople needing to sort their receipts for expense reporting to packrats hoarding all their sales receipts since 1954 in the hopes of eventually finding something useful to do with them. At the start, a free Lemon account let you scan an unlimited number of receipts, and a paid add-on added the functionality of including complete line-item detail in the scanned receipts instead of just the total as given to free accounts.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>'''Lemon''' <ins class="diffchange diffchange-inline">(whose name was perhaps the result of the fact that all the less-sour fruits were already taken) </ins>started in 2011 as an app to scan sales receipts, which were then read, interpreted, and categorized for you by their back-end server software and made available for you to see, individually and in totals by category, on the app and on the web. It was a pretty neat idea, for everybody from businesspeople needing to sort their receipts for expense reporting to packrats hoarding all their sales receipts since 1954 in the hopes of eventually finding something useful to do with them. At the start, a free Lemon account let you scan an unlimited number of receipts, and a paid add-on added the functionality of including complete line-item detail in the scanned receipts instead of just the total as given to free accounts.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>They encouraged you to store all your receipts on Lemon's cloud of servers, then toss the originals; one of Lemon's blog postings mentioned how some study or other determined that the chemicals in receipt paper were hazardous to your health, so the sooner you dump all of your receipt hoard the better! What could ''possibly'' go wrong with that?</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>They encouraged you to store all your receipts on Lemon's cloud of servers, then toss the originals; one of Lemon's blog postings mentioned how some study or other determined that the chemicals in receipt paper were hazardous to your health, so the sooner you dump all of your receipt hoard the better! What could ''possibly'' go wrong with that?</div></td></tr>
</table>Dan Tobiashttp://fileformats.archiveteam.org/index.php?title=Lemon&diff=11523&oldid=prevDan Tobias: Created page with "{{FormatInfo |subcat=Finance and Accounting |released=2011 }} '''Lemon''' started in 2011 as an app to scan sales receipts, which were then read, interpreted, and categorized..."2013-05-12T18:39:31Z<p>Created page with "{{FormatInfo |subcat=Finance and Accounting |released=2011 }} '''Lemon''' started in 2011 as an app to scan sales receipts, which were then read, interpreted, and categorized..."</p>
<p><b>New page</b></p><div>{{FormatInfo<br />
|subcat=Finance and Accounting<br />
|released=2011<br />
}}<br />
<br />
'''Lemon''' started in 2011 as an app to scan sales receipts, which were then read, interpreted, and categorized for you by their back-end server software and made available for you to see, individually and in totals by category, on the app and on the web. It was a pretty neat idea, for everybody from businesspeople needing to sort their receipts for expense reporting to packrats hoarding all their sales receipts since 1954 in the hopes of eventually finding something useful to do with them. At the start, a free Lemon account let you scan an unlimited number of receipts, and a paid add-on added the functionality of including complete line-item detail in the scanned receipts instead of just the total as given to free accounts.<br />
<br />
They encouraged you to store all your receipts on Lemon's cloud of servers, then toss the originals; one of Lemon's blog postings mentioned how some study or other determined that the chemicals in receipt paper were hazardous to your health, so the sooner you dump all of your receipt hoard the better! What could ''possibly'' go wrong with that?<br />
<br />
As it turned out, the businessperson-and-packrat market apparently wasn't the basis of a sufficiently lucrative business model, so they executed a sharp turn in their app's functionality. After introducing "Lemon wallet" functionality where your credit cards, loyalty cards, and other stuff in your wallet is stored (if you trust them enough to give them all your card numbers), they steadily shifted their efforts to this new feature, letting the classic receipt functions wither away. Each successive update removed more functionality; by 2013 they were terminating the web interface to see your spending history in favor of a bare-bones site that only lets you get at basic account info like your name and e-mail address; you can only get at the receipt data on the app now, and that seems to only show you the last two years of receipts (tough luck, packrat who scanned in all his receipts from 1954). Now they don't even import information from receipts any more (which was their primary feature when they started); they just scan in an image and make you do the work of entering the amount and merchant name and category.<br />
<br />
So it's a good idea, if you have any receipt data stored in their system, to export whatever you can of it while it's possible. Unfortunately, the export feature is one of the features only available to paid accounts, but there is a "free trial" you can sign up for on the app. If you do that, you can go through and get Lemon to export data as a [[CSV]] e-mail attachement, or save it to your account in one of several other services. You have to do this month by month by selecting dates in a pulldown (there's no "export all" feature), and this seems to only go back two years no matter how many earlier receipts you may have imported. The exported data includes only the totals of each receipt, no line items (even if you had a paid account in the past when they stored line items for such users).<br />
<br />
In the web dashboard interface (which is going away in June 2013, but is temporarily accessible until then), there's also an export feature, and receipts over 2 years old are visible, but it tells you that it's a "paid account feature" even after you've signed up for a trial account, so you can't export from there, apparently.<br />
<br />
== Exported data format ==<br />
<br />
The exported data is a [[CSV]] file with these fields:<br />
<br />
"#","Date","Time","Merchant","Total","Currency","Total in USD","Address","ZIP","State","Country","Tax","Note","Main Category","Sub Category","Expense Category","Image URL","Personal","(other user-created categories come here)"<br />
<br />
The first field is a consecutive number of the transaction within the particular export file (not a unique number for your whole history).<br />
<br />
Dates are in the format "02 Mar, 2013", and times are 24-hour "hh:mm".<br />
<br />
Oddly, the street address, state, zip code, and country are included, but not the city.<br />
<br />
Image URLs are within the host ''repl1.lemon.com'', and lead to pictures of the scanned receipts. There appears to be no security to them beyond the "security-by-obscurity" of the cryptic pathnames within the URL; it might be possible to figure out how to see other people's receipts by tweaking the URLs (though people have been prosecuted before for exploiting such vulnerabilities in other companies' systems; it's considered "hacking" even if it's done with a browser address bar). One also never knows how long Lemon will choose to leave those images online; the URLs could break any time.</div>Dan Tobias