The most serious was that there’s no way to validate the accuracy or completeness of data being sent by the vendor. But we discovered some big downsides with that approach. We started to create custom inbound email actions to process emails with attached data files as they were sent from each vendor. Check data quality and handle exception conditions defined by the client.Provide feedback to the client’s IT asset management (ITAM) team.Handle data in a variety of file formats including text (.csv) and MS Excel.Handle the same kind of data from multiple vendors (e.g.Allow data imports without elevated roles or system privileges.But to control their hardware and software assets today, they needed a solution to work with multiple vendors and data formats. The client’s desired future state is to enforce a single format for use by all vendors. The company, a global manufacturer of household appliances, has dozens of vendors around the world, which supply data (CSV and Excel files) using proprietary formats and column names. Recently along with my Crossfuze colleagues Josh McMullen and Scott Cornthwaite, I performed work for a client that needed to import asset data from several third party vendors.

Glide app builder from excel sheet