Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [csv]

Comma Separated Values is a tabular to store data

0
votes
1answer
46 views

Assign group permissions on folders using Powershell via CSV

we are working on a new Permission Concept. We created different Security Groups,depending on the Department. For example: Finance_List, Finance_Read, Finance_ReadWrite Controlling_List, ...
-1
votes
1answer
101 views

linux mysql convert .sql.tar.gz to csv

I have a .sql.tar.gz file tht ws generated by mysql export is there any command in linux to convert this sql.tar.gz file to csv? Thanks
1
vote
2answers
578 views

reading a csv file in powershell , header line having duplicates

I have a script I am trying to read a csv file with and assign column names to the data. however the files has multiple columns named the same see below Grade QA/QC and Symbol ID,Date,Water Level / ...
0
votes
0answers
32 views

compression of comma v/s pipe separated files

Comma separated data files takes almost same or slightly more disk space than pipe separated data. But once compressed using gzip the comma separated files are much smaller than pipe separated files. ...
0
votes
1answer
142 views

CSVDE group import where users are added from sAMAccountname

I am looking to do a CSVDE import onto my server 2008 r2 DC. I have set up the csv correctly and can import users and have users added to the group from the import, all as expected. I then found that ...
1
vote
2answers
197 views

Task Scheduler — how to expand /export the “Show Active tasks” window — Windows server Enterprise Edition 2007:

For the Task Scheduler -- how to expand the "Show Active tasks" window -- This is for Windows server Enterprise Edition (release date: 2007). Is there a way to export the data to a .csv file or ...
0
votes
1answer
204 views

Powershell script Import Users from CSV, add to group, with Success/Fail logs

I am attempting to create a powershell script to maintain users. Current environment. Office365 with ADFS, AD and on premise exchange server 2010. All integrated together. For the current problem, I ...
0
votes
0answers
63 views

How can I reset password and email it using a CSV?

In a nutshell, I have a CSV file with First name, Last name, and personal Email. I would like to use this file to rest the users passwords and then send them an email with their login information. I ...
0
votes
0answers
21 views

How to capture tables with different structure from web

I have thousands of web pages(need login with username and passwords) like https://XXX.incometax.XXX/Preview/ViewDetail?TIN_INFO_NO=11935# where only last four digits(11935 for this example) changes ...
0
votes
1answer
196 views

Extract data from multiple XMLs and generate CSV report - Powershell

I have few connectionstrings which are xml files. I need to generate a CSV report using all these connectionstrings with the following output: Below is my PS script which works fine for 1 file and ...
0
votes
1answer
370 views

Use for [$i] variable to create csv columns - Powershell

I am trying to grab information from the connectionstrings.config file and populate it to a CSV. I have the following script so far: $Filename = "C:\new.config" [xml]$config = Get-Content $fileName $...
0
votes
1answer
35 views

Export object location from CSV

I need to export the object location of servers from a list. I have tried using the following script, but it only checks the mentioned OU, how can I search the entire domain and export the canonical ...
3
votes
1answer
492 views

PowerShell Exporting to CSV / Workflow?

When the server is ping'd the resulting address is compared to an inventory for purposes of keeping the inventory up to date. I'm trying to tack on the result as "good" or "bad" in the next ...
1
vote
0answers
1k views

How to import data from CSV file to LDAP directory and keeping them up to date

lets say I have CSV file in format userID;login;firstName;lastName;validUntil Is here any easy way how to import data from this CSV to LDAP directory and how keeping LDAP up to date based on CSV (...
2
votes
1answer
19k views

Powershell read from CSV set variables

I was hoping I could get some guidance. I have a csv file with two columns "Path" and "Owner" I've created the belkow script and it can read from trhe CSV file, but when I attempt to assign the ...
3
votes
1answer
710 views

import list of pcs using import-Csv and change attribute using powershell script

Im trying to write a powershell script to change attribute called "comment" in a list of pcs using csv and import-Csv. Here is my script $computers=Import-Csv -Path "C:\sds.csv" foreach ($...
-3
votes
2answers
129 views

User Group membership script not working [closed]

Any idea why below code is not working ? Trying to export username then the groups on to a csv. I just need the group names only. Please help - many thanks $users = (Get-Content users.txt) ...
1
vote
3answers
13k views

Get-ADUser in foreach loop returns nothing if using object

$users = Get-Content "C:\PowerShellScript\CSV\swyxusers.csv" $test = Foreach ($user in $users){ Get-ADUser -Filter {Name -like "*$user*" } | Select-Object SamAccountName, Enabled } $test| export-...
1
vote
1answer
913 views

regexes in sed: matching a character that is not preceded or followed by a specific other character

Assume a wrongly formatted csv snippet using semicolons as field terminator: abc;d" "e"f;"ijk" According to RFC4180 a dquote inside a field should be represented by two dquotes: abc;d"" ""e""f;"ijk"...
2
votes
1answer
2k views

MaxMind GeoIP CSV to .dat

I need to put local IP addresses into MaxMind GeoIP DB. I've downloaded the CSV and adding new IP addresses and locations is easy. I've found two tools that do csv to dat for MaxMind GeoIP but I can't ...
1
vote
1answer
53 views

Strange e-mail behavior in powershell

I'm adding a new powershell piece into my user creation, which is to e-mail their supervisor with an alert that they have been created. However, for some reason, it sends the credentials to the next ...
2
votes
2answers
503 views

Powershell Scripts works for 10 months, suddenly stops working

When I create my new users every week, I execute this powershell scripts I put together. It has been working like a charm for 10 months, but as of last week started throwing this strange error: ...
2
votes
2answers
960 views

Powershell script to Inventory File Types

I have been writing a script to inventory drives by specific file types. (AVI, MPG, MP3, etc....) I can get the base script to work using only a set drive and extension, but I would really like to ...
0
votes
1answer
1k views

rsyslog convert json to text on the fly

I have application logging events in JSON format for later structured queries, etc. Now I have a task to log the same messages in plain text (CSV probably) and I really don't want to log each event ...
1
vote
2answers
2k views

csv import mysql null

I have to import some csv-formatted data into a mysql (mariadb) database. There is no csv header and the lines look like this: 00323acd-7909-41a4-a849-073ca3391dcf,2014-05,\N 00323acd-7909-41a4-...
0
votes
2answers
3k views

Bulk Update AD Attribues with Employee ID as matched key

I have a CSV file that I need to bulk update AD with. The file has an employeeID, which would match the employeeID field in AD. So far, I've been able to update a user successfully with a CSV file if ...
0
votes
1answer
1k views

NXLog unable to read complete .csv file

I try to work out why NXLog can't read the complete .csf file witch has the same name but gets edited every 12 hours by windows for a export. conf file of NXLog: #define ROOT C:\Program Files\nxlog ...
0
votes
1answer
3k views

System.Object[] instead of the actual path

The script below does not produce the path to the files in question, in my CSV file. Instead it is giving me System.Object[]. Please advise as to what I am doing wrong here. My goal is to clean up ...
0
votes
1answer
5k views

sftp: get file by mtime

Objective: Connect to sftp server with very simple script using -b option, cd to directory and get file with the latest modified time or created time. I can connect and download *.csv but that may ...
2
votes
2answers
3k views

Importing users to AD with CSV, cannot get some fields to work

Been trying to build a CSV file to import users into Active Directory. I can get everything to populate, except for E-mail, Password, and Enabling the user. Just using this cmdlet in Powershell. ...
2
votes
1answer
955 views

Handler mapping on IIS / OWIN /Nancy for a CSV file

I've an issue with IIS and OWIN/Nancy, here is the setup of our server : Windows Server 2012 R2 IIS 8.5 OWIN with Nancy (middleware) ASP.NET 4.5 Application developed in F#. I want to download a ....
2
votes
3answers
11k views

Batch script to export info from Active Directory (name, phone numbers, location, etc) into a csv file

The secretary at my work uses a spreadsheet that lists names, phone numbers, and locations of employees to look up info if someone asks. All this info is located in AD, but the problem is that we are ...
0
votes
1answer
2k views

Repeat the csv header twice without “Append” (PowerShell 1.0)

I have prepared a PowerShell script to export a list of system users in CSV format. The script can output the users list with Export-csv with single header row (the header row at top). However my ...
5
votes
3answers
2k views

How to Split a Huge CSV File in Linux?

I have 60TB of data that resides in 12 csv files. The data will be loaded into a clustered database where the loading processes is single threaded. In order to improve my load performance I need to ...
1
vote
1answer
2k views

Comparing 2 CSV files in powershell exporting difference to another file

I've write this script out, and could have swore I had it giving me a Failed early this morning but now I'm getting nothing and not sure why. Basically I need to compare $SourceAddress with $...
0
votes
1answer
6k views

How to script nagios csv export

nagios 3 can export availability data as csv (clicking through the web gui). Now I would like to do that automated and on a regular basis, so I am looking for a way to set all the parameters (e.g. ...
0
votes
1answer
380 views

Optimal setup for bulk CSV import

We're currently running a Wordpress site but need to import 10,000 - 20,000 posts per day from CSV files. Our current setup is an all-in-one LAMP server with 8GB RAM and 8 Virtual Cores. The import ...
4
votes
1answer
198 views

Powershell script to import CSV to AD

In attempts to automate a few things, I've come across a stumbling block with an import script for AD. A part of the script contains: New-ADUser -Name $Name –GivenName $Person.givenName –Surname $...
0
votes
3answers
1k views

Syslog-ng.conf csv parser lost first columns

I try to split information that come from IIS server with syslog-ng configuration. I create and fill the syslog-ng.conf but my csv parser lost the first column. let see: source s_network { ...
2
votes
2answers
523 views

Server 2012: how to plan for storage failover?

The Stuff I have the following components to work with: two rooms two beefy Dell R510s, one in each room two EMC VNXe storage devices, one in each room. The goal Ensure that if one server room ...
2
votes
3answers
15k views

How to export munin raw data to CSV?

I'm monitoring my Debian GNU/Linux server with Munin monitoring software. I was wondering whether I could export the raw data used to generate Munin charts? I want to do some in-depth statistical ...
5
votes
1answer
14k views

mongoexport csv output array values

I'm using mongoexport to export some collections into CSV files, however when I try to target fields which are members of an array I cannot get it to export correctly. command I'm using: ...
0
votes
1answer
71 views

deal with email attachments

I posted this question already but it was too vague and so was closed so I hope this is a bit better. We have a php based application which reads a csv report that is then added to a database and/or ...
3
votes
2answers
3k views

Performance of Cluster Shared Volume file copy from SAN

I am hoping someone can help me out with a strange issue. We are running a Microsoft Failover Cluster with Server 2008 R2 and an Equallogic PS4000 SAN. Our main configuration has 2 Dell Poweredge ...
9
votes
4answers
15k views

Install ssconvert (part of gnumeric) on a server without GNOME

I need to use gnumeric's file conversion tool ssconvert on a server. The problem is that gnumeric is a gnome application and can't be installed without a desktop installed. There is also no separate ...
2
votes
2answers
186 views

Display nth instance of grepped pattern

So here's my problem. I have an issue with a .csv file (Current.csv) in that there are commas randomly place throughout the data, so awk-ing the file doesn't give me constant column numbers for a ...
1
vote
1answer
2k views

directory listing export to csv

I'm trying to pull the names of files from a directory into a csv file with the following: Get-ChildItem -name | % { [IO.Path]::GetFileNameWithoutExtension($_) } ...
3
votes
1answer
536 views

CSV engine on MySQL server

I don't think that this is a programming question so I am going to ask it here - Reading the book high performance mysql, I read about the CSV engine. The paragraph says: The CSV engine can treat ...
1
vote
2answers
3k views

Export Active Directory Users, Groups, OUs

a) Can I export all users irrespective of there group memberships to a CSV File, for e.g. users.csv ? b) Can I also export all OUs to a CSV, so I can later re-import them into a New DC on a New ...
31
votes
4answers
75k views

How to export result of a MySQL query using phpMyAdmin 3.4.3?

I've got a 30K row table When I run a long, 50-line query on that table, a GROUP function reduces the number of rows to 7K I want to export the grouped 7K rows as a new table, or save them as a CSV ...