Importing Gift records
Posted: Thu Aug 28, 2008 7:06 pm
I am managing a project for Wycliffe members to be able to create and import donation history data. We are currently exporting it as a comma or tab separated file. Our first line looks like:
donorid
donor name
doormen
address
address
city
state
zip
country
gift date
gift amount
gift type
subtype
gift comments
receipt
funded
descriptor
motive
descriptor
I have tried using the IMPORT DATA FROM EXCEL option.
I have tried reading in the .text, .CV, and the .XL (saved as 97-2006 from the Excel 2007 version) versions of the file
all end with an error:
CSV - That file does not seem to be in the right format
TXT - That file does not seem to be in the right format
XLS - Microsoft Excel file format is invalid
Can anyone give me a clue as to what I can do to make this work for our members?
donorid
donor name
doormen
address
address
city
state
zip
country
gift date
gift amount
gift type
subtype
gift comments
receipt
funded
descriptor
motive
descriptor
I have tried using the IMPORT DATA FROM EXCEL option.
I have tried reading in the .text, .CV, and the .XL (saved as 97-2006 from the Excel 2007 version) versions of the file
all end with an error:
CSV - That file does not seem to be in the right format
TXT - That file does not seem to be in the right format
XLS - Microsoft Excel file format is invalid
Can anyone give me a clue as to what I can do to make this work for our members?