Skip to main content
368 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
64 views

I'm migrating data from PostgreSQL into Solr. In PostgreSQL my priority dates are stored as two dates and I want them indexed in Solr as a single pipe-separated string: 2017-07-17 | 2018-02-20 I tried ...
Linux's user avatar
  • 37
0 votes
1 answer
110 views

I have a macro that I'm trying to use to pull .csv data from a bookmarkable link into an Excel sheet. I've managed to get it to pull and paste the correct data. however it doesn't format correctly and ...
Benjamin Calvert's user avatar
  • 11
0 votes
0 answers
201 views

I am working with a large dataset stored in Google BigQuery and need to load a table exceeding 10GB into Power BI Premium. The table changes entirely every day, so a full daily refresh of the entire ...
Przemyslaw Remin's user avatar
  • 7,088
1 vote
0 answers
71 views

I'm working on a project where I need to sync content between production and local development environments in Strapi. My approach involves exporting data from production to JSON and then importing it ...
Alon Emanuel's user avatar
  • 184
0 votes
1 answer
1k views

I have a database backup of around 450MBs. I want to restore the database to Amazon Lightsail managed database with 2vCPU and 1 GB ram. I also have enabled Data Migration Import Mode to not get any ...
Rehan Shakeel's user avatar
  • 1
0 votes
0 answers
69 views

Each of my tab delimited text files has 1 column of data I want (well 2, but baby steps). I want to select the file to import, have that 1 column of data paste into my spreadsheet (into the cell I ...
Nick's user avatar
  • 61
0 votes
1 answer
216 views

I am facing issue while importing the data in azure sql database using bcp utility. bcp dbo.Account in "D:ABC\Account.csv" -S xxxxx.database.windows.net -U jfsa -P xxxxxx -d dbname -a 4096 -...
Vijai Maurya's user avatar
  • 129
2 votes
0 answers
257 views

I have a FTIR data set that has wavenumber in column 1 and all of the sample intensity / absorbance values in the other columns. Looks like this > FTIR<- read.csv(file="FTIR_20190328_test....
snschmid's user avatar
  • 21
0 votes
0 answers
62 views

The challenge i am facing here is that the name i used to save my dataframe cannot be found in the environment thereby making it difficult to see the column names of my dataset. this is the code am ...
Chinonyerem Okwunakwe's user avatar
  • 1
0 votes
0 answers
249 views

I am getting this error while importing a dataset approximately 1.5 million rows from mongodb to powerbi through sql connector. I have used the same connection of other tasks, so the connection is ...
Muhammad Afaq's user avatar
  • 1
1 vote
0 answers
21 views

I've been trying to create a list based on a reference file but I can't make it work. I have a .txt file that has a format like this: Vert 007, Horiz 002 Vert 007, Horiz 004 Vert 005, Horiz 006 Vert ...
Shahriar Rashvand's user avatar
  • 11
0 votes
1 answer
2k views

I am constantly facing this issue when importing .csv files into the database. I am getting the following error: Unhandled exception: 'ascii' codec can't decode byte 0xc3 in position 1022: ordinal not ...
Tereza Pávková's user avatar
  • 1
1 vote
0 answers
63 views

I'm writing a data import pipeline to train a model in tensorflow which requires that examples from three different datasets (consisting of image and label) are yielded together but kept separate, in ...
leocrsp's user avatar
  • 21
0 votes
0 answers
330 views

I'm trying to import 4 different Excel documents with Power Query in Excel. So I'm using the formula at the end of the post. To give you context I have a survey for 8 cities so I'm trying to create ...
user avatar
0 votes
2 answers
93 views

I want to show only the month and year in The input field of HTML (mm-yyyy (07-2022)). Month Should be Number. I am using HTML, CSS, JavaScript, and react. I am trying on React Project.
Jabed H Tusar's user avatar
  • 11
2 votes
1 answer
1k views

I'm trying to transfer an HSQL database into a MySQL one, whose structure is already created, and all is transfered well excepted blobs, which are purely ignored. Yet I can export complete tables (...
scoulou's user avatar
  • 47
0 votes
0 answers
2k views

I have received a data file for PostgreSQL but I work on MySQL Workbench 8.0 CE. The file format is TAR archive but I don't know how to import in on MySQL Workbench. I read online that I have to get ...
SkrtSkrt Yeet's user avatar
  • 1
0 votes
1 answer
122 views

I'm trying to load a climate .csv file into R. All the data appears in the first column. There are no error message but everything I tried doesn't work. Here's what I've tried : rouyn2005 <- read....
Christophe's user avatar
  • 25
0 votes
1 answer
215 views

I am looking for a way to modify my excel file to import my vendors for my product templates via name. The problem is I have to seperate multiple names in excel so Odoo can recognize it as one name. ...
for-loop's user avatar
  • 57
0 votes
0 answers
343 views

I have following table CREATE TABLE TEST ( C_ID NUMBER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, C_NUMBER NUMBER NOT NULL, C_TEXT VARCHAR(6) NOT NULL, C_DATE DATE NOT NULL ) and CSV ...
swirkens's user avatar
  • 31
0 votes
0 answers
122 views

I have many excel sheets that I need to remove the second sheet before importing them. All files are .xlsx type in one folder and have same format. What kind of function should I use to achieve such? ...
Alex L's user avatar
  • 1
0 votes
2 answers
259 views

I face the following problem: test_vector <- c('https://data.sec.gov/submissions/CIK0000789019.json', 'https://data.sec.gov/submissions/CIK0001652044.json', 'https://data.sec.gov/...
Philipp Schulz's user avatar
  • 195
1 vote
0 answers
133 views

I am new to IBM maximo, I tried searching for documentation to integrate by IoT data available in my database server with asset management module of IBM maximo. There are data import and REST API ...
HRMS Admin's user avatar
  • 93
1 vote
0 answers
104 views

I'm attempting to scrape data from spoilers for the new Pokemon Legends: Arceus game, and have run into a complication concerning images contained within the tables. The tables of interest are ...
watermelon_diet's user avatar
  • 21
1 vote
1 answer
565 views

I have a text file with header lines above the table and below the table is a blank line and then a table with summary statistics for the table. Handling the header lines is easy as most of the ...
GregDoesMath's user avatar
  • 49
1 vote
1 answer
2k views

I have tried inserting using itertuples but my file is too big. I even split the file in 4 different files even then its too big. one-fourth file takes more than 30 minutes. Is there a easier and ...
tp_'s user avatar
  • 17
0 votes
0 answers
152 views

I'm currently taking this R course on DataCamp ("Quantitative Risk Management in R") where there are two datasets with the same name but contain different values. They're both named "DJ&...
ruruu127's user avatar
  • 1
0 votes
0 answers
193 views

here is my model below var mongoose = require('mongoose'); var Schema = mongoose.Schema; var productSchema = new Schema({ name: { type: String }, description: { type: String }, price: { type: Number },...
Taiwo Olapade's user avatar
  • 11
0 votes
0 answers
3k views

I am importing a CSV file to Mysql Workbench. The data have 5 fields: ID, Product, Type, Date, Revenue. The Date and Revenue fields are recorded as numbers in CSV. However, When I import the data ...
SylviaS's user avatar
  • 1
0 votes
1 answer
2k views

I'm working on a problem where I need to merge two datasets. The first dataset is from SQL and imported using the RODBC library, while the second dataset is imported from Excel. I want to merge the ...
Christoffer Nielsen-jasa's user avatar
  • 5
0 votes
0 answers
351 views

I am new to learning python and it is an exciting language. I have successfully learned to import .csv file from an internet URL into my python. However, I am having no luck in doing so for an .xlsm (...
Lin Yu's user avatar
  • 1
2 votes
0 answers
1k views

I'm trying to import data into GA4. I've done it successfully but it turns that my timestamps were wrong, so it shows my data as it occurred today (even though the is data from multiple months). I've ...
Roee Alfasi's user avatar
  • 21
0 votes
0 answers
172 views

I'm running a POST to a 3rd party API in R and the data don't look properly formatted. I'm trying to figure out how to convert the results to a data frame. I'm wondering if maybe I'm not using the ...
Jarvis's user avatar
  • 31
0 votes
1 answer
359 views

I have one data frame containing the patient_id's matched with the names of the patients. Each patient has his/her own data file FirstNameLastName.csv. In order to anonymize the data I wrote the ...
user879156's user avatar
  • 43
1 vote
1 answer
1k views

I've been pushing CSV data into snowflake using a PUT command to stage the file and then COPY INTO to get the contents into the target table: snowsql -c myConnection -q 'PUT file://C:\\MyData.csv @~/...
Bob Tway's user avatar
  • 9,693
1 vote
1 answer
503 views

Good afternoon , Assume we have the following function : data_preprocessing<-function(link,drop_last_column=TRUE){ link=as.character(link) DT <- data.table::fread(link, ...
Tou Mou's user avatar
  • 1,274
0 votes
0 answers
129 views

a newbe here. I'm writing an essay in Rmarkdown and I want to render a PDF. When I try to import an excel sheet with the commands: dat1 <- read.xlsx("Seminararbeit.xlsx", 2L) and then ...
HPahls's user avatar
  • 1
0 votes
1 answer
653 views

I'm importing an array of JSON documents, like the following: { "_id": { "$oid": "6092e24247f3024d478902c2" }, "startSearch": "2021-05-05T18:20:...
Nosnetrom's user avatar
  • 171
0 votes
1 answer
1k views

The link is: http://www.b3.com.br/pt_br/produtos-e-servicos/negociacao/renda-variavel/fundos-de-investimentos/fii/fiis-listados/ I have to click in the "Exportar lista completa de Fundos em CSV&...
Zwirtes's user avatar
  • 1
0 votes
1 answer
504 views

I want to upload data into Google cloudsql instance from csv file stored on GCS bucket. I am using postgresql database and to import csv files using gcloud sql import csv command in my shell script. ...
CrimeMasterGogo's user avatar
  • 1
0 votes
1 answer
53 views

The error below is prompted when I attempt to load dataset into GraphDB using Preload tool. Does it mean that GraphDB does not allow empty URI? Can this error be skipped and the data loading can be ...
user.tan's user avatar
  • 1
0 votes
1 answer
319 views

What I'm attempting to do is simple: Given an excel dataset and user defined inputs, open the associated excel file, pull the associated information for the user inputted information and save this ...
aaron's user avatar
  • 81
0 votes
2 answers
1k views

I am connecting an API and everything is going fine, now I have one problem, I have a data excel list like this: Name Secondname Age alex test 2020-02-03 pieter guy 2020-04-04 in my script i have a ...
Marnix Bolier's user avatar
  • 67
0 votes
1 answer
59 views

I'm quite new to MS Access. I just set up a new Access database to be used with our schematics tool. Our tool can access the database, so this works fine. At the end of our schematics capturing ...
Georg 's user avatar
  • 27
3 votes
2 answers
1k views

I am importing rims from an csv file to a webshop project. nothing for sell, just a personal project for learning how importers work. I am trying to map my $EANColumn variable to the first row field ...
user avatar
-3 votes
1 answer
294 views

I'm trying to import data from MS Access to SQL Server, this process used to work, today I'm not able to import the data. When I try to import the data with the SQL Server Import and export wizard ...
Sergio's user avatar
  • 43
0 votes
2 answers
3k views

I have been using django-import-export library to upload my data as excel to the Django model and it has been working fine till i had to Upload an excel with 20,000 rows and it just took infinite time ...
Joe's user avatar
  • 13
0 votes
1 answer
308 views

I've been having issues with parsing data into MATLAB from a text file. The text file has discontinuities between its strings (it has spaces), and it seems like every time I tried to import the data ...
bonie10's user avatar
  • 41
0 votes
1 answer
171 views

Error: Invalid Object Name 'Tabelle1$' I am trying to reference to Tabelle1 as a worksheet. As I am new to vba I don't understand why the script can't recognize it, or what I have to do so that it ...
Torben Krügel's user avatar
  • 1
2 votes
0 answers
188 views

I wanna create nested entity with DataImportHandler. I use Solr 8.6, Postgress 12, openjdk-11. My config (schema.xml) looks like this: <schema name="products" version="1.5"> ...
Andrey Sapronov's user avatar
  • 21

1
2 3 4 5
…
8