I've set up a db to work w a colleague who's based remotely so he can
contribute to the shared task of inputting data.

Part of the useful data are pictures.

IWP doesn't allow the insertion of pictures into the db via the browser

Would it be possible to do the following by way of a workaround to this
limitation ?

Set up a password protected web site with a very simple file upload
form using mysql/php to allow someone to upload a picture along w an id
number related to an entry in the main db
Create an ODBC source based on the mysql db and create an FM file on
my system derived from it
Add this new file as a file referenced by the main db
Create script to regularly update the new file
Create relationship between the main db and the new file based for
example on an id number

IWP should then show pictures inserted by someone using the main db
from a remote site

Marmot

ps this may be bunkum: it's just an idea

I think the usual way to view pictures in a data base is not to insert them
in it, but to insert the "reference" (ie the path) to its file, while actual
pictures are in a separate folder - one file per picture -.
The way I do it is to have a separate 'Images.fp7' table - maybe a separate
file would even be better, as it would then be independant to the actual
DB -. And say, for the sake of example, that the pictures are photos of
persons, and it exists in the DB a 'Persons' table with one record per
person identified by a unique 'PersonID', eg '12345' for a given person.
Then the photo's file name of that person would be '12345.jpg'. The
relationships with any table is then straightforward.
In FMP6, I often used - when there were several thousands images to handle -
the 'Troi File' plugin at www.troi.com which has a free trial that has a lot
of excellent examples of what could be done, and the scripts can be used
almost 'as is'.
Now for the 'remote' question with a single person, I'd use the usual tools
as 'pcAnywhere' or 'Timbuktu', or even a simple 'ftp' program such as
'FileZilla'.
Remi-Noel


"marmot" <thdyoung (AT) mac (DOT) com> a écrit dans le message de news:
1168814233.634223.298880 (AT) 38g200...oglegroups.com...

Thank you Remi

Using FTP sounds good to me. My co-worker could upload image files to a
directory in /Applications/Filemaker\ Pro\ 7/Web/pictures with an id
corrresponding to a db entry and a calculation field could then grab it
and show it in the db served up with IWP.

What's puzzling me is how to make the pictures directory available in a
secure way using FTP ...

Marmot

Remi-Noel Menegaux wrote:

Marmot,
I use the FTP program 'FileZilla' only when I want to share with someone I
know the contents of a 10Gb space which is given for free by my Internet
Provider www.free.fr . That 'someone' - it could be you, if you wish, just
ask me to see how it works - has to fill up 3 fields one of which is the
password I gave. So the link is just between him and me. Unless, though, if
I give up those 3 fields contents to too many people, but I may change my
password anytime ...
If your own Provider does not give you that 'space', there are places which
exist - see Google - that provide spaces sometimes free. More, if you know a
bit of french, I guess you could subscribe a free access to my provider - ie
'Acces gratuit' at the above address - and then get that free 10Gb for you
(I couldn't check though, but there is no risk in trying).
Good luck. Please keep us posted...
Remi-Noel
PS : I also monitor completely a remote PC in Brussels - I am in Paris -
with 'pcAnywhere' which gives me full control (including File Transfer) of
that PC in which I put FMS(Server) and the solution I made for my client.


"marmot" <thdyoung (AT) mac (DOT) com> a écrit dans le message de news:
1168858259.520899.230100 (AT) 51g200...oglegroups.com...
Thank you Remi

Using FTP sounds good to me. My co-worker could upload image files to a
directory in /Applications/Filemaker\ Pro\ 7/Web/pictures with an id
corrresponding to a db entry and a calculation field could then grab it
and show it in the db served up with IWP.

What's puzzling me is how to make the pictures directory available in a
secure way using FTP ...

Marmot

Remi-Noel Menegaux wrote:

You could certainly from iwp open a php page that allows them to upload
the image files. Here is the link to an article and sample files to
help you out. http://www.fmwebschool.com/resources/upload.zip

In Kindness
Stephen Knight

thanks for this script, Stephen

I'm playing with it now

the head-scratch for me is
- secure configuration of ftp service so s.o outside my private ip
network can connect to a particular folder on my system in the FMP 7
web folder in Applications (I'm using a piece of sw called ftpd to this
end)
- if I used your scripts (which are v simple and easy to understand)
via IWP, where would I put them ? In the webserver folder on my Mac
presumably ? Since I use a DDNS service, presumably these scripts or
php pages would be addressed via the DDNS domain which I got fr the
DDNS company ...
- I've got the same DDNS domain to successfully serve a fmp db via IWP
direct from my system which is nice

Marmot

FMWebschool wrote: