Updating records with Excel Plug-In not working correctly?

Hello everyone!

I am currently trying to update all of our phone numbers (1500) in the contacts module to make them uniform.

I tried using the SugarCRM Excel Plug-In for Excel 2010 64-bit (query, Contacts->last_name->isNotEmpty), but when I change the values in "phone_work", select the whole column(from first to last record, without column titels) and right-click "update in Sugar" the only thing that gets updated (according to my activity stream at least) is the column "date_modified", but no the numbers.

When I tried selecting the entire rows and use the update from the dropdown menu nothing happens at all.

I tried testing both functionalities: I created 10 dummy contacts and used the query to get them listed and performed the same changes as descibed above with both methods and BOTH WORKED!

Is there a limit as to how much records can be updated at the same time? Is the update functionality disabled for large queries/lists? I am really confused :-?

  • Hi Robert,


    Also not sure what the problem could be. To check if it is related to some kind of timeout on server or platform side can you try with 10 records from the actual list to see if that works?

    If not can you put the log level to 'error' and check if you get anything in the sugarcrm.log file when trying to update?

    Thanks,

    Dennis

  • Hey Dennis,

    I updated 80-ish records from the actual list with one update and it worked. There seems to be an internal limit how much records can be updated at the same time. Whether this limit is caused by a server time-out after a specified amount of MS or if there is a config setting in the plug-in itself I don't know.