這個外掛並未在最新的 3 個 WordPress 主要版本上進行測試。開發者可能不再對這個外掛進行維護或提供技術支援,並可能會與更新版本的 WordPress 產生使用上的相容性問題。

CSV Me

外掛說明

CSV Me is a very simple plugin that allows users to add a csv file from any url or select files from their local computer. The plugin stores the files and makes the data available for use in Posts and Pages via a shortcode.

How to use CSV Me

  1. Follow the steps outlined in the Installation section to install the plugin.
  2. Open the CSV Me File Manager by using the dashboard widget or find it under the Tools section of the Admin Menu.
  3. Enter in a valid url linking to a csv file in the text box and clicking submit. Alternatively, users can select a file from their local machine and clicking save. If it is a valid csv file it will show up in your available files in the File Manager. See the frequently asked questions section for more information on valid csv file formats.
  4. Now the saved csv files are available for display using shortcodes in post and pages.

The following are examples of how to use the CSV Me shortcodes:

To display all data from a file named filename.csv:

[csv_me name='filename.csv']

Notice the underscore on csv_me, quotes around the file, and the filename.csv must match one of the files listed in the File Manager.

To display only column names of col1, col2 and col3:

[csv_me name='filename.csv' columns=’col1, col2, col3’]

This will display only col1, col2, col3, in that order, if they are valid columns listed in the File Manager. Learn more about how columns work CSV Me Documentation as well as the frequently asked questions section.

To display only rows 3 through 10:

[csv_me name='filename.csv' row_start=3 row_end=10]

Display sortable tables:

[csv_me name="example-file.csv" sortable='yes' header_style='blue']

This will display all the data in a table and allow users to sort the data by columns. The default header style is ‘blue’ however, it can be set to ‘green’ as well. It utilizes the excellent jQuery plugin called tablesorter.js.

Find out more tips on how to use the CSV Me shortcodes here: CSV Me Documentation

螢幕擷圖

  • CSV Me File Manager.
  • Example shortcode in a post.
  • Output produced by example shortcode.

安裝方式

From your WordPress Dashboard

  1. Visit ‘Plugins > Add New’
  2. Search for ‘CSV Me’.
  3. Activate CSV ME from your Plugins page.
  4. Visit CSV Me File Manager dashboard widget or find it under the Tools Admin Menu to upload new files.

From WordPress.org

  1. Download CSV Me.
  2. Upload the csv-me folder to your ‘/wp-content/plugins/’ directory.
  3. Activate CSV ME from your Plugins page.
  4. Visit CSV Me File Manager dashboard widget or find it under the Tools Admin Menu to upload new files.

常見問題集

My file is not displaying the columns correctly, what’s wrong?

Make sure that your csv file has column header values for the first row. Otherwise it will display all columns by default. Also check to make sure each column name in your shortcode matches one of the column names listed for your file in the File Manager.

Can I change the color, fonts, or other styles of my displayed tables?

Unfortunately, not at this time. All tables are displayed using the default WordPress styles.

Can I order my rows to be displayed in descending order?

Again, not at this time. However, future versions may support this feature.

I can’t upload my file I keep getting the error *does not seem to be a CSV file and was not added to your available csv files*, what is wrong?

CSV Me checks the MIME-Type and since this plugin is only meant to handle csv files there are only certain types that are saved. The following MIME types are allowed: text/comma-separated-values, text/csv, application/csv, application/excel, application/vnd.ms-excel, application/vnd.msexcel, text/plain

I cannot upload a file from my computer, what’s going on?

CSV Me uses a function, called finfo, to check what type of files are uploaded. It is a handy function but it only works in PHP 5.3 or above. A lot of hosting providers run PHP 5.2 as default. To fix this problem you can update your hosting server to run PHP 5.3. If using cPanel most providers should be similar to this: cPanel Configuration.

使用者評論

這個外掛目前沒有任何使用者評論。

參與者及開發者

以下人員參與了開源軟體〈CSV Me〉的開發相關工作。

參與者

將〈CSV Me〉外掛本地化為台灣繁體中文版

對開發相關資訊感興趣?

任何人均可瀏覽程式碼、查看 SVN 存放庫,或透過 RSS 訂閱開發記錄

變更記錄

2.0

  • Update: Added ability to allow sortable tables via shortcode
  • Fix: Improved display of data

1.1

  • Fix: Upload via url uses more secure and efficient wp_remote_get function
  • Fix: Shortcode now displays first column of the csv file correctly when spcified in shortcode
  • Fix: Shortcode ignores invalid column names

1.0

*Initial release