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
0
votes
1 answer

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 redundant GPO's. I need to search the xml files…
NobleMan
  • 225
  • 3
  • 10
0
votes
1 answer

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 download a dozen; I can provide part of the file…
Registered User
  • 27
  • 2
  • 5
0
votes
1 answer

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 requirement is to repeat the header row twice in my…
Mark
  • 217
  • 3
  • 11
0
votes
3 answers

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 { udp(ip(0.0.0.0) port(514)); }; template test { …
tejerka
  • 21
  • 2
0
votes
1 answer

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 displayed in a graphic way for customers and…
Alan Doolan
  • 3
  • 2
0
votes
1 answer

Does Oracle DB has a tool like DTS Wizard in SQL Server?

Is there a tool like the Microsoft SQL Server's DTS (Data Transformation Services) Wizard that simplifies the process of ad-hoc importing of flat files (CSV, TSV, or XLS) to Oracle database? Preferably free ones or the ones that are licensed…
adib
  • 101
  • 2
0
votes
1 answer

mysqlimport and "duplicate entry" error

I've used mysqlimport for MyISAM tables a lot in the past, without any problems. But now i want to import data into a InnoDB table and are facing the following problem: mysqlimport reports the following error and won't import anything: mysqlimport:…
harald
  • 403
  • 2
  • 6
  • 19
0
votes
2 answers

Looking for app to work fluidly with CSV data in graph form

It often occurs to me that if I had a good tool for viewing CSV data in graphical format, and comparing two sets of numbers to each other, I could do a great deal of meaningful trend watching and data interpretation. For example, perfmon can output…
Aszurom
  • 463
  • 2
  • 8
  • 19
0
votes
4 answers

Writing all running services to a .csv file with WS2003

I want to list all the current running services and output it to a .csv file. Does anyone know how to do this?
Kraffs
  • 132
  • 7
0
votes
1 answer

Exporting data from Lotus Notes databases

I'm looking for a tool, hopefully low cost or free, to help me export Lotus Notes databases (not Lotus Notes mail files!) to any kind of format. CSV/Excel etc.. I also need to be able to extract attachments in the database. They're all Word…
Jak
  • 3
  • 1
  • 2
0
votes
2 answers

SQL Passing a List as a SqlCommand Parameter

can i pass a List into a SqlCommand as a paramter? DELETE FROM MyTable WHERE Key IN @MyParam command.Parameters.AddValue("MyParam",MyList); i realize i could just loop over the list but i was looking for a cleaner solution.
KellCOMnet
  • 245
  • 2
  • 11
0
votes
1 answer

Have List of user but I want to find out if they are added to specific ADGroupMember

I have been trying to understand how to import my csv file and export of specific adgroup they are added or even they are not added Import-CSV " C:\Users\user.csv" | ForEach-Object { Get-ADGroupMember $_. sAMAcountName -Properties * |Select…
K0n2113
  • 11
  • 1
0
votes
1 answer

RegEx passed by CSV file not working in PowerShell

Hi I have a script trying to pull out the price value from a html file. the Regex works when I assign it in the script but when I put the regex in CSV, it refuses to give me the result. Could someone help with this? $htmlcontent = Get-Content…
Cliff
  • 3
  • 2
0
votes
1 answer

Recomendations for Data Transfer between heterogeneous sources/destinations

I apologize if this is not the right forum for this kind of question. We need to transfer data between DB Servers (MySQL, MSSQL), CSV files, API Sources (Web Services), etc. and we are looking into a program/source that can do that for us.…
Daniel
  • 101
0
votes
3 answers

Is there a way to export all AWS Security Groups to CSV? moreover, is there a recommended way of keeping track of SR changes?

We have a relatively small dev environment in AWS with about 50 Security groups with multiple permission entries. is there a recommended way of keeping track of SR changes, Access, etc? My manager dont want to use AWS config (Price wise), so the…
Moshe Harel
  • 1
  • 1
  • 1
1 2 3 4
5
6