By trapper-1 on

No longer needed, issue fixed, but I will leave this here because there is a solution I posted below.

I have an very urgent need for the 'views data export 7.x' module to support SQL Server OR some custom PHP code to export data from my views to csv or xls. Send me a bid and time-frame for completion, and I will promptly respond. I can write the static query for the export in SQL Server management studio, if you can provide the php and tell me how to implement it with a button in my view.

⋅ Categories: Drupal 7.x

Comments

WorldFallz’s picture

WorldFallz commented

huh? There are already several options:

http://drupal.org/project/views_datasource
http://drupal.org/project/views_data_export
http://drupal.org/project/views_export_xls

trapper-1’s picture

trapper-1 commented

I have tried these modules to no avail. I am using MS SQL Server (views_data_export only support MySQL), and views_export_xls errors out for similar reasons. I need support for MS SQL Server database. I would be happy for you to change the views_data_export code to support SQL Server, but if you want to provide some custom module that is fine also. My end-result is a button at the top of my view where the user can click and the php will execute and create the xls or csv file and open it. thanks.

WorldFallz’s picture

WorldFallz commented

ah, ok-- I just noticed you posted to the views_data_export issue queue. imo, that's the right approach. You might get a better response here by updating this thread to request a fix for that error instead of writing a completely new module. I don't have access to mssql anywhere atm or i would try to help.

trapper-1’s picture

trapper-1 commented

thanks. Yeah, I really think that the views_data_export module would work great for me, and I would prefer to find someone that can alter that module to support SQL Server. I am playing around with it, but I would happily pay someone who knows exactly what they are doing to fix this for me, if they can get it done quickly.

trapper-1’s picture

trapper-1 commented

for anyone else reading this with a similar issue, all you have to do is turn off the 'batched' property for the export view. I did this and everything worked great.