[Vtigercrm-developers] Accounts don't import

[Mickie]

Dear Team,

This import issues has been fixed and checkedin in svn (revision 9555).
The problem is, for the date_modified and date_entered fields, single quotes have been added two times.
If you look into the function save in data/SugarBean.php file you will know this.
In this function we have assigned the values like
$this->date_modified = $this->db->formatDate(date('YmdHis')); (in line 61) and
$this->date_entered = $this->db->formatDate(date('YmdHis')); (in line 71)

Now this date fields has been assigned values with single quotes. Againin line no 129 we have called the formatString function of adodb whichwill add one more single quote.
To fix this error we have to do the following steps
change the lines
$this->date_modified = $this->db->formatDate(date('YmdHis')); to $this->date_modified = date('YmdHis'); in line 61 and
$this->date_entered = $this->db->formatDate(date('YmdHis')); to $this->date_entered = date('YmdHis'); in line 71

Now we can save the import mapping.
Please let me know if i am wrong.
Thanks & Regards
Mickie


---- On Thu, 05 Oct 2006 Leandro Rache Sanchez <leandro at oriontek.org> wrote ---- 

Thanks Tim, This import work fine accounts and contacts without to save the 
import definition as a template.
Some ideas for import notes and other info from sugar4 to vtiger5?.

Leandro.

 El Vie 29 Sep 2006 11:31, Tim Smith escribió:
> We have confirmed this problem.  If you are trying to save the import
> definition as a template you will get an error displayed in the browser.
> Something similar to this:
>
> You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near '2006-09-29
> 11:15:45'', ''2006-09-29 11:15:45'', '1')' at line 1
>
> We may be able to fix it today but it depends on scheduling.  In any case,
> don't save as a template and you should be good to go.
>
> Tim (OnwealdTim)
>
> Tim Smith
> Onweald, Inc.
> http://www.onweald.com
>
> On 9/27/06, Leandro Rache Sanchez <leandro at oriontek.org> wrote:
> > Hi,
> > Im importing accounts and contacts from sugar to vtiger, in 4.3 this work
> > fine, but in 5, and last svn this not work properly, don't import noting,
> > it
> > seem some sql error.
> > Im not test yet the contacts.
> > --
> >
> >    ~     Leandro Rache Sanchez
> > (. .)   leandro at oriontek.org
> >   \V/
> > //"\\   Corporacion Tecnológica ORION.
> > /( ' )\  info at oriontek.org
> > ^*-*^   http://www.oriontek.org/orion/
> > ---------------------------------------
> >
> >
> > _______________________________________________
> > Get started with Online collaboration office & productivity tools -
> > http://zoho.com?vt

-- 

   ~     Leandro Rache Sanchez
 (. .)   leandro at oriontek.org
  \V/      
 //"\\   Corporacion Tecnológica ORION.
/( ' )\  info at oriontek.org
 ^*-*^   http://www.oriontek.org/orion/
---------------------------------------


_______________________________________________
Reach hundreds of potential candidates - http://jobs.vtiger.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20061005/5d7c5624/attachment-0004.html