[Vtigercrm-developers] Duplicate organization names stopping import?

[nilay khatri]

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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20180405/0f460b77/attachment.html>