Tag Info

Hot answers tagged

3

Create SPQuery object and set its Folder property and then call GetItems on List and finally loop through the item collection. $spQuery = New-Object Microsoft.SharePoint.SPQuery $spQuery.Folder = $folder; $items = $list.GetItems($spQuery);


2

You can also setup a basic SSRS report to list all the columns you want, then set a subscription on it to export it as a CSV file (to a doc library or network share) on a scheduled basis. Iterating by loop of any object as per your script will always get slower with the increasing volume of objects.


2

Add the following to DOCICON.XML (default location is C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML) <Mapping Key="csv" Value="icxltx.png" OpenControl=""/> Then in IIS Manager select the server and then select MIME Types, update the entry for csv to 'application/vnd.ms-excel'. This will allow you to click the ...


1

Just to understand correctly, do you want to use the CSV file to provide metadata for the files that will be imported from the file share? If so, the approach depicted in the article (SPJeff) will not work. This sample uses a SP list as destination (as opposed to a SP library which is needed to support files). Look at this article in Code Project ...


1

In the lack of more details concerning the possibilities would work for you (e.g. looking at custom development or a no-code solution), i would the easiest is to use the BDC via SharePoint Designer to load from external source according to your schema. The major point here is what possibilities you have: could you bulk-export to some data store accessible by ...


1

Try SPListItem.File.Url to get the the relative url of the file. And SPWeb.Url to get the url of the web and combine them together. In your code use: "Path" = $web.Url + "/" + $_.File.Url The code may look something like this. Note: I have not tested it. But it will give you an idea how to go with your scenario: if((Get-PSSnapin ...


1

I have done the same some months ago. See the following sample: $destination = "C:\\tools\\Folder" $webUrl = "<Url of the specific site>" $listUrl = "<Url of the specific list. This url is complete Url and NOT relative url>" ############################################################## $web = Get-SPWeb -Identity $webUrl $list = ...


1

I found my answer by fooling around with some HttpUtility methods. $Value = &lt;b&gt;Dear {0} Team,&lt;/b&gt;&lt;br/&gt;{1} request was completed &lt;a href='{2}'&gt;{3}&lt;/a&gt;.&lt;br/&gt;&lt;br/&gt;{2}&lt;br/&gt;&lt;br/&gt;To download the PDF of the form please click &lt;a ...


1

make sure that the values are correct for CSV. In your csv file how is is seperated? like so? hello "," blah "," magic "," sweet as you can see between each text is "," or , now looking at your csv format I can see an issue with: Political Geography,"A sample term set",,True,"One of the 7 continents","Continent","Asia" instead ammend it and try: ...


1

Personally, I would use PowerShell. But, if you really must use BCS, look at the samples for creating a custom BSC Connector to XML, XLS, or CSV. There are several out there. Scot Hillier wrote the book and there are samples in there: http://www.amazon.com/Professional-Business-Connectivity-Services-SharePoint/dp/047061790X Once you have the BCS connection ...



Only top voted, non community-wiki answers of a minimum length are eligible