Questions tagged [csv]

CSV is an acronym for Comma-Separated Values and is a file extension over a text file.

0
votes
0answers
10 views

Web Form with unique ID to CSV

I have a big question, I just joined a project for work about sharepoint. They threw me in there with knowing that I dont have any SharePoint knowledge. I dont want to let my first project down so i'...
0
votes
2answers
34 views

Exporting a list to csv from a custom page

I have a custom page created to allow users to be able to select their own parameters to filter items in a list using web-parts (with help from SharePoint designer 2013). This filtered list needs to ...
1
vote
0answers
32 views

CSV bulk file migration; additional columns for meta data

Similar to this post I have a number of local files, with associated metadata in an Excel sheet, that I would like to migrate to SharePoint. With inspiration from Microsofts own article on bulk CSV ...
0
votes
1answer
55 views

Extracting SharePoint data on daily basis

I want to export my SharePoint document library data on daily basis and csv file need to be save as naming convention as "Dataname_yyyyMMdd". As per my below script, it need to export data from the ...
1
vote
2answers
393 views

extract data from SharePoint document library to CSV using powershell

i am trying extract data of SharePoint document library to CSV file using powershell. I am getting data correct on CSv file. But one column i.e "Description" have more text data on it.So when run the ...
0
votes
1answer
192 views

import terms with other labels (synonyms) from CSV file using powershell

I have a CSV file with ~2000 terms and other labels (synonyms). There are some scripts online that do this however they show an error when they hit a term that doesn't have any other labels. Any ideas ...
0
votes
1answer
339 views

Sharepoint 2016 Powershell Script to export all fields to csv - including Created and Modified Fields

I am attempting to dump all data from my Sharepoint Lists to csv. I seem to have the code working at about 95% the way I want it, but I am missing the Created By, Created On, Modified By, and ...
3
votes
1answer
1k views

Using Powershell to update an Office 365 List with lookup column

I am wondering if anyone has seen an issue when updating an Office 365 list that contains a lookup column? I have 2 Lists in my SharePoint Online site, the first List is my lookup list that maps ...
0
votes
1answer
45 views

SharePoint 2016 Managed Navigation Import CSV Parameter Mapping

I am interested in importing my managed navigation information from an existing site into another sharepoint site (we are creating environments for testing and production, so we want them to mirror ...
1
vote
1answer
495 views

SharePoint - Powershell - Export Rich Text content to CSV

Below is my code to export rich text content to a .CSV file. The content comes from a SharePoint list. I am using CAML to fetch the content and adding it to $Content. This code exports the data but ...
0
votes
1answer
416 views

Error Importing CSV list into Office 365 Sharepoint

I'm trying to add a list to the Office 365 SharePoint application by importing a CSV. After selecting my range of cells and starting the import, I am thrown this error: cannot connect to the server ...
2
votes
1answer
54 views

Update (not add) List Item with PowerShell

I have managed to work a PS Script that added circa 9k items from a CSV file. After working some parsing issues with date/time, People fields etc. It's finally worked and all 9k items now sit on the ...
1
vote
1answer
465 views

Export sharepoint list with lookup values using powershell

I need to export the SharePoint list in CSV format for which I am using following code. It works fine except the "Project Name" Field which gives "microsoft.sharepoint.client.fieldlookupvalue" output ...
1
vote
1answer
1k views

Create and update list items from csv file

I have below scripts to import a CSV file into SharePoint list. I found the scripts from this link https://www.linkedin.com/pulse/auto-sync-external-data-native-sharepoint-list-lukasz-latynski i made ...
2
votes
0answers
200 views

How to get metadata term by tag when creating this document set

i got this code, what this does, is that it takes a .csv file, and converts into json(used papaparce.js to convert csv into json) and with that data i create and populate a new document set fields, my ...
1
vote
2answers
2k views

Auto-Sync CSV file into SharePoint list?

Is it possible to auto-sync a CSV File with a SharePoint Online List without needing to create an automated PowerShell script (or something similar)? For example, I have a People.csv in my C: . Is it ...
0
votes
1answer
363 views

Bulk upload documents and apply metadata from CSV

I have a weekly export in CSV format that contains employee information from another system. I would like to loop through the CSV and upload X number of documents to a permanent document library on a ...
1
vote
1answer
1k views

Export SharePoint Libraries to CSV via jQuery

I have a requirement to allow users to export data into a csv file from a few different document libraries. The data will be a select number of columns and filtered based on if the document is new or ...
1
vote
0answers
32 views

CSV object as parameter

Description I have written a PowerShell script that loops for all the documents and folders in a web application. The script write specific information about those documents and folders into a ...
1
vote
1answer
40 views

I am having a Database or csv file and i have to export that to SharePoint Document Library can it be achieved by Powershell

Is there any automated way to create SharePoint Document Library with the data's present in Database or CSV files. In that DB Table there is one column as link with Documents in it , will have to ...
2
votes
1answer
2k views

Exporting ALL fields and contents in a List to .CSV in Powershell

So I've been trying for the past 4 days now to write a full automated Powershell script that will connect to SharePoint Online, automatically login with credentials (with password located in a file), ...
1
vote
1answer
53 views

Generateing a public csv file on sharepoint (will be downloaded by a linux server)

Last year we made a solution for a customers website (on a linuxserver). They also have a sharepointserver, where they update some numbers daily in an excel sheet, and use a macro to generate a public ...
0
votes
0answers
112 views

SharePoint Online: Can't open a CSV File

SharePoint Online with Office 2013 A user was working on a spreadsheet, which was accidently saved as a CSV. We can't see it in SharePoint either in the browser or via Explorer view but it shows ...
1
vote
0answers
48 views

How to Make Lotus Notes Items Display In InfoPath

I'm taking on a task from someone else and I'm trying to understand how this was done. The old contractor took data from Lotus Notes ranging from MT No 803-809 (there are thousands of items and I'm ...
1
vote
1answer
426 views

Automated process for using .csv to create a chart/graph then embed to SharePoint site

Disclaimer: First, I am a student worker that has limited experience with coding. I am not sure how much of this process can be solved this way. Second, I recently started using SharePoint so I'm ...
0
votes
1answer
61 views

Export to CSV and format in a table

I am using this code but I would like to view in a table and export as a CSV but all my attempts have failed. Where does the code go? $siteUrl = "URL" $site = Get-SPSite $siteUrl $site.RootWeb....
3
votes
3answers
6k views

Add multiple users, groups and groups permission from *csv file to SharePoint 2013 using powershell

I am looking for script to add multiple users and multiple groups to SharePoint 2013. I have CSV file with cointains two columns with header "user" login and "group" name with are separated by (;) as ...
2
votes
1answer
1k views

how to export in csv format instead of .iqy

By default export to spreadsheet showing owssvr.iqy , we need to have owssvr.csv Please help.
1
vote
0answers
92 views

How to return only one user and date for Created By and Created Date column using PowerShell

I have a script that outputs to CSV all items and files from Libraries and Lists in a Site shown below: Add-PSSnapin microsoft.sharepoint.powershell $excludeLists = @("Master Page Gallery", ...
0
votes
1answer
40 views

Export to CSV on custom application results in that nothing works on the page anymore

i have a simple custom application which fetches records from a lists by a caml query and through an export button the user is able to get a csv file with the data. Generally the export works fine. ...
0
votes
4answers
2k views

Display Correct Modified By and Modified times and dates using Powershell

I have a script that outputs to CSV all items from all Lists and all files from all Libraries below: function Get-DocInventory([string]$siteUrl) { #$site = New-Object Microsoft.SharePoint.SPSite $...
1
vote
1answer
729 views

List Item Name not populating - PowerShell

I have a PowerShell script that outputs to a CSV file all items from all Lists and all files from all Document Libraries in a Site shown below: function Get-DocInventory([string]$siteUrl) { $web = ...
2
votes
1answer
8k views

How to export list to csv using PowerShell

I have a Powershell script that outputs data from all libraries in a site shown below: Add-PSSnapin Microsoft.sharepoint.powershell $url = "http://contoso.com" $site = New-Object Microsoft....
0
votes
1answer
1k views

How to output all previous versions of a file using Powershell

I have a script that displays multiple columns and outputs to CSV file below: Add-PSSnapin Microsoft.sharepoint.powershell $url = "http://contoso.com" $site = New-Object Microsoft.SharePoint.SPSite($...
0
votes
1answer
40 views

Powershell script duplicating files and displaying incorrect URL of the file's location

I have a powershell script that display a list of files that are checked out all users in a site and exports the output as a csv file: Add-PSSnapin Microsoft.Sharepoint.Powershell $url = "contoso....
0
votes
0answers
67 views

How to email csv file to Owners group using powershell

I have a script that exports data to a csv file listed below: $url = "http://portal.contoso.com" $site = New-Object Microsoft.SharePoint.SPSite($url) $web = $site.OpenWeb() $list = $web.Lists ...
2
votes
2answers
3k views

How to save a list in a csv file via Powershell

I have a SharePoint online list with more than 9000 items and 22 column. The list is being populated on daily basis. I am taking backup manually every morning by saving the list as excel file in the ...
2
votes
2answers
3k views

There is already a term with the same default label and parent term

I am using SP2013 on-premise standard edition and we tried to update the user profile with a PowerShell script. Unfortately, part of profiles cannot be updated. The exception is "There is already a ...
0
votes
3answers
217 views

How can I include site admins in a csv list of site collections?

I'm building a PowerShell script to export a list of all the site collections in a particular web application. So far I have this: Get-SpWebApplication http://www.contoso.com | Get-SPSite -Limit All ...
0
votes
1answer
266 views

How to export sharepoint management scripts' result to csv/text file

[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint”) > $null function EnumerateUserRolesPermissions ([string]$webURL){ $site = new-object Microsoft.SharePoint.SPSite($webURL) ...
0
votes
1answer
2k views

Simple Powershell script to import TermSet file into Group

I am looking for simple powerhell script to import termSet .csv file into TermGroup. What will be the simple script to accomplish this?
0
votes
1answer
36 views

How do I edit an Imported List?

I've imported an CSV file as a list to SharePoint. I need to update the links in the list now since the links in file mapped to another CMS. How can I edit this list now that it's in SharePoint? ...
0
votes
1answer
17 views

Foreach not recognizing close

I am trying to add items to a list from a CSV script. I have imported the code and established the variables and even test to ensure that the SP information is accurate. The following code does not ...
1
vote
1answer
28k views

Powershell - get a list of all the document libraries for a web application including content types - output to csv

I have following code and it works great. However, business unit now wants to see content types for each document library. Most document libraries come with Document and Folder content types. Now, ...
2
votes
1answer
1k views

Import-csv command to read a CSV from Document Library is giving error

I am trying to read a CSV file from a SharePoint 2013 Document Library. I am using following Powershell command for this. Import-csv "\\ServerName\sites\SiteName\MyDocumentLibrary\MyCSVFile.csv" ...
0
votes
1answer
289 views

Importing 5002 users into SharePoint Online with a work email

I need to create a test to prove that the 5000 list item limit can be exceeded. More specifically Users. I have en Excel spreadsheet that contains 5002 users. I don't need the trivial data to be ...
0
votes
1answer
67 views

Possible to start workflow when item added to network folder?

I am new to Sharepoint, but because I have development experience I am the 'Sharepoint Guy'. Sorry to all the professionals that I am giving a bad name, I am working on it - I swear! We have a ...
0
votes
0answers
656 views

Import/refresh automatically a CSV file ? Powershell or not?

I have to import a CSV file into a list (put it in a tab). But this CSV will be updated (weel, in fact it will be regenerated), and I need SharePoint to refresh the list with new data. I don't know ...
0
votes
1answer
159 views

Faster way of Downloading Metadata in CSV

we Have document library with 3lacs+ items. we have to download metadata of each file in a csv such as Modified date , modified By etc. I used powershell code for achieving this task but for some ...
3
votes
3answers
1k views

Slow CSV writing for huge document libraries in powershell

by using below PowerShell script, i get all the items list from the document library including sub folders hierarchy in a CSV file. This script works very fine for small data but for huge data like ...