CSV Import File Configuration

vinsnash

Would a CSV file configure as below work as import? Rather than a single line for each table row.

"Unit.Code",
"Unit.Name",
"Unit.Address1",
"Unit.Address2",
"Unit.State",
"Unit.ZIP",
'Unit.URL"

"011BMD",
"BOSTON MINUTEMEN",
"Gloucester High School",
"32 Leslie O Johnson Road",
"Gloucester,"
"MA,"
"01930-2500",
"http://www.bostonminutemendivision.com"

tford

vinsnash

Thank you. I have an application that will strip a .pdf file in that format. I was hoping just adding the "," would do it.

Looks like we'll have to find something else or do the horse work.

Vins Nash

pbrad

Hi Vins,
If I recall correctly, you have a background in MS Access. It probably wouldn't be too hard to create a small access application that would import your formatted file and export a correctly formatted csv file for import directly into AwareIM.

I did this for a client a number of years ago in a similar situation and all that they had to do was to drop the original file into a folder and autorun the Access Application and then import the resulting file into AwareIM.
Cheers,
Pete