Where are Images Stored

Epicor ERP 10
1

What table are images stored in?

I want to get the file path or the binary file to display on an internal webpage.

part-image
part-image.jpg1132×707 115 KB

I see they are on [Erp].Image but that doesn’t have a path or a binary blob of the file.

2

The Blob is stored in “FileStore” table. You have to custom code the conversion back to an image but that’s where the Blob is.

3

Would anyone happen to know how Ice.FileStore is joined to Erp.Image?

I think I figured it out.
Here is the SQL:

    SELECT p.PartNum, p.ImageFileName, p.ImageID, 
    	   i.*,
    	   fs.*       	   

    FROM [dbo].Part AS p

    INNER JOIN [erp].[Image] AS i
    ON (p.Company = i.Company AND 
        p.ImageID = i.ImageID)

    LEFT JOIN [Ice].[FileStore] AS fs
    ON (fs.Company = i.Company AND      
    	 fs.SysRowID = i.ImageSysRowID )

    WHERE p.PartNum = '56-044128-000'
4

You got it that’s the link. Thumbnail SysRow does the same thing hits a different record in FileStore

1 Like
5

Just in case anyone is wondering how you can change the BLOB into an image for output on a webpage you can do something like below.

This is PHP Code:

$row = sqlsrv_fetch_array($row);
echo "<img src='data:image/jpeg;base64," . base64_encode( $row['Content'] ) . "' alt='" . $row['ImageFileName'] . "' />";
2 Likes