Questions tagged [csv]
Comma Separated Values is a tabular to store data
80
questions
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 ...
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 ...
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:
...
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 ...
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 ...
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 ...
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 ...
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($_) }
...
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 ...
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 ...
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
...
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 ...
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 ...
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?
...
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 ...
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,...
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 ...
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),...
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 ...
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?
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...