With CSVPiG Pro you can import any number of columns and you do not need to specify any particular column headers.

Instead everything is controlled after uploading by mapping column headers to particular WordPress content elements.

Click on the add new template link in the Post Templates section

Enter a descriptive name in template name.

Assuming you have already uploaded your CSV file you will see a list of the available tokens which can be used to design your post template. These are the column headers of your CSV file.

You can drag and drop these tokens into any of the WordPress content elements you wish. For instance you can drag %title% into the Title: field etc.

• Title: the title of the WordPress post

• Slug: the string that is used when displaying the URL of the post. You can import your own separate column for custom post slugs. I usually just use the title token. If you do decide to use custom post slugs try to focus on the keywords that are used on popular search queries, and remember that the fewer keywords you use, the higher their relative value.

• Post: the main content body of your WordPress post. The post textarea in the template editor has been replaced with a TinyMCE WYSIWYG editor. The enabled buttons are mostly for formatting and inserting links and images. There’s also the “Full Screen” button, as well as the “HTML Source” view. If needed the user can switch back to the old field/editor by using the “toggle editor on/off” link below it. You can put any HTML or CSS you want in this area and then drag and drop the tokens into the appropriate places. Here’s an example of a typical post in HTML mode:

<h3>%csv_post_title%</h3>
%csv_post_post%

• Excerpt: Here you can a enter a token surrounded by plain text that can be used as the excerpt for the post.

• Category: the categories you want assigned to the post, multiple categories should be separated by commas in the CSV file. When saving as a CSV Excel will automatically enclose that whole field with quotes so the commas inside are not confused for field separators.

• Tags: the tags you assigned to the post, multiple tags should be separated by commas in the CSV file. When saving as a CSV Excel will enclose that whole field with quotes so the commas inside are not confused for field separators

• Custom Fields: you can map any remaining columns to custom fields in blog posts. Custom fields are an extremely powerful feature of WordPress enabling you to include a lot of additional content within your posts. The basic guide to custom fields can be read here http://codex.wordpress.org/Custom_Fields . I often use custom fields to store product specific data such as price or id and of course my actual affiliate link. There are a variety of free WordPress plugins that can then be used to include the content of particular custom fields inside your posts automatically, often in a header or footer to each post. You should drag your chosen token into the value field and choose a name for each new custom field. If you need more custom fields simply click the add custom field link to add more.

Whilst it is not strictly necessary you can use our free FieldPiG plugin to include custom fields inside your post template using WordPress short codes.
e.g. [fp]image_url[/fp]

• Author: An additional template field for setting a different post author (the default is the blog admin). The field expects author’s username. If the user does not exist in the DB, a new one will be created with a random password.

• Date: An additional template field which allows the user to override the CSVPiG scheduling and use a CSV token to specify the date/time for the post. It accepts the standard format (e.g. “2010-07-27 13:39”) as well as a number of other formats in use (e.g. “05 May 2010”, “May 5th 2010 1:12 PM”, “2010/05/05 8 AM PST”) including some dynamic ones (e.g. “-2 days”, “+3 weeks”).

• Attachments: Another addition to the templates, which enables the users to upload images to the WP Media Library. Please, not that CSVPiG does not upload the images themselves – all your images have to be already uploaded to the blog (e.g. into the /wp-content/uploads/ folder on most servers). The plugin will just link those files with your posts and allow you to use them e.g. for creating post thumbnails. The path to the image should be relative to the uploads folder (e.g. if your image is in “/wp-content/uploads/my_image.jpg”, the attachment path should be “my_image.jpg”). This also works for updating posts as well. Chat with us more about this advanced feature in the forums.