Title: Dieter Pfenning's Replies | WordPress.org --- # Dieter Pfenning [ ](https://wordpress.org/support/users/winball/) * [Profile](https://wordpress.org/support/users/winball/) * [Topics Started](https://wordpress.org/support/users/winball/topics/) * [Replies Created](https://wordpress.org/support/users/winball/replies/) * [Reviews Written](https://wordpress.org/support/users/winball/reviews/) * [Topics Replied To](https://wordpress.org/support/users/winball/replied-to/) * [Engagements](https://wordpress.org/support/users/winball/engagements/) * [Favorites](https://wordpress.org/support/users/winball/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 27 total) 1 [2](https://wordpress.org/support/users/winball/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/winball/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[BuddyPress Docs] Limited Access Can’t Download Attachments](https://wordpress.org/support/topic/limited-access-cant-download-attachments/) * [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [9 years, 8 months ago](https://wordpress.org/support/topic/limited-access-cant-download-attachments/#post-8406589) * Hi there, * i do have exactly the same problem. I’m using the boss theme (if this is of any interst). * Please help us. I would offer you access to our system for debugging. * Thank you for the plugin and your support. * Best wishes * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Gravity Forms To Excel AddOn] Blank page after submit](https://wordpress.org/support/topic/blank-page-after-submit-1/) * Plugin Author [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [10 years, 3 months ago](https://wordpress.org/support/topic/blank-page-after-submit-1/#post-6947807) * Hi Ben, * you are totally right regarding the error handling (exit vs return) and i am sorry for this. Thank you for your debugging and your info. * I will change that in the next version which i will try to release over the next weekend. * Best wishes * Dieter * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Gravity Forms To Excel AddOn] Row Order in Excel](https://wordpress.org/support/topic/row-order-in-excel/) * Plugin Author [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [10 years, 3 months ago](https://wordpress.org/support/topic/row-order-in-excel/#post-7222737) * Hi, * right now i just take the data from Gravity Forms in whatever order i get it. And i will need to find a way to do some kind of ordering of the data. I will put that on the wishlist. * But to be independent of the order of the data you can use VLOOKUP in Excel, please see [https://wordpress.org/support/topic/blank-fields-not-sent](https://wordpress.org/support/topic/blank-fields-not-sent) Best wishes * Forum: [Reviews](https://wordpress.org/support/forum/reviews/) In reply to: [[Gravity Forms To Excel AddOn] I installed the plugin disables access to WordPress](https://wordpress.org/support/topic/i-installed-the-plugin-disables-access-to-wordpress/) * Plugin Author [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [10 years, 4 months ago](https://wordpress.org/support/topic/i-installed-the-plugin-disables-access-to-wordpress/#post-7997793) * Finally i found the related circumstances which can cause the Addon to show the blank page of death. This was fixed in version 0.1.5.2. * When you did activate the Gravity Forms To Excel AddOn without having Gravity Forms enabled it did show the blank page of death. * Sorry for this and best wishes * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Gravity Forms To Excel AddOn] Undefined index: page](https://wordpress.org/support/topic/undefined-index-page-2/) * Plugin Author [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [10 years, 4 months ago](https://wordpress.org/support/topic/undefined-index-page-2/#post-6905504) * Hi, * in version 0.1.5.2 i added a check if $form[‘gf2excel-addon’] is defined. This might could have happened for forms with no addon settings while the addon was enabled. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Gravity Forms To Excel AddOn] Multi site](https://wordpress.org/support/topic/multi-site-51/) * Plugin Author [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [10 years, 4 months ago](https://wordpress.org/support/topic/multi-site-51/#post-7123079) * Hi, * in version 0.1.5.2 i fixed the blank page of death when Gravity Forms To Excel AddOn is activated without having Gravity Forms enabled. * Best wishes * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Gravity Forms To Excel AddOn] Multi site](https://wordpress.org/support/topic/multi-site-51/) * Plugin Author [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [10 years, 4 months ago](https://wordpress.org/support/topic/multi-site-51/#post-7122960) * Hi, * a little bit more testing brought to light, that if you do activate the Gravity Forms To Excel AddOn, without having Gravity Forms activated, in fact you get blank pages for your whole WordPress site. * **This defenitely should not happen and i will fix that in the next release.** * To fix your problem, you should activate Gravity Forms before you activate the Gravity Forms To Excel AddOn. * Best wishes * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Gravity Forms To Excel AddOn] Multi site](https://wordpress.org/support/topic/multi-site-51/) * Plugin Author [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [10 years, 4 months ago](https://wordpress.org/support/topic/multi-site-51/#post-7122959) * Hi, * could you please give me a bit more information: - Could you tell me more about your configuration (WordPress and Gravity Forms versions) * What i can say is, that my test environment is a multiste, where i do not have any problems with the addon. But that does not mean, that your environment can cause problems… * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Gravity Forms To Excel AddOn] Undefined index: page](https://wordpress.org/support/topic/undefined-index-page-2/) * Plugin Author [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [10 years, 4 months ago](https://wordpress.org/support/topic/undefined-index-page-2/#post-6905501) * Hi, * i’m sorry that you do have problems with my addon. * Looking at the code lines you gave to me it looks, that you somehow have a problem with the main plugin Gravity Forms. Because in both cases i added an action to existing Graviy Forms actions and in regular circumstances Gravity Forms should call my functions with “forms” as an parameter. In my test environment i can’t see your behaviour. * I will add an test to check whether “forms” does exist in the next release. But the addon will not act like it should if this parameter is not given. * Best wishes * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Gravity Forms To Excel AddOn] Blank fields not sent](https://wordpress.org/support/topic/blank-fields-not-sent/) * Plugin Author [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [10 years, 5 months ago](https://wordpress.org/support/topic/blank-fields-not-sent/#post-7013537) * Hi Thomas, * there are plenty of reasons for errors using VLOOKUP. Because i did not use the fourth parameter of VLOOKUP it is looking for similar written matches, a bit like the “like” in SQL. * I mark this thread as resolved, because the main question was solved. * Best wishes * Dieter * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Gravity Forms To Excel AddOn] Blank page after submit](https://wordpress.org/support/topic/blank-page-after-submit-1/) * Plugin Author [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [10 years, 5 months ago](https://wordpress.org/support/topic/blank-page-after-submit-1/#post-6947759) * Hi Fernando, * today i tested my sample form/excel on your site without any problems. I did not deactivate any other plugins. So it must have something to do with your specific form. This will need further testing… * I will keep you informed. * Best wishes * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Gravity Forms To Excel AddOn] Blank fields not sent](https://wordpress.org/support/topic/blank-fields-not-sent/) * Plugin Author [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [10 years, 5 months ago](https://wordpress.org/support/topic/blank-fields-not-sent/#post-7013519) * Sorry, there is something missing in the second Excel formula it should look like: * ``` =VLOOKUP("Gift Description"; 'WP40-GF2Excel'!A1:B23; 2) ``` * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Gravity Forms To Excel AddOn] Blank fields not sent](https://wordpress.org/support/topic/blank-fields-not-sent/) * Plugin Author [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [10 years, 5 months ago](https://wordpress.org/support/topic/blank-fields-not-sent/#post-7013513) * Hi Thomas, * it seems to me that this is an Excel related topic, but anyhow i will try to explain. * The question is how to handle Excel results where you do not exactly know the row in which your field will be. I will explain it using my Excel sample “gift- certificate.xlsx” file coming with the plugin. When i submit my sample form i will receive an Excel file where the second tab “WP40-GF2Excel” which contains the form inputs looks like: * ``` . Column A Column B Column C Line 1 – 19 … Line 20 Email Address dieter@winball.de 5 Line 21 Gift Description A piece of software 2 Line 22 Recipient Name A WordPress User 3 Line 23 Sender Name winball.de 4 ``` * In the first tab “Gift Certificate” the field C7 contains the formula: * ``` ='WP40-GF2Excel'!B21 ``` * to get the form input which should describe the gift (Gift Description). If the line 21 does not contain this info our form will show wrong data. * To be independent from the line number but still get the right data we can use the Excel function VLOOKUP. So i replace the formula in field C7 (in tab “Gift Certificate”) with: * ``` =VLOOKUP("Gift Description"; A1:B23; 2) ``` * In my example i get “A piece of software” again as the result, but now i am independent from the row number. * I hope you can handle your data now. * Best wishes * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Gravity Forms To Excel AddOn] Blank page after submit](https://wordpress.org/support/topic/blank-page-after-submit-1/) * Plugin Author [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [10 years, 6 months ago](https://wordpress.org/support/topic/blank-page-after-submit-1/#post-6947638) * Hi Fernando, * i tested your form and could not see any problems after submitting the form. I saw my confirmation message (text) and got an filled out Excel file via email. You may do have a problem with your confirmation page. You did configure a page as confirmation type and perhaps did not choose an existing page. * Best wishes * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Gravity Forms To Excel AddOn] Undefined index: page](https://wordpress.org/support/topic/undefined-index-page-2/) * Plugin Author [Dieter Pfenning](https://wordpress.org/support/users/winball/) * (@winball) * [10 years, 6 months ago](https://wordpress.org/support/topic/undefined-index-page-2/#post-6905459) * You’re welcome. Viewing 15 replies - 1 through 15 (of 27 total) 1 [2](https://wordpress.org/support/users/winball/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/winball/replies/page/2/?output_format=md)