Each table has the ability to import or export rows with just a few clicks. Shop managers can use this CSV file to manage rates in a spreadsheet program, or to duplicate rows quickly.
To export your table rows you must first select which rows you want to export. Checking the box at the beginning of each row indicates which rows should be added to the CSV file. Marking the checkbox in either the header or footer of the table will select all rows. Click the Export link below the table when finished selecting your rows export. The screen will fade to black for a moment with the word ‘Exporting’ in the center. When complete, a prompt will appear asking you to save the newly created CSV file to your computer.
Importing your rows again is even simpler than exporting. When you are ready to add new rows to the table, click the Import link beneath the table you wish to add the rows to. A small pop-up window will appear asking you to select the CSV file you wish to import. Click the Choose File button and search for the desired file on your computer. Once selected, click the Import button at the bottom of the pop-up window. A waiting cursor will appear momentarily. If the uploaded data is successfully validated, the pop-up window will disappear and the new rows will be appended to the end of the table.
An example import file is included in the root directory of the plugin. There is also an image that clarifies what you should expect after importing, but it may help more to setup a few rows and export them. This way you have an example that pertains to your own shipping model.
In some cases you may run into a problem with either of these tasks. If you receive an error message in CSV file rather than the exported data, please ensure the following:
- You must be using a recent version of your web browser that supports dynamic file handling
- Data streaming must be enabled in your PHP configuration by listing ‘data’ and ‘php’ in the setting Registered PHP Streams
- The setting allow_url_fopen must be set to ‘On’ in your PHP configuration