Questions tagged [csv]

Comma Separated Values is a tabular to store data

Filter by
Sorted by
Tagged with
2 votes
2 answers
535 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 ...
SeanKilleen's user avatar
  • 1,113
2 votes
3 answers
17k 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 ...
q9f's user avatar
  • 640
6 votes
1 answer
17k 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: ...
9point6's user avatar
  • 175
0 votes
1 answer
80 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 ...
Alan Doolan's user avatar
4 votes
2 answers
4k 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 ...
Sequenzia's user avatar
  • 191
15 votes
5 answers
31k 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 ...
Martin Taleski's user avatar
2 votes
2 answers
195 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 ...
user avatar
1 vote
1 answer
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($_) } ...
David Munoz's user avatar
3 votes
1 answer
637 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 ...
Jeff's user avatar
  • 1,089
1 vote
2 answers
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 ...
Mutahir's user avatar
  • 2,357
50 votes
5 answers
125k 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 ...
grape's user avatar
  • 501
9 votes
9 answers
10k views

How to store 3 million records in key value format?

We have to store basic information about 3 million products. Currently the info is one 180 mb CSV which gets updated quarterly. There will be about 30,000 queries per day, but the queries are just a ...
Phil's user avatar
  • 105
2 votes
5 answers
14k views

Counting number of items in a single-row CSV file?

I have a file containing a long comma-delimited list of numbers, like this: 2,8,42,75,101 What's the simplest command (from a Unix shell) to get the count of numbers in this file? In the example ...
An̲̳̳drew's user avatar
  • 1,275
0 votes
1 answer
553 views

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? ...
adib's user avatar
  • 101
0 votes
1 answer
3k views

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 ...
harald's user avatar
  • 403
1 vote
5 answers
19k views

Missing something when adding AD users with powershell

I'm going round in circles and hoping someone can point me in the right direction... I have created a .csv file as follows SamAccountName,Name,GivenName,Surname,DisplayName,Type,Path,Logon Name,...
Fred's user avatar
  • 11
0 votes
2 answers
2k views

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

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 ...
Aszurom's user avatar
  • 463
7 votes
2 answers
5k views

Import a 260GB csv file into MySQL

I have a really big csv ~260GB and I want to import it into MySQL. I use the following mysql script in MacOS DROP TABLE IF EXISTS tmp_catpath_5; create table tmp_catpath_5( a1 BIGINT(20),...
jimkont's user avatar
  • 173
5 votes
4 answers
17k views

MS SQL Server 2008: How to export all the tables into CSV?

I have to migrate from MS SQL Server and now creating a new ORACLE database with the data partially got from my old tables. For that I need to get the data from dozens of tables as unicode CSV or TXT ...
Andrew's user avatar
  • 321
0 votes
4 answers
2k views

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's user avatar
  • 132
4 votes
2 answers
12k views

export proper csv from SqlServer management studio query result

in SqlServer management studio, you can export query results to a csv file by right click -> "Save Results as" -> csv. However, the csv file does not contain column headers and does not escape any ...
Gabe Moothart's user avatar
1 vote
3 answers
11k views

Getting Windows EventViewer CSV file from Command-line

EventViewer in Windows has the ability to export a log to a CSV file. I would like to automatically make a backup of that log in that format (as has been done manually in the past few years). It's a ...
User1's user avatar
  • 2,556
5 votes
1 answer
5k views

Loading large CSV into Postgres

I'm trying to load a CSV of about 100M records (around 8GB on disk) into Postgres via the copy command: copy mytable from 'path/to/myfile.csv' with CSV; I have been monitoring the progress by checking ...
G__'s user avatar
  • 314
0 votes
1 answer
5k views

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 ...
Jak's user avatar
  • 3
0 votes
2 answers
5k views

SQL Passing a List<int> 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 ...
KellCOMnet's user avatar
29 votes
3 answers
30k views

How does one list warnings from the 'mysqlimport' utility?

To start off, this is not about loading data from within MySQL itself, but using the command-line tool "mysqlimport". I am using it to load a CSV directly into a table and need to see the warnings ...
brink's user avatar
  • 293
1 vote
3 answers
1k views

SELECT from inline CSV values in MS SQL

I occasionally get one-off requests to modify some data, and the request comes with some values in CSV. Is there a way I can treat arbitrary CSV as a table or row source quickly and easily, even as ...
Chris Wenham's user avatar
4 votes
9 answers
65k views

Convert a CSV file to a XLS file on the linux command line? [closed]

I'm using Debian Linux and I want to convert a CSV file to an Excel XLS Spreadsheet file. The catdoc package includes the xls2csv command that converts from XLS to CSV. However it doesn't do the ...
Amandasaurus's user avatar
  • 32.3k
1 vote
1 answer
4k views

Powershell - Generate CSV of all locally attched printers on all PC's in a domain

Need a little help finishing off my first Powershell scriptlet... I would like to create a single CSV file of all the XP PC's on my AD domain (approx 3,000) and record all the printers attached. ...
Guy's user avatar
  • 2,678
3 votes
5 answers
2k views

Filter fields with space character from csv file on command line

A csv file with multiple records is delimited by |. field1|field2|field3|field4|field5 I want to check if field3 is blank or contains "space" characters only. If it is blank or space, the whole ...
Michael Ellick Ang's user avatar

1
2