SleekView Charts for WordPress Importer: WXR import audit
The official WordPress Importer ingests WXR exports and stamps imported rows with _wxr_import_user_* postmeta plus original_post_id markers. SleekView reads those keys and charts what was imported, who got mapped and which attachments failed.
♾️ Lifetime License available
WXR imports vanish into wp_posts with almost no breadcrumb
WordPress Importer is the canonical free tool from the wordpress.org team for ingesting WXR exports between sites. It walks the XML, creates posts, terms and attachments, and attempts to remap authors. The footprint it leaves is sparse: _wxr_import_user_* postmeta on remapped users, _wxr_imported_post_id on legacy IDs and an admin-side progress log that does not persist. The native UI confirms success and disappears.
SleekView Charts reads the residual postmeta and joins it back to wp_posts to recover an audit trail. A Number card counts posts imported in the last 30 days using the _wxr_imported_post_id marker. A donut breaks imported rows down by post_type so the team sees the mix of pages, posts and attachments. A bar lists author mappings by remapped user. An area chart tracks imports over time, which is useful when you ingest content from several legacy sources.
Attachments are the usual failure point. The chart layer flags attachment rows where _wp_attached_file is missing or where the source URL did not download, so cleanup is targeted instead of guesswork.
Workflow
From _wxr_imported_post_id postmeta to an import audit
Connect SleekView to wp_postmeta
Pivot import markers into columns
Add the four chart cards
Flag attachment failures
Sample dashboard
Charts you can build from WordPress Importer data
Posts imported, last 30 days
Count
Imports by post type
Count
group by post_type
Author remapping counts
Count
group by remapped_author
Import volume per day
Count
group by post_date
Comparison
Default WordPress Importer log vs SleekView Charts
Default WordPress Importer log
- Import progress log only lives on screen during the run.
- No persistent audit of which post types were imported in which run.
- Author remapping outcomes vanish once the importer closes.
- Attachment failures appear as inline errors, then disappear.
- Cross-import cadence over time is not surfaced anywhere.
SleekView Charts
-
Posts-imported KPI counted from
_wxr_imported_post_idpostmeta. - Post-type donut so the page, post and attachment mix is visible.
-
Author-remap bar built from
_wxr_import_user_*postmeta. -
Import cadence area chart from
wp_posts.post_date. -
Attachment-failure queue from missing
_wp_attached_filerows.
Features
What SleekView Charts gives you for WordPress Importer
Recover the import history
WordPress Importer does not persist a log, but the postmeta breadcrumbs are enough for SleekView to reconstruct a per-run audit of every imported post and attachment.
Author mapping clarity
Bar of remapped authors exposes content that ended up under the default importer user, which is the usual symptom of an incomplete user mapping step.
Attachment failure queue
Filtered view of imported attachment rows missing _wp_attached_file surfaces broken media uploads that the native importer reports inline and then forgets.
Audience
Who builds WordPress Importer audit dashboards with SleekView
Site migration teams
Audit dashboard during incremental WXR ingests, with imports per day, post-type mix and remapped-author counts visible alongside the live import.
Content migration leads
Per-source visibility when consolidating several legacy blogs into one WordPress site through staged WXR imports across days or weeks.
Editorial compliance
Evidence that imported content has correct authorship attribution before the new site flips to public, with remap counts as the artifact.
The bigger picture
The official importer is reliable; the audit is missing
WordPress Importer is rock-solid at the technical job of moving WXR content from site to site. The gap is that it leaves almost no readable history once the run completes, which is awkward for any migration that imports from several sources or runs in passes. The _wxr_imported_post_id and _wxr_import_user_* postmeta are usually treated as internals, but they are exactly the breadcrumbs needed to reconstruct an audit.
Charting them turns a one-off dialog into a saved view, which is what serious editorial migrations need.
Questions
Common questions about SleekView Charts for WordPress Importer
Yes. WordPress Importer writes _wxr_imported_post_id and _wxr_import_user_* postmeta during every WXR ingest. SleekView reads those keys directly and joins them to wp_posts for chart cards.
 Yes, as long as the importer left its postmeta on the imported posts. That metadata persists indefinitely, so historical imports remain chartable after the fact.
 Yes, provided they were ingested via the WordPress Importer plugin. The chart layer keys off the importer's postmeta, not the WXR file format, so any importer-run shows up.
 Attachments fail loudly during the run and then disappear. SleekView builds a queue of imported attachment rows missing _wp_attached_file so a follow-up media re-import is targeted.
 If the WXR file embeds a source URL or you set a custom meta during ingest, SleekView can group by it. Out of the box the importer does not record a stable source identifier.
 No. SleekView is read-only against wp_postmeta and wp_posts, and chart queries run on demand. A live importer run is unaffected by whether the dashboard is open.
 Yes. SleekView views are capability-gated, so the import audit can be limited to editors-in-chief or a custom migration_lead role and hidden from contributors.
 Each site renders its own audit dashboard out of the box. Cross-site aggregation requires a SleekView data source that joins postmeta from each site into one table.
 Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkoutBrowse more
- Advanced Woo Search
- Yith Woocommerce Ajax Product Filter
- Woocommerce Stripe Payment Gateway
- Paypal Payments
- Stock Manager For Woocommerce
- Woocommerce Wholesale Prices
- Iconic Woothumbs
- Aelia Currencyswitcher
- Yith Woocommerce Stripe
- Trustpulse
- Pretty Links
- Restropress
- Advanced Shipment Tracking For Woocommerce
- Dokan
- Woocommerce Product Recommendations
- Content Restriction By Userrole
- Members Content
- Academypress
- Ultimatemember Friends
- Content Control Cm
- Ultimatemember Verified Users
- Wpadverts
- Memberpress Coachkit
- Paid Memberships Pro
- Ontrapages
- Buddypress Docs
- Pmpro Subscription Delays
- Swpm Buddypress Integration
- Profile Magic
- Ultimatemember Content Restriction