Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by TaiChi56

  1. Wow, thank you for taking the time to write this. I will do what you suggested and go from there. Again, thank you very much.
  2. Yes, I am importing all the movies also. They are listed under title.
  3. I have been working on a movie database and found a schema that makes sense to me as far as the relationship. But one thing I am having problems with is I am importing an Excel Spreadsheet with 715 rows of data. My problem is that each Movie has four actors, two main ones and the other two character actors. I have separated them into for different columns in EXCEL. Actor_1F is the Actors first name and Actor_1L Last name, I did this for each of the four actors. I really do not think this is correct. Because when I look at the Schema I cannot figure out how to relate the four actors to a movie. What I am doing is showing the picture of each actor and giving their Bio. The way I import the 715 rows is by using their name attached to an image field. I hope this is making sense. So long story short, How would I relate the four actors to a movie when importing in bulk, when they are separated like this. Here is an example of the EXCEL Spreadsheet? I have not finished separating the Actors first and Last names yet. Thank you.
  4. AMAZING, AMAZING, AMAZING. It worked, thank you for your help. LaRetta, thank you also. Both of you have a great day. Love this forum. 🙂
  5. Still not sure why it is not working. I can get it to work on Windows 10. But I am trying to stay with my MAC, since I really like it. So I should not be putting the "imagemac:" & Get (DocumentsPath) & "Photos/" & Film::title & ".jpg" in the Auto enter calculation? So how do I run it? I have 715 pictures right now so I would really like to be able to get them to auto fill. I already have the database built with all the information of each film, just need the container to fill the image that is related to that particular movie. The posters are stored in a directory called "Photos" in the Documents folder. Each movie poster is titled with a .jpg extension. Thank you.
  6. Still not getting this to work. I uploaded a small example of the database. I have the pictures in a folder called Photos and it is in the Documents folder. I cannot seem to get it to show the pictures. Thank you for looking at it. ClassicMovies_DB upload.fmp12
  7. I am sorry that it took so long to answer. I had thought I sent a thank you, but does not look like it, sorry. I am still not getting the this to work. Should I be changing something in the ImagePath calculation? I have the Photo folder in the document directory. Thank you.
  8. I have always developed with FileMaker for windows. I have bought myself a MacBook Air and love it. So now I am using FileMaker 16 Pro advance for MAC. I know that MAC does not label their directories like windows does. So I am having problems figuring out to get the right coding to access my photos. I have a folder called "Photos" that reside on the C: drive in windows. Then I reference that folder so pictures will populate automatically when I put in a record. Here is what I have on the windows fileMaker: ImagePath: Let ( [ // Transform the contents of a container field named Images to text ImageRef = GetAsText ( ImagePath); Photos = Position ( ImageRef; "/"; 1; PatternCount ( ImageRef; "/")) ]; Middle ( ImageRef; Photos + 1; Length ( ImageRef ) - Photos ) ) images: "imagewin:/C:/Photos/" & Film::title & ".jpg" Then I go into Import folder and point to the folder all the photos are in. The problem I have now is how to point to that folder in "imagewin", is their an alternative called imagemac, then I could put in Macintosh HD/Users/patricks/Documents. The folder is in the Document folder, called Photos. Thank you for any help.
  9. Awesome, that worked great. Thank you very much for your patience and help. Have a great holiday!
  10. Thank you. I attached a file so you can see what is going on. I am also having problems with the Director field. You can see where the name dropped down a space. If there is more than one director it then does the same thing as the actor field. Thank you for your help. FMForumUpload.fmp12
  11. Yes, it is one field in one record. It is a movie database and the field is the actor field. So in my edit box it shows the names one after the other in a vertical format. I want it on one line. I put your code in the actor field in Calculated value under manage database but nothing happened. Was that the correct way to do it? Thank you.
  12. I have a field that holds names, normally four names separated by commas. But right now they are aligned like this: John Doe, Jane Doe, Billy Doe, Jo Doe I need to have them listed on one line such as this: John Doe, Jane Doe, Billy Doe, Jo Doe I tried importing from a CSV and an EXCEL sheet and it still comes out vertical. Any help would be appreciated, thank you.
  13. Excellent that worked great but now that led me to another problem I did not realize I had because I imported these records off of an EXCEL spreadsheet. When making a new record is there a way to add those same "USE" criteria in the one field that uses a drop down from the value set or would it be better to just make that a regular edit box? Would that work? Thank you.
  14. I have a value set that goes to a field called "USE" the value set has the following: Patriotic, Contest, Concert, Festival, Broadway, Popular, Folksong, Christmas, Spiritual, Novelty and Mandrigal Is there a way to be able to highlight more than one of these "USE" and do a search? Example: I want to search the database for a Christmas song that is also a Broadway Play and a Festival piece? Christmas and Broadway and Festival. Can this be done with a drop down box? I cannot seem to be able to do this with the Find Operators. Thank you.
  15. Is it possible to create a custom menu but keep the find that Filemaker incorporates? The one by the "Delete Record" I cannot seem to find it when I create a custom menu. I really like that Search feature so I would not have to create custom ones. Thank you. Let me rephrase this. Why does the Find Icon go grey in the status bar when you use a custom menu. I cannot seem to get it to work in a custom menu.
  16. Thank you. I am having them put their Excel file in the same directory and folder where this database will be installed. I will try this. Again thank you.
  17. Ok, here is what I am trying to explain. The database is built for other people to download. I will not be there to be able to import for them. So if a person gets my database and has an EXCEL spreadsheet of their library I am giving them the option to import into their new database via a script. But I noticed on their initial database that if they do not understand that it already imported that they will click on the import button again and now they have doubled their imports. Does that make sense? I will then have a script where they can update their database by Excel if they want later on when they get more data to add.
  18. I have a script for the user to import an EXCEL file into the Database. I noticed though if the system is slow for some reason and the user does not look at the records tab to see that records have been imported the user may click import again thus doubling the data. How do I keep the user from inputting the same data twice? Here is my script: Go to Layout ["Choir Catalog Details" (ChoirCatalog)] Import Records [With dialog:off; Source: "CatalogImport.xlsx"; Worksheet: "Choral"; Add; Windows ANSI] Show All Records Thank you.
  19. You are a GENIUS!!!!!!!!!! That worked. Cannot believe I missed that. Thank you so much.
  20. I turned off dialog. Here is where I am trying to save it. file:C:/Users/SixCore/Desktop/"Catalog.xlsx" Still getting the same error.
  21. Perform Find[] Save Records as Excel [With dialog:On; ""Catalog.xlsx""; Automatically open; Records being browsed] Go to Layout [original layout] Show All Records I am getting the following error: ""Catolog.xlsx"" count not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk. I have a 2 TB drive with plenty of room. I have renamed it several times and made sure that it had full user access. When I debug I get this: Last error: [800] Unable to create file on disk I have made scripts many times before for EXCEL export and never had this problem. I have searched for an answer and have not found one.
  22. Thank you to both of you. Sorry it took so long for me to reply. I will work on your suggestions. Thank you.
  23. Thank you to both of you. Sorry it took so long to get back and reply. I will work on both suggestions. Thank you. 

  24. How would I make one table meet four categories in my relationship. I am doing a choral music database for our school. So I have the following: Mixed, Men, Women, Small Ensemble. Each of these libraries have the same information such as; Title, composer, Arranger, Lyricist, Voicing, etc..... So when I person clicks on Mixed they get all the information categories that they would get if they picked Men, just different information in them. So would I just make four tables of the categories and have each one have a Primary key, then make on table with all the information fields and have a PK, and then each of the categries would have the FK? Thank you.
  • Create New...

Important Information

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