does image file exist - comp.databases.filemaker

Hi all, I have added a calculated container field to the database. That is, a container with a dynamically created reference to an image. If the image exists then it displays in the containter field. Fantastic. The calculation looks this this... "imagewin:/" & vehiclesfolder & "" & RegistrationNumber & "/ 200/01.jpg" It would be great if I knew that the image had been found as was currently being displayed. Is there a way I can do this? If the image exists then I would want to use that fact in another calculation, something like... if imagesexists in container then x=1 else x=0 end if any tips? Many thanks C10B

Can't be done without very extensive scripting. Where you basicaly have to import the refenced image. Then if the import failed you know the image file doesn't exist. But you have to relaunch the script everytime you want to make sure the image still is there. It would be much easier to reuse the calculated field, make it thumbnail size then put this on your layout for visual reference. Keep well, ursus "C10B" <Citizen10Bears@gmail.com> schreef in bericht news:e333aa92-e81c-40b2-82e4-9d1a7c8e3158@79g2000hsk.googlegroups.com... > Hi all, > > I have added a calculated container field to the database. That is, a > container with a dynamically created reference to an image. If the > image exists then it displays in the containter field. Fantastic. > > The calculation looks this this... > > "imagewin:/" & vehiclesfolder & "" & RegistrationNumber & "/ > 200/01.jpg" > > It would be great if I knew that the image had been found as was > currently being displayed. Is there a way I can do this? If the image > exists then I would want to use that fact in another calculation, > something like... > > if imagesexists in container then > x=1 > else > x=0 > end if > > any tips? Many thanks > C10B

I haven't tested this, but I would expect something like this to work: Let( img = "imagewin:/" & vehiclesfolder & "" & RegistrationNumber & "/200/01.jpg"; isempty(x) ) C10B wrote: > Hi all, > > I have added a calculated container field to the database. That is, a > container with a dynamically created reference to an image. If the > image exists then it displays in the containter field. Fantastic. > > The calculation looks this this... > > "imagewin:/" & vehiclesfolder & "" & RegistrationNumber & "/ > 200/01.jpg" > > It would be great if I knew that the image had been found as was > currently being displayed. Is there a way I can do this? If the image > exists then I would want to use that fact in another calculation, > something like... > > if imagesexists in container then > x=1 > else > x=0 > end if > > any tips? Many thanks > C10B -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Howard Schlossberg FM Professional Solutions, Inc. Los Angeles FileMaker 8 Certified Developer Member, FileMaker Business Alliance

"Howard Schlossberg" <howard@nospam.fmprosolutions.com> schreef in bericht news:vXljk.7334$Zf.172@fe117.usenetserver.com... >I haven't tested this, but I would expect something like this to work: > > Let( img = "imagewin:/" & vehiclesfolder & "" & RegistrationNumber & > "/200/01.jpg"; > > isempty(x) > ) > Howard, it wouldn't work. Filemaker evaluates this as plain text. And the result would be always untrue, because the calc would always contain some text. It only shows up as image in a calculated container, but if you take the same calc and change the result to text it would only contain the text result of the calculation. I've been looking for ways to do this for some time now, but haven't found one. (and your calc is faulty, if there would be any chance it should read isempty(img) ) Keep well, Ursus

Yeah, that was stupid on my part. What I should have suggested was to set a container field (through script or through unstored calc field) to "imagewin:/" & vehiclesfolder & "" & RegistrationNumber & "/200/01.jpg" and then test the container field for isempty(). Ursus wrote: > "Howard Schlossberg" <howard@nospam.fmprosolutions.com> schreef in bericht > news:vXljk.7334$Zf.172@fe117.usenetserver.com... >> I haven't tested this, but I would expect something like this to work: >> >> Let( img = "imagewin:/" & vehiclesfolder & "" & RegistrationNumber & >> "/200/01.jpg"; >> >> isempty(x) >> ) >> > > Howard, it wouldn't work. Filemaker evaluates this as plain text. And the > result would be always untrue, because the calc would always contain some > text. It only shows up as image in a calculated container, but if you take > the same calc and change the result to text it would only contain the text > result of the calculation. I've been looking for ways to do this for some > time now, but haven't found one. > > (and your calc is faulty, if there would be any chance it should read > isempty(img) ) > > Keep well, Ursus > > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Howard Schlossberg FM Professional Solutions, Inc. Los Angeles FileMaker 8 Certified Developer Member, FileMaker Business Alliance

On Mon, 28 Jul 2008 02:16:25 -0700 (PDT), C10B <Citizen10Bears@gmail.com> wrote: >Hi all, > >I have added a calculated container field to the database. That is, a >container with a dynamically created reference to an image. If the >image exists then it displays in the containter field. Fantastic. > >The calculation looks this this... > >"imagewin:/" & vehiclesfolder & "" & RegistrationNumber & "/ >200/01.jpg" > >It would be great if I knew that the image had been found as was >currently being displayed. Is there a way I can do this? If the image >exists then I would want to use that fact in another calculation, >something like... > >if imagesexists in container then > x=1 >else > x=0 >end if > >any tips? Many thanks >C10B It can be done. It does have to be scripted, but it's not that complicated. What I do is use a separate, secondary .fp7 file to hold images and image references. The secondary file pulls the calculated file/pathnames from the main file, then the main file pulls the images from the secondary and displays them. I use error capture determine whether the image file exists or not, and a Case function to decide what to do about it. It works best if you insert the images directly into the secondary .fp7 file, because then you have 2 conditions to test for: does the file exist (using error capture), and is the file in your db (using IsEmpty). IMO you're always better off inserting images into your db instead of using references. It's just safer and more comprehensive doing it that way. Images can make your db file enormous and slow it down, yes, but using a secondary file for image storage pretty much eliminates those problems. That trick is one the guys on this board turned me on to. hope this helps -- FW FileMaker Pro 8.5 Advanced on Windows XP Pro SP2 FileMaker Server 8.0 on Windows 2003 Server R2

FastWolf, You basicaly explained what I hinted at in my first reply. I have tried it, but found it unreliable. The system works, but can you really be sure nothing has changed since the last time you have run the script. And with lots of images the logging of errors can become quite extensive. But yes it does work. Keep well, Ursus "FastWolf" <wolfsofast@NOSPAMcomcast.net> schreef in bericht news:c7ou84d6h06v8qlhsrsrm4899jmtoh19u4@4ax.com... > On Mon, 28 Jul 2008 02:16:25 -0700 (PDT), C10B > <Citizen10Bears@gmail.com> wrote: > >>Hi all, >> >>I have added a calculated container field to the database. That is, a >>container with a dynamically created reference to an image. If the >>image exists then it displays in the containter field. Fantastic. >> >>The calculation looks this this... >> >>"imagewin:/" & vehiclesfolder & "" & RegistrationNumber & "/ >>200/01.jpg" >> >>It would be great if I knew that the image had been found as was >>currently being displayed. Is there a way I can do this? If the image >>exists then I would want to use that fact in another calculation, >>something like... >> >>if imagesexists in container then >> x=1 >>else >> x=0 >>end if >> >>any tips? Many thanks >>C10B > > It can be done. It does have to be scripted, but it's not that > complicated. What I do is use a separate, secondary .fp7 file to hold > images and image references. The secondary file pulls the calculated > file/pathnames from the main file, then the main file pulls the images > from the secondary and displays them. I use error capture determine > whether the image file exists or not, and a Case function to decide > what to do about it. It works best if you insert the images directly > into the secondary .fp7 file, because then you have 2 conditions to > test for: does the file exist (using error capture), and is the file > in your db (using IsEmpty). > > IMO you're always better off inserting images into your db instead of > using references. It's just safer and more comprehensive doing it > that way. Images can make your db file enormous and slow it down, > yes, but using a secondary file for image storage pretty much > eliminates those problems. That trick is one the guys on this board > turned me on to. > > hope this helps > > -- > FW > > FileMaker Pro 8.5 Advanced on Windows XP Pro SP2 > FileMaker Server 8.0 on Windows 2003 Server R2

"Howard Schlossberg" <howard@nospam.fmprosolutions.com> schreef in bericht news:70Jjk.19033$gg.17786@fe105.usenetserver.com... > Yeah, that was stupid on my part. What I should have suggested was to set > a container field (through script or through unstored calc field) to > "imagewin:/" & vehiclesfolder & "" & RegistrationNumber & "/200/01.jpg" > and then test the container field for isempty(). > > Sorry Howard, but Filemaker still would evaluate the field as containing text and would never return an empty container. For the container to contain an image, the image would have to be imported, not referenced. Keep well, Ursus

On Wed, 30 Jul 2008 09:08:26 +0200, "Ursus" <ursus.kirk@orange.nl> wrote: >FastWolf, You basicaly explained what I hinted at in my first reply. I have >tried it, but found it unreliable. The system works, but can you really be >sure nothing has changed since the last time you have run the script. No, you can't, not from within FMP, unless you always run the script before viewing the record. > And >with lots of images the logging of errors can become quite extensive. You're right, and all it can do is tell you is a file exists (which after all was the OP's question), but not how recent it is nor whether it's newer or older than the one you have inserted. >yes it does work. It works best when the number of users is relatively small and the DBA can maintain near-total control over the source folder[s] of images; and/or when the images are not likely to be changed or updated. -- FW >"FastWolf" <wolfsofast@NOSPAMcomcast.net> schreef in bericht >news:c7ou84d6h06v8qlhsrsrm4899jmtoh19u4@4ax.com... >> On Mon, 28 Jul 2008 02:16:25 -0700 (PDT), C10B >> <Citizen10Bears@gmail.com> wrote: >> >>>Hi all, >>> >>>I have added a calculated container field to the database. That is, a >>>container with a dynamically created reference to an image. If the >>>image exists then it displays in the containter field. Fantastic. >>> >>>The calculation looks this this... >>> >>>"imagewin:/" & vehiclesfolder & "" & RegistrationNumber & "/ >>>200/01.jpg" >>> >>>It would be great if I knew that the image had been found as was >>>currently being displayed. Is there a way I can do this? If the image >>>exists then I would want to use that fact in another calculation, >>>something like... >>> >>>if imagesexists in container then >>> x=1 >>>else >>> x=0 >>>end if >>> >>>any tips? Many thanks >>>C10B >> >> It can be done. It does have to be scripted, but it's not that >> complicated. What I do is use a separate, secondary .fp7 file to hold >> images and image references. The secondary file pulls the calculated >> file/pathnames from the main file, then the main file pulls the images >> from the secondary and displays them. I use error capture determine >> whether the image file exists or not, and a Case function to decide >> what to do about it. It works best if you insert the images directly >> into the secondary .fp7 file, because then you have 2 conditions to >> test for: does the file exist (using error capture), and is the file >> in your db (using IsEmpty). >> >> IMO you're always better off inserting images into your db instead of >> using references. It's just safer and more comprehensive doing it >> that way. Images can make your db file enormous and slow it down, >> yes, but using a secondary file for image storage pretty much >> eliminates those problems. That trick is one the guys on this board >> turned me on to. >> >> hope this helps >> >> -- >> FW >> >> FileMaker Pro 8.5 Advanced on Windows XP Pro SP2 >> FileMaker Server 8.0 on Windows 2003 Server R2 > FileMaker Pro 8.5 Advanced on Windows XP Pro SP2 FileMaker Server 8.0 on Windows 2003 Server R2

Similiar Articles:

rgb to grayscale using jet colormap intensity - comp.soft-sys ...
if ~exist(fullFileName, 'file') % Still didn't find it. Alert user. errorMessage ... This MATLAB function reads a grayscale or color ... A true color image does ...

INSERT PICTURE INTO A CONTAINER FIELD DYNAMICALLY - comp.databases ...
What I long for is the ability to use conditional (Case or If) calculations, so that if the image file doesn't exist at one path, FMP would look at another (and another ...

Image block - comp.soft-sys.matlab
... standard MATLAB gray scale demo image. folder =3D 'C:\Program Files\MATLAB\R2010ba\toolbox\images\imdemos'; if ~exist(folder, 'dir') % If that folder does not exist ...

cannot open neither boot_archive nor miniroot jumpstart - comp ...
>Probable reasons: Except that you haven't booted any OS yet so we have a few bytes availabe in the netboot image. >a. file does not exist >b. file not on your ...

code for Compressed Sensing? - comp.soft-sys.matlab
... of a Matlab script that simply takes a JPG or TIFF image as input, does its "magic", and gives me an output file ... html The 'magic' you talk about actually doesn't exist ...

how to use xlswrite for image files ? - comp.soft-sys.matlab ...
i try to an image file to excel file, which divided R- G - B channels ... Images • Scientific Data ... that specifies the name of the file. If filename does not exist ...

Image processing edge finding algorithm - comp.soft-sys.matlab ...
I have made an image it's a black circle on a ... fullfile(folder, baseFileName); if ~exist(fullFileName, 'file ... errorMessage = sprintf('Error: %s does not exist ...

How to save files into a specific folder - comp.soft-sys.matlab ...
... from an avi movie % and save individual frames to separate image files ... images \imdemos\rhinos.avi'; % Check to see that it exists. if ~exist(movieFullFileName, 'file ...

double,unit8 - comp.soft-sys.matlab
... image.bmp')" 1. double(imread('image.bmp')) This reads the image file "image ... of the converted string, you get an error because that second pane does not exist.

Remove foreground. - comp.soft-sys.matlab
... There was a time I was fairly efficient at the image ... folder, baseFileName); if ~exist(fullFileName, 'file') errorMessage = sprintf('Error: %s does not exist ...

PHP: file_exists - Manual
I wrote this little handy function to check if an image exists in a directory, and ... for a file newly created by an external program in Windows then file_exists() does not ...

Image file does not exist
I am trying to install windows 7 beta 64-bit over a system running vista 32-bit. I have burnt to the ISO to DVD. When I boot from the DVD, setup starts and ...

7/16/2012 6:57:34 PM