Results 1 to 3 of 3

Thread: How can I export everything to a CSV file?

  1. #1
    petruzzo is offline Sugar Community Member
    Join Date
    Feb 2010
    Posts
    15

    Default How can I export everything to a CSV file?

    I'm trying to export everything in my Sugar installation to a CSV file. I can see how to get just the accounts, or just the leads, or just the notes, but I can't find a way to do all of it.

    I'm using version 5.5.1 because I don't have the latest PHP.

    Can someone help me out here?

  2. #2
    Angel's Avatar
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: How can I export everything to a CSV file?

    You can't do this from within Sugar itself. You need to get access to the MySQL sever via an admin tool such as phpMyAdmin or SQLyog and use that to export the database.
    Regards,

    Angel Magaña
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________

  3. #3
    rafael.q.g@hotmail.com's Avatar
    rafael.q.g@hotmail.com is offline Sugar Community Member
    Join Date
    Jun 2011
    Location
    Florianópolis - Brazil
    Posts
    782

    Default Re: How can I export everything to a CSV file?

    From some MySQL Admin tool, as MySQL Administrator or workbeanch you can export its data in many formats, as: csv, xls, sql and so on.
    Rafael Queiroz Gonçalves
    Advanced OMG UML Certified Professional
    Sun Certified Enterprise Architect for the Java Platform
    Sun Certified Programmer for the Java 2 Platform
    IBM Certified Advanced Application Developer - Lotus Notes and Domino
    IBM Certified Application Developer - IBM WebSphere Portlet Factory
    Computer Science Mastering / UFSC - PPGCC

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How To Export Custom Fields Into CSV File?
    By strzyze8 in forum General Discussion
    Replies: 3
    Last Post: 2010-10-15, 05:28 PM
  2. Email column in Export File
    By pedro78 in forum Help
    Replies: 0
    Last Post: 2010-03-01, 11:23 AM
  3. export as tab separated values file
    By Systems Navigator in forum Developer Help
    Replies: 3
    Last Post: 2010-01-18, 04:51 PM
  4. Replies: 0
    Last Post: 2005-09-17, 02:33 PM
  5. Import/Export file delimiter, currency format
    By malcolmh in forum Feature Requests
    Replies: 3
    Last Post: 2005-07-05, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •