Skip to main content

Add images to items in custom list in Sharepoint 2007

Had a requirement to include images to a custom list (along with single-line and multi-line columns) in Sharepoint 2007 server.
There were around 100 items to be added and wanted to find a work-around than adding as attachments to the respective items.

Created a standard name format for the images Eg Name1, Name2 etc in the harddisk
Created the custom list with the required columns and for image created Hyperlink or Picture column and selected the format for image as Hyperlink.
Create a picture library in the site.
Opened the picture library in Windows explorer and copied the images to the Picture library
The image url now would be http://<siteurl>/<listname>/<imagename.imageformat> for eg - http://xyzsite.com/Piclib/Name1.jpg
With a little of formatting in excel the column with the url's can be created.
Edit the list in datasheetview and copy-paste the url row to Image column, in the list
If required, can change the Image column format to Picture and it would display the image along with the other columns.

More about columns on -
http://office.microsoft.com/en-us/sharepoint-online-enterprise-help/column-types-and-options-HA010302193.aspx#_Toc277248473

Labels:

Comments

Post a Comment

Popular posts from this blog

Cannot open SharePoint 2010 Approval task form from Outlook

When trying to click on Open this task from Outlook 2010, it brings an error - " Outlook cannot open a new form. The form contains schema validation errors" Element '{ http://www.w3.org/1999/xhtml}div ' is unexpected according to the content model of parent element '{ http://schemas.microsoft.com/office/infopath/2009/WSSList/dataFields}Body '. As given in the error message, the issue is with the Body column of the workflow tasks list. For the approval workflow, there would be a tasks list. In the workflow task list, the Body column is Enhance Rich multi-line column. Change the setting to Plain text, instead of enhanced rich text. After that do an iisreset.
7 comments
Read more

How to link to Download a copy option in Office 365/SharePoint 2013

At times it is required to have the option to save a copy of a document uploaded in SharePoint document library, in a page or a webpart. The url to get the save option for a doc is - http:// site /_layouts/download.aspx?SourceUrl= url-of-document-in-library Change the bold text with the actual url, i.e., with the site url and the url to the doc in the doc library. For example, if the site is www.contso.com and the doc "Test" is uploaded in SiteAssets library, the url to save a copy would be - http://contso.com/_layouts/download.aspx?SourceUrl=http://contso.com/SiteAssets/Test.docx
1 comment
Read more

How to embed powerpoint presentation in SharePoint 2013 online

Open the SharePoint Online site and upload the required ppt in Site Assets or any doc library. The ppt can be dragged and dropped to the library also. After the ppt is uploaded, click on the ... next to the ppt and click on Share Under Invite People, enter Everyone and uncheck Require Sign-in and click on Share Again click on ... and then click on guest link in 'Open to anyone with a guest link' Copy the url and open it in the browser. Click on File - Share - Embed Select the required dimension from the preview. Copy and save the code. Open the page where the ppt has to be displayed. Edit the page and click on embed code and paste the code. The ppt would be displayed on the page and the user can view it directly.
Post a Comment
Read more