Get Insert Statement for existing row in MySQL

Using MySQL I can run the query: SHOW CREATE TABLE MyTable; And it will return the create table statement for the specificed table. This is useful if you have a table already created, and want...

magento: bulk delete products via import/export facility?

I'm using import/export advanced profile to import products CSV file. The question is, how do I bulk delete certain products using the same facility? I can target SKU's of products to be deleted...

How to import data from csv file to sqlite Manager tool

How can I import data from a CSV file into the SQLite Manager tool? I can not find the import option in SQLite manager. I have to import data from CSV to a particular table in db.

Bulk Insert Partially Quoted CSV File in SQL Server

I'm trying to import a correctly quoted CSV file, meaning data is only quoted if it contains a comma, e.g.: 41, Terminator, Black 42, "Monsters, Inc.", Blue I observe that the first row imports...

How to kill a while loop with a keystroke?

I am reading serial data and writing to a csv file using a while loop. I want the user to be able to kill the while loop once they feel they have collected enough data. while True: #do a bunch...

Best way to import many xml files using php without knowing any of the xml files format first?

I've come up with some functions but I'm not confident in them being the best approach. Here is one I made for establishing what I call headers because I do the same thing with .csv files and the...

SQLite import csv file with comma in text fields

I want to import csv file into SQLite db using sqlite> .separator , sqlite> .mode csv data sqlite> .import test.csv data where data is the table name with three columns, just like the file. The...

Remove duplicate products with same sku in woocommerce

I have used wp all import http://wordpress.org/plugins/woocommerce-xml-csv-product-import/ to import products from a XML file, but it has created duplicate products with same SKU. how can i delete...

Use ValidateSet with the contents loaded from a CSV file

I really like the way that ValidateSet works. It proposes the options as a list while you type your Cmdlet in the PowerShell ISE. I would like to know if it's possible to retrieve values from a...

How can I export a CSV using Symfony's StreamedResponse?

My code looks fine, I get status 200, I get the right headers, ... and yet my CSV file created will not donwload... There is no error, so I do not understand why it's failing. Here is my...

Run javascript function on cells of CSV / excel file

I have a javascript function here (view page source) that converts all the simple-text content of a text box into Unicode Devnagri script, following a character substitution algorithm, and outputs...

Python How to Import xlsx file using numpy

I am having no trouble importing csv data using numpy, but keep getting an error for my xlsx file. How do I convert the xlsx file to csv or how to I import xlsx file to the x2 variable? from...

Convert commas decimal separators to dots within a Dataframe

I am importing a CSV file like the one below, using pandas.read_csv: df = pd.read_csv(Input, delimiter=";") Example of CSV file: 10;01.02.2015 16:58;01.02.2015...

Import WordPress post images as featured image from external URL

I currently have a CSV file which has 2 columns - one for the Post ID and one for the image URL. There are 10,000 posts, and therefore 10,000 images. I need to import these into WordPress and set...

How to convert a string to date and extract values in Access query

I'm using Access DB 2007 - 2010; I've tried to import many CSV files but the timestamp column keeps failing to import correctly. So I linked all of the CSV's to an Access DB and I'm trying to...

How can I convert a JSON date with timezone to a SQL Server datetime?

I saved the output of a JSON object in a CSV file. I want to import the data into SQL Server. I have tried to cast the JSON date column to a SQL Server datetime data type. select...

CSV date format to MySQL date format

When I try to import my CSV file to MySQL, all the date become 0000-00-00. CSV date format is DD/MM/YYYY like this 16/11/2016. MySQL format is: YYYY/MM/DD. I am using phpmyadmin to import this....

How to push data from local SQL Server to Tableau Server on AWS

We are developing Tableau dashboards and deploying the workbooks on a EC2 windows instance in AWS. One of the data source is the company SQL server inside firewall. The server is managed by IT and...

Django Import-Export Import Duplicate key value violates Error

I'm working on a project with Django 1.10, Python 3.6 and PostgreSQL as the database backend, in which I have a model called 'Article" and I need to import data from CSV files. I have imported my...

import csv into Excel with #N/A

I have a application that is printing some numerical values to a .csv file and I would like to do the printing in such a way that the csv file can be opened with a double click in Excel without...

RMarkdown: "Error: path for html_dependency not found:"

I am a Chemist who uses R and R Studio to analyze mass spectrometry data. I have automated scripts that process my data, because there are a lot of files. The scripts call rmarkdown using render()...

Importing CSV from URL that has line breaks within one of the fields

I created a script that imports a CSV file from a URL into a Google Sheet. I have used Utilities.parseCsv(csv) in the past with no problems. However, this particular CSV file contains a field that...

python3: csv.writer how to remove end of line ^M?

I realized that every end of line of my export.csv file ends with ^M, Any idea how to remove it? Probably I have to modify somehow csv.writer When I import this csv file to SQL, I got one extra...

Problems with uploading CSV file to SQL Server with PHP

I have created a web application to allow users to upload CSV files into SQL Server. I have 8 columns in total. The id column in SQL Server is auto-increment so minus that column. The upload was...

how do i import Image from google drive to google colab

i have mounted the google drive to my colab notebook from google.colab import drive drive.mount("/content/gdrive") I can import csv files through it in my case df =...

Import csv data into a database in golang, but with a variable number of fields in each file

I've got a curly one (atleast for me) for you. I'm pretty new to go, but need to process some .csv files into a database, which would seem to be pretty easy if the csv files were consistent....

How do I install pandas into visual studios code?

I want to read an excel csv file, and after researching, I realized I need to import pandas as pd. Is there a way to install it into the visual studio code? I have tried typing import pandas as...

Postman Request body data from excel / csv file - forward slash

I get Request body data from excel file. I have already covert excel to csv format. I have kind of able to find a solution but it is not working 100% as jsonbody format in not fetching data...

Django import-export with FK constraint

I have been attempting to import data into my Django project using Django import-export. I have two models Ap and Job, Job has a FK relationship with Ap. Using the Admin, I can select the file...

Is there a Limit row function in Laravel Excel import?

I am using maatwebsite/excel package to import a CSV file. I cannot able to limit the imported rows. Like I need the first "n" number of rows from the uploaded file. I saw an...