Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

importing data into FileMaker "Donations" app

Posted on 2005-04-02
4
Medium Priority
?
373 Views
Last Modified: 2010-04-27
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


0
Comment
Question by:drew22
3 Comments
 
LVL 1

Author Comment

by:drew22
ID: 13689804
I think I figured it out:  

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

0
 
LVL 19

Expert Comment

by:billmercer
ID: 13690400
If you have answered your own question, you should request a points refund leaving a message in the support area.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 14251092
PAQed with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Screencast - Getting to Know the Pipeline
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question