dbTalk Databases Forums  

Calculation on container

comp.databases.filemaker comp.databases.filemaker


Discuss Calculation on container in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Chris Brown
 
Posts: n/a

Default Re: Calculation on container - 07-15-2007 , 11:14 PM






"You could probably use DataLog (from NightWing )"
that should be SuperLog




Bill Marriott wrote:
Quote:
Easy, and you don't need an external.



SuperLog is just a custom function.


Chris


Reply With Quote
  #12  
Old   
Bill Marriott
 
Posts: n/a

Default Re: Calculation on container - 07-16-2007 , 02:12 AM






Given the fields:

thefilepath (text)
yourcontainerfield (container)
containercalc (calculation, text result) = yourcontainerfield

1. File--> Import Records --> Folder...
2. Specify a folder with images
3. Select "Import only a reference..."
4. Click Continue...

5. Map File Path to the field "thefilepath" -- Do not map anything else.

6. After Import, run the following script:

Set Error Capture [On]
Go to Record/Request/Page [First]
Loop
Set Variable [$x;
Value:Substitute(yourtable::thefilepath;"file://";"image:/")]
Go to Field [yourtable::yourcontainerfield]
Insert Picture [Reference; "$x"]
Go to Record/Request/Page [Next; Exit after last]
End Loop

At the conclusion of the script, containercalc *will* contain pixel
resolution for the images.



Reply With Quote
  #13  
Old   
Matt WIlls
 
Posts: n/a

Default Re: Calculation on container - 07-16-2007 , 08:44 AM



In article <v8ednaGtycGZhgbbnZ2dnUVZ_iydnZ2d (AT) comcast (DOT) com>
"BillMarriott" <wjm (AT) wjm (DOT) org> wrote:

Quote:
Given the fields:

thefilepath (text)
yourcontainerfield (container)
containercalc (calculation, text result) = yourcontainerfield

1. File--> Import Records --> Folder...
2. Specify a folder with images
3. Select "Import only a reference..."
4. Click Continue...

5. Map File Path to the field "thefilepath" -- Do not map anything
else.
6. After Import, run the following script:

Set Error Capture [On]
Go to Record/Request/Page [First]
Loop
Set Variable [$x;
Value:Substitute(yourtable::thefilepath;"file://";"image:/")]
Go to Field [yourtable::yourcontainerfield]
Insert Picture [Reference; "$x"]
Go to Record/Request/Page [Next; Exit after last]
End Loop

At the conclusion of the script, containercalc *will* contain pixel
resolution for the images.

Not here, it doesn't.

Steps as described followed precisely. I have the file name and
nothing else.
Perhaps I should have asked this before: is this possibly
platform-specific? I am doing this on OSX 10.4.9. I just got home from
my 12-hour night shift. After a bit of a nap, I will try it on XP.
Matt





Reply With Quote
  #14  
Old   
Bill Marriott
 
Posts: n/a

Default Re: Calculation on container - 07-16-2007 , 08:59 AM



I verified the procedure both on Windows XP and Mac OS X using FileMaker 8.5
before posting.


Quote:
Not here, it doesn't.

Steps as described followed precisely. I have the file name and
nothing else.
Perhaps I should have asked this before: is this possibly
platform-specific? I am doing this on OSX 10.4.9. I just got home from
my 12-hour night shift. After a bit of a nap, I will try it on XP.
Matt






Reply With Quote
  #15  
Old   
Howard Schlossberg
 
Posts: n/a

Default Re: Calculation on container - 07-16-2007 , 11:36 AM



Matt WIlls wrote:
Quote:
In article <v8ednaGtycGZhgbbnZ2dnUVZ_iydnZ2d (AT) comcast (DOT) com
"BillMarriott" <wjm (AT) wjm (DOT) org> wrote:

At the conclusion of the script, containercalc *will* contain pixel
resolution for the images.

Not here, it doesn't.

How are you getting the resolution, Bill? I think the length() function
will give you image size.

Or are you using GetLayoutObjectAttribute(objectName; "content"/"source")?


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Member, FileMaker Business Alliance


Reply With Quote
  #16  
Old   
Bill Marriott
 
Posts: n/a

Default Re: Calculation on container - 07-16-2007 , 12:45 PM



Hi Howard,

Quote:
How are you getting the resolution, Bill? I think the length() function
will give you image size.

Or are you using GetLayoutObjectAttribute(objectName; "content"/"source")?
I'm not doing anything special beyond the script I posted...

Perhaps my computer is just a little bit smarter? Perhaps I'm going to have
to post a video or something to show I'm not using any special tricks.





Reply With Quote
  #17  
Old   
Matt WIlls
 
Posts: n/a

Default Re: Calculation on container - 07-16-2007 , 01:25 PM



In article <ZZSdna6clcjWMgbbnZ2dnUVZ_gKdnZ2d (AT) comcast (DOT) com>
"BillMarriott" <wjm (AT) wjm (DOT) org> wrote:

Quote:
Hi Howard,

How are you getting the resolution, Bill? I think the length()
function will give you image size.

Or are you using GetLayoutObjectAttribute(objectName;
"content"/"source")?

I'm not doing anything special beyond the script I posted...

Perhaps my computer is just a little bit smarter? Perhaps I'm going
to have to post a video or something to show I'm not using any
special tricks.

We're both using the same system, the same application (FM 8.5), and
the same procedure, but getting different results.
Your guess is as good as mine.

Matt




Reply With Quote
  #18  
Old   
Aladino
 
Posts: n/a

Default Re: Calculation on container - 07-16-2007 , 02:30 PM



Helpful Harry <helpful_harry (AT) nom (DOT) de.plume.com> wrote:

Quote:
You don't say what version of FileMaker, but as far as I know there is
no ability in any version to generate checksums from Container field
data
I'm using filemaker 8.5, my need is to create a registration number
starting from the data contained in the header field that applies on all
forms that my solution can print. Before now I used a Text field for the
header, but some clients found the text header to less elastic


Reply With Quote
  #19  
Old   
Chris Brown
 
Posts: n/a

Default Re: Calculation on container - 07-16-2007 , 05:03 PM



Bill Marriott wrote:
Quote:
I verified the procedure both on Windows XP and Mac OS X using FileMaker 8.5
before posting.


Not here, it doesn't.

Steps as described followed precisely. I have the file name and
nothing else.
Perhaps I should have asked this before: is this possibly
platform-specific? I am doing this on OSX 10.4.9. I just got home from
my 12-hour night shift. After a bit of a nap, I will try it on XP.
Matt






ah, 8.5
8.0Adv here, OSX.4.10


Chris


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.