tag:blogger.com,1999:blog-57231003088526139642024-03-05T07:39:03.109+02:003H ConsultingWelcome to my blog!
It aims to share useful information and tips about some tools and software I use in my daily work, especially related to business applications.Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-5723100308852613964.post-64445188523101443042020-09-19T12:59:00.004+02:002020-09-19T13:45:20.855+02:00PDFsam Basic an open source solution for manipulating pdfs files<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgDXxVE6SwPqDRlzXKB9Ls39t7JsGJO2eUfdq_WICURD0yjgrH-6Wsgsia3BfFKDVVSiwrJp-AmF1sY2wFlk7_vdSWjwmDW70VcEEnoT_1ccOUZv4UhGAkznWJQnOe6YEZAnaPR8IMUlLk/s216/pdfsam.PNG" style="margin-left: 1em; margin-right: 1em;"><img alt="pdfsam" border="0" data-original-height="54" data-original-width="216" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgDXxVE6SwPqDRlzXKB9Ls39t7JsGJO2eUfdq_WICURD0yjgrH-6Wsgsia3BfFKDVVSiwrJp-AmF1sY2wFlk7_vdSWjwmDW70VcEEnoT_1ccOUZv4UhGAkznWJQnOe6YEZAnaPR8IMUlLk/s16000/pdfsam.PNG" /></a></div><p><span style="font-size: medium;">Do you work with a lot of pdfs files, do you need to split, merge, extract pages, mix and rotates PDF files? <a href="https://pdfsam.org/pdfsam-basic/" target="_blank">PDFsam Basic</a> is the solution, it is a free, open source, multi-platform software. It is user friendly and available for Mac Os, Linux and Windows for installation. And if your are not able to install software on your companies laptop, because of permissions, you can <a href="https://pdfsam.org/download-pdfsam-basic/" target="_blank">download</a> the portable version for each of the platform.</span></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBGP_pChBhP45AjuFul8bD0DqI-_oalPppjbaEKin1Ba6taIHE7dOrmXSdXXYM6J18rPhQWJb9wNTc2nJvUzhNjFvp9_gIum3cwNpCDg0QUw0tVzVTlqrVwAXCrMFN9LS-Ho1kH54tcrAO/s1311/pdfsam-merge-home.jpg" style="margin-left: 1em; margin-right: 1em;"><img alt="pdfsam-merge" border="0" data-original-height="785" data-original-width="1311" height="384" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBGP_pChBhP45AjuFul8bD0DqI-_oalPppjbaEKin1Ba6taIHE7dOrmXSdXXYM6J18rPhQWJb9wNTc2nJvUzhNjFvp9_gIum3cwNpCDg0QUw0tVzVTlqrVwAXCrMFN9LS-Ho1kH54tcrAO/w640-h384/pdfsam-merge-home.jpg" width="640" /></a></div><br /><p><br /></p>Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com0tag:blogger.com,1999:blog-5723100308852613964.post-11446511040797672462020-09-18T22:41:00.004+02:002020-09-18T22:43:31.367+02:00Activate Developer Tab in Excel <p>Do you need to activate the The <b>Developer</b> tab? </p><p>It isn't displayed by default, but you can add it to the ribbon.</p><p>On the File tab, go to Options > Customize Ribbon.</p><p>Under Customize the Ribbon and under Main Tabs, select the <b>Developer</b> check box.</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0PXvH2jzm45KQDQUsjFPu_0LxnqfXrnD6H5Tp1-a1-JgirqKT9MPt0TFGFEgjuyus7p-Etpue3sPpFJatm_hIMG_v5h-_dAbcFmCcet0e3pwQABLBS07-i_bx3gYiDJxFn9b1AptdUna-/s683/image.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="424" data-original-width="683" height="398" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0PXvH2jzm45KQDQUsjFPu_0LxnqfXrnD6H5Tp1-a1-JgirqKT9MPt0TFGFEgjuyus7p-Etpue3sPpFJatm_hIMG_v5h-_dAbcFmCcet0e3pwQABLBS07-i_bx3gYiDJxFn9b1AptdUna-/w640-h398/image.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><p></p>Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com0tag:blogger.com,1999:blog-5723100308852613964.post-59584749329392265642020-09-18T20:04:00.010+02:002020-09-18T22:46:52.877+02:00Website login using excel vba<p>Do you need to constantly login, introduce username and password into a website in order to check updated data? </p><p>For example, if your are working with account receivables, do you need to check your company´s bank accounts to confirm if new deposits are available? And for that you have to input username and password manually every time you go to the bank website? Depending on the bank website, there is a timeout that is applied of 3 or 5 minutes and the website automatically logouts, so if you check the bank website 20 times, you have to input the username and password 20 times manually and it is prone to error. </p><p>To avoid the manual input of the credentials and the potential typing error, you can use excel with vba macro to automate the login process and it is valid for all websites that requires username and password.</p><p>Will show an example of login to a account in the Facebook website using excel and vba macro. What the macro does it is to automate the login process: creates a Internet Explorer windows and fills the username and password fields and clicks the login button.</p>For that, on the Visual Basic window, you need to include some libraries, go to References and select the following library: "Microsoft Internet Controls"<p></p><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJWN93vscydjyAOd5ni9lKhj_hpZj63QUifphyLYgcC19dQk2hpjlEscfr4Wb5WLu6cSJYS2Dxo-7amLFGoTmKKwTHMSTvvPVWvwQIH400IDoRtlearaVsaooT55DhzF4efqN7VkXajbwP/" style="margin-left: 1em; margin-right: 1em;"><img data-original-height="229" data-original-width="708" height="208" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJWN93vscydjyAOd5ni9lKhj_hpZj63QUifphyLYgcC19dQk2hpjlEscfr4Wb5WLu6cSJYS2Dxo-7amLFGoTmKKwTHMSTvvPVWvwQIH400IDoRtlearaVsaooT55DhzF4efqN7VkXajbwP/w640-h208/image.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div></div></div><div style="margin-left: 1em; margin-right: 1em; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3_q1NBe3FLHhcFmRY7F8PFrbFOKsmAzFlQx9WkoAfHNVyShHAS4Sf2PHgimDeIs3xuMp5i0GeruWyW2xNoZ_vTFX5vnKkSaRJGCp7sZRabLfKnWcLX72OrSy5Uxc9rwWNX5UuXmM4FrK1/" style="margin-left: 1em; margin-right: 1em;"><img data-original-height="444" data-original-width="521" height="340" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3_q1NBe3FLHhcFmRY7F8PFrbFOKsmAzFlQx9WkoAfHNVyShHAS4Sf2PHgimDeIs3xuMp5i0GeruWyW2xNoZ_vTFX5vnKkSaRJGCp7sZRabLfKnWcLX72OrSy5Uxc9rwWNX5UuXmM4FrK1/w400-h340/image.png" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><span style="text-align: left;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><div style="text-align: justify;"><span style="text-align: left;">After including this reference create or copy this procedure on VBA and fill with your username and password.</span></div></div></div></div><span style="text-align: left;"><div class="separator" style="clear: both; text-align: center;"><br /></div>
<pre><code>Sub SearchBotLogin()
'declare an Internet Explorer Object
Dim objIE As InternetExplorer
'create a new Internet Object
Set objIE = New InternetExplorer
'Set the Explorer to VIsible
objIE.Visible = True
'fill the Excel status bar with some progess information
Application.StatusBar = "Login"
'navigate IE to the web page
objIE.navigate "https://www.facebook.com/"
'wait here a few seconds while the browser is busy
Do While objIE.Busy = True Or objIE.readyState <> 4: DoEvents: Loop
'fill the username in the username field id
objIE.document.getElementById("<b>email</b>").Value = <b>"username"</b>
'wait here a few seconds while the browser is busy
Do While objIE.Busy = True Or objIE.readyState <> 4: DoEvents: Loop
'fill the username in the password field id
objIE.document.getElementById("<b>pass</b>").Value = <b>"password"</b>
'wait here a few seconds while the browser is busy
Do While objIE.Busy = True Or objIE.readyState <> 4: DoEvents: Loop
'click the 'Login' button
objIE.document.getElementById("<b>u_0_f</b>").Click
'wait again for the browser
Do While objIE.Busy = True Or objIE.readyState <> 4: DoEvents: Loop
'fill the Excel status bar with some progress information
Application.StatusBar = "Login OK"
End Sub</code></pre>The elements for username, password and login button can be obtained using the inspection tool on the Internet Explorer</span><div><span style="text-align: left;"><br /></span></div><div><span style="text-align: left;"><br /></span></div>Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com0tag:blogger.com,1999:blog-5723100308852613964.post-14201282260718623882014-03-28T23:23:00.000+02:002014-03-28T23:41:59.873+02:00IDEs for OpenErp Development<div dir="ltr" style="text-align: left;" trbidi="on">
PyCharm IDE seems nice for Openerp development:<br />
<br />
<ul style="text-align: left;">
<li>www.jetbrains.com/pycharm</li>
</ul>
<br />
Please feel free to suggest any other IDE.</div>
Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com0tag:blogger.com,1999:blog-5723100308852613964.post-85067912546728441302013-03-16T13:49:00.001+02:002013-05-05T12:01:25.346+02:00Productive employees... <div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr">
Harvard Business Review: Want Productive Employees? Treat Them Like Adults. <a href="http://goo.gl/mag/xVOJG7x">http://goo.gl/mag/xVOJG7x</a></div>
</div>
Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com0tag:blogger.com,1999:blog-5723100308852613964.post-55290174698901976142011-07-23T13:46:00.000+02:002011-07-23T13:46:51.571+02:00VB script to backup and send e-mailSometimes there is the need to send regularly to a specific e-mail address\person files with updated data. And most of the times it is done at the end of the day, when all the transaction of the day were recorded and ready to send. It can be quite boring if you do it every day, using for example outlook or the webmail, because the steps are always the same: creating the e-mail, adding the email address zipping the content, attaching the content, writing the subject and the body and sending the e-mail. And if you use webmail there are additional steps of logging on and the file uploading. So why not finding a solution that does this automatically with no human intervention.<br />
<br />
And it is possible if we combine windows task manager, some vb script, 7z and a Gmail account. You can download the source code at <a href="https://sites.google.com/site/3hadvisory/files/sendMail.zip?attredirects=0&d=1">sendMail</a>. The zip file contains 3 files: <br />
<ol><li>sendMail.vbs - vb script</li>
<li>7z.exe - program to create the zip file</li>
<li>logs.txt - log file to log the time and the events</li>
</ol><span style="color: black;">Some configuration is needed:</span><br />
<br />
<span style="color: blue;">homePath = "C:\xxx\" <span style="color: black;">'folder where sendMail.vbs, logs.txt, 7z.exe and created zip files are</span><br />
dataPath = "C:\xxxx\" <span style="color: black;">' folder that contains the files to zip</span><br />
attachFile ="zipFile.ZIP" </span><span style="color: black;">'created zip file that will be attached to the e-mail</span><br />
<br />
<span style="color: blue;">if zipFile("MAP*.?10") = 0 then </span><span style="color: black;">' file name of the file to zip or a wildcard containing the files to zip</span><br />
<br />
<span style="color: blue;"><span style="color: black;">For sending the e-mail, configure correctly the following parameters with your Gmail account details:</span></span><br />
<br />
<span style="color: blue;">With objEmail<br />
.from = <span style="color: black;">"</span><a href="mailto:xxx@gmail.com"><span style="color: black;">xxx@gmail.com</span></a><span style="color: black;">" </span><br />
.To = <span style="color: black;">"</span><a href="mailto:xxx@gmail.com"><span style="color: black;">xxx@gmail.com</span></a><span style="color: black;">; </span><a href="mailto:xxx@yahoo.com.br"><span style="color: black;">xxx@yahoo.com.br</span></a><span style="color: black;">"</span> .Subject = <span style="color: black;">"Test Mail"</span> .Textbody = <span style="color: black;">"The quick brown fox " & Chr(10) & "jumps over the lazy dog"</span> </span><span style="color: blue;"></span><br />
<span style="color: blue;"> .Item (schema & "smtpserver") = <span style="color: black;">"smtp.gmail.com"</span><br />
.Item (schema & "sendusername") = <span style="color: black;">"</span><a href="mailto:xxx@gmail.com"><span style="color: black;">xxx@gmail.com</span></a><span style="color: black;">"</span><br />
.Item (schema & "smtpaccountname") = <span style="color: black;">"</span><a href="mailto:xxx@gmail.com"><span style="color: black;">xxx@gmail.com</span></a><span style="color: black;">"</span><br />
.Item (schema & "sendpassword") =<span style="color: black;">"xxxxxx"</span></span><span style="color: blue;"></span><br />
<span style="color: black;">You can test it double clicking on the sendMail.vbs file and checking thee events logged on the logs.txt.</span><br />
<br />
<span style="color: black;">Later I will be explaining how run this file regularly from windows task manager.</span><br />
<span style="color: black;"><br />
</span>Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com0tag:blogger.com,1999:blog-5723100308852613964.post-81015931076555139622010-11-21T18:52:00.000+02:002011-05-22T13:19:23.979+02:00Applications can no longer be added as a custom tab in FacebookWondering why facebook disabled the following feature for applications:<br />
<br />
"Due to changes in Facebook, you can no longer add Cities I've Visited (or any Facebook application) to a custom tab on your Facebook Profile page. Facebook phased out this feature and suggests that you access your favorite Facebook apps from the left hand navigation on your Facebook homepage." (<a href="http://www.tripadvisor.com/help/map_custom_tab">source</a>)Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com1tag:blogger.com,1999:blog-5723100308852613964.post-1721425315675927772010-11-06T14:20:00.000+02:002011-05-22T13:24:21.205+02:00Free domain name hosting and free web hosting serviceIf you don´t bother to have your web site name ending with co.cc and you are searching for a free domain name service, <a href="http://www.co.cc/?id=696956">co.cc</a> offer can be a nice solution. If you have a blog ending with blogname.blogspot.com you can easily transform it to blogname.co.cc with just a <a href="http://www.co.cc/blogger/blogger.php">few changes</a>. You can also easily integrate with <a href="http://www.co.cc/adsense/adsense.php"><span id="goog_526792022"></span>Adsense<span id="goog_526792023"></span></a>, <a href="http://www.co.cc/windowlive/windowlive.php">Windows Live</a>, and <a href="http://www.co.cc/google_apps/google_apps.php">Google Apps</a>. It also offers a control panel where you can easily edit the following parameters: CNAME, A, MX, NS, TXT. <br />
<br />
After creating and configuring a new domain name you may search on Google for free web hosting and get many links writing and ranking free web hosting services. <a href="http://www.000webhost.com/375128.html">000webhost.com</a> is probably one of the best free web hosting providers. A free hosting account includes 1500 MB Disk Space, 100 GB Data Transfer,PHP with MySQL Database Support, cPanel Control Panel, Fantastico De Luxe 1-Click Autoinstaller and Website Builder Software. This can be very useful if you are building a site using Joomla open source content management system. <br />
<br />
Using <a href="http://www.co.cc/?id=696956">co.cc</a> and <a href="http://www.000webhost.com/375128.html">000webhost.com</a> together is a great combination.<br />
<br />
See also: <a href="http://3hconsulting.blogspot.com/p/recommended-sites.html">Recommended Sites</a>Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com1tag:blogger.com,1999:blog-5723100308852613964.post-73206159087204361372010-10-29T23:31:00.000+02:002010-11-04T10:30:22.946+02:00How to add a logo picture to Openerp Sales Order reportTo add a logo picture to the sales order report there are 2 possibilities:<br />
<br />
1. Adding directly to the company General Information tab and changing the following values at Header/Footer tab for ajusting the height and width:<br />
<image x="1.3cm" y="27.6cm" height="40.0" >[[company.logo]]</image><br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqY375iC2fyGI2JAWVqc1e9y5nR8frliwJoqvuBmP9a4UdpnWgZqrLx60uxkBweevWYRyLRsO8bmOtiu_WPoWgN9DhiMNSpTCYsJ0aJoOnlTgwdfG8hu-uWxgkCd2PFvNNexB4s8R-17C4/s1600/add_pic_5.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="248" nx="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgqY375iC2fyGI2JAWVqc1e9y5nR8frliwJoqvuBmP9a4UdpnWgZqrLx60uxkBweevWYRyLRsO8bmOtiu_WPoWgN9DhiMNSpTCYsJ0aJoOnlTgwdfG8hu-uWxgkCd2PFvNNexB4s8R-17C4/s320/add_pic_5.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Openerp company configuration</td></tr>
</tbody></table> <br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5uV3zUVxcWGNxJN7CepknYoudiNkzZvcO5mY8uzT73O3L5C9_W62BKZKQo5iIAOn0AeprO4c9tFxNp3O3q_vdY5xCDpU4rrRj_b0FGZmJCgzsOPXTrurTDsMH7VZr5G_mBk9U-cuTkMQN/s1600/add_pic_4.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="192" nx="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5uV3zUVxcWGNxJN7CepknYoudiNkzZvcO5mY8uzT73O3L5C9_W62BKZKQo5iIAOn0AeprO4c9tFxNp3O3q_vdY5xCDpU4rrRj_b0FGZmJCgzsOPXTrurTDsMH7VZr5G_mBk9U-cuTkMQN/s320/add_pic_4.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Openerp sales order report preview</td></tr>
</tbody></table><div class="separator" style="clear: both; text-align: center;"><br />
</div> 2. Inserting the picture into the *.sxw file and upload the picture file to the server root folder with the appropriate file name.<br />
<div align="center">Open the Sales Order report *:swx file.</div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhYUQgmFa60aj63xUD64Qt6PaREXdxonuGKl0Rzb98OzMG03hnY5OdpmnCK_sDGX-nPPzIOQBAAFD45mk8gmoa-so_9sQcXLvbS9kYfe6Mo2mMmWxMikDbOKW-wJ4YNhIY-TGj1ZngFtqu/s1600/add_pic_1.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="200" nx="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhYUQgmFa60aj63xUD64Qt6PaREXdxonuGKl0Rzb98OzMG03hnY5OdpmnCK_sDGX-nPPzIOQBAAFD45mk8gmoa-so_9sQcXLvbS9kYfe6Mo2mMmWxMikDbOKW-wJ4YNhIY-TGj1ZngFtqu/s320/add_pic_1.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Insert picture into *.sxw file</td></tr>
</tbody></table><div style="text-align: center;">Then follow the <a href="http://3hconsulting.blogspot.com/2010/10/how-to-edit-openerp-sales-order.html">instructions to load</a> the changed *.sxw file into Openerp.</div><div style="text-align: center;"><br />
</div><div style="text-align: center;">When trying to run the report you will get the following error:</div><div style="text-align: center;"> </div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOUbGzrVM4nZOjXsrTAzdEHgU5WXh9MJ8NvYicoMGdP7l2hKH2bF_rD481qYurQ-F0TSseAPe24zIKWhAuMrpSG2KkJIz0M8yU2JPu_7kYWZF5bjB2_MlrJxDn8vBDXNQnh5cO9t98YpBo/s1600/add_pic_2.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="285" nx="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOUbGzrVM4nZOjXsrTAzdEHgU5WXh9MJ8NvYicoMGdP7l2hKH2bF_rD481qYurQ-F0TSseAPe24zIKWhAuMrpSG2KkJIz0M8yU2JPu_7kYWZF5bjB2_MlrJxDn8vBDXNQnh5cO9t98YpBo/s320/add_pic_2.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Error when running the sales report</td></tr>
</tbody></table><br />
<div style="text-align: center;">The last line of the error indicates that the logo file is missing at Openerp server.</div><div align="center" class="separator" style="clear: both; text-align: center;">Please upload to the server root folder the logo file that we previously inserted in the *.sxw file and rename it with the name indicated in the error. At the end you will probably get the following result:</div><div align="center" class="separator" style="clear: both; text-align: center;"><br />
</div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyQe56UIeT6xOTvna4gD7dW-bwvgtn3ykDhCpHAs6oDLWRI6L9JLT99puJELA9avz8Y0pcNB4NMuh_QNpVG3of-vI20nX7G1zW42isJ7-l3MiFIa4nMp-9EEWoYw7GBdQf_Q0buRCtBUD5/s1600/add_pic_3.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="192" nx="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyQe56UIeT6xOTvna4gD7dW-bwvgtn3ykDhCpHAs6oDLWRI6L9JLT99puJELA9avz8Y0pcNB4NMuh_QNpVG3of-vI20nX7G1zW42isJ7-l3MiFIa4nMp-9EEWoYw7GBdQf_Q0buRCtBUD5/s320/add_pic_3.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Adding a logo using openoffice</td></tr>
</tbody></table><strong>Seel also:</strong><img alt="" border="0" height="1" src="http://www.assoc-amazon.com/e/ir?t=3hcons-20&l=btl&camp=213689&creative=392969&o=1&a=0764542222" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; margin: 0px; padding-bottom: 0px !important; padding-left: 0px !important; padding-right: 0px !important; padding-top: 0px !important;" width="1" /> <a href="http://3hconsulting.blogspot.com/2010/09/how-to-edit-openerp-pos-receipt.html"><span style="color: #888888;">How to edit Openerp POS receipt template</span></a>, <a href="http://3hconsulting.blogspot.com/2010/10/how-to-edit-openerp-sales-order.html"><span style="color: #888888;">How to edit Openerp Sales Order report/template</span></a> <br />
<div align="center" class="separator" style="clear: both; text-align: center;"><input name="IL_RELATED_TAGS" type="hidden" value="1" /></div>Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com0tag:blogger.com,1999:blog-5723100308852613964.post-44372160693429996012010-10-29T12:57:00.000+02:002010-11-01T09:13:55.313+02:00report_openoffice: OpenOffice.org reporting engine for OpenERPreport_openoffice module has overgrown itself over this year, and got independence from ODT/ODS formats, it now can work with almost any document format as template - html/txt/EPL2 etc. So you can get all and even better results than with MAKO, Jasper, ReportLab reporting engines. BTW, for next OpenERP (v.6). <a href="http://www.alistek.com/index.php?option=com_content&view=article&id=84&Itemid=75&lang=en">Check all info</a> regarding report_openoffice. <br />
<br />
<b>Seel also:</b><img alt="" border="0" height="1" src="http://www.assoc-amazon.com/e/ir?t=3hcons-20&l=btl&camp=213689&creative=392969&o=1&a=0764542222" style="border: medium none; margin: 0px; padding: 0px ! important;" width="1" /> <a href="http://3hconsulting.blogspot.com/2010/09/how-to-edit-openerp-pos-receipt.html"><span style="color: #888888;">How to edit Openerp POS receipt template</span></a>, <a href="http://3hconsulting.blogspot.com/2010/10/how-to-edit-openerp-sales-order.html"><span style="color: #888888;">How to edit Openerp Sales Order report/template</span></a>Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com1tag:blogger.com,1999:blog-5723100308852613964.post-68233664354224580162010-10-29T12:22:00.000+02:002010-11-04T10:31:18.578+02:00Showing excerpts in blogger home pageI was looking for way to show only excerpts in my blog home page and found this <a href="http://www.sriraj.org/blogger/showing-home-page-summary-excerpts-in-blogspot/">method</a> and <a href="http://www.google.com/support/blogger/bin/answer.py?answer=154172">this</a>.<br />
<br />
<a href="http://www.amazon.com/ProBlogger-Secrets-Blogging-Six-Figure-Income/dp/0470616342?ie=UTF8&tag=3hcons-20&link_code=btl&camp=213689&creative=392969" target="_blank">ProBlogger: Secrets for Blogging Your Way to a Six-Figure Income</a><br />
<img alt="" border="0" height="1" src="http://www.assoc-amazon.com/e/ir?t=3hcons-20&l=btl&camp=213689&creative=392969&o=1&a=0470616342" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; margin: 0px; padding-bottom: 0px !important; padding-left: 0px !important; padding-right: 0px !important; padding-top: 0px !important;" width="1" /><br />
<a href="http://www.amazon.com/Blogging-Dummies-Susannah-Gardner/dp/047056556X?ie=UTF8&tag=3hcons-20&link_code=btl&camp=213689&creative=392969" target="_blank">Blogging For Dummies</a><img alt="" border="0" height="1" src="http://www.assoc-amazon.com/e/ir?t=3hcons-20&l=btl&camp=213689&creative=392969&o=1&a=047056556X" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; margin: 0px; padding-bottom: 0px !important; padding-left: 0px !important; padding-right: 0px !important; padding-top: 0px !important;" width="1" /><br />
<a href="http://www.amazon.com/Create-Your-Own-Blog-Projects/dp/0672330652?ie=UTF8&tag=3hcons-20&link_code=btl&camp=213689&creative=392969" target="_blank">Create Your Own Blog: 6 Easy Projects to Start Blogging Like a Pro</a><img alt="" border="0" height="1" src="http://www.assoc-amazon.com/e/ir?t=3hcons-20&l=btl&camp=213689&creative=392969&o=1&a=0672330652" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; margin: 0px; padding-bottom: 0px !important; padding-left: 0px !important; padding-right: 0px !important; padding-top: 0px !important;" width="1" />Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com0tag:blogger.com,1999:blog-5723100308852613964.post-81833959890567872662010-10-29T12:12:00.000+02:002010-11-04T10:30:42.847+02:00How to edit Openerp Sales Order report/templateThis post will explain one possible method for editing Openerp Sales Order report/template. It is possible to use the same method for all other templates.<br />
<br />
Requirements:<br />
<ul><li><a href="http://www.openerp.com/"><span style="color: #888888;">Openerp</span></a> </li>
<li><a href="http://openoffice.org/"><span style="color: #2288bb;">OpenOffice.org</span></a><a href="http://www.blogger.com/"></a><span id="goog_237750488"></span><span id="goog_237750489"></span> </li>
<li>Openerp modules: </li>
<ul><li><a href="http://doc.openerp.com/technical_guide/base_report_designer.html"><span style="color: #2288bb;">base_report_designer</span></a> and </li>
<li><a href="http://doc.openerp.com/technical_guide/sale.html"><span style="color: #2288bb;">sale</span></a> </li>
</ul></ul>At "Server\addons\sale\report" openerp directory there will be the "order.sxw" file. This is a template file that can be easily edited using OpenOffice.org Writer. The report looks like this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirAWwb8_IT6ACSfMUlW6dpZgi-gWfuD9rM_U8zwS96pH7pRke9ypLCWRTqkvmOHt69TjK5APlF171-IP_dXLuM92V6JaT_f_xRAAwKfg_07L9hPH5-dhLf7BO61D4F14MSkB7rTm9Z9KcZ/s1600/order.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="180" nx="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirAWwb8_IT6ACSfMUlW6dpZgi-gWfuD9rM_U8zwS96pH7pRke9ypLCWRTqkvmOHt69TjK5APlF171-IP_dXLuM92V6JaT_f_xRAAwKfg_07L9hPH5-dhLf7BO61D4F14MSkB7rTm9Z9KcZ/s320/order.jpg" width="320" /></a></div><br />
Before editing, make a backup copy of the file. After editing, ajusting and saving it as wished, it necessary to load the file into openerp. To do it, first assure that module base_report_designer is installed. Then go to the administration menu as show bellow and click report designer:<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhK2olL4HjEhbSIZlAPDY-iwCcyN8AlBuqXA5loriFcxngL376_69EDKXXkjn6bZgwVWW0HOpCdXUwNoxZsdiJ8jHPD-EUciT8oyO0-XYMRiGkPQISy1bexeiZLWtQX0yfS50CmC13YF2N3/s1600/openerp_report_designer_menu.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="308" px="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhK2olL4HjEhbSIZlAPDY-iwCcyN8AlBuqXA5loriFcxngL376_69EDKXXkjn6bZgwVWW0HOpCdXUwNoxZsdiJ8jHPD-EUciT8oyO0-XYMRiGkPQISy1bexeiZLWtQX0yfS50CmC13YF2N3/s320/openerp_report_designer_menu.jpg" width="320" /></a></div><br />
<br />
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">Choose the sale report (sale.order) and click on the option "Upload the modified report"</div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3wLwifwI_VpfzXmwWUY_OAah9Q_S0MrWUHW6Mu6IPL5iQxw1j0mjfPEmyouawkhcOfiGLXmnVoVFT0XajJEXbX4Y9IwbJOU8JNhIGFOHHIpO_2Pk2NA8Ef5atv4SQ6x-FvW8qWUlh3bFT/s1600/1.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" nx="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3wLwifwI_VpfzXmwWUY_OAah9Q_S0MrWUHW6Mu6IPL5iQxw1j0mjfPEmyouawkhcOfiGLXmnVoVFT0XajJEXbX4Y9IwbJOU8JNhIGFOHHIpO_2Pk2NA8Ef5atv4SQ6x-FvW8qWUlh3bFT/s1600/1.jpg" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Report designer</td></tr>
</tbody></table><div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;"><br />
</div><div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguUbcL7oHb5WRKJDPt5zkogH1YXUIUW4HJgvrg-DBjvp9O13O2C9vn3f-oAqA-rSR4-aLRZxe8_wvpbeumS-LVDk2ah2RtnoSXv60YN10yW4_IQlDXZjusYNYEc12jGiUzSU82XkuE-VWW/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" nx="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEguUbcL7oHb5WRKJDPt5zkogH1YXUIUW4HJgvrg-DBjvp9O13O2C9vn3f-oAqA-rSR4-aLRZxe8_wvpbeumS-LVDk2ah2RtnoSXv60YN10yW4_IQlDXZjusYNYEc12jGiUzSU82XkuE-VWW/s1600/2.jpg" /></a></div><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjP8-ys8-_bGA77mJ7cOJ-gvCFVY30__b3x0_1pqWoZrU6yIVIoS8WV5u1UPfOjxjKuqTJj3xiH75ec166ocy_UMX6-UZTkhlBKAnQSCbjG1uPI3Z8Dl4I5gD5Io5oYXMdg9lvopJSTGwqj/s1600/3.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="217" nx="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjP8-ys8-_bGA77mJ7cOJ-gvCFVY30__b3x0_1pqWoZrU6yIVIoS8WV5u1UPfOjxjKuqTJj3xiH75ec166ocy_UMX6-UZTkhlBKAnQSCbjG1uPI3Z8Dl4I5gD5Io5oYXMdg9lvopJSTGwqj/s320/3.jpg" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Report Selection</td></tr>
</tbody></table><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhirHKyZUw9CCp0dcq1iybQ6MjJaBy6oCVkjFpXVpsHe07WilRYPnYyul88h0vl-kwdg3QElkb33e_9DTqwRdXG9CvtpGVkv-V1okkOvY3K78Kb64IoaWs_zb9vSbm5RK2KboMUYyVpLhQF/s1600/4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" nx="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhirHKyZUw9CCp0dcq1iybQ6MjJaBy6oCVkjFpXVpsHe07WilRYPnYyul88h0vl-kwdg3QElkb33e_9DTqwRdXG9CvtpGVkv-V1okkOvY3K78Kb64IoaWs_zb9vSbm5RK2KboMUYyVpLhQF/s1600/4.jpg" /></a></div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYX_wI1P4Uv9di_LA0hXeGo_WJBSo9kNwKARKozzXqQDvcjizgvr23GA211Ymmj2gyQ6xro3IO3npStNbSlDi7_pNXGBXuQiIsyiQGENVPdmUQ2MAgAGYUE7KoYgW_FrpbCa744IwJWCMq/s1600/5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="185" nx="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYX_wI1P4Uv9di_LA0hXeGo_WJBSo9kNwKARKozzXqQDvcjizgvr23GA211Ymmj2gyQ6xro3IO3npStNbSlDi7_pNXGBXuQiIsyiQGENVPdmUQ2MAgAGYUE7KoYgW_FrpbCa744IwJWCMq/s320/5.jpg" width="320" /></a></div><br />
Select the modified *.sxw file from your hard disc and click "update the report"<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfxV2l69_0EG5_xfAv7a6yXZtvtkjOFKIO1HV_iPIrhMjlrfVmsqTlApetkeYq_RkAnNyyNs28ba5G-hLAfyH2HfCz5v8DslSwT9rwWaQZJ-jSh7Dbk2RPFAGke0Z39wV0Z1NOFfNWvyBQ/s1600/6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="133" nx="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfxV2l69_0EG5_xfAv7a6yXZtvtkjOFKIO1HV_iPIrhMjlrfVmsqTlApetkeYq_RkAnNyyNs28ba5G-hLAfyH2HfCz5v8DslSwT9rwWaQZJ-jSh7Dbk2RPFAGke0Z39wV0Z1NOFfNWvyBQ/s320/6.jpg" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;">After this you can try to print the sales order report and it will come out already with the changes.</div><br />
You can find more info <a href="http://doc.openerp.com/developer/3_11_reports/11_1_openoffice_report.html"><span style="color: #888888;">here</span></a>, regarding the openerp report mechanism.<br />
<div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;"><strong>See also:</strong> <a href="http://3hconsulting.blogspot.com/2010/09/how-to-edit-openerp-pos-receipt.html">How to edit Openerp POS receipt template</a>, <a href="http://3hconsulting.blogspot.com/2010/10/reportopenoffice-openofficeorg.html"><span style="color: #2288bb;">report_openoffice: OpenOffice.org reporting engine for OpenERP</span></a> </div>Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com2tag:blogger.com,1999:blog-5723100308852613964.post-32745805663829093682010-10-22T14:12:00.000+02:002010-11-04T10:31:48.999+02:00Customize outgoing mails to the customersAt your server directory, search for the following file "Server\addons\auto_email_sale\sale.py". <br />
Edit the file and change lines 53 and 54, with the desired text:<br />
<br />
<div class="codetitle"><b>Code:</b></div><div class="codecontent">body= _("Your order is confirmed.\nPlease, see the attachment.")<br />
state = self.pool.get('email.smtpclient').send_email(cr, uid, smtpserver_id[0], email,_("OpenERP: Sale Order Confirmed"),body,[],[( "report.sale.order",ids )])</div><br />
Then save the file, logoff and login again to Openerp and test if the Subject and the Body were changed.<br />
<br />
Note: You may need to restart openerp server, update modules to valid changes before login.<br />
<br />
<a href="http://www.amazon.com/Kindle-Wireless-Reader-Wifi-Graphite/dp/B002Y27P3M?ie=UTF8&tag=3hcons-20&link_code=btl&camp=213689&creative=392969" target="_blank">Kindle Wireless Reading Device, Wi-Fi, 6" Display, Graphite - Latest Generation</a><img alt="" border="0" height="1" src="http://www.assoc-amazon.com/e/ir?t=3hcons-20&l=btl&camp=213689&creative=392969&o=1&a=B002Y27P3M" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; margin: 0px; padding-bottom: 0px !important; padding-left: 0px !important; padding-right: 0px !important; padding-top: 0px !important;" width="1" />Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com0tag:blogger.com,1999:blog-5723100308852613964.post-38012663672217231882010-10-19T00:59:00.000+02:002010-11-01T12:58:13.304+02:00Visual Studio 2010<div>Some of the features of the new Visual Studio 2010:</div><div></div><div><br />
<strong>Debugging and Diagnostics</strong></div><ul><li>IntelliTrace (Historical Debugger)</li>
<li>Static Code Analysis</li>
<li>Code Metrics</li>
<li>Profiling</li>
<li>Debugger</li>
</ul><div><strong>Testing Tools</strong></div><ul><li>Unit Testing</li>
<li>Code Coverage</li>
<li>Test Impact Analysis</li>
<li>Coded UI Test</li>
<li>Web Performance Testing</li>
<li>Load Testing1</li>
<li>Microsoft Test Manager 2010</li>
<li>Test Case Management2</li>
<li>Manual Test Execution</li>
<li>Fast-Forward for Manual Testing</li>
<li>Lab Management</li>
</ul><div><strong>Integrated Development Environment</strong></div><ul><li>Multiple Monitor Support</li>
<li>Multi-Targeting</li>
<li>One Click Web Deployment</li>
<li>JavaScript and jQuery Support</li>
<li>Extensible WPF-Based Environment</li>
</ul><div><strong>Database Development</strong></div><ul><li>Database Deployment</li>
<li>Database Change Management2</li>
<li>Database Unit Testing</li>
<li>Database Test Data Generation</li>
<li>Data Access</li>
</ul><div><strong>Development Platform Support</strong></div><ul><li>Windows Development</li>
<li>Web Development</li>
<li>Office and SharePoint Development</li>
<li>Cloud Development</li>
<li>Customizable Development Experience</li>
</ul><div><strong>Architecture and Modeling</strong></div><ul><li>Architecture Explorer</li>
<li>UML® 2.0 Compliant Diagrams (Activity, Use Case, Sequence, Class, Component)3</li>
<li>Layer Diagram and Dependency Validation</li>
<li>Read-only diagrams (UML, Layer, DGML Graphs)</li>
</ul><strong>Lab Management </strong><br />
<ul><li>Virtual environment setup & tear down</li>
<li>Provision environment from template</li>
<li>Checkpoint environment</li>
</ul><strong>Team Foundation Server2 </strong><br />
<br />
<ul><li>Version Control</li>
<li>Work Item Tracking</li>
<li>Build Automation</li>
<li>Team Portal</li>
<li>Reporting & Business Intelligence</li>
<li>Agile Planning Workbook</li>
<li>Test Case Management </li>
</ul><iframe align="left" frameborder="0" marginheight="0" marginwidth="0" scrolling="no" src="http://rcm.amazon.com/e/cm?t=3hcons-20&o=1&p=8&l=bpl&asins=0470548657&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr" style="align: left; height: 245px; padding-right: 10px; padding-top: 5px; width: 131px;"></iframe><iframe align="left" frameborder="0" marginheight="0" marginwidth="0" scrolling="no" src="http://rcm.amazon.com/e/cm?t=3hcons-20&o=1&p=8&l=bpl&asins=B0038KTO8S&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr" style="align: left; height: 245px; padding-right: 10px; padding-top: 5px; width: 131px;"></iframe><iframe align="left" frameborder="0" marginheight="0" marginwidth="0" scrolling="no" src="http://rcm.amazon.com/e/cm?t=3hcons-20&o=1&p=8&l=bpl&asins=0071668950&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr" style="align: left; height: 245px; padding-right: 10px; padding-top: 5px; width: 131px;"></iframe>Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com0tag:blogger.com,1999:blog-5723100308852613964.post-48045423842960357112010-09-27T11:26:00.001+02:002010-11-06T13:06:50.051+02:00The Open ERP effectCheck out this SlideShare Presentation: <br />
<div id="__ss_989414" style="width: 425px;"><strong style="display: block; margin: 12px 0px 4px;"><a href="http://www.slideshare.net/tiny07/the-open-erp-effect" title="The Open ERP effect">The Open ERP effect</a></strong><object height="355" id="__sse989414" width="425"><param name="movie" value="http://static.slidesharecdn.com/swf/ssplayer2.swf?doc=pptslides-1233773244972901-1&stripped_title=the-open-erp-effect&userName=tiny07" /><param name="allowFullScreen" value="true"/><param name="allowScriptAccess" value="always"/><embed name="__sse989414" src="http://static.slidesharecdn.com/swf/ssplayer2.swf?doc=pptslides-1233773244972901-1&stripped_title=the-open-erp-effect&userName=tiny07" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="355"></embed></object><br />
<div style="padding-bottom: 12px; padding-left: 0px; padding-right: 0px; padding-top: 5px;">View more <a href="http://www.slideshare.net/">presentations</a> from <a href="http://www.slideshare.net/tiny07">Fabien Pinckaers</a>.</div></div><span><span><a href="http://www.amazon.com/Free-Customer-Relationship-Management-Software/dp/1155197763?ie=UTF8&tag=3hcons-20&link_code=btl&camp=213689&creative=392969" target="_blank">Free Customer Relationship Management Software: Erp5, Apache Ofbiz, Jfire, Postbooks, Compiere, Splendidcrm, Adempiere, Openerp, Sugarcrm</a><img alt="" border="0" height="1" src="http://www.assoc-amazon.com/e/ir?t=3hcons-20&l=btl&camp=213689&creative=392969&o=1&a=1155197763" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; margin: 0px; padding-bottom: 0px !important; padding-left: 0px !important; padding-right: 0px !important; padding-top: 0px !important;" width="1" /></span><img alt="" border="0" height="1" src="http://www.assoc-amazon.com/e/ir?t=3hcons-20&l=btl&camp=213689&creative=392969&o=1&a=1158988443" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; margin: 0px; padding-bottom: 0px !important; padding-left: 0px !important; padding-right: 0px !important; padding-top: 0px !important;" width="1" /></span><br />
<span><br />
<span><a href="http://www.amazon.com/Freies-Unternehmens-Informationssystem-Lx-Office-Adempiere-Project-Open/dp/1158988443?ie=UTF8&tag=3hcons-20&link_code=btl&camp=213689&creative=392969" target="_blank">Freies Unternehmens-Informationssystem: Compiere, Jfire, Erp5, Lx-Office, Intars, Adempiere, Project-Open, Openerp, Weberp, Opentaps, Dolibarr (German Edition)</a></span></span>Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com0tag:blogger.com,1999:blog-5723100308852613964.post-79594809120183869762010-09-26T21:27:00.000+02:002010-11-05T17:37:42.414+02:00How to edit Openerp POS receipt templateThis post will explain one possible method for editing Openerp POS receipt template. It is possible to use the same method for all other templates.<br />
<br />
Requirements:<br />
<ul><li><a href="http://www.openerp.com/">Openerp</a> </li>
<li><a href="http://openoffice.org/">OpenOffice.org</a><a href="http://www.blogger.com/"></a><span id="goog_237750488"></span><span id="goog_237750489"></span> </li>
<li>Openerp modules:</li>
<ul><li><a href="http://doc.openerp.com/technical_guide/base_report_designer.html">base_report_designer</a> and</li>
<li><a href="http://doc.openerp.com/technical_guide/point_of_sale.html">point_of_sale</a> or </li>
<li><a href="http://doc.openerp.com/technical_guide/point_of_sale_extension.html">point_of_sale_extension</a></li>
</ul></ul>At "Server\addons\point_of_sale_extension\report" openerp directory there will be the "pos_receipt.sxw" file. This is a template file that can be easily edited using OpenOffice.org Writer. Before editing, make a backup copy of the file. After editing, ajusting and saving it as wished, it necessary to load the file into openerp. To do it, first assure that module base_repot_designer is installed. Then go to the administration menu as show bellow and click report designer:<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhK2olL4HjEhbSIZlAPDY-iwCcyN8AlBuqXA5loriFcxngL376_69EDKXXkjn6bZgwVWW0HOpCdXUwNoxZsdiJ8jHPD-EUciT8oyO0-XYMRiGkPQISy1bexeiZLWtQX0yfS50CmC13YF2N3/s1600/openerp_report_designer_menu.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="308" px="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhK2olL4HjEhbSIZlAPDY-iwCcyN8AlBuqXA5loriFcxngL376_69EDKXXkjn6bZgwVWW0HOpCdXUwNoxZsdiJ8jHPD-EUciT8oyO0-XYMRiGkPQISy1bexeiZLWtQX0yfS50CmC13YF2N3/s320/openerp_report_designer_menu.jpg" width="320" /></a></div><br />
<div align="center"><input name="IL_RELATED_TAGS" type="hidden" value="1" /></div>Choose the receipt report (pos.receipt) and click on the option "Upload the modified report"<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcBPl-GcHX0njmDZEy3CEY2PaTqYw3Lm3-6b190C7m-r08839alZlRZgFXRVCNE4gvNYyVPY0KVLKF2YJWldgvzDx7r0CsdL_Knv7UAPi-x9M6shPF0g11uYyEqzORUCQ62eapntAsw19m/s1600/openerp_report_designer_file.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="136" px="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcBPl-GcHX0njmDZEy3CEY2PaTqYw3Lm3-6b190C7m-r08839alZlRZgFXRVCNE4gvNYyVPY0KVLKF2YJWldgvzDx7r0CsdL_Knv7UAPi-x9M6shPF0g11uYyEqzORUCQ62eapntAsw19m/s400/openerp_report_designer_file.jpg" width="400" /></a></div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqXB67U2jV78TvvefXvO0dwRP-xaEAcGdmeDZNNhc8Pu39eaSDRQ7vCaW4ZIS60_KFRRsrhyUiHccd7XatobieElwImfgTtAgYerRaZxzdgSOjlxdrNG0-JAHHmo91CiqRA-DGxXDSz-kD/s1600/openerp_report_designer_choose_new_file.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="231" px="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqXB67U2jV78TvvefXvO0dwRP-xaEAcGdmeDZNNhc8Pu39eaSDRQ7vCaW4ZIS60_KFRRsrhyUiHccd7XatobieElwImfgTtAgYerRaZxzdgSOjlxdrNG0-JAHHmo91CiqRA-DGxXDSz-kD/s400/openerp_report_designer_choose_new_file.jpg" width="400" /></a></div><br />
<div align="center"><input type="hidden" name="IL_RELATED_TAGS" value="1"/></div>Locate the file on your hard disc and update on Openerp. After this you can try to print the pos receipt and it will come out already with the changes.<br />
<br />
You can find more info <a href="http://doc.openerp.com/developer/3_11_reports/11_1_openoffice_report.html">here</a>, regarding the openerp report mechanism.<br />
<br />
<strong>See also: </strong><a href="http://3hconsulting.blogspot.com/2010/10/how-to-edit-openerp-sales-order.html"><span style="color: #888888;"><strong>How to edit Openerp Sales Order report/template</strong></span></a><strong>, </strong><a href="http://3hconsulting.blogspot.com/2010/10/reportopenoffice-openofficeorg.html"><span style="color: #2288bb;">report_openoffice: OpenOffice.org reporting engine for OpenERP</span></a><strong> </strong><br />
<input name="IL_RELATED_TAGS" type="hidden" value="1" />Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com3tag:blogger.com,1999:blog-5723100308852613964.post-14062436328087904942010-09-04T12:06:00.000+02:002011-06-19T12:33:43.926+02:00Creating a java applet for Roman to Numeral conversion and vice-versaI was wondering if I could publish on my blog a small java applet for converting Roman to Numeral and vice-versa. I adapted the code I found on this <a href="http://www.faqs.org/docs/javap/c9/ex-9-3-answer.html">web site</a> and created the applet using Netbeans IDE 6.9.1 and when I built it, Netbeans generated 4 files: a html, a jar, a txt and a jnpl.<br />
<br />
When the applet was ready, the first issue I found was where to find a place to host the files. After researching on the internet I found a tip saying that I could use Google Sites and create a new site associated to my Google account, and a page for holding files. After that I uploaded the jar and the jnpl files. Then edited the the html file, changing the url for the jar and the jnpl files and pointing them to the google site uploaded files urls. Then tested the html file on my dektop. After that I copied the content of the html file to my blog and posted it.<br />
<br />
This is the final result using the .jnpl file:<br />
<br />
<div align="center"><script src="http://java.com/js/deployJava.js">
</script><br />
<script>
var attributes = {
code: "JAppletRC",
archive: "https://sites.google.com/site/3hadvisory/files/RomanNumeral.jar?attredirects=0&d=1",
width: 275,
height: 175
};
var parameters = {jnlp_href:"https://sites.google.com/site/3hadvisory/files/launch.jnlp?attredirects=0&d=1"}; <!-- Applet Parameters -->
var version = "1.5"; <!-- Required Java Version -->
deployJava.runApplet(attributes, parameters, version);
</script></div><br />
You can obtain the same result without using the .jpnl file and using the following tag:<br />
<applet<br />
code=JAppletRC<br />
width=275 height=175<br />
archive="<a href="https://sites.google.com/site/3hadvisory/files/RomanNumeral.jar?attredirects=0&d=1">https://sites.google.com/site/3hadvisory/files/RomanNumeral.jar?attredirects=0&d=1</a>"><br />
</applet><br />
<br />
You can download the <a href="https://sites.google.com/site/3hadvisory/files/dist_roman_to_numerals.zip?attredirects=0&d=1">distribution folder</a>.<br />
You can also download the <a href="https://sites.google.com/site/3hadvisory/files/src_roman_to_numerals.zip?attredirects=0&d=1">source files</a>.Hetulhttp://www.blogger.com/profile/06917778698885511693noreply@blogger.com0