Staff Import – Import Preview

WordPress Plugin Staff List CSV – Staff Import – Import Preview.

Import Preview is the last step before Import. Import preview doesn’t create any staff members. It loads CSV data into a staging (temporary) table. Content of this table is displayed on the screen and will be used in the next, final step – insert staff member records into WordPress database.
It is a good time to look at the table and check if all required data is included and mapped to appropriate Staff List fields. If not, go back and change the settings. Next, refresh the preview table until you’re satisfied with the result.
You can run import preview procedure multiple times. No staff member records will be added.

Import Preview – loading data (refresh).

1. Click Refresh Import Preview to populate the staging table with content of the CSV file.
2. Data is loading. Wait until finished.
3. CSV file is parsed and successfully loaded into a staging (temporary) table.
4. Click tab Import Preview to refresh the stats.
5. Data in the staging table is ready for a review.
  • Post ID. Should be 0.
  • CSV Row. Your CSV file row number.
  • CSV Column Name. Should match CSV column names. Only mapped columns are listed.
  • Staff List Field. Names come from Staff List template selected in Import Options. Only mapped columns are listed.
  • CSV Data. CSV values mapped to the staff list template (Field Mapping).
  • Meta Fields. Used in import process. Disregard this column.
Data Review
  1. All rows from CSV file are added to the import preview table?
  2. Expected qty = Import preview qty?
  3. All CSV columns are mapped (CSV Column Name)?
  4. Is CSV data mapped to the right fields (CSV Column Name <-> Staff List Field)?

Import Preview Timeout

Please disregard this section unless you’ll run into timeout error.
Why the timeout error.
PHP timeout error means that a PHP operation you’ve requested was taking too long to complete and was shut down. Every WordPress site has a maximum execution time limit for processing server requests. This looks at all the PHP scripts running on your site and blocks those running past the time limit.
Most hosting companies enforce a max execution time that’s anywhere between 30 and 60 seconds. This range gives your PHP scripts enough time to complete their jobs, even if they take some time to execute. The max_execution_time WordPress error is one of the most common warnings seen in WordPress.
How to fix the timeout error.
  1. Increase the max execution time of PHP script.
  2. Split the CSV file.
The first option requires increasing the value of max_input_time. May not work, unless you have a full control of your hosting environment. Please Google for details.
The better solution is to split your CSV file into two or more files, each one containing smaller number of records. That should work, since the main reason for the error is the number of records that have to be processed in a single batch.