Stack Overflow
Stack Overflow

Questions tagged [importdata]

24 questions
2
votes
1 answer

How to Import/Edit Data on GUI without SQL

I am new to Python and would like to implement a simple Employee Management System (as shown on the attached photo) that do the following functionality • A GUI for entering, viewing, and exporting employee data. (I have done this task) • The ability…
Neamah
  • 57
  • 5
1
vote
0 answers

Quota/limitations on importrange() and importdata() in Google Sheets?

I have one main Google Sheet that computers an approximately 10 column x 30 row worksheet. I have roughly 400 "client" Google Sheets (separate files) that pull that 10 x 30 worksheet in to use for data validation. Working in a school environment,…
Seth Battis
  • 106
  • 8
1
vote
1 answer

Extract date and numbers in google sheet from steam price history

I have this link with a lot of info: https://steamcommunity.com/market/pricehistory/?currency=1&appid=570&market_hash_name=Exalted%20Fractal%20Horns%20of%20Inner%20Abysm I want to extract all the data of each date and put in a list divided in date,…
Jean Lock
  • 13
  • 3
1
vote
1 answer

How to copy data from a tab daily to another tab and add rows

At the moment we get requests from people to send them an e-mail with a travel deal they found on our website. We do this on a daily basis. We get the export in csv format (we download it to Google Sheets via =importdata). Every day at 5 AM the data…
Sami Chouchane
  • 195
  • 1
  • 11
1
vote
1 answer

TypeError: 'type' object is not subscriptable during reading data

I'm pretty new importing data and I´m trying to make def that reads in the presented order. The error is in the fuction, not in the data. def read_eos(filename: str, order: dict[str, int] = {"density": 0, "pressure": 1, "energy_density": 2}): …
SANTIAGO
  • 13
  • 1
  • 3
0
votes
0 answers

advanced query function follow up a data

I have a Google sheets where i’m using a simple query function to import data from another Google sheets (SPREADSHEET 01) SPREADSHEET 01 contains: Column A Column B Column C Column D NAME 01 PRODUCT 01 CITY 01 ✓ NAME 02 PRODUCT 02 CITY…
bilal mosbah
  • 1
  • 1
0
votes
1 answer

Google Spreadsheets IMPORTDATA imports "date" from CSV file as integer instead of "date"

I have an URL to a CSV file which I would like to import to google spreadsheets. I am using IMPORTDATA function : =IMPORTDATA(B21) You can see the doc in here: spreadsheed link My csv file looks like…
fascynacja
  • 1,625
  • 4
  • 17
  • 35
0
votes
1 answer

MATLAB how do I get data from a csv in Matlab on Linux? xlsread and importdata

I have a script that analyzes data from a csv using xlsread but I need to run the script on Linux, and I am currently using Windows10, so xlsread does not work. I have tried to use the 'basic' parameter, but that does not work. data =…
mkpappu
  • 358
  • 1
  • 3
  • 16
0
votes
0 answers

matlab importdata produces strange output if there are blank cells in a txt file

I want to import thef following txt file in matlab. Run Local Local Local Local First-order Index exitflag f(x) # iter F-count optimality 1 -10 14 2 …
Simon
  • 325
  • 1
  • 6
0
votes
1 answer

What is correct format/syntax of timestamp in offline event data in google analytics 4

I have some data from CRM and I wanna use Offline Event Data in Data Import of GA 4 to insert CRM's "offline data". In CSV files that I imported multiple times, All things are good, but although no error found, "timestamp_micros" of events did not…
Saeed Navayi
  • 1
  • 1
0
votes
1 answer

How to Update Data mysql database by uploading excel file in PHPExcel Codeigniter3

i read many import excel for insert data in Mysql Database, but i don't find reference how to update data by uploading excel file. So, How to update data in mysql DB when i import data excel file ? Example : In DB Table A…
Nings
  • 1
  • 5
0
votes
1 answer

How can i extract a json object to googlesheets?

I would like to extract an object result of a json url to google sheets. Pls find the code that i use to import json data to google sheet: https://github.com/bradjasper/ImportJSON However, it extracts the data as a table. Is there a way to extract…
Serhat
  • 23
  • 5
0
votes
1 answer

Import data from steam price history

I have this link with a lot of info: https://steamcommunity.com/market/pricehistory/?currency=1&appid=570&market_hash_name=Exalted%20Fractal%20Horns%20of%20Inner%20Abysm I want to import all the data to a google sheet I am using IMPORTDATA Function…
Jean Lock
  • 13
  • 3
0
votes
1 answer

Bulk Import Derby error SYSCS_IMPORT_DATA CHARACTERDELIMITER must be CHAR(1)

Hi I trying to import txt values file into derby database using CALL SYSCS_UTIL.SYSCS_IMPORT_DATA. Each value column is delimited by ; and the line of values is delimited by LF Line Feed. 111142501;283811110;01111000;28111004;EXPO[LF] In my java…
José Pascual Gimeno Marí
  • 1
  • 3
0
votes
0 answers

Need to get data flowed from power automate excel file to Oracle database in DataGrip

I am asked to make a table in DataGrip with the data from excel spreadsheet file being made and updated in Power Automate. I did not make the flow in Power Automate so I have no experience with this. Here is the current flow in Power Automate. As…
Ryan Watterson
  • 1
  • 1
1
2