Hey Guys,<br>
<br>
So, I am 99% finished porting the non-MSSQL compliant SQL into
Compatible SQL. I have a running version of vTiger on my desktop, and all the features we have tested work fine (including all the modules, custom reports, etc...) the only known issue that doesn't work is the calendar module writes dates incorrectly to the db, and I haven't spent anytime trying to fix it yet is all). If someone is interested, I have some very unorganized, but mostly complete,
notes located here: <a href="http://www.joeynovak.com/wiki/index.php/VTiger_on_MSSQL">http://www.joeynovak.com/wiki/index.php/VTiger_on_MSSQL</a> <br><br> Again, I don't know what the best way to go about this is, but my Company is willing to invest resources into merging the braches of vTiger into one branch that works on postGres, MSSQL, and MySQL. They wish to make this investment now, so that in the future, we will be able to reap the benefits of continued vTiger improvements without having to patch it to make it work on MSSQL everytime a new release comes out. Specificaly, they have authorized me to spend one to two weeks of work time on the effort.
<br><br> I can do all this, I just want to make certain that my work will be of as much benefit as possible to the community, and my company by getting the work into the main vTiger branch in the svn repository when I am done. If I start with the
5.0.4 branch, and make all the changes to make it work on Postgres, MySQL, and MSSQL with one code base, and test it, how would I submit my work? Again, please keep in mind that although I have extensive programming experience, I have never contributed to an opensource project before, and don't know what is expected. Sreenivas's reply earlyer today, told me I should create a new branch, as I browsed the code, I could not find the seperate postgres branch he spoke of. Is it not clearly labeled? Is the
5.0.3 branch really the MySQL/Postgres branch, and 5.0.4 is MySQL only?<br><br> If someone is willing to lend me some more guidance, then we should be able to put forth this effort and achieve the mutual goal of my company and the vTiger community without using very much more of everyones time.
<br><br> Thanks Guys,<br><br> Joey<br><div><span class="gmail_quote">On 9/20/07, <b class="gmail_sendername">Sreenivas Kanumuru</b> <<a href="mailto:svk@vtiger.com">svk@vtiger.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>Hi Joey,<br><br>Today, we have separate distributions for MySQL, and Postgres. It will be nice not having to maintain these different code bases. We are considering adding multi-database support soon. If your changes help us in this process we will certainly look into it.
<br><br>For now, the best way to proceed is to create a new branch (5.0.3 for MSSQL) and contribute your changes to it. Then you can request help from the community in testing it with MySQL and other databases.<br><br>Regards,
<br><br>Sreenivas<br>vtiger Team.<br><br><br><br><br>----On Thu, 20 Sep 2007 <b>Joey Novak <<a href="mailto:joey.novak@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">joey.novak@gmail.com
</a>></b> wrote ---- <br><br><blockquote style="border-left: 1px solid rgb(160, 154, 255); padding: 6px;"><div><span class="e" id="q_11524164a57a641e_1">
Hey Guys,<br><br> I am still working hard on modifying the parts of vTiger that don't work well with MSSQL to work well with MSSQL, and MySQL. What do I need to do to get my changes considered for the next release of vTiger? It is easy for me to test them on MySQL, but I don't know about postgres. I have never worked on a big OpenSource project, so I am not framiliar with the proper etiquete for contributing changes, but I think these changes would be valuable to the project.
<br><br> Joey<br> <br> <a href="http://www.joeynovak.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.joeynovak.com</a><br><br><br> C) 803-409-9969 (Work Cell)<br> W) 757-233-0834
<br> H) 757-383-8523 (SkypeIn)<br>"Very funny, Scotty. Now beam down my clothes."
<br><br>Be nice to nerds. Chances are you'll end up working for one. <br> --Bill Gates<br><br>Your most unhappy customers are your greatest source of learning. <br> --Bill Gates<br><br>Cope with Life, go buy a slurpee!
<br></span></div><a href="http://www.slurpee.com/games.html" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.slurpee.com/games.html</a>
_______________________________________________<br>Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://jobs.vtiger.com</a>
<br>
</blockquote></div></blockquote></div><br><br clear="all"><br>-- <br>---<br> <a href="http://www.joeynovak.com">http://www.joeynovak.com</a><br><br><br> C) 803-409-9969 (Work Cell)<br> W) 757-233-0834<br>
H) 757-383-8523 (SkypeIn)<br>"Very funny, Scotty. Now beam down my clothes."<br><br>Be nice to nerds. Chances are you'll end up working for one. <br> --Bill Gates<br><br>Your most unhappy customers are your greatest source of learning.
<br> --Bill Gates<br><br>Cope with Life, go buy a slurpee!<br><a href="http://www.slurpee.com/games.html">http://www.slurpee.com/games.html</a>