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,308
questions
0
votes
1
answer
17
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
9
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
44
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
33
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
37
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
92
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
56
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
11
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
65
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
42
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
68
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
38
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 = [...
-1
votes
0
answers
34
views
POST and GET API calls in PowerShell
I've written a PowerShell script to import a csv file of data, convert each row into a JSON payload and make a post call to
the script successfully gets the CSV data, maps it and posts it. but what I ...
- 11