Upsert® Lens
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