Questions tagged [csv]
Comma Separated Values is a tabular to store data
80
questions
1
vote
1
answer
59
views
SQL Server Management Studio 2019 save to CSV and then import it after test
I'm fairly new to SQL, and I'd like to do some quick testing.
I'm about to update a field in 81 records in a table. After each test, I'd like to get back where I started. I've saved off my query ...
1
vote
0
answers
218
views
Ansible export to csv
I want to get a csv with a list of new updates in this form:
testvm-001.localdomain,ImageMagick-6.9.11.27-4.el7
testvm-001.localdomain,ImageMagick-libs-6.9.11.27-4.el7
I have a code that will display ...
2
votes
2
answers
243
views
Best way to filter output by date range
I need to filter a row of a csv file by a date.
The file is structured as so:
[email protected] active 01/24/11 10:04 07/23/23 16:56
...
0
votes
1
answer
204
views
Have List of user but I want to find out if they are added to specific ADGroupMember
I have been trying to understand how to import my csv file and export of specific adgroup they are added or even they are not added
Import-CSV " C:\Users\user.csv" | ForEach-Object { Get-...
0
votes
1
answer
85
views
RegEx passed by CSV file not working in PowerShell
Hi I have a script trying to pull out the price value from a html file. the Regex works when I assign it in the script but when I put the regex in CSV, it refuses to give me the result. Could someone ...
0
votes
1
answer
2k
views
NXLog unable to read complete .csv file
I try to work out why NXLog can't read the complete .csf file witch has the same name but gets edited every 12 hours by windows for a export.
conf file of NXLog:
#define ROOT C:\Program Files\nxlog
...
0
votes
3
answers
4k
views
Is there a way to export all AWS Security Groups to CSV? moreover, is there a recommended way of keeping track of SR changes?
We have a relatively small dev environment in AWS with about 50 Security groups with multiple permission entries. is there a recommended way of keeping track of SR changes, Access, etc?
My manager ...
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
...
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 ...
0
votes
1
answer
32
views
Recomendations for Data Transfer between heterogeneous sources/destinations
I apologize if this is not the right forum for this kind of question.
We need to transfer data between DB Servers (MySQL, MSSQL), CSV files, API Sources (Web Services), etc. and we are looking into a ...
2
votes
1
answer
4k
views
MaxMind GeoIP CSV to .dat
I need to put local IP addresses into MaxMind GeoIP DB.
I've downloaded the CSV and adding new IP addresses and locations is easy.
I've found two tools that do csv to dat for MaxMind GeoIP but I can't ...
0
votes
1
answer
87
views
How to extract the Table Definitions of a MYSQL Table into CSV?
The output of mysqldump -not csv does not contain the columns, just values:
select * from AUDIT_RESULT
INTO OUTFILE '/va/tmp/audit_nresult.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES ...
1
vote
1
answer
745
views
Issues with converting JSON to CSV with nested values
So far I have had no problems converting standard JSON to CSV with jq in the past. But now my data becomes complicated.
Major base tags are account and subaccount. All other values are variables. The ...
0
votes
0
answers
143
views
Issues with Bash Script to SSH and Copy String Variables from a CSV to a remote file
Here is my script
#!/bin/bash
clear
PSQLSTART="INSERT INTO TABLE (Name, Description, Field3, Field4, Field5, Field6, Field7, Field8, Field9, Field10, Field11, Field12, Field13, Field14, Field15,...
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
0
answers
535
views
Upload 300MB or more CSV file to GCP storage bucket
I am trying to upload a 3GB CSV file to Google Cloud Storage Bucket but every time I try it only processing 295.5MB and uploads 295.5MB. Why is this? I have set my bucket size limit to 15GB.
2
votes
2
answers
40k
views
Powershell read from CSV set variables
I have a csv file with two columns "Path" and "Owner".
I've created the below script and it can read from the CSV file, but when I attempt to assign the variables from the csv it ...
0
votes
1
answer
10k
views
Assign group permissions on folders using Powershell via CSV
we are working on a new Permission Concept.
We created different Security Groups,depending on the Department.
For example:
Finance_List, Finance_Read, Finance_ReadWrite
Controlling_List, ...
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 ...
2
votes
3
answers
7k
views
reading a csv file in powershell , header line having duplicates
I have a script I am trying to read a csv file with and assign column names to the data. however the files has multiple columns named the same see below Grade QA/QC and Symbol
ID,Date,Water Level / ...
0
votes
1
answer
2k
views
Unable to read CSV file from browser instead it's downloading from S3?
I am storing some CSV files on S3 and I make them public to access it over browser but whenever I try to access S3 URL for the CSV it's getting downloaded. I already setup headers with Content-Type to ...
-1
votes
1
answer
1k
views
linux mysql convert .sql.tar.gz to csv
I have a .sql.tar.gz file tht ws generated by mysql export
is there any command in linux to convert this sql.tar.gz file to csv?
Thanks
0
votes
1
answer
765
views
CSVDE group import where users are added from sAMAccountname
I am looking to do a CSVDE import onto my server 2008 r2 DC. I have set up the csv correctly and can import users and have users added to the group from the import, all as expected. I then found that ...
1
vote
2
answers
3k
views
Task Scheduler -- how to expand /export the "Show Active tasks" window -- Windows server Enterprise Edition 2007:
For the Task Scheduler -- how to expand the "Show Active tasks" window -- This is for Windows server Enterprise Edition (release date: 2007).
Is there a way to export the data to a .csv file or ...
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 ...
0
votes
1
answer
967
views
Powershell script Import Users from CSV, add to group, with Success/Fail logs
I am attempting to create a powershell script to maintain users. Current environment. Office365 with ADFS, AD and on premise exchange server 2010. All integrated together. For the current problem, I ...
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
0
answers
101
views
How can I reset password and email it using a CSV?
In a nutshell, I have a CSV file with First name, Last name, and personal Email. I would like to use this file to rest the users passwords and then send them an email with their login information.
I ...
0
votes
0
answers
26
views
How to capture tables with different structure from web
I have thousands of web pages(need login with username and passwords) like https://XXX.incometax.XXX/Preview/ViewDetail?TIN_INFO_NO=11935# where only last four digits(11935 for this example) changes ...
2
votes
3
answers
17k
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
1
answer
1k
views
Extract data from multiple XMLs and generate CSV report - Powershell
I have few connectionstrings which are xml files. I need to generate a CSV report using all these connectionstrings with the following output:
Below is my PS script which works fine for 1 file and ...
0
votes
1
answer
728
views
Use for [$i] variable to create csv columns - Powershell
I am trying to grab information from the connectionstrings.config file and populate it to a CSV. I have the following script so far:
$Filename = "C:\new.config"
[xml]$config = Get-Content $fileName
$...
0
votes
1
answer
141
views
Export object location from CSV
I need to export the object location of servers from a list. I have tried using the following script, but it only checks the mentioned OU, how can I search the entire domain and export the canonical ...
3
votes
1
answer
921
views
PowerShell Exporting to CSV / Workflow?
When the server is ping'd the resulting address is compared to an inventory for purposes of keeping the inventory up to date.
I'm trying to tack on the result as "good" or "bad" in the next ...
1
vote
0
answers
3k
views
How to import data from CSV file to LDAP directory and keeping them up to date
lets say I have CSV file in format
userID;login;firstName;lastName;validUntil
Is here any easy way how to import data from this CSV to LDAP directory and how keeping LDAP up to date based on CSV (...
3
votes
1
answer
2k
views
import list of pcs using import-Csv and change attribute using powershell script
Im trying to write a powershell script to change attribute called "comment" in a list of pcs using csv and import-Csv.
Here is my script
$computers=Import-Csv -Path "C:\sds.csv"
foreach ($...
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 ...
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
1
answer
5k
views
System.Object[] instead of the actual path
The script below does not produce the path to the files in question, in my CSV file. Instead it is giving me System.Object[]. Please advise as to what I am doing wrong here.
My goal is to clean up ...
-3
votes
2
answers
300
views
User Group membership script not working [closed]
Any idea why below code is not working ?
Trying to export username then the groups on to a csv. I just need the group names only.
Please help - many thanks
$users = (Get-Content users.txt)
...
1
vote
3
answers
32k
views
Get-ADUser in foreach loop returns nothing if using object
$users = Get-Content "C:\PowerShellScript\CSV\swyxusers.csv"
$test = Foreach ($user in $users){
Get-ADUser -Filter {Name -like "*$user*" } | Select-Object SamAccountName, Enabled
}
$test| export-...
1
vote
1
answer
1k
views
regexes in sed: matching a character that is not preceded or followed by a specific other character
Assume a wrongly formatted csv snippet using semicolons as field terminator:
abc;d" "e"f;"ijk"
According to RFC4180 a dquote inside a field should be represented by two dquotes:
abc;d"" ""e""f;"ijk"...
0
votes
3
answers
1k
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
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 ...
1
vote
1
answer
59
views
Strange e-mail behavior in powershell
I'm adding a new powershell piece into my user creation, which is to e-mail their supervisor with an alert that they have been created. However, for some reason, it sends the credentials to the next ...
2
votes
2
answers
1k
views
Powershell Scripts works for 10 months, suddenly stops working
When I create my new users every week, I execute this powershell scripts I put together. It has been working like a charm for 10 months, but as of last week started throwing this strange error:
...
2
votes
2
answers
2k
views
Powershell script to Inventory File Types
I have been writing a script to inventory drives by specific file types. (AVI, MPG, MP3, etc....)
I can get the base script to work using only a set drive and extension, but I would really like to ...
0
votes
1
answer
3k
views
rsyslog convert json to text on the fly
I have application logging events in JSON format for later structured queries, etc. Now I have a task to log the same messages in plain text (CSV probably) and I really don't want to log each event ...
1
vote
2
answers
4k
views
csv import mysql null
I have to import some csv-formatted data into a mysql (mariadb) database. There is no csv header and the lines look like this:
00323acd-7909-41a4-a849-073ca3391dcf,2014-05,\N
00323acd-7909-41a4-...