  Could me help me to update a fields' value in db. through a module. I know the table name, and fields data will read from the excel and update in db.

Question

Hi ,

Could anyonehelp me to update a fields' value in db. through a module.

I know the table name,columns and fields .

Data will read from the excel and update in db.

Thanks,

Abhishek Bhardwaj

Francesca Shiekh

abhishek bhardwaj · Accepted Answer

Do you mean you want to do it programmatically? If you want to update in code via the module bean, you could convert your excel spreadsheet to csv then have a custom script that reads the csv, retrieves each bean by ID (I am assuming you have the id in the spreadsheet), update the bean and save it.

See: http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.6/API/Classes/SugarBean/CRUD_Handling/

FrancescaS