https://legacy.forums.gravityhelp.com/topic/export-date-in-tsv-or-tab-delimited-file Gravity Support Forums Topic: Export Data in TSV or tab-delimited file en-US Sun, 19 Apr 2026 23:49:32 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/export-date-in-tsv-or-tab-delimited-file#post-42497 Tue, 29 Nov 2011 19:13:10 +0000 David Smith 42497@https://legacy.forums.gravityhelp.com/ <p>Hi fallingup,</p> <p>An automated scripted solution is possible but would require a solid grasp of PHP. Unfortunately, it isn't something we would be able to walk you through. If you are interested, a good place to start digging would be the export.php file within the Gravity Forms plugin folder.</p> <p>Good luck! :) </p> https://legacy.forums.gravityhelp.com/topic/export-date-in-tsv-or-tab-delimited-file#post-42493 Tue, 29 Nov 2011 18:50:54 +0000 Casey Kluver 42493@https://legacy.forums.gravityhelp.com/ <p>Hmmm ok thanks for the help. This would definitely be good enough for me, but the client we are working with is a non-profit organization and they need to have this process automated, and are not willing to compromise on having to do the simple find and replace etc. </p> <p>So there no way to write a script or anything to transform the export file? Any other ideas on how I can achieve this?</p> <p>Thanks for the help! </p> https://legacy.forums.gravityhelp.com/topic/export-date-in-tsv-or-tab-delimited-file#post-42468 Tue, 29 Nov 2011 16:50:52 +0000 Carl Hancock 42468@https://legacy.forums.gravityhelp.com/ <p>The export tool produces a CSV delimited file. A CSV file is a plain text file. It just has a .CSV file extension. </p> <p>The hook only changes the separator used in the delimited CSV. It can't be used to remove the "" wrapped around each input and it can't be used to change the filename of the resulting export.</p> <p>In order to do what you want to do you'd have to manually change the data by opening it in a text editor, search and replace to remove the double quotes and then save it as a .txt file. </p> https://legacy.forums.gravityhelp.com/topic/export-date-in-tsv-or-tab-delimited-file#post-42448 Tue, 29 Nov 2011 13:33:14 +0000 Casey Kluver 42448@https://legacy.forums.gravityhelp.com/ <p>Yes it is the same code you posted but with Chris's modification above. I have only replaced the "/t" with "`"</p> <p><a href="http://www.pastie.org/2939668" rel="nofollow">http://www.pastie.org/2939668</a></p> <p>So again looking at the format examples I posted in my comment above I need to remove the "" wrapped around each input, and most importantly I need this to be exported as a plain text file (.txt) NOT a CSV or TSV.</p> <p>Thanks for all the help! </p> https://legacy.forums.gravityhelp.com/topic/export-date-in-tsv-or-tab-delimited-file#post-41879 Tue, 22 Nov 2011 12:48:13 +0000 David Smith 41879@https://legacy.forums.gravityhelp.com/ <p>Could you post the exact code you are using (including the edits you have made)? </p> https://legacy.forums.gravityhelp.com/topic/export-date-in-tsv-or-tab-delimited-file#post-41432 Thu, 17 Nov 2011 13:40:25 +0000 Casey Kluver 41432@https://legacy.forums.gravityhelp.com/ <p>Thanks so much for the help.....yes I need a plan text file not CSV or TSV. </p> <p>Also here is the format from the sample data the client gave....<br /> <a href="http://pastie.org/2878949" rel="nofollow">http://pastie.org/2878949</a></p> <p>And here is the format that I received from a test with the code change you gave above (replacing the "\t" with "~")<br /> <a href="http://pastie.org/2878972" rel="nofollow">http://pastie.org/2878972</a></p> <p>It looks like I still getting the "" wrapped around each input? What do you think? </p> https://legacy.forums.gravityhelp.com/topic/export-date-in-tsv-or-tab-delimited-file#post-41365 Wed, 16 Nov 2011 21:49:38 +0000 Chris Hajer 41365@https://legacy.forums.gravityhelp.com/ <p>So you do not need CSV or TSV? You need plain text? </p> <p>Can you post the exact format you need, at pastebin.com or pastie.org, so the formatting will be preserved? It looks like this is the format that is required for your export? And instead of a comma or tab, you need a ~? If so, instead of the "\t" in the code from David Smith, you can use "~" there.</p> <p>~</p> <p>Does that resolve the issue? </p> https://legacy.forums.gravityhelp.com/topic/export-date-in-tsv-or-tab-delimited-file#post-41353 Wed, 16 Nov 2011 19:05:06 +0000 Casey Kluver 41353@https://legacy.forums.gravityhelp.com/ <p>Thanks so much for the help! The problem was indeed my plugin version. I should have checked that first. I updated and we are good to go. It looks like now instead of separate data cells in the .csv file each piece of input info is wrapped around "" and all in one data cell. This seems to but what the clients needs except for one last piece. The sample file they sent us is a text file. So now somehow we need the export file as a .txt not a .csv. Here is an example of the data they sent us (which again is saved in a text file) - names and address replaced obvioulsy :)<br /> <pre><code>2008-07-25 00:12:44.000~Lizzy~~GOZ~~219 N AM AVE~TUCSON~AZ~85745~~10 ~19991031~D000000000~F~I| 2008-07-25 00:12:44.000~Lou~~GO~~230 N FM AVE~TUCSON~AZ~85745~~10 ~19991031~D000000000~F~I| 2008-07-25 00:12:44.000~Phil~~John~~200 N AM AVE~TUCSON~AZ~85745~~10 ~19991031~D000000000~F~I|</code></pre> https://legacy.forums.gravityhelp.com/topic/export-date-in-tsv-or-tab-delimited-file#post-41091 Mon, 14 Nov 2011 21:33:57 +0000 Chris Hajer 41091@https://legacy.forums.gravityhelp.com/ <p>What happens when you try this? The code provided by David is designed to replace the comma with a tab character in the export file. Sounds like that's what you're trying to do.</p> <p>This hook was added in 1.6 What version of the plugin are you using? </p> https://legacy.forums.gravityhelp.com/topic/export-date-in-tsv-or-tab-delimited-file#post-41071 Mon, 14 Nov 2011 17:19:26 +0000 Casey Kluver 41071@https://legacy.forums.gravityhelp.com/ <p>This doesn't seem to be working for me...maybe I have the wrong idea here?<br /> We have a client that needs to export the entries from a registration form into a tab-delimited text file. Its looking like this doesn't transform it into a csv file? I have seen (not tested) converters out there that transform a .csv into a tab-delimited text file, but the clients needs something more automated. Anyone have any helps/thoughts?</p> <p>BTW thanks so much for posting this David! </p>