Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [csv]

Comma Separated Values is a tabular to store data

Comma Separated Values is a tabular to store data in plain text. There is no single CSV format, but in general there are 4 principles:

  • are plain text files (basically, this means numeric, graphical, or other values are expressed using printable characters rather than various-sized groups of bits),
  • consists of records (typically one per line),
  • with the records divided into fields that are separated by delimiters (typically a single reserved character such as comma or TAB, or sometimes any sequence of spaces and tabs),
  • where every record includes exactly the same sequence of fields (this is very occasionally violated).

Source: wikipedia

80 questions
1
vote
1 answer

SQL Server Management Studio 2019 save to CSV and then import it after test

I'm fairly new to SQL, and I'd like to do some quick testing. I'm about to update a field in 81 records in a table. After each test, I'd like to get back where I started. I've saved off my query results to a CSV. I haven't been able to find how…
Mighty
  • 111
  • 2
1
vote
0 answers

Ansible export to csv

I want to get a csv with a list of new updates in this form: testvm-001.localdomain,ImageMagick-6.9.11.27-4.el7 testvm-001.localdomain,ImageMagick-libs-6.9.11.27-4.el7 I have a code that will display a list of updates, but I don’t know how to save…
rk3dnp
  • 21
  • 3
1
vote
1 answer

Issues with converting JSON to CSV with nested values

So far I have had no problems converting standard JSON to CSV with jq in the past. But now my data becomes complicated. Major base tags are account and subaccount. All other values are variables. The entry year got variable values and changed by…
safect
  • 13
  • 5
0
votes
1 answer

Unable to read CSV file from browser instead it's downloading from S3?

I am storing some CSV files on S3 and I make them public to access it over browser but whenever I try to access S3 URL for the CSV it's getting downloaded. I already setup headers with Content-Type to text/csv.
satya
  • 21
  • 3
0
votes
1 answer

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, Controlling_Read, Controlling_ReadWrite Planning_List,…
Phil9431
  • 3
  • 1
  • 3
0
votes
1 answer

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 the master file from which my csv is included has…
Gareth Palmer
  • 1
  • 1
0
votes
1 answer

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 am trying to import a list of users from a csv,…
Clay Thompson
  • 1
0
votes
0 answers

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 had to populate a bunch of users before "going…
T. Leaf
  • 1
0
votes
0 answers

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 for each url. Each url retrives tax information…
Learner
  • 101
  • 4
0
votes
1 answer

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 gives me the desired output. I have been playing…
user3421341
  • 33
  • 1
  • 1
  • 8
0
votes
1 answer

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 $CSCount =…
user3421341
  • 33
  • 1
  • 1
  • 8
0
votes
1 answer

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 name of the object to a CSV. Get-ADObject -Filter…
JJJJNR
  • 870
  • 6
  • 20
  • 32
0
votes
1 answer

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 twice in both formats. Is it possible to convert…
stimur
  • 894
  • 6
  • 11
0
votes
2 answers

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 there is just one row of information. What…
Jim
  • 17
  • 3
  • 6
0
votes
1 answer

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 define ROOT C:\Program Files (x86)\nxlog Moduledir…
Alex
  • 1
  • 2
1 2 3
4
5 6