Skip to main content
380 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
103 views

Need some help with I have a csv file provided by my client, which contains the export of products from an internal database connected to an invoicing software. But some fields are in json. This is an ...
Jorge Santos's user avatar
  • 9
0 votes
0 answers
66 views

I have large CSV files with stock values and I have successfully added these to my MariaDB database using the "LOAD DATA INFILE" command: LOAD DATA LOCAL INFILE '/mnt/HD/HD_b2/Public2/...
Jimmy Westberg's user avatar
  • 215
0 votes
1 answer
135 views

I am trying to import data from a CSV file that is stored in a Bucket. The CSV file uses the "|" delimiter. I would like to import these data to a MySQL database on Cloud SQL. However, I ...
user avatar
0 votes
0 answers
493 views

I am using myworkbench 8.0 to import data to MySql 8.0.32 from a 16G csv file. I get "Error Code: 5. Out of memory (Needed 784334881 bytes)". Machine spec: Win 10, 8Gb ram. CSV is | ...
Tshif's user avatar
  • 1
0 votes
1 answer
483 views

Wanted to know the tool which can extract data in csv from a table or by executing a sql query like select * from table 1 inner join table 2 on ... Data is currently in oracle database and required ...
umang's user avatar
  • 25
0 votes
1 answer
206 views

While importing or exporting to a CSV file, I see that python rounds off value but only for certain rows/columns whereas the other data is kept intact. Not sure why this is happening for certain rows/...
aseb's user avatar
  • 27
1 vote
0 answers
246 views

I am trying to load a csv into a data frame using pandas.read_csv. My data has a column of cell ids that are 18 digits long, and then other columns with other data. Sometimes there is an empty entry, ...
Sweta's user avatar
  • 11
0 votes
0 answers
69 views

I'm running VB 2019, trying to import a CSV file into an Access database using this code: Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + My....
user3516774's user avatar
  • 29
0 votes
1 answer
217 views

I am trying to get some data from a csv file having more than than 3 million rows. I've set an ADODB connection to my csv file and everything works fine except for querying date columns. Here is how I ...
Oğuzhan Orhan's user avatar
  • 3
-1 votes
2 answers
649 views

I have created a csv file with two columns - the subject and the modules. and i want to print out all the modules for the same subject the csv file looks like this csvfile currently my code looks like:...
Humaira's user avatar
  • 1
1 vote
1 answer
793 views

I need to get the values from my csv file and for this I need to set the seperator to ';' and the values are in '"'. If I try it like this: final CSVReader reader = new CSVReader(new ...
Phil's user avatar
  • 37
3 votes
1 answer
2k views

This was part of another question (Reading URLs from .csv and appending scrape results below previous with Python, BeautifulSoup, Pandas ) which was generously answered by @HedgeHog and contributed to ...
Michael Wiz's user avatar
  • 173
-1 votes
2 answers
547 views

I am working on a project that has a function that allows users to import a file (Excel or CSV) to DB (MsSQL). I have read tutorials on the internet and followed them, but the problem is one of my ...
Nguyen Dinh Khanh's user avatar
  • 1
1 vote
2 answers
3k views

I don't know where it is wrong, right in my code, please help I already wasted lot of my time... THANK YOU _/\_ admin.py from import_export import resources from import_export.admin import ...
Naveen Sargam's user avatar
  • 17
0 votes
2 answers
55 views

My code is as follow The output is null, I should use while loop as you see, but somewhere in my code is not working properly. and I'm not able to use any other library I need an hours array and rate ...
Alex Jey's user avatar
  • 1
0 votes
1 answer
1k views

I have a csv file that has header called CompanyName. In the csv there are tons of rows and different company names. But I keep a text file with specific companies whose data I need to retrieve. ...
Milan Patel's user avatar
  • 43
2 votes
2 answers
2k views

I am trying to import this CSV file: HEADER "{ ""field1"": ""123"", ""field2"": ""456"" }" "{ "...
maxime.b28's user avatar
  • 61
1 vote
2 answers
3k views

Very new to Python here. I am trying to read a file from a folder, but without knowing its full name. For example AAA_05212021.csv is the file name located in C:\test\ AAA is the known part of the ...
Trainee 's user avatar
  • 13
2 votes
1 answer
6k views

I have a CSV file that looks like below In my SSIS package (Visual Studio 2017), I create a Flat File connection Text qualifer: " Header Row Delimiter: {LF} Header Rows to skip: 0 Column ...
faujong's user avatar
  • 1,179
0 votes
0 answers
158 views

I'm trying to import data through files and below code works fine with csv files but, when I upload a zip file it uploads some garbage value into database. Can you please help me with this. Thank you! ...
Rushi's user avatar
  • 25
-1 votes
2 answers
37 views

I would like to get the if "172" in statement to identify the addresses with 172 in them. Thinking I must have syntax wrong on "if "172" in {row["IP_ADDRESS_ZLOC"]}:...
zero_point_zero's user avatar
  • 1
0 votes
1 answer
913 views

I'm new to VBA and therefore need some help. I'm trying to import data from a CSV file using a method where I can chose the csv of a list using the following piece of code: Private Sub ...
jjj's user avatar
  • 35
1 vote
0 answers
913 views

I have a CSV file filename.csv with the following content: UID;Datum;Klasse;SendungsNr 6177;14.08.20;624;00340434299338038179 6178;14.08.20;624;00340434299338038186 6179;14.08.20;624;...
Albin's user avatar
  • 1,147
0 votes
0 answers
315 views

I have two tables. one is user-table -name - user and another table named profile. The format of csv file for user is like this: first_name,last_name,username,email,phone,user_role,status,...
Joshi's user avatar
  • 2,800
0 votes
1 answer
667 views

Trying to Store GTIN numbers in WordPress Database via WooCommerce CSV Import In Excel I created my CSV in which there is a column called meta:wpseo_global_identifier_values Through excel formulas I ...
Matt's user avatar
  • 1

1
2 3 4 5
…
8