Comma-separated values or character-separated values: a text format to store tabular data. Often used to import or export MySQL tables.
0
votes
1answer
28 views
Having issue on Loading Meta Data From CSV to CPT
I have a custom post type which has one Title, and two meta box custom fields as
$price = isset( $we_productMetas['price_box'] ) ? esc_attr( $we_productMetas['price_box'][0] ) : '';
$color = isset( $...
0
votes
0answers
20 views
How to Upload CSV Data into Custom Post Type Data with Metabox programmatically
I have a Custom Post Type called movies which had only title enabled from post support and 3 custom field of metabax as box office, year, and director like
now I have like 150 rows CSV formatted ...
1
vote
0answers
36 views
How to make a wordpress site multilingual by uploading a translated CSV file that has the traslations?
I have a website which is in french and i need the website to be read by my users in english too. How do i achieve that without making or creating entirely new pages with english translations. I have ...
0
votes
0answers
9 views
Multiple CSV exports
I have just various CSV exports from a directory plugin, i need to find the quickest way to sort the content out then import it back into a new plugin directoy. Does anyone the easiest way to do this?
...
1
vote
1answer
36 views
Importing CSV into database table not working?
global $wpdb;
if (isset($_POST["import"])) {
$fileName = $_FILES["file"]["tmp_name"];
if ($_FILES["file"]["size"] > 0) {
$file = fopen($fileName, "r");
while (($column = fgetcsv($file, ...
0
votes
0answers
14 views
WooCommerce add price in variations
I have a dilemma that I hope someone can help me with.
I have a jewellery website with over 20,000 products. On the single product page I will have two variations drop down boxes, one for "Chain ...
1
vote
1answer
26 views
How to handle a CSV with 65,000+ rows and make it searchable?
I have a csv of 65,000+ rows. Each row only has two fields, an ID code and a Description. This csv will get updated every year or so. The users needs to be able to type in the code and get a list of ...
0
votes
0answers
19 views
multiple string replace of post's content for large data
I am trying to replace all player name mentioned into my post's content with related player's profile link.
And all the player name and player links saved in a csv file.
Example:
player one,www....
0
votes
0answers
31 views
CSV export from Frontend [duplicate]
i have an custom SQL quarry i need to allow users to DOWNLOAD CSV file from this quarry from their fronted panel
SELECT ATT_fname, ATT_lname, ATT_email, ATT_address, ATT_phone FROM ...
0
votes
1answer
14 views
Imported posts for cpt are imported as scheduled, not published [SOLVED]
I'm importing posts to a plugin's custom post type for Stores. As I had roughly 1500 stores to upload, I decided to make it via csv/txt bulk import. I created one post, and exported it to have the ...
0
votes
1answer
334 views
How to export custom database data to excel file
Hi everyone I have the code below, but when I click on the link generated a new page is open with 0 display on it.
What I'm doing wrong?
function list_reservation_to_csv() {
global $wpdb;
$...
1
vote
0answers
83 views
Huge category CSV import does not work
I have a 1.5 MB (with about 20.000 line) CSV file and I would like to import this into my new WordPress site. The code below does not create all of the categories, only some of them. I already ...
1
vote
0answers
28 views
Manipulate CSV data during upload, is it possible?
I am generating membership invoices from client supplied membership list CSV. I created a custom post type, and I'm using wpallimport to upload the CSV data into that custom post type. Each row in the ...
0
votes
0answers
293 views
PHP Curl DOM Parse multiples HTML files in folder into CSV (inline data in row)
Im willing to use PHP curl to parse multiples HTML files from a directory source instead of a single one. I would like to parse any kind of text element and put it in one row per html file and datas ...
0
votes
0answers
84 views
download automatically custom woocommerce export csv file
need help on the setup of the auto download.
Here the idea I want to implement.. I have a custom function to export woocommerce order to csv file. it was a manually downloaded from shop order>>action>...
1
vote
0answers
17 views
How to import .csv file with descriptions to a gallery in media?
I have this CSV file that I want to import into an image gallery I have in my "media" tab. Images are named like 79.jpg, 80.jpg, 81.jpg, and so on.
My CSV file is ordered like this:
id;;creator;...
-2
votes
1answer
581 views
Reading CSV values and showing them in PHP
I have a project going on and this is the first time I've encountered CSV. I've read numerous post but haven't found what I need.
So we have and CSV with values like this
Name,Country,Color,Pet
...
1
vote
1answer
469 views
What’s the fastest way to import products with variations in WooCommerce (CSV, XML, …) [closed]
I’m setting up an onlineshop for a customer and I’m at a point I need some advice from you.
I have about 4,000 products to import into my WooCommerce shop (using version 3.2.6). Each of the 4,000 ...
0
votes
1answer
21 views
Pull specific data from CSV
I'm building a website, and client has specific request. Open source app has .csv file providing bunch of data. They want to pull some fields from that csv and to place it in on wordpress website.
...
0
votes
0answers
133 views
How Do I Email A Gravity Forms Recent Entry As CSV
My question is how do I send an email that has a .csv of just the most recent entry. I tried to comment out the foreach loop and also change the GFExport::start_export to a lower number, neither has ...
0
votes
0answers
36 views
Delete all custom posts then upload a new CSV of events
I was having an issues with deleting all posts and then re-uploading a new CSV of events to a custom post type 'events' and managed to put together a solution together that works.Hopefully this will ...
0
votes
1answer
64 views
how can i import the csv file in wordpress woocommerce.?
my client has a Wordpress website and we are facing some issue while importing the products with variations in the website. the website link is https://www.primadonsanddonnas.com. The CSV file ...
0
votes
0answers
371 views
Trying to print from an array to a CSV file, printing to screen instead
I've created a custom page template for my wordpress site that reads data from custom tables, manipulates it, and then puts into a form. This displays just fine.
the next thing the code does is call ...
0
votes
1answer
35 views
import user info csv
I want to import user information using csv file.
I use BP-Groups-Import-User plugin.
The challenge is to add column first name and last name in csv file but i can not get the value to store.
my ...
3
votes
1answer
652 views
Creating 20,000 Posts or Pages using a .csv file?
Here's my challenge: I have a .csv file which contains 20,000 rows of data.
Each row contains 5 columns of data on an particular individual.
I need each row (each person) to be populated into a ...
0
votes
0answers
320 views
Updating database with CSV file and Cron job
I have two ecommerce websites. They sell the same products at the same prices. One is WordPress (woocommerce). The other has a .NET backend and a MSSQL database. I need to import the stock level from ...
0
votes
0answers
11 views
Products aren't detected if CSV importer are used
I created a plug to import a CSV personalized.
The problem is that a plugin to create animation doesn't detect these products until I open the product on backend and update it.
Is there a way to ...
0
votes
2answers
485 views
Creating custom page template from existing PHP site
I have an existing site that has 5 or 6 php pages, with HTML mixed in for some tables and forms. The biggest purpose of the site is to upload CSV files into a database table and then on other pages ...
0
votes
0answers
426 views
Front end/Database connection in WP
I've been tasked with a project where the user needs to access the front end admin page that I've created and upload a CSV (1-3 daily). This Information needs to go into a database and be split into ...
0
votes
1answer
312 views
Download full html page with CSV export plugin
I am making a csv exporter plugin for my own need. But the problem I have is that, it download whole page as html when I click Export button. Here is my code. Please help me to slove this problem. ...
1
vote
1answer
516 views
Why is file_get_contents returning page source?
I'm trying to write a shortcode in my theme's functions.php file that can display the contents of a CSV file on our server.
I'll worry about reading the CSV file into arrays and such later, but for ...
1
vote
1answer
75 views
file_exists() acting weird
I'm trying to pull some data out of a csv file but I'm stuck because file_exists() says the file doesn't exist when used with get_template_directory_uri().
This is the short code:
function ...
4
votes
2answers
2k views
Allow CSV files to be uploaded
I am trying to allow CSV files in a dashboard menu page like this..
<form method="post" enctype="multipart/form-data">
<input type="file" name="csv_file" id="csv_file" multiple="false" ...
1
vote
1answer
48 views
Pulling Data from CSV vs. pulling data from database
I developed a custom post type with a custom taxonomy for my WP theme and I need to add a number to associate with my taxonomy.
Example: The taxonomy is "store" and the average savings for that ...
2
votes
1answer
61 views
Creating a Wordpess Plugin that writes data to a csv file. The data doesn't show in the csv file?
I am writing my first Wordpress Plugin that should simply write data to a csv file. This is the code, I can't figure out why the data won't write to the csv file?
add_action('admin_menu', '...
0
votes
0answers
205 views
Force CSV download with template_redirect
I'm struggling to get a dynamically-generated CSV to download with a template_redirect. It seems to work (if not this exact version, another similar version) when it does not go through Wordpress, e.g ...
0
votes
0answers
1k views
Button to download export data Wordpress in CSV file
i need my own download button to get a csv of my users, i know lot of plugins did that but i really need to create mine. I found some post there but i really don't know why mine doesn't work
So i ...
0
votes
2answers
849 views
Creating a CSV with PHP inside the plugin directory
I am trying to develop a method in my admin panel that will allow for the creation of a CSV file within the plugin directory
Here is my code: where $amount is the next increment of filename ...
0
votes
0answers
107 views
Extracted CSV as Array for Custom Query Loop
How can one extract via PHP the Infos in the CSV/ Excel file.
I have a excel file with over 100 entrys and many rows and i would to like place the file in CSV format on the server and then extract ...
0
votes
1answer
57 views
get csv of users with user_meta
i would like to export all users with user_metas.
Right now my sql looks like that
SELECT
u.ID,
u.user_email,
u.display_name,
um1.meta_value AS first_name,
um2.meta_value AS ...
0
votes
2answers
475 views
How can I automatically send an email with an excel file containing submissions for a form rather than an email per submission?
I recently took over web admin for a nonprofit organization and one of the things they would like changed with their site is to have multiple forms such as contact, volunteer, donations, more info, ...
0
votes
1answer
185 views
Import media in bulk with caption and titles?
I am converting a non-WP site to a new WP site. The old site has about 500 images that I need to import to the media library in bulk, and I need it to include the captions and titles.
Is there an ...
0
votes
1answer
90 views
'pre_user_query' interfering with user export
I needed to add sortable columns to clients wordpress for custom meta data I created so I used a pre_user_query hook
add_action('pre_user_query', 'user_column_orderby');
function user_column_orderby(...
0
votes
0answers
26 views
Issue: CSV file upload works only when “View page source” is done
I ma having little wired issue while uploading the csv file. Here the code I have. The actual site is developed in wordpress. This is to show the issue and same issue happens in the plugin developed.
...
0
votes
1answer
1k views
Custom CSV exporter - Cannot modify header information - headers
In my admin dashboard, i created a custom module for report filtering using custom queries. I need to add another functionality which is to export these results to CSV. I tried to create a very simple ...
1
vote
1answer
781 views
Custom Plugin For Converting CSV To MySQL
I wrote a plugin to add a csv file to the database. I created a custom table to use. My file path looks like this,
wuno-uploader/wuno-uploader.php
wuno-uploader/inventory.csv
On an settings option ...
0
votes
1answer
154 views
Creating connections programmatically with common fields on CPT's
I'm trying to create a programmatic connection between two CPT's that have a common field (id_number). For example:
CPT "City":
post_name:New York
id_number:34
CPT "Color":
post_name:Red
...
0
votes
1answer
2k views
WooCommerce - Adding Product Attributes to CSV Export
I'm trying to customize the WooCommerce CSV Export plugin to add additional columns for two standard product attributes ("fund" and "appeal code").
I'm able to add the actual headers, but can't get ...
1
vote
0answers
2k views
Export Wordpress Table to CSV from page
I want to export my members table to csv format on my default download location. So I used a shortcode in functions.php and called it on a page. I am getting an already sent header warning and csv ...
1
vote
1answer
260 views
Feed format for woocommerce [closed]
I am using woocommerece for my website. I get product feed from different suppliers in excel format with different information in different columns (no consistency in product attributes such as price, ...
