Prajesh Draft Importer

Prajesh Draft Importer simplifies the handoff from a marketing spreadsheet to WordPress drafts.

Select Posts, Pages, or an eligible custom post type. Download an empty CSV or Excel template with matching column names. Upload the completed sheet, review row validation, and create drafts.

• Full-width dashboard built with WordPress wp.element and wp.components.
• Headers generated from supported WordPress fields, registered single-value scalar metadata, and simple ACF fields.
• Excel field guide and supported choice dropdowns.
• Row validation and formatted previews, with 50 records per page.
• Explicit checkbox selection and confirmation before creating drafts.
• New drafts only; existing content is never updated.
• Automatic content matching helps prevent duplicate imports.
• Personal batch history with links to created drafts.

No account, paid license, external service, or tracking is required. Spreadsheet content is processed on your WordPress site. Temporary previews expire after 24 hours and are removed on completion or discard. Scheduled cleanup of abandoned previews runs through WP-Cron; its timing depends on site traffic. Import history and duplicate markers persist in the database. Files are not added to the media library.

Not every metabox exposes a field schema. Arbitrary custom-coded metaboxes, complex ACF fields, images, taxonomies, relationships, and repeater fields are not supported in this first release. ACF support requires ACF to be active and simple field groups assigned directly to the selected post type.

Excel processing requires PHP ZipArchive and SimpleXML. CSV remains available without these extensions. Processing limits are 5 MB uploads, 10,000 rows and 256 columns; Excel archives are limited to 20 MB uncompressed. Formulas are rejected: paste calculated results as values first.

Source Code and Development

The complete editable source is included in this plugin. Runtime files are authored directly and are not compiled or minified outputs.

• prajesh-draft-importer.php: plugin bootstrap.
• includes/class-pgdim-plugin.php: field discovery, validation, draft creation and history.
• includes/class-pgdim-workbook.php: bounded XLSX reading and template generation.
• assets/admin.js: plain JavaScript dashboard using WordPress-provided wp.element and wp.components. createElement calls are written directly; there is no JSX compilation.
• assets/admin.css: editable backend stylesheet.

No npm installation, webpack, bundling, transpilation or build step is required. Edit the included runtime source directly. WordPress supplies its UI and translation packages; no third-party JavaScript libraries are bundled. JavaScript translations use WordPress.org language packs, and only a development POT reference is included.