Hey all,

I'm attempting to find the best way for a custom import wizard for a custom object.

Here's my circumstance:

Our Sales department gets lists of locations that we deploy assets to (called a deployment). These lists are usually no more than 500 at any given time, but can be as little as 10, or sometimes one offs.

I represent locations in our environment through Location__c.

What I would like, is build a wizard like interface that helps the Sales dept upload their locations in a project form. So a little wizard that allows them to upload the new locations, review them, and authorize/commit them to the DB.That way I can run workflow and triggers on new locations BEFORE we commit them fully as authorized locations.

I'm planning on creating a bunch of logic to check for duplicate locations (using Lat / long, address checking etc...) so using the standard "custom object importer wizard" is sort of out of the question. It's a little complicated for the common Sales guy. (no offence to sales guys...)

The issue is then: If I don't use the standard import wizard, what options do I have?

I'm looking for all advice I can get.

Is anyone aware of an app that utilizes custom csv file imports?

Also, I've seen sites that simply ask you to paste in excel data into a text box, and it manages to delimit it for you. Is that a viable option?