Importing Legacy Info (Con’t)
Importing Legacy Info (Con’t)
Step 1: File Upload a Delimited list (Tabs, preferably)
Step 2: Add list qualifiers around the fields (“) and write the file out to disk
Step 3: Use the <CFHTTP> tag to import the file into a session-based CFQUERY object
Step 4: Process the query through a multi-page staged process
Step 5: Pray to whatever god you believe in