[Vtigercrm-developers] Duplicate organization names stopping import?

[Alex Hall]

Well, what do you know... I somehow never even noticed that duplicate
prevention option. The joys of using a screen reader, I suppose. Thanks for
pointing it out. If this doesn't solve the problem, I'll reply to this
thread, but I have a feeling it will.

On Thu, Apr 5, 2018 at 11:56 AM, nilay khatri <nilay.spartan at gmail.com>
wrote:

> I guess in that case I would include more fields in the duplicate criteria
> for that module rather then just Organization name.
>
> On Thu, Apr 5, 2018 at 8:43 PM, Alex Hall <ahall at autodist.com> wrote:
>
>> Hello list,
>> I have a sync job that runs every morning. It imports--or updates, if the
>> organization exists--thousands of organizations. Around 50, though, fail to
>> import, with the error that an update would cause a duplicate. Indeed,
>> these organizations all have at least one other entity with the same name,
>> but they have different details. I should say that I'm using web services,
>> not a CSV or anything. The job asks our AS400 for data, then runs through
>> the data it gets, asking VTiger if the organization being considered
>> exists. If it doesn't, a new one is made and added; if it does, the AS400's
>> data overwrites VTiger's data for the organization. Matching is based on
>> customer number, a custom field in VTiger but a primary key in the AS400.
>>
>> Given that I could import them initially, but can't now update them, this
>> seems like less a SQL restriction and more something odd in VTiger. Again,
>> too, the import went fine, but now that I want to update the organizations,
>> I get a duplication warning and that organization is skipped. Finally, a
>> reminder that I'm saying "import", but this is a file that relies on web
>> services to operate. It has no CSV at all, and doesn't use VTiger's
>> standard importing. It's all web services.
>>
>> --
>> Alex Hall
>> Automatic Distributors, IT department
>> ahall at autodist.com
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>



-- 
Alex Hall
Automatic Distributors, IT department
ahall at autodist.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20180405/59710556/attachment-0001.html>