Questions tagged [import-csv]
Import_Csv is a PowerShell command that creates a custom, table-like object and populates it with data from a CSV file. DO NOT use this tag for generally reading data from a CSV file. Instead, use the [csv] tag or other language-specific related tags
import-csv
332
questions
0
votes
1
answer
26
views
Error when trying to import a CSV file to a live GoogleSheets: "DeprecationWarning: The order of arguments in worksheet.update() has changed"
This is my query:
import gspread
from google.oauth2.service_account import Credentials
import csv
# Path to your service account key file
SERVICE_ACCOUNT_FILE = '/Users/xxx/Desktop/projects/importcsv....
- 21
-2
votes
0
answers
31
views
Having trouble importing Fitbit data table to BigQuery
I am having difficulties in importing the dataset named 'heartrate_seconds_merged.csv' into BigQuery as a new table. I am doing this as part of the data analytics capstone/case study.
I need help to ...
- 1
-1
votes
0
answers
18
views
Error in uploading image url through csv in woocommerce prducts
I was uploading a csv file of products to import and add products in my woocommerce products, it include images url as “url1,url2,url3″… Each url ending with proper file type – .jpg, .png, etc.
In ...
- 1
0
votes
0
answers
13
views
Adding a template to multiple existing sharepoint sites
I have made a code for adding a template to multiple existing SharePoint sites at once with foreach and Import-csv. I think it almost works but I keep getting the same error.
PS C:\WINDOWS\System32>...
- 11
0
votes
0
answers
27
views
Using Import csv and foreach to duplicate template to multiple sharepoint sites
I have a question about SharePoint online. Our project assignment is to make new sites for our client. We want to design a script that makes it easier to use a template and add that to a site. I have ...
- 11
0
votes
0
answers
69
views
All data in one column in CSV file due to formatting of the source file
I receive a CSV file from a colleague that containing sales data. This data I then need to read in to a data table using Powershell.
The format of the file looks like this:
","""&...
-3
votes
1
answer
35
views
Errorno 2 No such file or directyory
Calculyour textating total months - CSV file
Iimportedd csv file correctly. I even received a path after adding csvpath.Trying toocalculatedg the total number of months in the CSVs file, now getting ...
0
votes
0
answers
243
views
How do import .csv files in VS Code using SQL, and analyse the data?
I've got the two csv tables below.
Users:
id
name
1
Bradley
2
Peter
3
Sanjay
Purchases:
id
date
user_id
1
2022-11-01
2
2
2023-10-03
3
3
2023-04-21
NULL
I have them saved as csv files on VS ...
- 15
0
votes
0
answers
148
views
How can I append to the notes field for AD groups in PowerShell from imported CSV file
I am attempting to write a script that will import a list of AD groups, and then update the owner (managed by) field as well as append to the notes field, however, I am not able to make this work. ...
- 1
0
votes
1
answer
268
views
How can I automate the Importing csv to azure board using API in powershell
`I have done automation of backing up azure board work item in csv form to my local using API now I'm trying to restore it back into the azure boards. I'm not getting the proper approach to do that, ...
0
votes
0
answers
26
views
Read a .csv file containing static parameters [duplicate]
I have got a csv file, with equal coumns and unequal rows, I would like to call some static parameters from this CSV which method is the most appropriate?
class Script
{
static void Main()
{
...
- 11
0
votes
0
answers
141
views
AttributeError: 'NoneType' object has no attribute 'update' when trying to add files to a csv file
I've been working on an expense manager in python where you can import you spending from CSV file add more put them in a chart etc then you could export the info into CSV file but then faced this ...
- 11
0
votes
1
answer
61
views
Why is import-csv failing when cmd runs manually? [duplicate]
So I have this very simple script that I am using invoke-command to execute a cmd line on a bunch of remote nodes. The csv has 2 columns, host & stub. The csv has no whitespaces or anything.
...
- 31
0
votes
0
answers
57
views
Need a Column Delimiter in MySQL
I am very new to MySQL. I am trying to load a CSV file into MySQL Table.
load data local infile 'C:/Users/fg/Downloads/test.csv' into table my_schema.my_table
fields terminated by ','
escaped by '&...
0
votes
0
answers
43
views
CSV imports to different sheets based on number of columns
I am trying to import 3 different .CSV files into an automated "Import CSV Sheet" using Google Apps Script. I am trying to modify the "append sheet" to append to a specific sheet ...
