Jump to content

Welcome to DevFuse Forums

Sign In  Log in with Facebook

Create Account
Welcome to DevFuse Forums, like most online communities you must register to view or post in our community, but don't worry this is a simple free process that requires minimal information for you to signup. Be apart of DevFuse Forums by signing in or creating an account.
  • Start new topics and reply to others
  • Subscribe to topics and forums to get email updates
  • Get your own profile page and make new friends
  • Send personal messages to other members.
Guest Message by DevFuse

(View All Products)Featured Products

  • Donations

    Help fund your forum with donations, setup goals and track member donations. Offer rewards for members donating.
  • Timeslips

    Have your members submit their race times and share with others.
  • Videos

    Allows your members to submit their own videos for community viewing. Support is included for all the major video sites.
  • Forms

    Build your own forms for your members without coding experience. Support included for pm, email and topics.
  • Collections

    Build a community database of items for your members. Full features custom fields included.


[IPS] Export IP.Content database entries to CSV (Excel) format

This topic has been archived. This means that you cannot reply to this topic.
No replies to this topic

#1 News Bot

News Bot

    Dedicated Member

  • Members
  • PipPipPipPipPip
  • 1,909 posts
  • IP.Board Version:N/A

Posted 17 July 2013 - 10:08 AM

This hook exports IP.Content database records as Microsoft Excel files in .csv format.
If a demo is required I can set it up. Please PM me.
To use it go to Other Apps -> Content -> Databases -> click Manage Records near the database you want to export as .csv. and finally click on Export as CSV button. Hook has no settings.
When the .csv file is opened by Excel 2010 you have to set it to comma delimited not tab delimited to do that you open up Excel 2010 go to file -> open and open the .csv file and the options should pop up.
Disclaimer: if you have a database with thousands of records it is very possible that PHP will time out eventually or run out of memory and database entries will not be exported as expected. In order for that to happen you should have tens of thousands of records here, but you never know.
Tutorial on how to install a hook can be found here.
Worth a read: How to import a .csv file that uses UTF-8 character encoding.

View Resource