Comma Separated Values is a tabular to store data
1
vote
2answers
85 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 ...
0
votes
1answer
78 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 ...
2
votes
1answer
243 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
50 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 ...
2
votes
2answers
465 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 ...
0
votes
0answers
63 views
Azure Table Storage bulk import app? [closed]
Is there a (preferably threaded) app for doing bulk imports to Windows Azure Table Storage which does the inserts in batches and has automatic retry, going from CSV or XML? TableXplorer seems to do ...
0
votes
1answer
459 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 ...
0
votes
0answers
113 views
PHP MySQL script - sometimes it works well, sometimes the connection resets
I have a PHP script that queries a MySQL table and exports to .csv. Pretty basic stuff. About 1000 row table.
The problem I'm having is that sometimes it will work instantly (download the .csv), ...
2
votes
2answers
105 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
401 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($_) }
...
0
votes
1answer
106 views
Django Dynamic File Name [closed]
A beginner Django guy here, I am looking to change my csv export file name to be dynamic hopefully naming the file with the date it was generated.
My current code is
response['Content-Disposition'] ...
1
vote
1answer
130 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
675 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 ...
2
votes
3answers
3k views
How Export Result of MySQL Query on PHPMyAdmin 3.4.3?
1) I've got a 30K row table.
2) When I run a long, 50-line query on that table, a GROUP function reduces the number of rows to 7K.
3) I want to export the grouped 7K rows as a new table, or save them ...
9
votes
9answers
3k 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 ...
0
votes
5answers
1k 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
1answer
113 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
1answer
483 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 ...
0
votes
2answers
734 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 ...
0
votes
2answers
496 views
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 ...
4
votes
2answers
512 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 ...
2
votes
3answers
7k 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
4answers
321 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?
1
vote
2answers
4k 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 ...
2
votes
3answers
2k views
Linux terminal-based CSV or TSV editor - command-line Calc?
I'm trying to find a command line editor (or vim plugin) for large CSV or TSV files that will fix the width of cells and keep the row and column headers in view so I can move between cells and edit ...
1
vote
3answers
2k 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 ...
1
vote
1answer
602 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
1answer
2k 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
1answer
632 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 ...
3
votes
3answers
5k 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
3answers
687 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 ...
1
vote
5answers
12k views
Convert a CSV file to a XLS file on the linux command line?
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
1answer
2k 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. ...
