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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...