PGP: Checking filetype and returning the extension using windows' FileSign.txt

I am actually looking for things like this: EncryptedFile.pgp ----decryption---> DecryptedFile(no extension) ----use some checking methods----> DecryptedFile.extension I know that there are alot...

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...

How can I automatically export csv and send it to a database or textfile

I have to make a mailing list to which you can subscribe in Wordpress. I've found a WP plugin in which you have a form with two fields, name and email. These are being saved into a csv file which...

How to import multiple image?

Field image is accepting this type of format for multiple image import: a:10:{i:0; a:1:{s:6:"imgurl";s:71:"http://example.com/wp-content/uploads/2015/01/image.jpg";} i:1; ...

disable duplicate post check in wp-all-import wordpress plugin

I am using the wp all import wordpress plugin to import posts to my wordpress blog from a csv file. The file has over 10000 posts, the problem is the plugin posting gets slower as the database...

Update database tables with 30 CSV files (updated daily) using phpMyAdmin and SQL query

I am creating a new Wordpress site that is hosted by WP Engine. I have 30 CSV files located on my local hard drive that get updated each day and need to update their corresponding tables in the...

Black diamond/questionmark replacing random characters in WordPress

My WordPress site was imported by creating CSV's in OpenOffice Calc, saving as Unicode (UTF-8) to preserve the Korean characters. The post contents imported without any major hiccups, but...

Wordpress insert thousands of records

I am facing issue server execution timeout and sometime maximum memory used. I want to insert 30k records into database from a CSV. The issue is everything is going through the one loop. I have...

Wordpress CSV Import posts with category, tag and custom field through HeidiSQL

World, please help me with this because I'm going crazy. I am trying to import a huge csv into Wordpress since 2 days. WP plugins are just slow, I have a big csv file so using wp plugins is not an...

Attempting to parse large file to array in PHP/Wordpress. Keep getting memory error

I am trying to get a lot of words into a database as individual entries. The file is a 17MB text file of comma separated words. The PHP is: $file = file_get_contents(plugins_url( '/cipher.txt' ,...

Persistent 504 Timeouts with WooCommerce

I am consistently getting 504 "Gateway Timeout" errors when trying to update posts, settings, or other data in Wordpress. This is on a shared NetworkSolutions host, and Network Solutions support...

Woocommerce Wp all import Dynamic pricing issue

I'm using Bulk Pricing for WooCommerce for the dynamic pricing but my problem is I cannot insert data from csv using wp all import, because the field is array with one meta key. Here's what it...

How to edit mySQL wp_posts table from plugin php in WordPress?

I have a need to change a plugin that creates/edits entries to the wp_posts table. Currently, it is lacking in that it cannot target some specific fields. I am endeavoring to edit the plugin so I...

How to get a Product Variation Custom Field to work along other plugins?

I get this code (see below) to create a Product Variation Custom Field. It works just fine. Now I need to use the WP All Import Pro plugin to import Products from a csv file. This plugin allow to...

Wordpress site - using custom PHP and database

I have finally finished coding a project with an HTML form for file upload, and a large PHP file that submits a 200 field CSV into my database. It first uploads to a staging table and then splits...

PHP Header error Warning: Cannot modify header information - headers already sent by (output started at myphpfile:1) in php file on line 1

I have the header at the very beginning of my script and so I've no idea why I'm getting this error, anyone have any other ideas? im trying to send an email later in the script but it contains...

How can I export Wordpress post content into csv with <p> and <br>?

I'm using the WP All Export plugin to create custom exports of my posts into CSV. However, none of the post content has <p> or <br> tags, it's just white spaces. I need the tags because I'm...

Woocommerce Deleted Products Variations Remain

I have recently added the WP All Exports Plugin to my Wordpress site and exported a list of all the products from my woocommerce store. I have noticed that I have in excess of 100 Variants on the...

load data infile is not allowed MariaDB

I created a PHP script that imports posts from a CSV file into a WordPress website. To do this, I first bulk import the posts into a table of the WP website database and then the PHP script...

Import products with meta-data using WP All Import plugin?

I'm using Woocommerce to setup my online store and I've set my products up with meta-data fields and when I need to import the products to my live site with csv. My columns have meta:_branchid,...

SQL lite import csv error CREATE TABLE data;(...) failed: near ";": syntax error

Brand new to SQL lite, running on a mac. I'm trying to import a csv file from the SQL lite tutorial: http://www.sqlitetutorial.net/sqlite-import-csv/ The 'cities' data I'm trying to import for the...

How to change a Wordpress term's slug before saving

We are using WP All Import to import product data from a CSV into WooCommerce. Everything works fine (great plugin!) but we have one problem: Two of our product attributes contain disallowed...

JSON reponse for Jquery/Ajax in Wordpress fails for bigger size file

I am implementing own custom function for historical extract in CSV format from MySQL database using jQuery-Ajax in WordPress environment. I have an HTML where user selects the start date and end...

Composer install issue on prod, no issues on local enviroment

Recently I unignored composer.lock along with package-lock.json (likely unrelated), and I changed our gulp deploy script to use composer install instead of composer update. Before pushing new code...

Contact Form DB - WordPress plugin exporting to excel is not working

I've around 5 forms in my WordPress website. All using Contact Form 7. Also installed the Contact Form DB plugin (contact-form-7-to-database-extension - the plugin is discontinued now). Problem...

Wordpress bulk products upload (woocommerce) - 650K

I'm using WordPress + Woocommerce for one project. The problem is that the CSV file from the client has over 650k records for products and I have to upload all these products to woocommerce...

Cannot establish a connection with MySQL running on MacOS

My MySQL appears to not be running correctly on my MacOS Catalina (10.15) according to Homebrew and according to my wordpress app, it cannot make a connection to my MySQL server. When I try to...

Wordpress + php + mysql High cpu usage

I'm load testing a production server using wordpress, php 7.2 and mysql Ver 15.1 Distrib 10.1.44-MariaDB, with 4 Core i7 CPUs and 10GB Ram running on ubuntu 18.04 LTS. The problem is even with a...

How to use download button in shiny and save results in various formats (csv, texte, pdf, spss...)?

I am currently working on shiny app. And I would like the app allows to download (save) results in various formats : csv, texte, pdf, xlsx, SPSS, SAS and Stata. Here is my UI : # Define UI ui <-...

Import multiple custom field values from single CSV entry

My data in the database is stored in this format as an array. The correct way of storing: array ( 0 => '18459', 1 => '18462', ) The format for importing is separated by a pipe in my csv file...