This version adds a link to Community and Support forum for your convenience. It also checks if Twig Anything plugin is active and installed, and shows a notice if it is not. This is not a critical update.<\/p>"},"ratings":{"1":0,"2":0,"3":0,"4":0,"5":0},"assets_icons":[],"assets_banners":{"banner-772x250.png":{"filename":"banner-772x250.png","revision":"1208691","resolution":"772x250","location":"assets"}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":[],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":"1208086","resolution":"1","location":"assets"},"screenshot-2.png":{"filename":"screenshot-2.png","revision":"1208086","resolution":"2","location":"assets"},"screenshot-3.png":{"filename":"screenshot-3.png","revision":"1208086","resolution":"3","location":"assets"}},"screenshots":{"1":"The slick Data Source settings panel with CSV format selected and custom format configuration fields: Delimiter character, Enclosure character and Escape character.","2":"An example of CSV format in action: a CSV file with country names and their corresponding top-level domain names is parsed, and then only countries that start with \"D\" are displayed.","3":"A Twig Template that uses CSV data and outputs an example shown on the previous screenshot."},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[62061,62063,567,62058,6590],"plugin_category":[],"plugin_contributors":[90977],"plugin_business_model":[],"class_list":["post-37843","plugin","type-plugin","status-publish","hentry","plugin_tags-comma-separated-values","plugin_tags-comma-separated","plugin_tags-csv","plugin_tags-csv-api","plugin_tags-excel","plugin_contributors-meglio","plugin_committers-meglio"],"banners":{"banner":"https:\/\/ps.w.org\/twig-anything-csv\/assets\/banner-772x250.png?rev=1208691","banner_2x":false,"banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/twig-anything-csv_bfccb5.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/twig-anything-csv\/assets\/screenshot-1.png?rev=1208086","caption":"The slick Data Source settings panel with CSV format selected and custom format configuration fields: Delimiter character, Enclosure character and Escape character."},{"src":"https:\/\/ps.w.org\/twig-anything-csv\/assets\/screenshot-2.png?rev=1208086","caption":"An example of CSV format in action: a CSV file with country names and their corresponding top-level domain names is parsed, and then only countries that start with \"D\" are displayed."},{"src":"https:\/\/ps.w.org\/twig-anything-csv\/assets\/screenshot-3.png?rev=1208086","caption":"A Twig Template that uses CSV data and outputs an example shown on the previous screenshot."}],"raw_content":"\n
Read CSV data from local files, WordPres media files, local or remote databases or 3rd party API, and output it anywhere in WordPress with using shortcodes, in posts\/pages, headers\/footers, widgets or in Visual Composer.<\/p>\n\n
You can configure how CSV is parsed by specifying delimiter character, enclosure character and escape character.<\/p>\n\n
This is a free add-on that adds CSV support (comma-separated values) to the\nTwig Anything<\/a> WordPress plugin.<\/em><\/p>\n\n Tutorials below demonstrate 3 examples:<\/p>\n\n Let us use a CSV file with a list of countries and their corresponding top-level domain names (TLD). Here is an extract from the file:<\/p>\n\n In our example, let's display TLDs for all countries that start with \u201cD\u201d:<\/p>\n\n Columns are numbered starting from #0, so we will need the column #0 (country name) and #5 (top-level domain name).<\/p>\n\n After the CSV input has been parsed, the resulting lines are passed to your Twig Template as the data<\/strong> variable. You can then loop over it with using \u201cfor\u201d syntax:<\/a>:<\/p>\n\n Let us take a closer look at this piece: First of all, Inside the loop, we output a country name with using Using the same CSV file, let's now output our data in a table with using HTML markup.<\/p>\n\n If you are not very familiar with HTML, I recommend going through the following tutorials - you'll learn in 10 minutes, I guarantee!<\/p>\n\n You can also use the following table generators and just copy-paste the HTML they generate right into your template. The generators also allow to apply some basic styling, like borders, colors, margins, paddings etc.<\/p>\n\n So, we will use the following HTML tags:<\/p>\n\n Here is our template:<\/p>\n\n Notice how we use the Actually, you can use just any HTML and stylize your table the way you need.\nJust don't forget to put While you prepare your template, you usually preview it many times by clicking\nthe \"Preview Changes\" button. Once you are happy with the preview, you will\nwant to embed it somewhere - in a post or a page, footer \/ header,\nin a widget or as a Visual Composer block.<\/p>\n\n To embed your template, you will use a shortcode:<\/p>\n\n In WordPress, every Twig Template has its own slug, just like posts and pages.\nIt can be found under the template title.<\/p>\n\n Alternatively, you can use the template ID:<\/p>\n\n Automatic installation is the easiest option as WordPress handles the file transfers itself and you don\u2019t need to leave your web browser. To do an automatic install of Twig Anything CSV, log in to your WordPress dashboard, navigate to the Plugins menu and click Add New.<\/p>\n\n In the search field type \u201cTwig Anything CSV\u201d and click Search Plugins. Once you\u2019ve found the plugin, you can view details about it such as the the point release, rating and description. Most importantly, of course, you can install it by simply clicking \u201cInstall Now\u201d.<\/p>\n\n The manual installation method involves downloading our CSV (comma separated values) format plugin and uploading it to your webserver via your favourite FTP application. The WordPress codex contains instructions on how to do this here<\/a>.<\/p>\n\n Automatic updates should work like a charm; as always though, ensure you backup your site just in case.<\/p>\n\n Because this is an add-on for the\nTwig Anything<\/a> WordPress plugin,\nit can fetch your CSV input from various sources: a local file,\na URL, a MySQL database (out of the box) and many more\nwith custom data source add-ons.<\/p><\/dd>\n Yes<\/strong>, you can specify any delimiter character (one character only).<\/p>\n\n If you want to use By default, the delimiter character is set to a comma \",<\/strong>\".<\/p><\/dd>\n Yes<\/strong>, you can specify any enclosure character (one character only).<\/p>\n\n By default, its value is double-quotes \"<\/strong><\/p><\/dd>\n Yes<\/strong>, you can specify any escape character (one character only).<\/p>\n\n By default, its value is a backslash \"\<\/strong>\"<\/p><\/dd>\n In your Twig Anything template, use the Twig's \"for\" syntax<\/a>.\nFor example:<\/p>\n\n Note that the the sequence of all CSV lines is always passed to your template as data<\/strong> variable\nand in the same order as it appears in the parsed data source (e.g. a .csv file).<\/p><\/dd>\n Columns are indexed starting from 0, so to access the content of the first column,\nuse \n
EXAMPLE 1: MULTILINE TEXT<\/h4>\n\n
Belgium,Brussels,EUR,Euro,BE,.be\nBelize,Belmopan,BZD,Dollar,BZ,.bz\nBenin,Porto-Novo,XOF,Franc,BJ,.bj\nBhutan,Thimphu,BTN,Ngultrum,BT,.bt\n<\/code><\/pre>\n\nDenmark - .dk\nDjibouti - .dj\nDominica - .dm\nDominican Republic - .do\n<\/code><\/pre>\n\n{% for row in data if row.0|slice(0,1)|upper == 'D' %}\n {{ row.0 }} - <strong>{{row.5}}<\/strong><br\/>\n{% endfor %}\n\n{% for row in data %}...{% endfor %} is the loop. The code inside the loop will be rendered once for every line from the CSV file.\n<\/code><\/pre>\n\nif row.0|slice(0,1)|upper == 'D'<\/code><\/p>\n\nrow.0<\/code> is how we access column #0, a country name in our case. Next, |slice(0,1)<\/code> is a Twig filter that takes the first character of the country name. The next filter is |upper<\/code> and it simply uppercases the first letter returned by the previous filter. Finally, we only allow for countries that start with the \u201cD\u201d letter: == 'D'<\/code>.<\/p>\n\n{{row.0}}<\/code> and a TLD name with using {{row.5}}<\/code>. Plus a very basic HTML markup: <br\/><\/code> to insert a line break and <strong>...<\/strong><\/code> to make TLD name appear bold.<\/p>\n\nEXAMPLE 2: TABLE<\/h4>\n\n
\n
\n
\n
<table>...<\/table><\/code> to make a table<\/li>\n<thead>...<\/thead><\/code> to make a table header with column headings<\/li>\n<tbody>...<\/tbody><\/code> to make a table body with all the rows from CSV<\/li>\n<tr>...<\/tr><\/code> to make a table row<\/li>\n<th>...<\/th><\/code> to make a cell in the header's row<\/li>\n<td>...<\/td><\/code> to make a cell in a regular rows in the table's body<\/li>\n<\/ul>\n\n<table>\n <thead>\n <tr>\n <th>Country<\/th>\n <th>TLD<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n {% for row in data if row.0|slice(0,1)|upper == 'D' %}\n <tr>\n <td>{{ row.0 }}<\/td>\n <td>{{ row.5 }}<\/td>\n <\/tr>\n {% endfor %}\n <\/tbody>\n<\/table>\n<\/code><\/pre>\n\n{% for row in data %}<\/code> syntax to loop over CSV lines,\nand then output a table row <tr>...<\/tr><\/code> inside the loop, so that\na new row is made for every CSV line.<\/p>\n\n{{row.0}}<\/code>, {{row.1}}<\/code> etc where you want\nyour csv values in the cells <td>...<\/td><\/code>.<\/p>\n\nEXAMPLE 3: SHORTCODES<\/h4>\n\n
[twig-anything slug=\"my-template-slug\"]\n<\/code><\/pre>\n\n[twig-anything id=\"123\"]\n<\/code><\/pre>\n\n\nMinimum Requirements<\/h4>\n\n
\n
Automatic installation<\/h4>\n\n
Manual installation<\/h4>\n\n
Updating<\/h4>\n\n
\n
twig-anything-csv.zip<\/code> to the \/wp-content\/plugins\/<\/code> directory<\/li>\n\n
TAB<\/code> as the delimiter, input \\t<\/code>\nin the Delimiter Character<\/em> setting.<\/p>\n\n{% for row in data %}\n Text in the first column: {{row.0}},\n Text in the third column: {{row.2}} <br\/>\n{% endfor %}\n<\/code><\/pre>\n\n{{row.0}}<\/code>; for the second column, use {{row.1}}<\/code> and so forth.<\/p><\/dd>\n