• Good evening everyone, I am having difficulty grasping the intricacies of what I think is a fairly simple undertaking. Can anyone tell me if I’m on the right path, way in left field, or better yet, if there’s a plugin or snippet out there that would make my life a lot easier.

    I have a table in excel that is loaded with data. (ids, business-names, addresses, phone-numbers, hours, and various other schema and non-schema data-types) I want to use that data to create a post in wordpress but I’m fairly green when it comes to this sort of thing.
    Here is how I would think to go about it:

    1) I need to convert my excel spreadsheet into a .csv so I can upload it to my server. (Although I have no idea where in the server I should upload it to.)

    2) Code a php script that calls for specific columns of a row which is defined via a custom field and ‘id’ input by me. (I have a general idea how to do this but it will take me a bit of tinkering)

    3) Code a script to retrieve and display the corresponding data for some custom fields which can then be referenced within the post’s template (eg. [name], [address], etc.)

Viewing 2 replies - 1 through 2 (of 2 total)
  • Try this plugin: WP Ultimate CSV Importer

    @brau0153,

    Ultimate CSV Importer can import records with any number of custom fields. You can easily map the column headers mentioned in the CSV to the corresponding fields of WordPress. You can use the “Add Custom Field” to create new fields in WordPress if your CSV has additional fields. Name the new field and map to the additional field in the CSV. Proceed your import. You can see the custom fields and their data which is populated to the respective post.

    The above will solve the Question 1 & 2.

    For Question 3 , you need to customise it on the theme template.

    @neotechnomad
    Thanks for recommending us.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Populating custom field values for a post’ is closed to new replies.