Revision as of 10:21, 3 August 2008 by Christopher Hunt (talk | contribs) (Moved "Exporting Filemaker DB" to here)

Importing / exporting e-mail contacts

Compatability through CSV files: When you export contacts to CSV (comma-separated values), the generated file is actually pretty similar to an Excel spreadsheet and can be viewed / edited by MS Excel or OOo Calc. If you make a couple of contacts in Outlook or Entourage, then export them to CSV, then open the file in Calc, you can take a look for yourself. Now older programs (for example, FileMaker Pro 6) might be able to export to CSV but might not have the column headers on the top row. Fortunately, you can just manually write them in by comparing the labels with the labels specified on the CSV you exported from the program you want to gain compatability with.

MS Office compatability

Case: professor has some ancient MS Word documents (from a legecy Office Mac version), can't open them anymore because Office doesn't have the filters needed to read the files.

MS Office's "Recover text from any file" feature can recover the text from these documents. OpenOffice can sometimes open older files. Neither of these preserved formatting in this instance.

How to export a Filemaker database to MS Excel

  1. Open the database in Filemaker.
  2. Click on the File menu
  3. Cick on Import/Export
  4. Click on Export
  5. In the window that opens, near the bottom, next to "Save as type", select "Comma-separated Text (CSV)"
  6. Choose where you want to save the exported doccument, give it a name and click "Save"

--Mitrevski, Petar 15:28, 28 July 2008 (EDT)

Powered by MediaWiki