DwZone Forum Welcome to the DwZone-it Forum     FAQ   Search   Memberlist   Usergroups       Register -->   Login   Import/Export Tools   DwZone Forum Index -> Import/Export Tools Moderators: Administrators, Moderators  Mark all topics read Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes. Search for  View  Normal Expanded Dynamic Dynamic Memory Threaded Threaded Expanded Threaded Dynamic    Per page  102550    Messages Since  Last Visit Last Day Last Week Last Month Last 6 Months Last Year All Messages 11 to 20 of 382 (Total: 233) First |  Prev |  Next |  Last    Subject Author Date      Re: ASP export to PDF    PeterMiller   13:20 31 Jul 2014      Re: ASP export to PDF    Gianluigi   13:27 31 Jul 2014      Re: ASP export to PDF    Gianluigi   13:33 31 Jul 2014      Re: ASP export to PDF    PeterMiller   3:32 8 Aug 2014      Name redefined error    Ken Pollard   8:26 13 May 2014      Re: Name redefined error    Gianluigi   10:08 13 May 2014      Re: Name redefined error    Ken   10:53 13 May 2014       My Export.csv function stop working since 2 months    Jitendra Dhamani   20:36 23 Mar 2014     Hi, My Export.csv function stop working since 2 months, it shows double headers in chrome and exports Export.asp file in IE only. Any help in fixing this would be highly appreciated. Below is coding. <%@LANGUAGE="VBSCRIPT"%> <!--#include virtual="/Connections/conn.asp" --> <% Dim rsOrders Dim rsOrders_numRows Set rsOrders = Server.CreateObject("ADODB.Recordset") rsOrders.ActiveConnection = MM_conn_STRING rsOrders.Source = "SELECT orders.*, users.* FROM (users INNER JOIN orders ON users.userid = orders.user_id) ORDER BY id DESC" rsOrders.CursorType = 0 rsOrders.CursorLocation = 2 rsOrders.LockType = 1 rsOrders.Open() rsOrders_numRows = 0 %> <% '*********************** ' http://www.DwZone.it ' Csv Writer ' Version 1.2.0 ' Start Code '*********************** Dim dwzCsv_rsOrders Set dwzCsv_rsOrders = new dwzCsvExport dwzCsv_rsOrders.Init dwzCsv_rsOrders.SetFileName "Orders-Export.csv" dwzCsv_rsOrders.SetNumberOfRecord "ALL" dwzCsv_rsOrders.SetStartOn "ONLOAD", "" dwzCsv_rsOrders.SetFieldSeparator "," dwzCsv_rsOrders.SetFieldLabel "true" dwzCsv_rsOrders.SetRecordset rsOrders dwzCsv_rsOrders.SetEncloseField "No" dwzCsv_rsOrders.addItem "id", "id", "String" dwzCsv_rsOrders.addItem "order_type", "order_type", "String" dwzCsv_rsOrders.addItem "order_number", "order_number", "String" dwzCsv_rsOrders.addItem "order_code", "order_code", "String" dwzCsv_rsOrders.addItem "invoice_number", "invoice_number", "String" dwzCsv_rsOrders.addItem "din", "din", "String" dwzCsv_rsOrders.addItem "samay", "samay", "String" dwzCsv_rsOrders.addItem "month_year", "month_year", "String" dwzCsv_rsOrders.addItem "ship_date", "ship_date", "String" dwzCsv_rsOrders.addItem "payment", "payment", "String" dwzCsv_rsOrders.addItem "order_status", "order_status", "String" dwzCsv_rsOrders.addItem "sale_from", "sale_from", "String" dwzCsv_rsOrders.addItem "payment_method", "payment_method", "String" dwzCsv_rsOrders.addItem "serial_number", "serial_number", "String" dwzCsv_rsOrders.addItem "courier", "courier", "String" dwzCsv_rsOrders.addItem "tracking_number", "tracking_number", "String" dwzCsv_rsOrders.addItem "user_id", "user_id", "String" dwzCsv_rsOrders.addItem "username", "username", "String" dwzCsv_rsOrders.addItem "email", "email", "String" dwzCsv_rsOrders.addItem "company_name", "company_name", "String" dwzCsv_rsOrders.addItem "vat_country", "vat_country", "String" dwzCsv_rsOrders.addItem "vat_number", "vat_number", "String" dwzCsv_rsOrders.addItem "gender", "gender", "String" dwzCsv_rsOrders.addItem "first_name", "first_name", "String" dwzCsv_rsOrders.addItem "last_name", "last_name", "String" dwzCsv_rsOrders.addItem "billing_address", "billing_address", "String" dwzCsv_rsOrders.addItem "billing_address2", "billing_address2", "String" dwzCsv_rsOrders.addItem "billing_postal_code", "billing_postal_code", "String" dwzCsv_rsOrders.addItem "billing_city", "billing_city", "String" dwzCsv_rsOrders.addItem "billing_state", "billing_state", "String" dwzCsv_rsOrders.addItem "billing_country", "billing_country", "String" dwzCsv_rsOrders.addItem "billing_telephone", "billing_telephone", "String" dwzCsv_rsOrders.addItem "billing_fax", "billing_fax", "String" dwzCsv_rsOrders.addItem "shipping_country", "shipping_country", "String" dwzCsv_rsOrders.addItem "same_as_billing", "same_as_billing", "String" dwzCsv_rsOrders.addItem "shipping_gender", "shipping_gender", "String" dwzCsv_rsOrders.addItem "shipping_first_name", "shipping_first_name", "String" dwzCsv_rsOrders.addItem "shipping_last_name", "shipping_last_name", "String" dwzCsv_rsOrders.addItem "shipping_company_name", "shipping_company_name", "String" dwzCsv_rsOrders.addItem "shipping_address", "shipping_address", "String" dwzCsv_rsOrders.addItem "shipping_address2", "shipping_address2", "String" dwzCsv_rsOrders.addItem "shipping_postal_code", "shipping_postal_code", "String" dwzCsv_rsOrders.addItem "shipping_city", "shipping_city", "String" dwzCsv_rsOrders.addItem "shipping_state", "shipping_state", "String" dwzCsv_rsOrders.addItem "shipping_telephone", "shipping_telephone", "String" dwzCsv_rsOrders.addItem "shipping_fax", "shipping_fax", "String" dwzCsv_rsOrders.addItem "product_type", "product_type", "String" dwzCsv_rsOrders.addItem "master_name", "master_name", "String" dwzCsv_rsOrders.addItem "selling_title", "selling_title", "String" dwzCsv_rsOrders.addItem "descriptions", "descriptions", "String" dwzCsv_rsOrders.addItem "qty", "qty", "String" dwzCsv_rsOrders.addItem "mudra", "mudra", "String" dwzCsv_rsOrders.addItem "price_unit", "price_unit", "String" dwzCsv_rsOrders.addItem "cost_unit_jrd", "cost_unit_jrd", "String" dwzCsv_rsOrders.addItem "cost_unit_rs", "cost_unit_rs", "String" dwzCsv_rsOrders.addItem "discounts", "discounts", "String" dwzCsv_rsOrders.addItem "base_ship", "base_ship", "String" dwzCsv_rsOrders.addItem "incr_ship", "incr_ship", "String" dwzCsv_rsOrders.addItem "qty_total", "qty_total", "String" dwzCsv_rsOrders.addItem "trans_fee", "trans_fee", "String" dwzCsv_rsOrders.addItem "extra_charges", "extra_charges", "String" dwzCsv_rsOrders.addItem "refund_amt", "refund_amt", "String" dwzCsv_rsOrders.addItem "freight_ntd", "freight_ntd", "String" dwzCsv_rsOrders.addItem "user_ip", "user_ip", "String" dwzCsv_rsOrders.addItem "portal_name", "portal_name", "String" dwzCsv_rsOrders.addItem "email_code", "email_code", "String" dwzCsv_rsOrders.addItem "stock_code", "stock_code", "String" dwzCsv_rsOrders.addItem "company", "company", "String" dwzCsv_rsOrders.addItem "cart_id", "cart_id", "String" dwzCsv_rsOrders.addItem "shipping_instructions", "shipping_instructions", "String" dwzCsv_rsOrders.addItem "notes", "notes", "String" dwzCsv_rsOrders.Execute() '*********************** ' http://www.DwZone.it ' Csv Writer ' End Code '*********************** %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/template_admin.dwt" codeOutsideHTMLIsLocked="false" --> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <!-- InstanceBeginEditable name="doctitle" --> <title>KingBattery - Admin</title> <!-- InstanceEndEditable --> <link rel="stylesheet" type="text/css" href="/siteassist_css/template_admin.css" /> <SCRIPT language="JavaScript1.2"> window.onerror=function(){return true;} </SCRIPT> <!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable --> <style type="text/css"> <!-- .style1 {color: #786F69} --> </style> </head><body onload=""> <div id="globalContainer"> <div id="topHead"> <div style="clear: left;"><img src="/images/kb_Logo.gif" alt="Logo" border="0" /></div> </div> <div class="topNavTable" id="topNavOuter"> <div id="topNav"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td> <div align="right" id="SAW_TopNavigation"><span class="style1"><a href="/admin_area/orders/Results.asp?S_order_type=&S_payment_method=&S_tracking_number=&S_order_number=&S_order_status=Not Shipped&S_type_name_en=&S_order_code=&S_sale_from=&S_subtype_name_en=&S_invoice_number=&S_username=&S_inventory_name=&S_din=&S_billing_country=&S_inventory_code=&S_month_year=&S_user_ip=&S_selling_title=&S_ship_date=&S_serial_number=&S_portal_name=&S_payment=&S_courier=&S_notes=&S_mode=Not Shipped&Search.x=33&Search.y=9">Orders</a> | <a href="/admin_area/customers/customers/Results.asp?S_userid=&S_company_name=&S_user_type=&S_first_name=&S_user_from=&S_last_name=&S_username=&S_email=&S_billing_country=&S_shipping_instructions=&S_reg_date=&S_news_letters=&Search.x=46&Search.y=14">Customers</a> | <a href="/admin_area/statics/product/Results.asp">Statics</a> | <a href="/admin_area/products/inventory/Results.asp?S_inventoryid=&S_type=&S_product_type=&S_voltage=&S_product_subtype=&S_capacity=&S_inventory_name=&S_color=&S_inventory_code=&S_photo=&S_short_description=&S_stock=&S_long_description=&S_part_number=&S_description=&S_compatible_model=&Search.x=43&Search.y=15">Products</a> | <a href="/admin_area/shipping_fee/Results.asp">Shipping Fee</a> | <a href="/admin_area/inquiry/Results.asp">Inquiry</a> | <a href="/admin_area/rates/exchange/Results.asp">Rates</a> | <a href="/admin_area/bank_accounts/Results.asp?S_company_name=JRD+Company+Ltd.&S_long_description=&S_bank_name=&S_value_date=&S_account_type=&S_debit_out=&S_entry_date=&S_credit_in=&S_bank_description=&S_checked=&S_mode=JRD&Search.x=26&Search.y=15">Bank Accounts</a> | <a href="/admin_area/expenses/listing_fee/Results.asp?S_listing_fee_id=&S_country=&S_update_date=&S_mudra2=&S_month_year2=&S_listing_fee=&S_portal=&S_total_qty=&Search.x=42&Search.y=15">Expenses</a> | <a href="/admin_area/portals/Results.asp?S_portalsid=&S_name=&S_status=&S_country=&S_incharge=&S_type=&S_notes=&Search.x=41&Search.y=13">Portals</a> | <a href="#">Logout</a>   </span></div></td> </tr> <tr> <td><!-- InstanceBeginEditable name="Admin-MenuBar" --> <ul id="SAW_TopNavigation_02"> </ul> <!-- InstanceEndEditable --> <div id="SAW_TopNavigation_03"></div> </td></tr> </table> <div style="clear: left;"> </div> </div> <div style="clear: both;"></div> </div> <div id="innerContainer"> <div id="innerRight"><!-- InstanceBeginEditable name="PageBody" --> <h1>Orders - (All) </h1> <br /> <strong>Export Record </strong> <br /> <hr /> <p>Export Orders Records has been completed...<br /> <br /> </p> <!-- InstanceEndEditable --></div> <br /> </div> <div id="topNav-2"></div> </div> </body> <!-- InstanceEnd --></html> <% rsOrders.Close() Set rsOrders = Nothing %> <!--#include virtual="/dwzExport/CsvExport.asp" -->          Re: My Export.csv function stop working since 2 months    Gianluigi   10:48 24 Mar 2014      Re: My Export.csv function stop working since 2 months    Jitendra Dhamani   19:50 24 Mar 2014   Last Visit: Sunday 28 Apr, 2024 4:18 pm First |  Prev |  Next |  Last    Login Username:  Password:   Log me on automatically each visit:   Read Message   Unread message Read message [popular]   Unread message [popular] Read message [locked]   Unread message [locked] All times are GMT-2 Jump to:  Select a forum    Php Extensions --------------------  » Advanced Form Controls  » Advanced Image Gallery  » Advanced Mail  » Advanced Search  » Ajax DataGrid  » Ajax loader  » Boolean Update  » Dynamic Captcha Image  » Dynamic Chart  » Dynamic Image  » Form Validator  » Google Maps  » HTML to PDF  » Import/Export Tools  » Multi Column Combo  » Multiple file upload  » Multiple Record  » Other extensions  » PayPal IPN  » Query Manager and Recordset Wizard  » Recordset Paging  » Server Side Validation  » Shopping Cart  » Site Search Engine  » TreeView  » Two tables manager  » Upload and resize  » WYSIWYG Html Editor  Asp Extensions --------------------  » Advanced Form Controls  » Advanced Image Gallery  » Advanced Search  » Advanced Mail  » Ajax DataGrid  » Ajax loader  » Asp TreeView  » Asp Upload and Resize  » Boolean Update  » Dynamic Captcha Image  » Dynamic Chart  » Dynamic Image  » Form Validator  » Google Maps  » HTML to PDF  » Import/Export Tools  » Multi Column Combo  » Multiple file upload  » Multiple Record  » Other extensions  » PayPal IPN  » Query Manager and Recordset Wizard  » Recordset Paging  » Routing Map24  » Server Side Validation  » Shopping Cart  » Site Search Engine  » Two tables manager  » WYSIWYG Html Editor