|
|
Thank you for your answer, Oguz! Unfortunately, it appears a DNS-less
connection is not an option for CF8 - it was only for pre-MX CF instances.
Unless there's some documentation I've missed?
The end result I need to happen is:
I've got several users who will eventually be maintaining the system I'm
creating. They are accustomed to Excel, and would like to bulk-upload data
from Excel to the program (which is based in MS SQL). I've simplified the
Excel file so as not to confuse the users, and will need to process each record
before I can push it to the database (error checking, cross-referencing the
sheets, etc). This prevents me from using ye olde MS SQL import functionality.
Based on my research, it looked like the best option was to:
1. upload the file to a temp directory on the server, asking the user for
various other bits of information on the upload form.
2. run a couple of queries in the file and do my processing/datachecking,
returning validation errors if anything is wrong
3. if all is kosher, call the appropriate functions to create/save, etc from
my cfcs using the data I've processed
Is there a way of doing this other than setting up the DNS in administrator?
Am I making things more difficult than they need to be? It seemed like a
straightforward solution, if only I could get the bug fix to run.
Best wishes,
Cat
|
|