Tagged Questions

Comma Separated Values is a tabular to store data

learn more… | top users | synonyms

1
vote
3answers
91 views

Batch script to export info from Active Directory (name, phone numbers, location, etc) into a csv file

The secretary at my work uses a spreadsheet that lists names, phone numbers, and locations of employees to look up info if someone asks. All this info is located in AD, but the problem is that we are ...
0
votes
0answers
13 views

Using Powershell, append a table to an existing Word document [migrated]

I have a Powershell script that reads data from a CSV file to create a table in an existing Word document. It works fine as far as creating the table, but it seems to be deleting the contents of Word ...
0
votes
1answer
71 views

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 ...
4
votes
3answers
252 views

How to Split a Huge CSV File in Linux?

I have 60TB of data that resides in 12 csv files. The data will be loaded into a clustered database where the loading processes is single threaded. In order to improve my load performance I need to ...
1
vote
1answer
716 views

Comparing 2 CSV files in powershell exporting difference to another file

I've write this script out, and could have swore I had it giving me a Failed early this morning but now I'm getting nothing and not sure why. Basically I need to compare $SourceAddress with ...
0
votes
0answers
217 views

Export CSV data from IPERF output to MySQL

I have a multiple clients to single server bidirectional iperf set-up for network monitoring. The iperf server runs good and displays output in CSV format based on the cron jobs written on the client ...
0
votes
1answer
991 views

How to script nagios csv export

nagios 3 can export availability data as csv (clicking through the web gui). Now I would like to do that automated and on a regular basis, so I am looking for a way to set all the parameters (e.g. ...
0
votes
1answer
120 views

Optimal setup for bulk CSV import

We're currently running a Wordpress site but need to import 10,000 - 20,000 posts per day from CSV files. Our current setup is an all-in-one LAMP server with 8GB RAM and 8 Virtual Cores. The import ...
4
votes
1answer
83 views

Powershell script to import CSV to AD

In attempts to automate a few things, I've come across a stumbling block with an import script for AD. A part of the script contains: New-ADUser -Name $Name –GivenName $Person.givenName –Surname ...
-1
votes
2answers
309 views

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 { ...
1
vote
2answers
281 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 ...
1
vote
3answers
4k 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 ...
4
votes
1answer
2k 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
59 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
1k 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 ...
3
votes
2answers
2k 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
2answers
130 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
1k 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($_) } ...
1
vote
1answer
185 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
1k 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 ...
6
votes
3answers
11k 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
5k 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
3k 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
201 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
851 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
2k 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
825 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
1k 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 ...
3
votes
3answers
9k 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
522 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
6k 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 ...
3
votes
3answers
3k 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
4k 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 ...
2
votes
1answer
1k 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
959 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 ...
8
votes
3answers
9k 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
737 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
6answers
21k 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
3k 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. ...
1
vote
4answers
920 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 ...