Rebuilding Image File Reference data in a Db

[Stan Mathews]

Re: Rebuilding Image File Reference data in a Db

The suggested code is not meant to open a directory for selection. It is meant to automatically populate an ifr field based on the value in another field (holding the name of the image).

"Unique ID in the table always matches the photo name in the proto repository"

Since you have multiple image types you would have to manage the process a bit differently.

For field1 you would use

filefind.get(path_var+id_value+"_A.*",FILE_FIND_NORMAL,"PN")

for field2

filefind.get(path_var+id_value+"_B.*",FILE_FIND_NORMAL,"PN")

etc.

If you are using ui_get_image_filename() you can force the extension/type with something like

ui_get_image_filename("C:\*.jpg") or ui_get_image_filename("P:\*.jpeg")

There is a View, Settings, Preferences, Image Fields option to display the Alpha internal image locator dialog (Prompt), where all images in the directory are listed, in place of the usual Windows Explorer style default.

[Ted Giles]

Re: Rebuilding Image File Reference data in a Db

Thanks Stan, I plumbed that in and it shows the file type I am after.
Last silly question on this.
Can I force the IFR Icon to default to a specific folder and file type?
It is possible that I will get the user to always use JPEG format, so to save extensive coding, can the field icon be forced along a specific path, or do I have to code for all 12 photos?

Edit. Hold up, just re read the last sentence!
That picks up the folder I want but shows all jpg and jpeg files. I suppose the only way is to ensure that only jpeg files are used.

[Mike Wilson]

Re: Rebuilding Image File Reference data in a Db

Ted,
the wildcard system works always. The jpeg and jpg both have jp in common, so if you want both try jp*, or if only jpeg, make that the .jpeg litteral.

[Ted Giles]

Re: Rebuilding Image File Reference data in a Db

A solution! Whoopie!
Taking all the comments above has allowed me to work towards a solution which works in the application.

The easiest way I found to get the Image Icon to show the selection of JPEG files only in the Windows file picker, was to pre-populate the image field with a .jpeg default image.
Using Paint, I created a .jpeg image as a default. The default folder is selected using the filefind() process.
This default image can be a blank white square, but I have opted to put some text in it.
When user creates a record, the image placeholders show the default image, which in my case says "Empty".

You can still choose PNG, BMP or JPG, but the first choice is JPEG.

So, depending on the client requirements, a default image type could be defined as a variable and changed to suit, thus showing the selection you want in the Windows file picker.
I will be working on the default image folder issue next using all the gratefully received assistance on this thread.