Importing Images

[ITALIA]

Hello everyone!

On a table called "Product" there are two fields called "Picture" (jpeg field) and "Picture Location" (the URL of tha Product Image). For every record in this table, i need to import the Images of the products, but because there are a lot of records in it, if i import the images one by one it's going to take forever.

I was wondering if there is a way to automatically import the images using (maybe) the Picture Location field to find the path. I was thinking about writing a script, but i need to investigate if there's a function that let me import an image to the database.

Thanks in advance for your attention.

MAURO TRENTINI

[ITALIA]

Re: Importing Images

Just adding an example.
I began to write the script to import the pictures and i came up with something like this:
--------------------------------script-------------------------------------
dim pic as P

tbl = table.open("product.dbf")
tbl.fetch_first()
while .NOT. tbl.fetch_eof()
tbl.change_begin()
?? Here goes the function to import the pictures (something like tbl.Picture = FILE(PictureLocation))
tbl.change_end()
end while
tbl.close()
--------------------------------------------------------------------------

King Regards,
MAURO TRENTINI

[Stan Mathews]

Re: Importing Images

Just adding an example.
I began to write the script to import the pictures and i came up with something like this:
--------------------------------script-------------------------------------
dim pic as P

tbl = table.open("product.dbf")
tbl.fetch_first()
while .NOT. tbl.fetch_eof()
tbl.change_begin()
?? Here goes the function to import the pictures (something like tbl.Picture = FILE(PictureLocation))
tbl.picture = image_filename_encode(drive-path-filename)
tbl.change_end()
end while
tbl.close()
--------------------------------------------------------------------------

King Regards,
MAURO TRENTINI

But you have to supply the dirve-path-filename before the line is executed. This can be driven by a ui_get_file() or other means.

[ITALIA]

Re: Importing Images

"But you have to supply the dirve-path-filename before the line is executed. This can be driven by a ui_get_file() or other means."

Thanks for the quick reply.
I don't understand what's the drive-path-filename. If you mean the location of the file, i tried with the following code but Alpha5 gets frozen if i try to execute it.


--------------------------------------------------------------------------
location = "Z:\BVHE\pic\BVE001.jpg" //a test location just for debug, the real path for each picture is in tbl.PictureLocation

dim pic as P

tbl = table.open("product.dbf")
tbl.fetch_first()
while .NOT. tbl.fetch_eof()
tbl.change_begin()
tbl.Picture = image_filename_encode(VAR->location)
tbl.change_end()
end while
tbl.close()
--------------------------------------------------------------------------


P.S.: tbl.Picture is a jpeg field (if i open the "product" table and i right-click on the Picture field, i can select "import image" from the menu and select the picture to import).
tbl.PictureLocation is a character field (the full path of each picture as "C:\pic\pic01.jpg").

King Regards
MAURO

[ITALIA]

Re: Importing Images

Hello everyone...
I've been investigating on this problem so far and i found something that could be very helpful. Taken from Alpha5 user guide:


Alpha Five lets you add images to your database in two ways.

Bitmap and JPEG Image fields - store Windows Bitmap (.BMP) or JPEG (.JPG) images in the database. The images are stored in .FPT memo files.

Image File Reference fields - store the paths and filenames of Windows Bitmap (.BMP) or JPEG (.JPG) images in the database, while the images are stored independently in Windows folders. For many applications this is a more efficient way of storing images, and it can result in much smaller databases.


I think i have to change structure to my table "product" and in detail i have to change the field "Picture" from JPEG field as it's now to "Image File Reference field".
I'm pretty sure this has to be done.

I'll keep investigating on it and i'll post a possible solution as soon as possible.

Thanks to everyone that replies to this.

Regards
MAURO

[ITALIA]

Re: Importing Images

Hey Guys i finally found a solution to the problem.

There's a function on the events under "FIELDS" category called "Set Image File Name in Linked Image Field". That is exactly what i was looking for.

I simply set that function for all the items in the table and i get the path from the "PictureLocation" field.

Now when i select an Item, its Picture is correctly displayed.

STAN thanks for your reply.


King Regards
MAURO TRENTINI