<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta content="text/html;charset=UTF-8" http-equiv="Content-Type"></head><body >
Dear Team,<br>
<br>
This import issues has been fixed and checkedin in svn (revision 9555).<br>
The problem is, for the date_modified and date_entered fields, single quotes have been added two times.<br>
If you look into the <span style="font-weight: bold;">function save</span> in <span style="font-weight: bold;">data/SugarBean.php</span> file you will know this.<br>
In this function we have assigned the values like<br>
<span style="font-weight: bold;">$this->date_modified = $this->db->formatDate(date('YmdHis'));</span> (in line 61) and<br>
<span style="font-weight: bold;">$this->date_entered = $this->db->formatDate(date('YmdHis'));</span> (in line 71)<br>
<br>
Now this date fields has been assigned values with single quotes. Again
in line no 129 we have called the formatString function of adodb which
will add one more single quote.<br>
To fix this error we have to do the following steps<br>
change the lines<br>
<span style="font-weight: bold;">$this->date_modified = $this->db->formatDate(date('YmdHis'));</span> to <span style="font-weight: bold;">$this->date_modified = date('YmdHis');</span> in line 61 and<br>
<span style="font-weight: bold;">$this->date_entered = $this->db->formatDate(date('YmdHis')); </span>to <span style="font-weight: bold;">$this->date_entered = date('YmdHis'); </span>in line 71<br><br>Now we can save the import mapping.<br>
Please let me know if i am wrong.<br>
Thanks & Regards<br>
Mickie<br><br><br>---- On Thu, 05 Oct 2006 <b>Leandro Rache Sanchez <leandro@oriontek.org></b> wrote ---- <br><br><blockquote style="border-left: 1px solid rgb(160, 154, 255); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>
Thanks Tim, This import work fine accounts and contacts without to save the <br>import definition as a template.<br>Some ideas for import notes and other info from sugar4 to vtiger5?.<br><br>Leandro.<br><br> El Vie 29 Sep 2006 11:31, Tim Smith escribió:<br>> We have confirmed this problem. If you are trying to save the import<br>> definition as a template you will get an error displayed in the browser.<br>> Something similar to this:<br>><br>> You have an error in your SQL syntax; check the manual that corresponds to<br>> your MySQL server version for the right syntax to use near '2006-09-29<br>> 11:15:45'', ''2006-09-29 11:15:45'', '1')' at line 1<br>><br>> We may be able to fix it today but it depends on scheduling. In any case,<br>> don't save as a template and you should be good to go.<br>><br>> Tim (OnwealdTim)<br>><br>> Tim Smith<br>> Onweald, Inc.<br>> <a href="http://www.onweald.com">http://www.onweald.com</a><br>><br>> On 9/27/06, Leandro Rache Sanchez <leandro@oriontek.org> wrote:<br>> > Hi,<br>> > Im importing accounts and contacts from sugar to vtiger, in 4.3 this work<br>> > fine, but in 5, and last svn this not work properly, don't import noting,<br>> > it<br>> > seem some sql error.<br>> > Im not test yet the contacts.<br>> > --<br>> ><br>> > ~ Leandro Rache Sanchez<br>> > (. .) leandro@oriontek.org<br>> > \V/<br>> > //"\\ Corporacion Tecnológica ORION.<br>> > /( ' )\ info@oriontek.org<br>> > ^*-*^ <a href="http://www.oriontek.org/orion/">http://www.oriontek.org/orion/</a><br>> > ---------------------------------------<br>> ><br>> ><br>> > _______________________________________________<br>> > Get started with Online collaboration office & productivity tools -<br>> > <a href="http://zoho.com?vt">http://zoho.com?vt</a><br><br>-- <br><br> ~ Leandro Rache Sanchez<br> (. .) leandro@oriontek.org<br> \V/ <br> //"\\ Corporacion Tecnológica ORION.<br>/( ' )\ info@oriontek.org<br> ^*-*^ <a href="http://www.oriontek.org/orion/">http://www.oriontek.org/orion/</a><br>---------------------------------------<br><br><br>_______________________________________________<br>Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com">http://jobs.vtiger.com</a> <br>
</div>
</blockquote></body></html>