File path drag and drop? 
Author Message
 File path drag and drop?

I would like to say, wow!  This is a cool place.  I am new to FileMaker, and
I am currently learning to build my own database for my business.  I am new
to database development so bear with me if you can.

I am currently using FileMaker 6.0v3 on a Mac with OS X 10.2.1.  I have
figured out how to make a script that will open a file path specified in the
field I have called "File".  It does a good job, it opens each file in its
specific application.  I did this using a combination of script commands
center specifically around the command 'open URL'.

My first question is:  Is this the best method?

I am currently having to do a find/replace for spaces I have in the file
names to %20.  Apparently, a path as a URL just does not like spaces.

My second question:  is there a way to just drag the file from a Finder
window to the field, and FileMaker automatically fills in the path to the
file?

This would be an awesome thing for me.  I am currently doing more typing for
the file paths than for the entire record.

Granted I am somewhat new to my Mac (8 months).  But the only advantage I
see to a Windows machine at this point is the "address" line you get in
explorer.  In Windows I could at least copy and paste the path from the
explorer window, but Finder on my Mac does not have a "path/address" line.
At least one I have found, that spells out the absolute path for the file
you have selected in the window.

Like I said, I am new, so any suggestions would be greatly appreciated.

Scott Korey



Tue, 22 Mar 2005 01:56:05 GMT
 File path drag and drop?

With fm6, you should not be typing any filepaths!

You can import filename, filepath, picture or text, and/or thumbnail (if a
picture file) using the folder of files and the new records option - very
scriptable.

You can import filepath into an  existing record or set of records if there
is a match between a field containing the file name and the filename of the
file, using import from a folder of files and the update existing records
option - also scriptable.  This is brilliant because it means that if you
have move the originals to a different directory, you can update the
filepaths to reflect this and keep everything humming along.

You can open a file in the application that created it just by
command-clicking the filepath field, no script required (although I haven't
tested this in Jaguar).

--
Bridget Eley


on 10/4/02 3:56 AM:

Quote:
> I would like to say, wow!  This is a cool place.  I am new to FileMaker, and
> I am currently learning to build my own database for my business.  I am new
> to database development so bear with me if you can.

> I am currently using FileMaker 6.0v3 on a Mac with OS X 10.2.1.  I have
> figured out how to make a script that will open a file path specified in the
> field I have called "File".  It does a good job, it opens each file in its
> specific application.  I did this using a combination of script commands
> center specifically around the command 'open URL'.

> My first question is:  Is this the best method?

> I am currently having to do a find/replace for spaces I have in the file
> names to %20.  Apparently, a path as a URL just does not like spaces.

> My second question:  is there a way to just drag the file from a Finder
> window to the field, and FileMaker automatically fills in the path to the
> file?

> This would be an awesome thing for me.  I am currently doing more typing for
> the file paths than for the entire record.

> Granted I am somewhat new to my Mac (8 months).  But the only advantage I
> see to a Windows machine at this point is the "address" line you get in
> explorer.  In Windows I could at least copy and paste the path from the
> explorer window, but Finder on my Mac does not have a "path/address" line.
> At least one I have found, that spells out the absolute path for the file
> you have selected in the window.

> Like I said, I am new, so any suggestions would be greatly appreciated.

> Scott Korey



Tue, 22 Mar 2005 05:49:08 GMT
 File path drag and drop?
Ok, I am playing with the Import function.  Using the "folder of files"
option does give me a list where I can pick and choose what variables I want
to put into what fields.  Now I only get this option when leaving the
setting for picture and thumbnail, so it only imports the reference not the
whole file.  However I have a problem, it doesn't let you just pick one file
from the entire folder and just import its info.

I already have quite a few records created with myself manually typing in
the file path.  How would I use the Import option to have it replace the
correct record one by one.  This is an issue because the files I reference
can change from one directory location to another, and that is from record
to record.  It isn't like I have one table and one folder of files that
would be associated.  I have one table with multiple file locations.

Also the entire command+click thing doesn't seem to work for myself.  I
tried to click on the imported file paths, and nothing happens.  I did
notice that it looks like a url, but is much more straight-forward.  For
example:

FileMaker 6 Import looks like:  file://Macintosh HD 2/Onsight
Images/Invoices & Receipts/2000/travel/xxxx.pdf

Me manually inputting:  file://localhost/Volumes/Macintosh HD 2/Onsight
Images/Invoices & Receipts/2000/lodging/xxxx.jpg

Using my homemade open url script, it will open the file.  But the
command+click causes nothing to happen.  Am I missing something?  Does the
field have to be a container type or is text type ok?  I was trying it as a
text field.

As you can tell lots of learning for myself.

Scott


Quote:

> With fm6, you should not be typing any filepaths!

> You can import filename, filepath, picture or text, and/or thumbnail (if a
> picture file) using the folder of files and the new records option - very
> scriptable.

> You can import filepath into an  existing record or set of records if there
> is a match between a field containing the file name and the filename of the
> file, using import from a folder of files and the update existing records
> option - also scriptable.  This is brilliant because it means that if you
> have move the originals to a different directory, you can update the
> filepaths to reflect this and keep everything humming along.

> You can open a file in the application that created it just by
> command-clicking the filepath field, no script required (although I haven't
> tested this in Jaguar).

> --
> Bridget Eley


> on 10/4/02 3:56 AM:

>> I would like to say, wow!  This is a cool place.  I am new to FileMaker, and
>> I am currently learning to build my own database for my business.  I am new
>> to database development so bear with me if you can.

>> I am currently using FileMaker 6.0v3 on a Mac with OS X 10.2.1.  I have
>> figured out how to make a script that will open a file path specified in the
>> field I have called "File".  It does a good job, it opens each file in its
>> specific application.  I did this using a combination of script commands
>> center specifically around the command 'open URL'.

>> My first question is:  Is this the best method?

>> I am currently having to do a find/replace for spaces I have in the file
>> names to %20.  Apparently, a path as a URL just does not like spaces.

>> My second question:  is there a way to just drag the file from a Finder
>> window to the field, and FileMaker automatically fills in the path to the
>> file?

>> This would be an awesome thing for me.  I am currently doing more typing for
>> the file paths than for the entire record.

>> Granted I am somewhat new to my Mac (8 months).  But the only advantage I
>> see to a Windows machine at this point is the "address" line you get in
>> explorer.  In Windows I could at least copy and paste the path from the
>> explorer window, but Finder on my Mac does not have a "path/address" line.
>> At least one I have found, that spells out the absolute path for the file
>> you have selected in the window.

>> Like I said, I am new, so any suggestions would be greatly appreciated.

>> Scott Korey



Tue, 22 Mar 2005 07:15:05 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Getting Long File Path from short Path / File Name

2. Dropping file system files after dropping database devices on SQL 6.5

3. How to save the report as a template after they drag and drop the pivotTable

4. Non-Functioning Drag and Drop in DTS Designer

5. Drag and Drop of Dimension does not work in PivotTable

6. No DTS Drag and Drop with w2k

7. drag and drop to an image box

8. Datagrid Drag and Drop

9. drag & drop list box items

10. Drag/Drop on Treeview Controls

11. Drag & Drop


 
Powered by phpBB® Forum Software