formtools / module-export_manager Goto Github PK

Hi Benkeen, may I propose these changes to .php in the subject? This fix csv output if there are textarea fields:

function smarty_function_smart_display_field($params, &$smarty)
{
    $value = FieldTypes::generateViewableField($params);

    // additional code for CSV encoding
    if (isset($params["escape"])) {
        if ($params["escape"] == "csv") {
			// Check if we need to enclose field between double quotas
			$needQuote = (strstr($value, ",") || strstr($value, "\n"));
			// trim spaces and other useless char
			$value = trim($value);
			$value = preg_replace("/\"/", "\"\"", $value);
			// replace inner "\n" or "\r" with '|' character, otherwhise csv will be corrupted.
			$value = str_replace(array("\n","\r"), '|', $value);
			// add double quotas if required
			if ($needQuote)
				{
				$value = "\"$value\"";
				}
        }
        if ($params["escape"] == "excel") {
            $value = preg_replace("/(\n\r|\n)/", "<br style=\"mso-data-placement:same-cell;\" />", $value);
        }
    }

    echo $value;
}

Very minor. You can just click the button twice. But should fix!

A blast from the past! Apparently saving it fixes it. Look into!

Hi,

Currently the Data is exported as multiple format. For pdf i take it as a save as pdf, For this i need the field name and other details should be in Template like arrangement. Any Idea and direction ?

FT 3.01 / Windows Localhost install

1. Create Option List & Assign Field Values and Display Text
   

2. Link Option List to to Field1/Col_1 in DB - displays as expected
   

3. Add record

4. Display record using HTML /Printer Friendly Format - Display Text is shown NOT value
   

5. Export as XML - <col_1> shows Display text
   

6. Check database in phpMyAdmin - displays correct field value from Option List
   

7. Scratch head - I am missing something obvious - Option list export value should be exported?
   Option List display text should only appear in For Tools UI (internal form page)?

Trying this with external form - data saved OK in db but when exported as XML for round trip to another system incorrect option list value is exported.

Can workaround by making display and value exactly the same but...

8. Lies down

Thanks. Apologies if I have completely lost it

T

When generating files on the server, needs a "working" Ajax icon. Right now it's not clear that anything's happening.

Hi guys, I've a problem with Smarty Template. What I'm doing right now is to export groups of data from an online tool called Formtools (www.formtools.org) via Smarty template. I've got a script who export data by colums, but I need to group some of that fields into another one completely different. How can I select all the columns I need and put them into another field?

This is the script:

[code]
{strip}

<export_datetime>{$datetime}</export_datetime>
<export_unixtime>{$U}</export_unixtime>
<form_info>
<form_id>{$form_id}</form_id>
<form_name></form_name>
<form_url>{$form_url}</form_url>
</form_info>
<view_info>
<view_id>$view_id</view_id>
<view_name>Dati preliminari</view_name>
</view_info>

{foreach from=$submissions item=submission name=row}

{foreach from=$display_fields item=field_info name=col_row}
{assign var=col_name value=$field_info.col_name}
{assign var=value value=$submission.$col_name}
<{$col_name}></{$col_name}>
</{$message}>
{/foreach}

{/foreach}


{/strip}[/code]

I have a need to change values of Option List every week. If the value is not present this week, it won't be present at export, despite it existence in database. Yes, there is a workaround to change every time before the export to the list with all possible values but , except for the needless complexity, the main problem is in role management -- i have to modify the client account to administrator, change its menu to add administration links. Yes it's of inconvenience of actual role-based management system, but it's a bit odd way to perform such a simple action. Of course i can (and possibly will) write an python script, accessing directly to the DB, but i wish to see a proper way to do this simple thing by the correct means.
Best regards

When you have a form that contains a textarea there's an issue with the CSV exporter if a submission includes a line break (return/enter) in the textarea. It causes the submission to go to a new row at the line break.
I'm not sure if CSV supports a line break, so the best possible solution that I can think of is to update this module to convert a line break into a space before serving up the file.

Steps to reproduce:

1. Create a form with a textarea
2. Enter a submission, and have the textarea contain multiple lines (using enter/return to go to a new line)
3. Export submissions as a CSV

File exports on submission would be awesome. as xml, csv, plain text. To local folder - or - to an ftp might be asking too much, but would also be awesome.

I can't tell you how excited I was to see this app get updated! Awesome job so far.

I want to give you a suggestion about .csv export. You should add separator configuration and number decimal format. This because if region is set, for example to Italy, standard csv separator is ";" and not "," and numbers decimal separator is "," not "."
Now I know that I can fix by myself modifying the template, but may be generally useful have these options in module's "settings" page.
Best regards
Marco
(sorry for the large amount of messages from me, I'm studying your code so maybe soon I can help instead of requesting ;) )

See: formtools/core#509

Hello!
In the previous version of Formtools (and Smarty) I was able to include {php} code in Smarty in order to create custom export templates. Now, this is not possible anymore.
I need to create an export template in which I call a php query with a INNER JOIN between Formtools tables and assign the array to a Smarty variable in order to show the results.
What can I do?

Empty file fields appear as broken image in Export Manager popup.

They should be wrapped in a test to only show the visible ones.

{if $export_type.export_type_visibility == "show"} ... {/if}

Plus the page really is ugly. Update it!

Is it possible adjust export to CSV etc. Field Values (from Option Lists) instead of Displayed Text?
e.g. if Options are set: Field Value "1" Displayed Text "Yes", Field Value "0" Displayed Text "No".

According to Smarty Template in Export Types
{assign var=value value=$submission.col_name}
are exported "Displayed Text" values (e.g. "Yes").

How to adjust the Smarty Template to get the Field Value (e.g. "1" when answered "Yes") for exports?
The reason is that I need to work with codes of the answers not with displayed texts. Am I missing something if I guess the field values in Option Lists are there exactly for that purpose?

I have tried just blindly {assign var=value value=$submission.field_value}, but with no effect.
Many thanks for help!

Form Tools 3.0.15, Export Manager 3.1.0

You SHOULD be able to access the file upload URL and folder for each field through the following variables:

{foreach from=$submissions item=submission name=row}
{foreach from=$display_fields item=field name=col_row}

{$field.field_info.settings.file_upload_url}
{$field.field_info.settings.file_upload_dir}

{/foreach}
{/foreach}

But right now they only get passed if the values have been expressly overridden for that field. Those values should ALWAYS be passed.

As a temporary workaround, people can manually override the default "File Upload folder" settings for each file field. Once this is fixed, they can safely delete that setting.

See thread: http://forums.formtools.org/showthread.php?tid=570

This is blocking the export of large databases. The application should use php.ini to set the time limit and not magic numbers hidden in code here: https://github.com/formtools/module-export_manager/blob/master/code/Module.class.php#L597

Hi!

The pop-up showing exported data no longer displays uploaded file name as a link. So, to download/see that file you have to go back to the form view screen, enter entry details and download/see file from there.

When displaying ALL records with the "HTML/Printer Friendly" display button, the popup is blank, but when displaying SELECTED records with the "HTML/Printer Friendly" display button, the popup displays the selected records just fine.

Please help me to display the uploaded image files in the Printer Friendly format Dispay ether Table or One by One format

Please help me to display the uploaded image files in this code

ASSOCIAÇÃO FILIADA: {$form_name} - {$view_name}

{strip}
{foreach from=$submissions item=submission}
{assign var=submission_id value=$submission.submission_id}

{/foreach}
{/strip}

Could Not be able to download the latest file upload and Export Manager modules upgrades

Oops! The server is too busy to handle your request right now. Please wait and the page will keep trying every 30 seconds to generate your upgrade file. Depending on how busy things are, this may take a few attempts.

Not sure how this snuck in. This isn't valid for some export types.

Not sure exactly how to explain this, but some fields (usually the large comment field) allows user entered data to mess up the system of comma/quote separation of fields, so that when data is exported and opened in Excel or Open Office Calc, some of the rows are messed up. It also looks like sometimes my comment field has quotations around it, but sometimes it does not. Perhaps a problem with \out chars like single or double quotes? I can supply an exported example if necessary, though it contains data I would not want publicly visible.

Just an update. This bug seems to be slightly different in latest versions (ft 2.1.5 and export manager 2.1).

When I export an Excel version, the file opens fine in Excel, but when I export a csv file, a textarea data field seems to break the line and thus mess up the csv file. Also, if I save the exported Excel version as a csv file, the new csv file also has the broken line problem, even though the Excel file displays ok in Excel (i.e. no broken line.)

Seems like textarea fields are carrying along a carriage return, perhaps? I tried adding wrap=virtual and deleting all the spaces in the textarea html, but that doesn't seem to make a difference.

.ID,Last Name,First Name,Email,Phone,Org,Category,Address,City,State,Province,Country,Zip,DL Interest,Find Us,Support nit removal?,Prevention Program,Failed Treatment,Caused Illness,Comments,Date,Last modified,IP Address
24203,Moore,Andy,[email protected],phone,Moorezilla,Education,5 Linden,Peabody,Massachusetts,,United States of America,01960,"No Nit Policy, Other",Internet Search,yes,no,yes,n/a, test
,2011-10-27 12:28 PM,2011-10-27 12:46 PM,71.233.45.129

Not sure if this will translate right. Problem seems to occur right before date field... right after textarea field for Comments.

As described.

See this thread, which includes the fix: http://forums.formtools.org/showthread.php?tid=202

When I export submission in xls or csv format I obtaina "page not found" error.
I found the solution in this forum post http://forums.formtools.org/showthread.php?tid=2014
In fact my server has register globals disabled and disabling line 756
// foreach ($GLOBALS as $key => $val) { @eval("global $$key;"); }
solved the problem.
I thing it should fixed.

Possibly a bug. See description here: formtools/core#270

Hi, I tried to export some data from my form tool accounts into a CSV, but I need a particular one. How could modify the export template in an easy way?