Results 1 to 4 of 4

Thread: Change export format

  1. #1
    sortsol is offline Junior Member
    Join Date
    Jun 2006
    Posts
    1

    Default Change export format

    Hi all,

    First time poster. I have been using the product for a while, but have never had to post before.

    Anyway, the default export from the Leads screen exports all the data in 2 big rows in a csv file. The first row being the database field names and the second row being the data.

    I would like to change it so that everthing is in two columns instead. First column being the field names and second column the data.

    I have isolated the code where I think it needs to be changed. It is in export.php in the export() function. I can't seem to manipulate the code correctly though to display how I want it to.

    Any help would be appreciated.

    Thanks,

    Mike

  2. #2
    sacramentojoe is offline Sugar Community Member
    Join Date
    Nov 2005
    Posts
    447

    Default Re: Change export format

    Quote Originally Posted by sortsol
    Hi all,

    First time poster. I have been using the product for a while, but have never had to post before.

    Anyway, the default export from the Leads screen exports all the data in 2 big rows in a csv file. The first row being the database field names and the second row being the data.

    I would like to change it so that everthing is in two columns instead. First column being the field names and second column the data.

    I have isolated the code where I think it needs to be changed. It is in export.php in the export() function. I can't seem to manipulate the code correctly though to display how I want it to.

    Any help would be appreciated.

    Thanks,

    Mike
    Hi Mike, I don't fully understand what it is that you want. Columns are more for Excel and not csv. You can open the csv into Excel and it should display in Columns where each of the commas are. When I open it up in Excel it appears to export the way you want. The top row (the labels) become headers in Excel and the rest of the rows filter in accordingly.

  3. #3
    kingjatin is offline Senior Member
    Join Date
    May 2010
    Location
    India
    Posts
    35

    Default Re: Change export format

    Hi ,

    I have custom module made for persons, where I have my some custom fields that i enter.

    But when I am exporting the records I get all the fields including the system ones as well.

    I need to limit the number of fields to be exported, can you please let me know of the file or function to modify my custom module.

    thanks

  4. #4
    loisal is offline Member
    Join Date
    May 2010
    Posts
    5

    Default Re: Change export format

    Using a Crystal report viewer in the .NET application can make the rpt file open in the web page. You will not be able to make changes to the viewer’s options that are provided. However, you can use the following code to export to a desired format through the application.
    boReportDocument.ExportToDisk(ExportFormatType.Por tableDocFormat,"c:\\temp\\myRpt.pdf");

Thread Information

Users Browsing this Thread

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

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
  •