https://legacy.forums.gravityhelp.com/tags/import Gravity Support Forums Tag: Import - Recent Posts en-US Sun, 19 Apr 2026 16:33:59 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/custom-form-field-with-multiple-inputs#post-273572 Fri, 24 May 2013 12:34:45 +0000 marcel.ambiente 273572@https://legacy.forums.gravityhelp.com/ <p>Friend, there's an error at line 11, instead "onclick" =&gt; "StartAddField('add_loc'), put onclick" =&gt; "StartAddField('addloc'); without the underline character at "addloc"... Obviously, all "add_loc" reference (type) will not work, so I suggest you to substitute every "add_loc" therm to "addloc". </p> https://legacy.forums.gravityhelp.com/topic/returns-in-textarea-causing-problems-in-csv-export#post-272918 Fri, 24 May 2013 07:12:36 +0000 post@smart-media.no 272918@https://legacy.forums.gravityhelp.com/ <p>Hi,<br /> You can remove the returns before the data is saved to the database with the following script:</p> <pre><code>add_filter(&quot;gform_save_field_value&quot;, &quot;save_field_value&quot;, 10, 4); function save_field_value($value, $lead, $field, $form){ $new_value = str_replace(array(&quot;\n&quot;, &quot;\t&quot;, &quot;\r&quot;), &#39;&#39;, $value); return $new_value; }</code></pre> <p>\n removes new lines<br /> \t removes tabs<br /> \r remove carriage returns </p> https://legacy.forums.gravityhelp.com/topic/problem-with-the-export-messages-in-cvs-format-french-languages-messages#post-257719 Fri, 17 May 2013 10:11:23 +0000 ScottSendraDesign 257719@https://legacy.forums.gravityhelp.com/ <p>I am experiencing the same problem. When I export a .csv file that includes a "return" in a text field, Excel reads that as a new line. Is the official solution to this to not use the textarea field for user entry of paragraphs? </p> <p>My research into this problem suggests that the csv file should have "/n" for the returns. Is this not happening? Is there a way to filter out returns in the textarea fields beforre their are exported and replace them with another character?</p> <p>The form is located here:<br /> <a href="https://achievefoundation.org/support-us-category/fundraising/honor-your-teacher-3/" rel="nofollow">https://achievefoundation.org/support-us-category/fundraising/honor-your-teacher-3/</a> </p> https://legacy.forums.gravityhelp.com/topic/returns-in-textarea-causing-problems-in-csv-export#post-254514 Wed, 15 May 2013 20:16:00 +0000 ScottSendraDesign 254514@https://legacy.forums.gravityhelp.com/ <p>I am having an issue when I import Gravity Forms csv forms into Excel. The form I created uses multiple textarea fields. If a return is entered into a textarea, i.e more than one paragraph is added, when I import the csv data into Excel, the return is interpreted as a line break. This messes up my columns quite a bit!</p> <p>Is there a way of filtering for returns and replacing or deleting them? Or a way of preventing certain characters from being allowed in a textarea field?</p> <p>Thank you! </p> https://legacy.forums.gravityhelp.com/topic/setup-a-testsite-on-local-machine-but-form-will-not-save-and-fields-are-lost#post-250642 Mon, 13 May 2013 10:39:34 +0000 Rob Harrell 250642@https://legacy.forums.gravityhelp.com/ <p>Handling via priority support. </p> https://legacy.forums.gravityhelp.com/topic/setup-a-testsite-on-local-machine-but-form-will-not-save-and-fields-are-lost#post-242515 Wed, 08 May 2013 06:24:49 +0000 Vayu 242515@https://legacy.forums.gravityhelp.com/ <p>Hi.<br /> I have a huge form setup on this site. <a href="http://forsikringsdeal.dk/" rel="nofollow">http://forsikringsdeal.dk/</a>. Unfortunately, you have to be logged ind to see the form.<br /> We run the latest version of WP 3.5.1, but have not updated to the latest version of GravityForms. We need to do some testing first and also we plan to make some big changes to the site, hence I have setup a copy of the site on a local machine. The Gravityforms version we use now is 1.6.12.<br /> However, I am having problems getting the form to work on the local machine. I have exported the data with phpMyAdmin. I have read that it can cause issues and have also installed and run the meta recovery plugin. But still, when I try to make changes to the form, it returns with a page where I have to create a new form. I have testet it in GravityForms 1.6.12 and 1.7.2. See screenshot: <a href="https://www.evernote.com/shard/s3/sh/6be961c6-40b4-416a-8dbc-1ea749a886d3/bb126703cdbbf90e2ed0ef81667a911a" rel="nofollow">https://www.evernote.com/shard/s3/sh/6be961c6-40b4-416a-8dbc-1ea749a886d3/bb126703cdbbf90e2ed0ef81667a911a</a></p> <p>The fields are not lost, so when I exit the page and go back into the form editor, the fields are back. But it will not let me save any modifications.</p> <p>I need all the entries for this form, hence I cannot just export and import xml data, as this creates a new form without all the entries.</p> <p>Is there anything I can do to fix this?<br /> It worries me a bit actually, as of right now, we don't have a functioning backup process if our site is hacked and data is lost. I mean, we have a backup, but the backup will not get us a functioning form again.<br /> Hope there is a solution.<br /> Thanks<br /> Vayu </p> https://legacy.forums.gravityhelp.com/topic/problem-with-the-export-messages-in-cvs-format-french-languages-messages#post-239714 Mon, 06 May 2013 08:07:27 +0000 Juhlsen 239714@https://legacy.forums.gravityhelp.com/ <p>We got this problem each time we make a Gravity form and the costumer need the data.<br /> Replicating the problem is easy:</p> <p>1. Just make a form that has various fields including one or more text fields.<br /> 2. Make the form 'live' on a webpage.<br /> 3. Now enter some data into the form from a few 'users'.<br /> 4. In the text input fields try to enter some multi line text with line breaks -as users often do.<br /> 5. Export the form data to a .csv file.</p> <p>If you then try to import the data into an Excel then the user data without linebreaks will import ok into each column and create a new line for each user.</p> <p>However whenever a text field got a linebreak within the "" then excel will start a new line and the data for that user gets split over one or more lines and put into the wrong columns.</p> <p>There are no simple solution to fix this in Excel so the data remains completely useless for the costumer. You can try to fix it manually but this is very hard when the form got data from thousands of users.</p> <p>One of our developers has made a routine to fix the .csv files.<br /> But Gravity Forms need a build in solution if we should continue to use it - as costumers must be able to export and import into Excel them self.</p> <p>A simple solution would be an option to export form data with linebreaks within "" converted into something like "&lt;/br&gt;" or "*LB*" or "|" (maybe user specified) when exported. Then it can be imported into Excel correctly and you can then replace the code in Excel with something else. </p> https://legacy.forums.gravityhelp.com/topic/notification-routing-list-export-then-import#post-232250 Wed, 01 May 2013 12:38:45 +0000 David Peralty 232250@https://legacy.forums.gravityhelp.com/ <p>There currently isn't a way to export/import such details from one form to another. You could duplicate the original form and change the fields in it to keep the notifications and confirmations. </p> https://legacy.forums.gravityhelp.com/topic/notification-routing-list-export-then-import#post-232233 Wed, 01 May 2013 12:26:43 +0000 Bruce_Alfred 232233@https://legacy.forums.gravityhelp.com/ <p>Hi,<br /> Is there a way to export a notifications routing list from one form to then import into another. I've got a lengthy notifications routing list, and I'd rather not have to redo it by hand.<br /> Thanks,<br /> Bruce </p> https://legacy.forums.gravityhelp.com/topic/problem-with-the-export-messages-in-cvs-format-french-languages-messages#post-201358 Mon, 08 Apr 2013 14:06:50 +0000 Chris Hajer 201358@https://legacy.forums.gravityhelp.com/ <p>@damdo74, can you explain what is happening to you exactly? Also, if you can post a sample of your exported CSV to pastebin.com or pastie.org, we will be happy to take a look. </p>