[Vtigercrm-developers] Bulk insert/update from API

[Sukhdev Mohan]

Hi,

I've a project where we have to import Orgs, Quotes, Sales Orders and Invoices. Each import has to do a lot of db queries to find if the record is new or to update, get assigned_user_id, get org to connect to etc

The process is:
Read CSV -> map to entity -> check if entity is already imported:
a. It’s imported and not changed
b. It’s imported and changed
c. It’s a new record
-> call vtws_update/create

Is there a way to make a large commit from the API?

So suppose there are 10 records: 8 to update and 2 create, is there a way to create/update in bulk, like an array contains all the different entities and saving/updating and committing to db?

Also is there a way to specify username instead of userid or account name instead of accounted, in general is it possible to specify a String field instead of id? Would reduce a lot of queries.

Sukhdev Mohan