Jump to content

Search the Community

Showing results for tags 'file path'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 5 results

  1. I have been reading and think I am clear on creating paths for export. Been practicing imports also. I can use a variable to say the file name but... I will have files for import where they are identical but first three characters of the file. How can I write generic import if it insists on my specifying the name? I wish I could say to import ALL files in a directory. I will know all but first three characters (ID of part number) of the file name. I wish I could say, "tell me all the file names that are in that directory" and the script like a loop or something and grab them all and import them. And how can I get the file name that I am importing into the imported records so I know where they came from? Please ideas. I don't even know the technical word for what I am asking. oh and I see I had put originally that I was intermediate. I realize I was very wrong after my last post. I will go change it back to ding-dong or whatever the earlier levels are so please respond like I'm one.
  2. I am not a FileMaker power user by any stretch of the imagination, nor does my question relate to any particularly sophisticated use of the program, so I hope others here will forgive and bear with me. I formed a band my junior year of college with guys who have remained my best friends throughout all of the subsequent 46 years. Though we’re scattered in different parts of the country now, we reunite at least twice a year to make music again, and for the past 23 years we have recorded songs together at these reunions. I created a FileMaker database to chronicle these recording sessions, and all of the songs done at each of them. The record for each song contains the fields you might expect: Title, Songwriter; Original Artist (for songs we didn’t write ourselves); Year; Session; Lyrics; and a repeating field for personnel — i.e., who sang and played what on each song. Each band member also has a Comment field so he can share his feelings about the song or memories of the recording session for it. We store the master copy of the database in Dropbox, and all can access it at any time — though I’ve put a system in place to ensure that no more than one person at a time can modify or add data to the file, to avoid the dreaded “conflicted copy” syndrome. Each record in the database also has a Container field for the recording it pertains to. To avoid the unthinkable bloat that would result in storing 23 years worth of .wav files in the database, I naturally used FileMaker’s “Store only a reference to this file” feature for this field. The music files themselves reside on a 128GB thumb drive. The plan was to strike exact copies of this Master thumb drive for each band member that they would physically insert into their own computers, so the the song associated with a given record would play when they access the database and double-click the Container field. Perspicacious readers may now guess where I’m headed. I am the only one of the five of us who is on a Mac system. My Master thumb drive, as well as a copy I struck from it, works perfectly for its intended purpose. I have taken the copied drive from home (where it was created) and used it with no problems whatsoever on my work Mac. No matter which Mac I use, as long as I access the database from Dropbox and have the thumb drive inserted in that Mac, all is well — since the Mac automatically “sees” and can instantly access any external device plugged into it. My bandmates, however, are all on Windows systems — and as my closest friend feared, when I sent that copy of the thumb drive to him. it did not work in the same way, due to Windows’ convention of assigning a letter to any external device plugged into a Windows-based machine. It appears a Windows system needs a strictly defined file path to locate the music files on the thumb drive. And a different letter is likely to be assigned to this drive in each person’s machine, based on how many other peripherals he has plugged into it at any given time. My obvious question: is there any way around this issue? Is there some way to tell a Windows system “Look for the music files referenced in this database on the ‘F:’ drive” (or whatever drive is appropriate)? Or is each individual member doomed to manually relinking each one of the 280 or so music files that I so carefully linked on the master thumb drive? Only my closest friend I referenced has a degree of computer savvy, so I was hoping to make this entire process as easy as possible for all concerned. Thank you very much in advance for any help that can be given. P.S. The database was created in FileMaker Pro 11.
  3. I have created an "opener" file called "OpenMP" that is located on the Windows Desktop. Also, a global variable for the directory where the FMP14 files are located called "$$marinaDir" = "MarinaPro v17". When activated the launcher opens but does not open the target file using the following file path, "filewin:/C:/$$marinaDir/Marina.fmp12." However if I substitute with the following, "filewin:/C:/MarinaPro v17/Marina.fmp12"; all is good. The script elements follow: #Create variable... Set Variable [$$marinaDir; Value: "MarinaPro v17"] #Start MarinaPro... Open File ["Marina"] (Marina File Path: filewin:/C:/$$marinaDir/Marina.fmp12) What am I missing?
  4. Hi All, I can never seem to get my head around file paths and even more so when we need to use variables. Can any of you help me with the following please? What I have is an inventory system that has been adapted from the starter solutions, I have created a new field called colour. I have a folder system set up with lots of different colour folders i.e. black, blue, yellow etc... I would like to add a button that performs a script that goes to the correct colour folder so that I can select the correct part. The folder path containing these colours would be "/Users/USERNAME/Documents/FOLDER/FOLDER/FOLDER/FOLDER/HERE ARE THE COLOUR FOLDERS" if that makes sense.... I know this involves a variable using the colour field but cannot get my head around it. (I am aiming to then further this later on by being able to go straight to the part code within that folder without having to manually select one. I think I will be able to complete this once I have got used to doing the first part) Thank you to everyone who can help.
  5. Hi, I'm trying to import images into my FileMaker database. My problem is: How can I import all my images at once and automatically match or store it based on the value in the Container in the field? For example: I have 5 images located/stored in the same folder of my FileMaker database: 11111.jpg , 22222.jpg , 33333.jpg , 44444.jpg , 55555.jpg **NOTE THAT FILENAMES CAN ALSO BE ANY RANDOM NAMES LIKE 36745.JPG , 76935.JPG , 36790.JPG , ETC.** -In my FileMaker database, I have PRODUCTS Table. -In my PRODUCTS Table, I have PHOTO Field Name. -My PHOTO Field Type is "Container" -- not 'Text' or 'Calculation'. -My Container Values are: 11111.jpg , 22222.jpg , 33333.jpg , 44444.jpg , 55555.jpg --> So that makes 5 rows right? What I want to do is, import all those 5 images from my folder into my FileMaker database while FileMaker will automatically search for its matching value in the database. Once FileMaker found its matching value/filename, it will place the image in that container. Basically, it will be like this: FILENAME = VALUE (IF 11111.jpg = 11111.jpg THEN place that image in that container) I want to know how to do this because I know it will save a lot of time when importing hundreds, thousand or even hundred-thousand files. I hope my explanation to my problem is very clear to you. Your help will be highly appreciated! Thank You very much in advance.
  • Create New...

Important Information

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