[Vtigercrm-developers] Importing records

[Simone Travaglini]

Hi in past when I tried import of big number of record I had same duplicate
problem.

2015-07-22 9:16 GMT+02:00 ardi zeneli <zeneliiardi at gmail.com>:

> Hello,
>
> I tried importing a file of 40.000 records with the built-in import
> functionality of vtiger but it created lots of duplicates, which resulted
> in more than 568.000 records added. Any idea why this happened, and how to
> avoid this in the future?
>
> Thanks.
>
> On Wed, Jul 22, 2015 at 8:30 AM, Simone Travaglini <
> simonetravaglini at gmail.com> wrote:
>
>> Hi richard, do you mean you had success with built in import
>> functionality with big file? someone had exeperience with big number of
>> record with built in functionality?
>> Vtiger team?
>>
>> 2015-07-21 22:24 GMT+02:00 Richard Hills - Technologywise <
>> richard at tw.co.nz>:
>>
>>> This is sound advice, though I will also mention that I have had success
>>> with imports of this size from CSV files. I always try the built in import
>>> functionality before resorting to scripts.
>>>
>>>
>>> On 21/07/15 22:39, Alan Lord wrote:
>>>
>>>> On 21/07/15 11:23, ardi zeneli wrote:
>>>>
>>>>> Hello,
>>>>>
>>>>> I have to import nearly 1 milion records in vTiger which are divided in
>>>>> almost 500 excel files. Can anybody tell me which would be the best way
>>>>> to do this import?
>>>>>
>>>>
>>>> I would use the server APIs and create new objects iterating over your
>>>> spreadsheet. With that many I would write a "wrapper" script which breaks
>>>> into manageable chunks (say 5000 at a time) so you can resume more easily
>>>> if something goes wrong after 250,000 imports ;-)
>>>>
>>>> Al
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> http://www.vtiger.com/
>>>>
>>>
>>> --
>>> Richard Hills
>>> TechnologyWise Ltd, Tauranga, NZ
>>> richard at tw.co.nz
>>> www.technologywise.co.nz
>>> ph: +64 (0)7 571 1060
>>> fax: +64 (0)7 571 1061
>>>
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>>
>>
>>
>>
>> --
>> Simone Travaglini
>> 328 5499846
>> Linkedin: Simone Travaglini
>>
>>
>> Rispetta l'ambiente: non stampare questa mail se non ti è veramente
>> necessario!
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>



-- 
Simone Travaglini
328 5499846
Linkedin: Simone Travaglini


Rispetta l'ambiente: non stampare questa mail se non ti è veramente
necessario!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150722/cf7c18aa/attachment.html>