tag:blogger.com,1999:blog-74558706612530011952011-07-08T06:10:18.882-07:00Bo Snitkjær Nielsenhttp://www.blogger.com/profile/18396398806129920106noreply@blogger.comBlogger31100tag:blogger.com,1999:blog-7455870661253001195.post-79461302962819856052009-12-01T02:54:00.000-08:002009-12-01T03:08:25.090-08:00There are 5 rows in the spreadsheet used for the import<br /><br /><ol><li>Account no.</li><li>Text note</li><li>From date *<br /></li><li>To date *</li><li>Amount (rember income is negativ and expense is positive in accounting ) **<br /></li></ol><br />* Data needs to be in this format yyyy-mm-dd i.e. 2009-12-01, google sheet can format this for you and<br />** So far tested with danish number separators i.e. <span id="result_box" class="short_text"><span style="background-color: rgb(255, 255, 255);" title="tusind">one thousand </span></span>is 1.000,00, alternatively don't use <span id="result_box" class="short_text"><span style="background-color: rgb(255, 255, 255);" title="tusind">thousand separators<br /></span></span><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7455870661253001195-7946130296281985605?l=economic-google-docs.blogspot.com' alt='' /></div>Bo Snitkjær Nielsenhttp://www.blogger.com/profile/18396398806129920106noreply@blogger.com0tag:blogger.com,1999:blog-7455870661253001195.post-2839402907195202122009-12-01T02:28:00.000-08:002009-12-01T02:30:24.940-08:00You can get the project source code <a href="http://code.google.com/p/economic-google-docs/">here</a><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7455870661253001195-283940290719520212?l=economic-google-docs.blogspot.com' alt='' /></div>Bo Snitkjær Nielsenhttp://www.blogger.com/profile/18396398806129920106noreply@blogger.com0tag:blogger.com,1999:blog-7455870661253001195.post-63213096557206262222009-12-01T01:51:00.000-08:002009-12-08T07:29:36.846-08:00<ol><li><span class="blsp-spelling-error" id="SPELLING_ERROR_0">Create</span> a Google <span class="blsp-spelling-error" id="SPELLING_ERROR_1">spreadsheet</span> to <span class="blsp-spelling-error" id="SPELLING_ERROR_2">use</span> for <span class="blsp-spelling-error" id="SPELLING_ERROR_3">exporting</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_4">your</span> budget data <span class="blsp-spelling-error" id="SPELLING_ERROR_5">into</span> www.e-conomic.dk, <span class="blsp-spelling-error" id="SPELLING_ERROR_6">see</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_7">the</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_8">picture</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_9">below</span> for <span class="blsp-spelling-error" id="SPELLING_ERROR_10">the</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_11">syntax</span><br /></li><li><span class="blsp-spelling-error" id="SPELLING_ERROR_12">Add</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_13">the</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_14">gadget</span> from <span class="blsp-spelling-error" id="SPELLING_ERROR_15">this</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_16">url</span> <a href="http://hosting.gmodules.com/ig/gadgets/file/117702584331648449273/cs-gadget-16.xml?nocache" rel="nofollow">http://hosting.gmodules.com/ig/gadgets/file/117702584331648449273/cs-gadget-16.xml?nocache</a></li><li><span class="blsp-spelling-error" id="SPELLING_ERROR_17">Enter</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_18">the</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_19">values</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_20">you</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_21">wish</span> to <span class="blsp-spelling-error" id="SPELLING_ERROR_22">export</span> to <span class="blsp-spelling-error" id="SPELLING_ERROR_23">E-conomic</span><br /></li><li><span class="blsp-spelling-error" id="SPELLING_ERROR_24">Enter</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_25">your</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_26">Agreement</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_27">no.</span> and <span class="blsp-spelling-error" id="SPELLING_ERROR_28">user</span> id</li><li><span class="blsp-spelling-error" id="SPELLING_ERROR_29">Press</span> "anvend" (<span class="blsp-spelling-error" id="SPELLING_ERROR_30">use</span> in <span class="blsp-spelling-error" id="SPELLING_ERROR_31">danish</span>)</li><li>Mark <span class="blsp-spelling-error" id="SPELLING_ERROR_32">the</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_33">values</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_34">you</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_35">wish</span> to import in <span class="blsp-spelling-error" id="SPELLING_ERROR_36">the</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_37">the</span> interval <span class="blsp-spelling-error" id="SPELLING_ERROR_38">field</span></li><li><span class="blsp-spelling-error" id="SPELLING_ERROR_39">Enter</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_40">e-conomic</span> password in <span class="blsp-spelling-error" id="SPELLING_ERROR_41">the</span> password <span class="blsp-spelling-error" id="SPELLING_ERROR_42">field</span> </li><li><span class="blsp-spelling-error" id="SPELLING_ERROR_43">Press</span> "<span class="blsp-spelling-error" id="SPELLING_ERROR_44">Update</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_45">e-conomic</span>" to import <span class="blsp-spelling-error" id="SPELLING_ERROR_46">your</span> budget data<br /></li></ol><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_jh-Rq24deIc/SxToTis6AmI/AAAAAAAAA4s/uFXL8okg0_k/s1600/Capture.JPG"><img style="margin: 0pt 10px 10px 0pt; float: left; cursor: pointer; width: 320px; height: 156px;" src="http://3.bp.blogspot.com/_jh-Rq24deIc/SxToTis6AmI/AAAAAAAAA4s/uFXL8okg0_k/s320/Capture.JPG" alt="" id="BLOGGER_PHOTO_ID_5410204474809123426" border="0" /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><span class="blsp-spelling-error" id="SPELLING_ERROR_47"></span><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/7455870661253001195-6321309655720626222?l=economic-google-docs.blogspot.com' alt='' /></div>Bo Snitkjær Nielsenhttp://www.blogger.com/profile/18396398806129920106noreply@blogger.com0