Introduction:
Our client is an advanced water treatment company offering the copper silver ionization system. Not only this, but they also offer an expert water sampling service carried out by his water engineers combined with a management service using out our cloud-based water management service, Tetras.
Challenges:
They were facing difficulties to insert bulk number of System Metric object records creating manually.
- They want to create a System Metric object records automatically, when send email to created email service email address.
- They want to create a System Metric records under the related System Record.
- They want to create a System Metric object record based on email attachment CSV File.
Solutions:
- We have created an email service to create a System Metric object record.
2. We have created an Apex Class
3. System Metric Object Records update based on email Attachment Csv File.
System Metric Create
- If sending a mail with this CSV attachment, The System Metric record was created in a particular system.
- System Metric records insert under System object record based on the System index number column in Attached CSV File.
- If we send an email with the below example CSV attachment, The System metric record was created in the related list of mentioned systems in CSV File.