Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About nycpost

  • Rank

Profile Information

  • Gender
  1. Thanks, Comment. That makes sense. I have a couple other instances where I have things like this that I've been wondering about breaking off into their own tables. I'll look at them and see if those entities are things that I need to track now - or have a chance of becoming things I need to track in the future. And yes, the relationship would definitely be by IDs, not by names.
  2. Hi Everyone, I’ve been building a database over the last several years and recently discovered that I am missing a few entities in it’s structure. The database is designed to help organize post-production for film and television. It was only as I got further along down the road that I realized there were elements I was missing. I wanted to do certain things and discovered that with the way it’s currently built, I couldn’t. I’m going back now to re-think the structure of the database, adding in new tables to give me the functionality I need (and may need in the future). Going back
  3. You are correct, sir! That worked perfectly. Thanks so much, eos. I had been banging my head against that one for hours.
  4. Hi All, I'm running into some trouble with a script and could use some help. I have three fields I want to concatenate into a text string. The fields are named: Proxy 1 Proxy 2 Proxy 3 The concatenating calc field is named: Text String Export What I would like to do is have the Proxy fields display a value list of other field names in my table, such as: Shot Name Pull Name Description Vendor So, for each Proxy field you can choose which other field you want to include in the concatenated calc field. Now, the concatenating calc field is working fine, but I cannot seem to
  5. Hi, Comment. I've stripped the file down to the essentials and attached it here. I've made an account for you and I'll PM your login along with some more details. If you could take a look I'd really appreciate it. Thanks, Mike Database Clone.zip
  6. A little more info. After more testing it looks like my results are pretty intermittent. Sometimes it works, sometimes it doesn't. I'm totally baffled by this.
  7. Sorry for the late reply, bcooney and Comment. I got buried under a ton of work this week and haven't had a chance to check the boards. Comment, I'm afraid that if I strip the DB down or clone it that some functionality might break. The whole DB relies on many interrelated tables and the presence of values is often required in order for calcs and scripts to run and evaluate properly. I'm afraid if I strip it down it might do our troubleshooting more harm than good. I think I've come across something interesting here though. Per your suggestion, I tried hard-coding the file name into
  8. Sorry, but I don't quite follow. When you say: Are you talking about manually importing, or importing via script? I've tried both, and each time it doesn't remember the source table in the FMP document I select.
  9. Thanks, bcooney! The notes table holds notes made on records from several tables and acts as a giant value list on many different types of shots, hence the reason to make a note record on import for every shot version. I'm trying to understand the demo file you posted, but still can't figure out how you determine the table within the source file. Is there a way to ID the table? Thanks, Mike
  10. I have a script that automates the import of a tab delimited file. My database has two tables, one called "Shot Versions" (which is where I keep versions of shots that our visual effects vendors create) and another called "Notes" (where I keep all the notes I make on the Shot Versions). The script first imports the tab delimited data into the Shot Versions table and then, because I want to make a note on every one of those records, I import the Shot Version IDs from the found set into the Notes table. I then use those IDs as foreign keys to link the Notes table to the Shot Versions table.
  11. Thanks, Comment. That works beautifully. I didn't realize the same expression I was using later in the XSLT to pull those values would also work for the for-each, but it does! Thanks again! Mike
  12. Hi All, I have an XML doc that I need to import into FMP. The document lists multiple "Event" elements. Sometimes these Event elements are followed by a "Comment" element. I want to filter the XML on import so only those Events who are followed by a Comment are imported. I'm trying to use the "for-each" expression in conjunction with the "preceding-sibling" axis to select the correct nodes, but it fails to pull any values from the XML. Below is an example of the XML I'm using and the XSLT. Can anyone shed any light on the proper syntax for this? Much appreciated, Mike
  13. Comment, that works great. Thanks so much! Your knowledge seriously knows no bounds!
  14. Oh, OK. Yes, the XML would always only have 1 comment following each event, so multiples won't be a problem.
  15. OK, so I would need to script it so the Events are brought into one table and the Comments into another and then link them via TC? That can work. But to confirm, there's no way to relate a subsequent Comment to the previous Event? Thanks, Comment. Mike
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.