XML export posts from one single day

How to export all posts from one single day. I've tried Tools > Export > Post. But problem is that there's only monthly backup, not date-wise as in "only 5th July 2015". How can I achieve this?
Category: Web

Should I store external API data in my WP database or keep it as a transient?

I am in a situation where I need to use data from an API (XML) served by a third party in my WordPress site. The data will be updated on that third party application. Specifically this is data about properties that is stored on said 3rd party web application. The data is made available in XML format. I would like to allow displaying of this data in a WP website, as well as searching, and eventual portal to said application …
Category: Web

Import Instagram post as Wordpress post

I've been searching a lot but haven't found one very simple thing: how to import a post created on Instagram and turn it into a Wordpress post, that is, copy one Instagram post (text + photo) and create a simple post on the Wordpress blog?
Category: Web

Create XML sitemap in wordpress

This question has already been asked before, however, I cannot reply to those comments because I am a new user. Therefore, I will post my question here. I am trying to create a XML sitemap for my wordpress site. Someone on this site suggested that a duplicate of the XML export file be made. This file is located here. How can I modify this file in my theme so that it is updated automatically? Where will the exported file be …
Topic: xml Wordpress
Category: Web

Dynamically Create Posts Via XML File

I'm new to wordpress/php and I'm trying to create new posts dynamically through a xml file. The xml I'm working with is this one. The file get updated periodically during the day in a FILO fashion (new item are added at the top and the bottom one get push out) and right now we have someone manually creating new posts every few hours by grabbing a few value in each items. So what I'm wondering is if I can automate …
Category: Web

How do I get data from my database into my Custom Export Field

I am trying to get data from my database to export to a XML or CSV File by using a custom query. This is my function with the query : <?php function get_workhours($ID){ $sql = $wpdb->prepare("SELECT worked_hours FROM db_info WHERE job_id = $ID"); $data = $wpdb->query($sql); if(empty($data)){ return "0"; }else{ return $data; } ?> And in my custom export field i have this : [get_workhours{ID}] And when I try to preview this it gives me the error : An unknown …
Category: Web

How do you code a featured image into an XML as a jpg link, instead of using a data-id number?

All I want to do is get Wordpress's featured image XML code to use a jpeg link as the meta_value, instead of the image gallery data-id number. Basically change this code: <wp:postmeta> <wp:meta_key><![CDATA[_thumbnail_id]]></wp:meta_key> <wp:meta_value><![CDATA[202466]]></wp:meta_value> </wp:postmeta> To something reading like this: <wp:postmeta> <wp:meta_key><![CDATA[_thumbnail_id]]></wp:meta_key> <wp:meta_value><![CDATA[http://xxxx.com/wp-content/uploads/xxxx.jpg]]></wp:meta_value> </wp:postmeta> I appreciate the help, hopefully its something simple enough.
Category: Web

Generate/save JSON or XML file from JSON script

I have a JSON script which at first Search for jobs with a specific attribute and then afterwards Get the job details. For now the script is like this and is saved as a Postman collection: { "info": { "_postman_id": "xxx", "name": "JOBAD Service", "schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json" }, "item": [ { "name": "GetJob", "request": { "method": "POST", "header": [ { "key": "SOAPAction", "value": "http://xxx", "type": "text" }, { "key": "Content-Type", "value": "text/xml", "type": "text" } ], "body": { "mode": "raw", "raw": …
Category: Web

How to import nested categories from XML file?

We're importing an eXtended RSS file generated by WordPress thru the native Importer: Tools: Import in the WordPress admin panel Importing parent posts is straightforward, by defining the respective parent id: <wp:post_parent>1</wp:post_parent> However, during the export the hierarchy of categories, subcategories and so on gets lost, and we're trying to set the according parent categories inside xml file. We've tried the following without any success: <category domain="docs_category" nicename="category-1"><![CDATA[Category]]></category> And for another post: <category domain="docs_category" nicename="subcategory-1" parent="category-1"><![CDATA[Subcategory]]></category> We cannot find any …
Category: Web

Import media (.xml) does not attribute featured images to posts

I am exporting all content from one wordpress site and importing to a clean install. The featured image of each post is not loading after being imported even though the media has been imported. The media settings are the same and I can see the year/month structure in FTP after I import it. When editing an existing post you can see the preloader turning in the featured image indicating that the database data for the featured image is indeed there, …
Category: Web

WP Import All Multiple Dynamic Link Imports

What I’m trying to accomplish is to import the property details but they have a dynamic link. I need to get the property codes from this link -> https://api.supercontrol.co.uk/xml/filter3.asp?siteID=46111&propertycode_only=1 e.g (583427) The Property Codes relate to the data that I need from this link format -> https://api.supercontrol.co.uk/xml/property_xml.asp?id=XXXXXX&siteID=46111, the XXXXXX is the where the property code needs to go. There are currently 37 property codes that I need to import and need to get it to work with a cron to …
Category: Web

WordPress create custom XML RSS feed template

I am trying to create a custom XML RSS feed. However, my code is not quite working as expected. Here is what I have done: In functions.php I have created the feed called "top": add_action('init', 'customRSS'); function customRSS(){ add_feed('feedname', 'top'); get_template_part('rss', 'top'); } In my child theme I have created file rss-top.php which contains my template file. I am looking for a quite simple template structure like below: <?xml version="1.0" encoding="UTF-8"?> <articles> <article> <title>Overskrift</title> <teaser>Short excerpt</teaser>d <link>http://link-to-post.com/</link> <image>http://placehold.it/100x100</image> <date>19-06-2017 11:21:00</date> …
Category: Web

WP All Import manual Cron

I am having problem to set up Cron to import stock. In Plugin WP-All Import i have two urls. One which starts import, another one is checking process and if it's stuck it kicks it back on. I'm runing website on cpanel and i tried everything i found on internet. I keep getting 503 error. But when i go to link it works. Do you have any expiriences with WP All import and C-panel cron anyone? My last settings i …
Category: Web

Wordpress xml import too slow

I'm trying to import posts and media with xml but is really slow, because there are 160000 posts and 160000 media. Further many posts are duplicated (same title, different categories and obviously different id) but wordpress import only one of them, is there any other method?
Category: Web

Wordpress importer / problem with images

i'm experiencing problem with WordPress importer. If I generate XML within my current wp, and import it to other site it doesn't get images. All links are working fine,all details are there, but images are missing in upload folder. If I use Theme testing unit (xml), its working perfectly. Any solution, ideas ?
Topic: xml Wordpress
Category: Web

Unlimited false pages showing in Sitemap?

I don’t know since when it started but today, I looked at it and it shows more than 90k pages are indexed on google in search console when my site has only 90 posts and some pages. https://priceunder.in/sitemap.xml
Category: Web

wp_insert_post from XML feed only inserting first post

My aim is to import all XML files from a folder inside the WordPress installation (/data/*.xml) To achieve this, I added action in functions.php: /** * Show 'insert posts' button on backend */ add_action( "admin_notices", function() { echo "<div class='updated'>"; echo "<p>"; echo "To insert the posts into the database, click the button to the right."; echo "<a class='button button-primary' style='margin:0.25em 1em' href='{$_SERVER["REQUEST_URI"]}&insert_mti_posts'>Insert Posts</a>"; echo "</p>"; echo "</div>"; }); Here's my code: /** * Create and insert posts from CSV …
Category: Web

XML FOLDER - wp_insert_post - how to assign XML variables to post

I'm trying to repurpose a code that worked for CSV files to do the same for XML-> That is import all files in the folder and create Wordpress custom posts(cikkek). So, I managed to parse the XML files in the given folder and get the right variables that I need: $posttitle = $xml->THIR->CIM[0]; $postlead = $xml->THIR->LEAD[0]; $postcontent = $xml->THIR->HIRSZOVEG[0]; Now my question is, how can I assign these variables to the last part of the code (line 65 - wp_insert_post). …
Category: Web

Rss error in first line of xml : not well-formed (invalid token)

I'm having a problem with my rss feed. Validator.w3.org is not accepting it, saying not well-formed (invalid token) on line 1. It seems that the name of the website appearing between <?xml ?> and <rss> might be causing the problem. Column 54 is the end of the site name. I cannot find where i can remove it... Any idea ? Thank you
Topic: xml rss Wordpress
Category: Web

About

Geeks Mental is a community that publishes articles and tutorials about Web, Android, Data Science, new techniques and Linux security.