Questions tagged [export-to-csv]
A set of techniques to write a CSV (Comma-Separated Values) file from a data source. CSV files store data in plain-text form, allowing great usability and they often are used as a way to exchange data from information systems
export-to-csv
5,311
questions
0
votes
1
answer
37
views
Read/Write pipeline in pandas
I'm building a simple pipeline to pull a dataset from a database and write it to a csv so that I can access the data more quickly in the future.
Currently, I have this:
# data loading as a pipeline
# ...
- 305
0
votes
1
answer
55
views
Export sheet in a workbook to CSV file in the same location every week
I have a sheet in a workbook I would like to export to a csv file that gets updated every week.
So ideally, I want the VBA code to export whatever data is in the sheet and overwrite what was existing ...
- 3
0
votes
0
answers
26
views
Exporting web table (Not a simple plain html table) to excel or csv [closed]
I want to automatically export table from a web page to excel. you can use any method.
The web page I am referring to uses a different kind of coding, which when tried to export the table from usual ...
0
votes
2
answers
42
views
How do I list certificates in personal store across all servers in domain
I need to get a list of all of the certificates in the personal store across all of the servers in my domain. I am currently using the following powershell command which provides the desired results
...
- 23
0
votes
0
answers
13
views
How do I get @variables in a sql query to stay set when I export the query results to cvs from phpmyadmin?
I'm using phpmyadmin.
I have a query like this
set @months := '36';
select bla, bla, bla
From tables
where date = @months;
Runs great from the sql tab. When the results come up I hit export at the ...
- 101
0
votes
0
answers
29
views
Is there a way to prevent the output of http headers from appearing in the content of a csv file?
I'm currently working in a Laravel Project with a Laravel Jetstream scaffolding with Inertia js and Vue 3. Everything is working as expected but now I need to make a downloadable CSV file.
At first I ...
- 48
-1
votes
1
answer
48
views
In a JSP file use a form to call a method in a java file to create and then download a a csv file for the user [duplicate]
Having a hard time figuring out how to get my JSP file to trigger a method in my java while using a form. The method sends a query to a db, I want to take the result set from that query and turn in ...
- 31
0
votes
1
answer
41
views
Trying Export .csv with CSV Helper in a blazer server app hosted on Azure
I have installed CSV Helper on my Blazer Server App running on Azure using .NET8. When I run the app in my environment it exports to my desktop. When I publish the app and its running on Azure, The ...
0
votes
0
answers
15
views
Generate csv template with dropdown list in react
I want my users to be able to download a default spreadsheet file with some fields having drop-down values. I know how to do this with Excel/Google Sheets but I'm unable to do this programmatically ...
-1
votes
0
answers
17
views
How can I show all results of an aspx table on one page or export to csv?
Currently I am manually copying and pasting the results from the following website into a spreadsheet on a daily basis:
https://registers.maryland.gov/RowNetWeb/Estates/frmEstateSearch2.aspx
Obviously,...
- 1
0
votes
0
answers
55
views
JSON conversion error from aws configservice query
I have a problem generating the list of my resources in AWS, and later converting them into CSV using the JQ command, exactly this is the command I am running from the AWS CLI
aws configservice select-...
- 555
0
votes
1
answer
36
views
Wrong column formatting of CSV file output
My code is meant to transform a text file in the format below:
> gene name
gene sequence
to a csv file where in each row, 1 column has a gene name and other has a gene sequence.
However, some of ...
- 33
0
votes
1
answer
47
views
PDF to CSV in as400 [duplicate]
I am trying to convert a PDF report into CSV file.
So currently a query is used to generate the report. To convert into csv, i wrote a CL program and added two commands
RUNQRY and saved the output in ...
0
votes
1
answer
93
views
How to Track Export Actions Per User with WPDataTables Plugin in WordPress?
I'm currently evaluating the WPDataTables plugin for a WordPress project. Specifically, I need to track how many times each user exports data from a table. This functionality is critical for our ...
- 3
0
votes
1
answer
61
views
When Converting excel to csv for empty cells quotes not coming
I'm trying to import excel file to csv format through power shell using this command
import-excel c:\users\xxxx\TestFile.xlsx | export-csv c:\users\xxx\CSVFile.csv -NoTypeInformation -Encoding UTF8
...
- 93
0
votes
1
answer
13
views
Can PieCloudDB export the results of a query to a CSV file?
PostgreSQL can use copy command to achieve it(e.g. Copy (Select * From table) To 'test.csv' With CSV DELIMITER ',' HEADER;). Can PieCloudDB support this feature? Or is there any other method to export ...
- 55
0
votes
0
answers
68
views
Export DBISAM BLOB and TEXT columns
I was recently confronted with the fact that the Borland Database System Utility does not export the TEXT and BLOB columns to a .CSV file.
I searched online, and did not find anything very concrete ...
- 11
0
votes
0
answers
49
views
Create a CSV file by adding double quotes to the column with multiple commas in Power Flow
I have built a power flow which gets a CSV file daily in the service account and the power flow takes it and creates a file in the SharePoint folder. I face an issue when the pipeline I have built on ...
- 31
1
vote
1
answer
77
views
Query list of computers and export DNS servers to CSV
I am trying to query a list of servers and export the DNS servers to a spreadsheet. If I run the following command against one server, I get access denied:
Get-DnsClientServerAddress -CimSession ...
- 45
1
vote
1
answer
39
views
how to display specific array of arrays elements matching pattern
I have the following array, with thoushand json elements, like the following
[
{ ...
- 13
0
votes
0
answers
31
views
Need Powershell query to export database table data from remote datastore using API endpoint and username and password. Need that data into CSV format
# Define credentials and API endpoint
$username = "username"
$password = "password"
$apiUrl = "https://apiurl.com"
# Create the authentication header
$base64AuthInfo = [...
0
votes
1
answer
47
views
Error Creating CSV Data File From A JSON data
I am using Pandas and other libraries to create a timetable csv data file for a game. I am encountering error while running it. Please provide any suggestions on correcting my code.
class ...
- 7
1
vote
1
answer
47
views
How can I extract data from a multipage PDF into a single CSV file using camelot python library?
I've got a PDF file consisting of 4 pages of data. The first 3 pages contain 3 tables with the same columns. After some research I've found a pretty good python lib called camelot-py. Would it be ...
- 31
0
votes
2
answers
67
views
Parse CSV string auto convert to number issue
I am trying to convert JSON data into CSV using papa parse. In my JSON I have a field article id which is a string type but when showing in CSV it automatically converts it into a number which creates ...
0
votes
0
answers
55
views
Using Invoke-sqlcmd occasionally outputs a blank csv file
I'm fairly new to using powershell so bear with me. My goal is to query a database over our network and save the file output of the query as a csv on the local machine. The query works as intended but ...
0
votes
1
answer
41
views
PY - How to extract data from CSV and pasted to other CSV
I was assigned a task to take a data from a CSV file which is an export from a biometric function. What I need to do is to take that data and past it into another CSV file that is sent to the client.
...
0
votes
3
answers
61
views
How can I export an Array[Array[Array[Double]]] into a file in scala?
I have a code that takes too long to calculate an Array[Array[Array[Double]]], but I need the result to calculate something else with different parameters but the same Array[Array[Array[Double]]] so ...
- 1
1
vote
1
answer
41
views
Using jq to parse multilevel json
I'm trying to parse a JSON file that look like this:
[
{
"date":"date1",
"results":
[
{
"field1":"string11",
...
- 23
1
vote
1
answer
56
views
How to write a SQL statement that spools the result of select, replace and order by with custom delimiters to a csv file
I am trying to do exactly what the question says: selecting from a table, replacing special characters from a column, order the result, then spool to a .csv file, with a custom delimiter.
I can only ...
- 199
0
votes
1
answer
61
views
How to insert "meta data" in beginning and end of SQL Query
I'm writing a small SQL query for work to automate some jobs that we regularly do. I have managed to figure out most of it but one thing is bugging me.
I have to generate a CSV file that contains a ...
