Empower the IT admin

Problems can now be solved on your own. Enjoy greater visibility and control over your Sugar instance.

Until now, only developers could manage these crucial under-the-hood processes. But with Upsert^® Lens, admins of all levels will appreciate the convenience of interacting with their instance's backend via Sugar's familiar and easy-to-navigate list views.

Key features

No-code access to config settings

Forget using SQL to manage core settings in your Sugar config table. Now you can search, view, and manage backend configurations from directly inside the application.

User tracker history

Use Upsert^® Lens to search within and monitor the tracker activity for your users, giving a full view into which records your users are engaging with and how often.

Scheduler job queue management

Have you ever needed to re-run a scheduled job? Or just wondered why a scheduled job failed? Now you can easily monitor the job_queue table to spot problems and re-execute failed jobs. No need to wait for the cron as you can now manually execute jobs right from the record and list view to get the answers you need now.

Full-text search (FTS) queue viewer

Global Search indexing is no longer a mystery as Upsert® Lens gives you clear insight into the fts_queue table and even allows you to index a given record from the record and list view without waiting on the cron.

Plug-in upgrade history

Having trouble with a plug-in installation? Check the plug-in manifests and manage broken installations without the headache of decoding manifests.

Fields metadata management

It's easy to double-check custom field metadata now that you can search, view, and manage compiled metadata using Upsert^® Lens.

Geocode management

Check on the geocode, geocode jobs, and geocode queue to ensure your addresses are being geocoded as expected

Vardef viewer

Search through your vardefs to find fields by module for any attribute such as required, readonly, or audited.

System requirements

Upsert^® Lens is compatible with:

• Sugar Sell, Serve, Enterprise, and Professional products
• Versions 10.0 and higher
• Hosted in SugarCloud or on-site