WordPress.org

1. alantrotter
   Member
   Posted 4 weeks ago #

   Hello,

   For a project I am doing I have a large Excel file of timed entries. I want to take this file and load it into Wordpress so that it will schedule publication. The volume of entries makes it kind of important that I automate this process rather than doing it by hand. Is there any way I can do that?

   So for example the table has date, time and entry:
   23/11/2009 | 02.25 | This entry should be published on the 23rd of November at 2.25am
   23/11/2009 | 02.35 | And this one ten minutes later

   How should I go about taking that Excel file and putting it into Wordpress to be automatically published? Any ideas?

   Thanks.

2. mtw28
   Member
   Posted 4 weeks ago #

   I was going to suggest using XML-RPC to add posts into wordpress, then using PHP and an XML parser... but thought there might be a simpler solution. Looks like someone made a plugin to import posts into wordpress from excel files, maybe it would work for you.

3. alantrotter
   Member
   Posted 4 weeks ago #

   Thank you! I will test that and report back on how it goes.

4. alantrotter
   Member
   Posted 6 days ago #

   I tried that plugin and had some problems, but this one, which does basically the same thing has worked better for me:

   CSV importer – http://wordpress.org/extend/plugins/csv-importer/

   Thanks for the help, mtw28.

Reply

You must log in to post.