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:
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.
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.
Had a import Mishap today. No bueno.
Had a import Mishap today. No bueno.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
Re: Had a import Mishap today. No bueno.
someone's out there thinking "ahh, yeah, look at that. loaded an excel file instead of the ascii csv file. been there!"
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
Re: Had a import Mishap today. No bueno.
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.
It sure seems like the "Data file" dialog should only allow CSV files to be selected.
Tom - V8.8 build 3137 - MySql / PostGres