I am trying to upgrade multiple instances of the same DB with a new version of the DB (improved scripts, layouts, etc.). I added a script to each DB instance which allows me to export all relevant tables from the existing DBs. I can then start the new DB version (blank) and import the tables/data back. As I cannot dynamically assign file names to the exported tables and I don't want to have to change the export/import file references manually, I decided to export all tables to a folder with the static name 'export' and therefore I can reference the same path for the import. But in order to keep tables from different DB instances separate I created an AppleScript that

• creates a folder with the name of the DB 'export <DB name>'
  
• creates an alias called 'export' pointing to the DB specific export folder created in the previous step
  
• exports all tables using file reference 'file:export/<table name>' as output file

But when I tested my FM script I keep getting errors ("... could not be created on this disk..."), because FM doesn't seem to be able to follow a file reference that includes an alias. Is there something I'm doing wrong or does FM indeed not handle aliases?

Cheers,

Michael.

Not sure if it does (I don't use Macs in developement). But what you can do is hard code a fixed location for the export and import and use Applescripts to move & rename files from their source to that fixed location for import. And on export, take the fixed file/location and rename/move it to where you want it.