Importing Gift records

A place for discussion on how to use the program more effectively

Post Reply
GregDC
Posts: 1
Joined: Thu Aug 28, 2008 6:35 pm
Type the middle number, please (202): 302
Location: Orlando, FL
Contact:

Importing Gift records

Post by GregDC »

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?
Greg Della-Croce
Project Manager
Wycliffe Bible Translators
Post Reply