[sklett]

I’m trying to figure out how I can get the image associated with a product (storedisplayimage) and it looks like this isn’t supported.

Can anyone confirm if this is the case? Is there some other view where you can access images and file cabinet assets?

Thanks,

Steve
This is a cached copy. Click here to see the original post.

[sklett]

RE: Accessing images and File Cabinet assets

Enhancement 134721 – Item/File Cabinet > Expose Item Display Image in binary format (or URL if binary is not possible)

[Luke]

RE: Accessing images and File Cabinet assets

The enhancement has very few details. All images in the file cabinet are accesible via a URL that is exposed on the image record. Can you be more specific about what you need to do?

[sklett]

RE: Accessing images and File Cabinet assets

I haven’t reviewed the ER and didn’t write it, so I’m not sure what it says.

Originally posted by Luke

Can you be more specific about what you need to do?

Yes. I would like to access the images for an inventory item. I don’t know how they are stored on the backed (BLOB, FS, etc) but I need to get the images somehow. If there was a MediaItem view and the Items View had an FK into that MediaItems view I could probably achieve what I want. If it’s only a URL and I can’t get the encoded binary data that’s fine, I can initiate an HTTPRequest and get the image that way. I just need something.

I’ve reviewed the record guide PDF and didn’t see anything that looked like it was possible to get data on File Cabinet items or images associated with an inventory item. Am I missing something?

Hope that clears things up.

-Steve

[Luke]

RE: Accessing images and File Cabinet assets

I think I’m misunderstanding. The 2 images that you select on the store tab within the item record only allow you to use images that are already in your file cabinet. Locate the files in the file cabinet, click the edit link, and there should be a URL field that displays the path to the image.

Do you need them as a way to display item images in your NetSuite web store?

[sklett]

RE: Accessing images and File Cabinet assets

No, I need to get the images through the ODBC connector. I’m using ODBC in an integration environment, to fill the gaps in Web Services.

Maybe an example would be more clear:

Code:
SELECT i.Name, mi.url, mi.filename, mi.file_size FROM Items AS i
LEFT JOIN MediItem AS mi ON mi.item_id = i.store_image_id;
I just want need to programatically get to the image data.

Imagine if you were developing a desktop application and you wanted to display a list of items with their respective images pulled from NetSuite – you would need what I need

I know I can access URLs and all that from the UI but I’m not working within the UI, I’m working from a custom application that needs to query this data from the DB.

Is that a better explanation?

[Luke]

RE: Accessing images and File Cabinet assets

Makes perfect sense now. ODBC was the key I was missing.

The join you wrote in your last example is exactly what I would imagine. Let me consult my ODBC guru and get back to you tomorrow.

[sklett]

RE: Accessing images and File Cabinet assets

Sorry for the confusion, I thought this was the ODBC forum, I didn’t realize there were enterprise reporting topics not related to ODBC.

My bad! (I can’t believe I just used that phrase… it’s late)

[Luke]

RE: Accessing images and File Cabinet assets

Actually it was my bad. I was looking through a bunch of posts and not just in a particular forum. I should have looked closer. Apologies.

[Luke]

RE: Accessing images and File Cabinet assets

It turns out we don’t currently expose the mediaItem table/view in ERV or ODBC. I couldn’t find an enhancement request for this so I entered one. You can now vote for enhancement 135014.

[shanondink]

RE: Accessing images and File Cabinet assets

I voted for both of these enhancement requests.

Right now, the only way I’ve found is to manually do an Item Image Search which exposes the External URL of the images. Then pull that into excel and create commands to download the images to my offline web server.

Would like the field exposed via 2 methods:

1. ODBC on the Items table.

2. SuiteScript via XML query of an Item.

If this is put in a separate table/view/XML query, make sure to expose the “Last Modified Date” so we can track changes instead of having to pull the entire list of data

Regards,

Shanon

[ducktrevor]

RE: Accessing images and File Cabinet assets

Hello All,

Maybe this is the wrong place for this question but it looks like the closest thread to my issue.

Is it possible to pull the store Display Thumbnail URL so that I can create a custom template that looks like this:

<img src="” alt=”” title=””>

instead of pulling letting NetSuite write out the image tag using

Basically what I am trying to do is access the Meta Tag info I have stored on each item record to put in the Alt tag of each image when displayed in the store.

Is this possible?

Any help would be appreciated.

Thanks You,

Trevor

Corso’s Cookies

http://www.corsoscookies.com

trevor@corsoscookies.com

[Author]

Posts