Using referecing images to container field

[RodM]

I suppose my application having 3 images per patient..somewhere said I should not store that many images actually in the container? i read, now I am trying to figure what make below code function.. whereas the container references the file store on the drive//

My field is a container, inside creating a calculation like:

Let (

txt = GetAsText ( ***my field name*** );

GetValue ( txt; ValueCount (txt))

)

BUT?? Nothing happens differently.. I can still right click container field and insert image i browse for on my disk....... with this kind of code does THE FUNCTION still behave the same ?

I should be able to emove image from drive and the FM container no longer displays image right?

[bcooney]

The formula the you posted is used to get the path of a file stored as a reference in a container field, rather than embedded in the container field. If you right click and Insert Image and do NOT check Store as Reference, then the file is embedded in the database.

You can only store one image per container field (either referenced or embedded). If you have more than one image per "patient" record, then you should have a table for the images that is related by PatientID to the patient record.

[RodM]

Thanks again, Didn't even see the little Refer file image click in dialog..

The 2 suggesting, from your experience, storing to file makes sense, but I am concerned about image gloat.. size and corrupting my application with patient data inside it.. If so, should it be a external file? I perplex or have no experience storing such image data!

Since we need to scan personal data having upto 4 Jpg images per patient.. even stripping to B/White (acceptable) , i am concerned what employees might stuff in a file.

As it is now, without lots of images, only a few embedded during development, our application compiled is on 34M including the run time files.

Embedded seems the application can grow quite large?

Then the office, has to update patient info, at least 1 or 2 times a year.. Some photo editing

How would a container get or read a specific 4 files at some specific folder.

if Patient is J. Smith , DriverLic# J12345

By default I thought my patient filenames might look like 4 images

SmiJ12345-1.jpg

SmiJ12345-2.jpg

SmiJ12345-3.jpg

SmiJ12345-4.jpg

Thanks for your time & Help

[bcooney]

Yes, your instincts are correct. Embedding images does lead to file size bloat (but not necessarily instability).

If you reference images, then they must not be moved, bcs FM will not adjust the path.

Again, a container can only refer to one image. You'll need a new table of images (referenced or embedded), related to patients.

Photo editing, of course, is done outside of FM.

Read up on file references in Help, and search for the many threads about the subject here on the forums.

[RodM]

BTW I searched 'file refences' in help... i think its the longest list 117 pgs.. and i do cruse these pages.. I spent a lot of time trying to get this..

I have 3 containers in a patient file... is that a problem?

[RodM]

This is all about getting images in my applications

I like the way to just right click and get an image inserted.. its friendly.. but when I hide the Top menu bar, I seem to loose this insert image right click option..

Is there a way I can insert image File as reference is my preferred choice

I tried using 360 getfileasContainer but it tends to default to Embedded the image.. Ot I can't figure it insert as reference method

Another point, Trying to eliminate "File/ File/ Edit etc..." menu along top at runtime, I have tried using several kinds of custom menu schemes... or just have the Edit/ text/font/color options.. I can't figure how to get the insert image option included.. or had FM forgot this option,

Someone, memtioned account privialges?

i haven't looked at.. an area i am less familiar with

I tried the Klosiak compile switch (misspelt) But is just a black screen - I loose the desktop?

Any help appreciated Thanks, my in my other issues working perfect thank much.

[bcooney]

You should have a separate related table for images (even if they are referenced and not embedded), not 3 container fields in Patients.

Insert File must be in your menus in order to use right-click Insert File.

Kiosk takes over the entire system. No menu bars, no desktop. Probably not what you want.

[RodM]

oh me, this guy again

Maybe i misunderstand the container use.. Or this is a design preference issue.. Container fields seems like a regualr type var to me..... and in this app, I store several images per State-file, then related down per City-file NOW these 4 patient IMAges I have a system config file even with containers for logo, header images not stored in another file ALL these hold images... are not being manipulated (installed/ edited) by operators..

The only reason this is being discussed is ..

finalizing my runtime and giving my user a way to get image into the container fields...

[color:orange]Still I am stupidly wondering why? your saying NOT to store these 4 containers in a patient file?

..not mentioned b4, My application already creates a specific coded reference filesname.. by operator entering the patient last name, drivers license, the city and state and 1-4 images information.

Smith_J3940_95670_1.jpg

Smith_J3940_95670_2.jpg

Smith_J3940_95670_3.jpg

Smith_J3940_95670_4.jpg

My operators scan in photoshop or similar NAMING THE 4 FILES..

I a gobal_var for where to find Path for this particular location or app.. 'D:documentationetc...etcccccdApplicaionpatientIMAGES'

I KNOW WHERE MY Patient FOLDER IMAGES ARE.. i think your asking that I create another database to have such referencing or control where of image... I pre coded named these patient files hiding the patient names, maybe Heppa thing.

I guess if I can deal with revisiting " my custom menu" I might have missed the insert option.. I WILL SOLVE MY ISSUES"

OBSERVATION THEN i will scrap 360 'getasfilecontainer' button... iT seems to take along time to register that first time FM loading for just this one EXT cmd.

Big thanks

[RodM]

Back from attemptin Custom menu again? ...Can not find INSERT portion see image attached please. ( ver fm9 adv)

PS.. have not moved to ver 10 due to most my clients use 8.5.. and need to stay compatible downward for a while longer)

[bcooney]

Rod,

All I'm suggesting is that images are stored in a separate TABLE, not file, and related to whatever parent by a foreign key.

If you want to right-click insert, you need the Insert menu in your Menu Set, and the Insert File.. command in the Menu. You also need the field on the layout.

Barbara

[RodM]

sorry for the merry go round.. the attached image does not have that insert options

[bcooney]

The screen capture you show is the dialog to define a Menu Set. It is the highest level.

Menu Items belong to Menus which belong to a Menu Set.

So, you need to add the Insert File menu item to a menu that will be included in the Runtime Menu set.

This is, admittingly, a very confusing interface within FM.