Completed

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

Job Description:

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

About the Client:
( 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

21 freelancers are bidding on average $131 for this job

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
(1972 Reviews)
8.2
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
(480 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
(261 Reviews)
7.4
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
(136 Reviews)
7.3
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
(32 Reviews)
6.1
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
(86 Reviews)
5.8
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
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
(53 Reviews)
4.9
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
(30 Reviews)
4.9
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
(11 Reviews)
4.3
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
(4 Reviews)
4.0
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
(8 Reviews)
3.8
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
(3 Reviews)
3.3
dave22153

I am familiar with PHP development and exporting to .csv files. I believe I can help you write the functions to query your database and get the data to be ready to import. Relevant Skills and Experience I have good wo More

$100 USD in 2 days
(0 Reviews)
0.0