python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - import-csv

Import-csv, column name has multiple lines - how do I access data

I have an excel file I convert to csv, and use this to import the data. For some reason, I can't get the data for the sdk column, maybe because it has a line break in the name. This is what the csv l...
test-img

Michele

powershell

indexing

row

import-csv

Votes: 0

Answers: 0

PowerShell Add AD users to AD group by UPN from CSV

Import-CSV "C:\Temp\jacktest.csv" | Foreach-Object { $aduser = Get-ADUser -Filter "UPN-eq '$($_.UPN)'" if( $aduser ) { Write-Output "Adding user $($aduser.SamAccountNa...
test-img

Jack Brooks

powershell

active-directory

powershell-4.0

import-csv

Votes: 0

Answers: 2

Latest Answer

This answer is meant to help you troubleshoot your issue so we can understand what could be going wrong with your CSV. Note, this code assumes that your CSV is comma delimited and the CSV has a column...
test-img

Santiago Squarzon

Script to get AD logon name from a list of DisplayName

I'm trying to get a list of AD user's logon names from a list of display names using this script. Import-Csv 'C:\temp\displaynames.csv' ForEach-Object { $name = $_.displayname Get-...
test-img

Matt

powershell

import-csv

get-aduser

Votes: 0

Answers: 3

Latest Answer

You could do the following LDAPFilter trick to query all users at once, this should be as efficient as it gets when querying multiple Active Directory users (with the AD Module; [adsi] should be even ...
test-img

Santiago Squarzon

Importing csv file using COPY FROM on Mac

Using the query editor in the pgAdmin4 app, I would like to import data from a csv file into a table. My code is as follows: CREATE DATABASE gps_tracking_db ENCODING = 'UTF8' TEMPLATE = templa...
test-img

Katie Tseng

postgresql

filepath

pgadmin-4

import-csv

postgresql

filepath

pgadmin-4

import-csv

Votes: 0

Answers: 1

Latest Answer

Make sure the file /Users/CDDEP/Downloads⁩/Urbano 2014/⁩tracking_db⁩/data⁩/sensors_data⁩/GSM01438.csv does exists Replace COPY main.gps_data with \COPY main.gps_data to use the client side utility ...
test-img

Gab

Posts

Questions

Blogs

Jobs