drew22
asked on
importing data into FileMaker "Donations" app
Donations is a FileMaker Pro donations management application:
http://www.filemaker.com/products/applications/donations/home.html
I have imported contact data into the app's contact table, and now I am trying to import contact email and phone numbers into the related table that holds this info:
one contact record -> many records for email addresses and phone numbers.
The same field stores both phone numbers and email addresses.
I have extracted phone numbers into a separate cvs import file and I can sequence the records to match the sequence id field of the contact table:
1 joe@yahoo.com
1 joes@workemailaddress.com
1 203 444-3456
1 965 333-2234
2 fred@blah.com
2 412 5567
etc.
Question 1:
How can I get access to the tables that make up this application independent of this application? From within the Donations app I can't the import dialog to show me the Contact_Number table. If I could open this blasted table outside this application I could get somewhere, but the whole Donations app is one bundled file. It does not include an embedded FileMaker runtime (I don't know if that's even an option, I'm not an FileMaker guy)
drew
http://www.filemaker.com/products/applications/donations/home.html
I have imported contact data into the app's contact table, and now I am trying to import contact email and phone numbers into the related table that holds this info:
one contact record -> many records for email addresses and phone numbers.
The same field stores both phone numbers and email addresses.
I have extracted phone numbers into a separate cvs import file and I can sequence the records to match the sequence id field of the contact table:
1 joe@yahoo.com
1 joes@workemailaddress.com
1 203 444-3456
1 965 333-2234
2 fred@blah.com
2 412 5567
etc.
Question 1:
How can I get access to the tables that make up this application independent of this application? From within the Donations app I can't the import dialog to show me the Contact_Number table. If I could open this blasted table outside this application I could get somewhere, but the whole Donations app is one bundled file. It does not include an embedded FileMaker runtime (I don't know if that's even an option, I'm not an FileMaker guy)
drew
If you have answered your own question, you should request a points refund leaving a message in the support area.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
From within the Donations app, backup and delete data.
Quit Donations app.
Open individual table in BackUp directory.
Do my import stuff
Launch Donations app and restore data.
drew