Skip navigation
suraj_0008
suraj_0008 Calculating status...
Currently Being Moderated

Export table data into CSV

Apr 16, 2012 11:26 AM

Categories: Web Apps Tags: #csv #export_to_csv

Hello All, I am new to BC, I wants to export data into CSV file. Quick response will be appreciated.

1787 Views   8 Replies   Latest reply: suraj_0008, Apr 18, 2012 4:43 AM
 
Replies
  • Sidney Mitchell
    Currently Being Moderated
    1. Sidney Mitchell,
    Apr 16, 2012 11:45 AM   in reply to suraj_0008
    Report

    Hi suraj_0008!

     

    If needing to export data from your site please create a report (Reports -> Custom Reports) then after generating the report the system will present a series of option to export (pdf, csv, xls) file type.

     

    See the step by step guide below...

     

    - http://kb.worldsecuresystems.com/212/bc_2123.html

     

    Kind regards,

    -Sidney

     
    |
    Mark as:
  • suraj_0008
    Currently Being Moderated
    2. suraj_0008,
    Apr 16, 2012 12:22 PM   in reply to Sidney Mitchell
    Report

    Hello Sidney, Thank you for your quick reply, but the solution you have given me worked at only Admin side. I wants to implement the export csv functionality at the client side.

    So, that any visitior of my website can come and download data into csv.

    There should be definitaly any option for doing that, but I have not find it yet. If you know anysuch thing then please reply me.

     

    Thank you

    ~Suraj

     
    |
    Mark as:
  • Sidney Mitchell
    Currently Being Moderated
    3. Sidney Mitchell,
    Apr 16, 2012 12:26 PM   in reply to suraj_0008
    Report

    Oh I see what you are fully after. 

     

    We don't have a "front-end" feature for this as the only option would require you to upload the CSV file to the site.  Then to use the literature feature so clients can download the CSV file. 

     

    - http://kb.worldsecuresystems.com/665/bc_665.html

     

    -Sidney

     
    |
    Mark as:
  • suraj_0008
    Currently Being Moderated
    4. suraj_0008,
    Apr 17, 2012 12:16 AM   in reply to Sidney Mitchell
    Report

    Hello Sidney, My feeling is that, there should be definitely a way of doing it. What just I needs to do is to make one server call to any scripting file like AXPS or can say PHP, if it supports.

    So, can you please tell me how can I make one create AXPS file in business catalyst and where can I store that file, so that, that file can be accessible once I hit a button for exporting the data.

     
    |
    Mark as:
  • mario_gudelj
    1,578 posts
    Oct 13, 2010
    Currently Being Moderated
    5. mario_gudelj,
    Apr 17, 2012 12:21 AM   in reply to suraj_0008
    Report

    Hi suraj_0008,

     

    There definitely isn't a way to do it. You can not run server side scripts on BC of any kind, and do not have a direct database access. If this your requirement you will need to use a different platform that allows for this.

     

    Cheers,

     

    Mario

     
    |
    Mark as:
  • suraj_0008
    Currently Being Moderated
    6. suraj_0008,
    Apr 17, 2012 12:45 AM   in reply to mario_gudelj
    Report

    Hello mario_gudelj,

     

    Thank  you for your response. But, if data can be export from Admin side then why we can't do it from the client side. I am accepting that BC won't allow us to write any server side scripts. But here should be definitely a way of exporting data in CSV to the client side.

     

    Thanks

    Suraj

     
    |
    Mark as:
  • mario_gudelj
    1,578 posts
    Oct 13, 2010
    Currently Being Moderated
    7. mario_gudelj,
    Apr 17, 2012 6:11 PM   in reply to suraj_0008
    Report

    Hi Suraj,

     

    We've had this feature before in BC where you were able to create a customer report and publish it inside the secure zone for the logged in customers to download. This feature has been removed. I don't know for which reason. Most likely because it was extremelly underutilised. In any case, you will need to generat those files through reports and publish them on your site.

     

    Cheers,

     

    Mario

     
    |
    Mark as:
  • suraj_0008
    Currently Being Moderated
    8. suraj_0008,
    Apr 18, 2012 4:43 AM   in reply to mario_gudelj
    Report

    WOW, I got a solution for this, now I can export csv from client end. Ofcourse BC doesn't support any server side scripting, but you can use any other scripting language and can integrate with BC. And than that starts running...

     

    Cheers

    Suraj

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points