Had a import Mishap today. No bueno.

[Jaymer]

Using Import Templates, lets say I have a CRM Leads table and allow users to load, via a specified CSV format, new Leads. They load into a temp table for some pre-processing and the user, when satisfied, starts a Panel Operation on the grid to load them into the live Leads table.

Using Aware's cool feature of Import templates, its nice to offer a "Leads-Brief" and "Leads-Full" import option, with one allowing more columns in the import.
I have instructions for this screen:

Screen Shot 2020-09-17 at 2.25.57 PM.png (60.98 KiB) Viewed 5631 times

OK, so today, instead of picking a CSV file, the user did a XLS.
This loaded BINARY data into MSSQL, causing the Leads grid to "just spin" when the user sees what got imported. Of course, they got a msg that "errors occured during import", but thats no matter, the grid hangs and never loads.
Only deleting in SSMS (MS SQL) would solve it - nothing in Aware could be done on this table.

Screen Shot 2020-09-17 at 11.15.02 AM.png (134.91 KiB) Viewed 5631 times

So, is there a moral to this story?
Do others allow users access to this dialog?
Anyone seen this?
There's no Process involved here - no way to check/validate the import file's extension.
I've used "EXPORT Leads USING mytemplate" before, but not sure if I can enable all 3 of those checkboxes from a Procedure doing an "IMPORT LEADS.....". If I use a Process, I'd have to have the customer rename their file to a specific name each time - or prompt for that file and I could copy it to the hardcoded filename - at least then I could check the extension. Dunno... gonna have to work around whats almost a good thing just to prevent this in the future.

[Jaymer]

someone's out there thinking "ahh, yeah, look at that. loaded an excel file instead of the ascii csv file. been there!"

[tford]

I haven't had the same exact result, but I've loaded a non CSV file in by mistake.

It sure seems like the "Data file" dialog should only allow CSV files to be selected.