Intranet & Spreadsheets

  • tomslattery

    (@tomslattery)


    16 years, 8 months ago

    Hi!

    I am developing a company intranet using WP. At the core of the site is pricing for the company’s products. It comes to me in the form of a pretty lengthy Excel spreadsheet. I’m wondering of there is anything that can take that data and turn it into something viewable in the WP world.

    My initial thought was to just paste the sheet into a page/post. But if somebody searches the site for a particular product number, I’m assuming the result will be the entire spreadsheet pasted into one page.

    My goal is that the user can search by the product number and get that single result.

    Thanks!
    ~TPS

Viewing 3 replies - 1 through 3 (of 3 total)
  • MichaelH

    (@michaelh)

    16 years, 8 months ago

    My goal is that the user can search by the product number and get that single result.

    That would imply either a post, or a page, for each product.

    Might give this a look:
    http://ww.wp.xz.cn/extend/plugins/csv-importer/

    s_ha_dum

    (@apljdi)

    16 years, 8 months ago

    You could pull that spreadsheet into a new database table then create a page for searching and displaying data from that table. It shouldn’t be too hard. You’d need a mechanism to update the product list though.

    Thread Starter tomslattery

    (@tomslattery)

    16 years, 8 months ago

    My initial test of the CSV importer concept has proven to be very useful. However, most of the fields I am importing become custom fields which do not display on the post.

    Where my ‘post’ field is the product number, the additional fields deal with pricing and related information to that particular product.

    I’m wondering how to get that additional information visible in the post.

    Thanks!
    ~TPS

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

The topic ‘Intranet & Spreadsheets’ is closed to new replies.