You will need to covert the file to one that FMP can use. Click on the expand triangle for a list of supported formats. I have not dealt with .ale files before but a quick search suggests they are some type of txt file. Can the .ale file be exported in one of the formats listed below? You could start with that. I'm sure others will chime in if I'm off base here.
Never heard of a .ALE file type. What is it?
The Avid Log Exchange (ALE) file format was created so that the contents of film-based databases could be transferred between systems. Cinema Tools supports importing and exporting ALE files, making it possible to share databases with other systems.
I just tried with a sample ALE file and it should work. However, the structure of the file will mean the first few records are not needed. The format of the file I have is:
Name Camroll Labroll KN Start KN Duration Tape Start End Duration Tracks Soundroll Sound TC Scene Take Notes Perf Daily Roll Ink Number TC 24
tc_01_04_bob_2.mov 000001 FN 83 7693-5725+12 0409+15 001 01:13:42:11 01:19:10:06 00:05:27:20 VA1 1
tc_01_05_bob_1A.mov 000001 FN 83 6139-9521+00 001 01:19:10:19 01:23:36:09 00:04:25:15 VA1
So effectively the first 10 records can be deleted after import.
Sounds like the .ale format is for similar type programs i.e. video type data. Does Cinema Tools support exporting in one of the formats that FMP understands? If so start there and see what kind of output you get and from there perhaps fields can be mapped (or not).
Beat me to it!
Sounds like there are good replies to this posting already, but when I've had to import something that FMP didn't natively understand I've used two approaches, one in FMP and one outside FMP:
1. Inside FMP.
Import all records into a table with one field. Then do a table scan on that table (layout) and do whatever you need to parse each record, writing the fields to the actual separate table's fields in FMP.
2. Outside FMP.
I did parsing using a text edit tool, or RegEx parser, or an external program. Save parsed data to a text file. Import into FMP. Depending on the complexity of the file, sometimes the external program was for me the easiest overall choice. In one case, I made a web service so I could integrate the parsing into the FMP application, but, having the external web service, I could still use the parsing program for other users.
A must-have feature for me was FMP 13's http POST feature. That one feature alone made me upgrade to 13!
FMP is so extensible!!!
Sorry, I've never heard of it either.
My thoughts on the issue:
Where is the file coming from?
If its from a person maybe they are (incorrectly) entering their own (just for fun¿) extension.
If its from an automated system maybe the programmer put in the wrong (valid) extension?
Sorry I can't really help. I used to get a file with a strange extension and had to change it to ".txt". I know you can use AppleScript to do it. §^=)
See this link for information on apps that can open .ale files:
(note the 'ANY text editor' for either platform). From there you need to know what to do with it - and this link implies text with columns and data as tab-delimited).