Completed

Correctly export post type data to .CSV using plugin WP All Export, PHP functions.

This task should boil down do some php functions and tinkering with a wordpress export plugin. I imagine it would take one or two hours max, but we shall see.

We are changing from one directory/map plugin to another.

The goal is getting data exported correctly to a .csv, so that I can then import it to the new directory system / plugin.

This import/export is already tested and working fine, almost. The difficulty is that for several columns of posts some are stored in custom fields, and some are stored in a custom database table. So I’m having trouble getting all of them exported. A previous developer had set up this custom database table I believe.

We are using the plugin WP All Export Pro, and have the “pro” version purchased. [login to view URL]

The plugin can use PHP functions to alter how it works, which is what I need help with, as I am not good with PHP.

The uploaded file is the current .CSV as it stands now, with issues.

My export file has missing data, starting about halfway through. On line 793 on down, there is no data for a number of columns. I have confirmed that this data actually exists for those posts.

Also, you will notice that for those same columns, the data is duplicated four times, separated by a pipe. Not ideal but I could deal with it. But perhaps it's related to my main issue? I don't know.

The plugin developer said:

After looking into this further, I found out what the problem is. Turns out, only some posts have this information stored in custom fields. Others have the data stored in a custom database table, wp_places_locator (please see: [login to view URL]).

If you are at all comfortable with PHP, it really shouldn't be that hard to write the functions. Here's an example for the website column:

function my_get_website( $post_id ) {

$website = get_post_meta( $post_id, 'website', true );

if ( ! empty( $website ) ) {

return $website;

} else {

global $wpdb;

$data = $wpdb->get_row( "SELECT `website` FROM `" . $wpdb->prefix . "places_locator` WHERE `post_id` = '" . $post_id . "'" );

if ( $data ) {

return $data->website;

}

}

return null;

}

I have more detailed info on this and my communication with the plugin developers.

To get started you would log in to Wordpress admin, find “All Export” down low in the left menu, and select “Manage Exports”. On that page mouse over the most recent export at the top titled “AWA Listings Export - 2019 December 28 01:00” and then click on “Edit Export”. The next screen is where you will do the work. Click on a Field name to edit that field. Correctly writing and inserting the php here is what needs to be done. For this export, the fields with issues are Street, City, State, ZipCode, Country, lat, lng, email, phone, website.

Then click “update template” to proceed. Then “Run Export” to test.

I will be available for questions.

Thanks!

Skills: PHP, WordPress, MySQL, Software Architecture, HTML

See more: wp all import custom post type, wp all export custom export field, wordpress export database table to csv plugin, wp all export documentation, wp all import pro license key, export csv file in php wordpress, wp all import users, export list of posts from wordpress, post form data csv, javascript post form data csv, export sql server data excel using vbs, data processing companies german doutch post type data, data processing job german deutsche post type data, export post type excel plugin wordpress, export user data csv buddypress plugin, wp all export, how to get custom post type data in wordpress, how to create custom post type in wordpress without plugin, import custom post type data wordpress, how to add custom field in custom post type in wordpress without plugin

About the Employer:
( 9 reviews ) Bend, United States

Project ID: #23093120

Awarded to:

workon

Hi, this with take 2-4 hours to solve this issue. I will need a wp admin & ftp access. Let me know if there's anything else. Thanks.

$75 USD in 1 day
(243 Reviews)
7.4

22 freelancers are bidding on average $131 for this job

mituld

Hello I hope are you fine I have got it your idea you need the Correctly export post type data to .CSV using plugin WP All Export, PHP functions and I am ready to start work now and i have pass work this type and i More

$130 USD in 7 days
(472 Reviews)
8.2
TakeReal

Hello, My name is Sergey. I am Freelancer from Saint Petersburg, Russia. I can help you as an experienced WordPress programmer to export data from Custom table 'wp_places_locator'. So, WP All Export will produce c More

$100 USD in 2 days
(1909 Reviews)
8.2
babitabubu

HI, I have read the task detail and checked the links. I can do it for you. Please message me so I can clear my question and start work for you immediately. I can finish within 3 days. Thank you and regards

$220 USD in 3 days
(231 Reviews)
7.2
BaNgan

Hi, First I need to get login credential to your current site with the plugin. Per my understading, the export script should check for custom field exist on the post type or not then check that missing data on external More

$127 USD in 3 days
(259 Reviews)
7.2
amitpandeyposin

Hi there we are a team of more than 8 years experience in Wordpress and we have also good experience export data in .csv file we can do this your work please come on chat to discuss the details will try to start your More

$140 USD in 7 days
(128 Reviews)
7.1
techplusintl

Hi there, I'm ready to export post type data to .CSV using plugin WP All Export. 17+ years experience and expertise in : CMS (Wordpress, Magento, Shopify, OpenCart, Joomla, Drupal, Prestashop, Wix, SquareSpace) PHP F More

$140 USD in 5 days
(140 Reviews)
6.6
desireds

Hi, I have reviewed your project details carefully and feel that I can immediately work on your project. I have a team of expert developers who can deliver your project on time. Work Expertise- PHP related work CMS, More

$220 USD in 10 days
(97 Reviews)
6.4
milliard

Hi there, I have gone through your requirement. I have a few questions to discuss. I am putting this place holder bid to initiate discussion. I request to open up chat so we can discuss my queries and then I can propos More

$140 USD in 7 days
(30 Reviews)
6.1
BestPrince1120

⭐ Wordpress Expert is here!! ⭐ Hi Client! Thank you for posting your project. I have 7 years of experiences with Wordpress. I have read your suggestions carefully. I can complete your project with high quality and spe More

$100 USD in 3 days
(49 Reviews)
5.1
kdwebsolution9

Hello sir, Hope you are doing well. i have 6+ years of experience in WordPress php codeigniter woocommrece html css mysql javascript bootstrap graphic design website design etc. these job suitable for me Kind Rega More

$140 USD in 7 days
(29 Reviews)
4.9
TechnicalKnight

I can help you in exporting correct fields in the plugin. I have seen the csv file and understood the issue, i have read your long description and clear understanding of the issue.

$100 USD in 2 days
(42 Reviews)
4.8
scripts24

Hello Sir! I will provide CSV using plugin WP all Export, PHP functions. @@@@@@@@@@@@@@PLEASE FEEL FREE TO CHAT HERE@@@@@@@@@@@ Php Expert Technologies is a full service, design, and development company offering end More

$200 USD in 8 days
(12 Reviews)
4.2
aeljack

Dear I am Alex and I have done really many projects on WordPress site developement. I read your project description and I am very interested in your project. You project is stood out to me because I've done very simil More

$140 USD in 7 days
(5 Reviews)
3.9
azizfatkhur

Hello sir, I am a web developer and individual freelance which is a works full-time. I have experienced in the field of wordpress-based web development for more than 3 years. I am understand the details that you desc More

$90 USD in 4 days
(11 Reviews)
4.0
svetaprof222

Hello, how are you? As a php expert with abundant experience, I'm glad to see your project. I'm sure your project is very fit with my skills and experience, so I can do this project perfectly. I'm ready for you, hope y More

$100 USD in 7 days
(9 Reviews)
3.8
zeroconf

Hello, thank you for sharing so much information about your issue, this is really helpful to understand it. The simplest solution here is to try to extract the information from the custom field and if not set then try More

$75 USD in 1 day
(3 Reviews)
3.9
Followalinfotech

i have 5+ year experience as a frontend and backend developer. I can provide dedicated Developer for your project. First Thing I want to say that, I will work continuously until you are happy 100% with my work & commun More

$140 USD in 7 days
(4 Reviews)
3.3
sunny0070

Greetings!! I'm WordPress expert and also I'm authoring plugin extensions, themes extensions, building theme from scratch and building plugin from scratch. I'm able to help you out with this because how I'm also have More

$200 USD in 1 day
(4 Reviews)
2.5
viharthakkar

Hey, I am wordpress plugin developer. I have review your requirements. You want to export post data with custom field value. I have more then three year of experience in wordpress development.

$66 USD in 2 days
(1 Review)
1.6
azana681

Do you have a WordPress Issue? Let’s azanahmed433 help you How do I help? ✔ Custom plugin and theme coding ✔ Working on child themes ✔To check WordPress 5.0 compatible with all the themes and plugins. ✔ Updating We More

$140 USD in 7 days
(0 Reviews)
0.0