Export to file using alias

[michael_w]

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.

[Wim Decorte]

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.