The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 783 errorHandler->error
/showthread.php 26 require_once
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 783 errorHandler->error
/showthread.php 26 require_once
Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/global.php(841) : eval()'d code 40 errorHandler->error
/global.php 841 eval
/showthread.php 26 require_once
Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 909 errorHandler->error
/showthread.php 26 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 5024 errorHandler->error
/global.php 909 build_theme_select
/showthread.php 26 require_once
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions.php 5044 is_member
/global.php 909 build_theme_select
/showthread.php 26 require_once
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key "mybb" - Line: 1952 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1952 errorHandler->error
/inc/functions_indicators.php 41 my_set_array_cookie
/showthread.php 629 mark_thread_read
Warning [2] Undefined property: MyLanguage::$ratings_update_error - Line: 5 - File: showthread.php(732) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/showthread.php(732) : eval()'d code 5 errorHandler->error
/showthread.php 732 eval
Warning [2] Undefined variable $postsdone - Line: 867 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 867 errorHandler->error
Warning [2] Trying to access array offset on value of type null - Line: 867 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 867 errorHandler->error
Warning [2] Undefined array key 6992 - Line: 867 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 867 errorHandler->error
Warning [2] Undefined array key 6996 - Line: 867 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 867 errorHandler->error
Warning [2] Undefined array key 7008 - Line: 867 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 867 errorHandler->error
Warning [2] Undefined array key 7746 - Line: 867 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 867 errorHandler->error
Warning [2] Undefined array key 7949 - Line: 867 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 867 errorHandler->error
Warning [2] Undefined array key 9623 - Line: 867 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 867 errorHandler->error
Warning [2] Undefined array key 39063 - Line: 867 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 867 errorHandler->error
Warning [2] Undefined array key 39791 - Line: 867 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 867 errorHandler->error
Warning [2] Undefined array key 6996 - Line: 1576 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 1576 errorHandler->error
/showthread.php 1578 buildtree
/showthread.php 1578 buildtree
/showthread.php 879 buildtree
Warning [2] Undefined array key 7746 - Line: 1576 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 1576 errorHandler->error
/showthread.php 1578 buildtree
/showthread.php 1578 buildtree
/showthread.php 879 buildtree
Warning [2] Undefined array key 39063 - Line: 1576 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 1576 errorHandler->error
/showthread.php 1578 buildtree
/showthread.php 1578 buildtree
/showthread.php 879 buildtree
Warning [2] Undefined array key 9623 - Line: 1576 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 1576 errorHandler->error
/showthread.php 1578 buildtree
/showthread.php 1578 buildtree
/showthread.php 879 buildtree
Warning [2] Undefined array key 39791 - Line: 1576 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 1576 errorHandler->error
/showthread.php 1578 buildtree
/showthread.php 879 buildtree
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions_user.php 844 is_member
/inc/functions_post.php 406 purgespammer_show
/showthread.php 880 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: inc/functions_post.php(474) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php(474) : eval()'d code 6 errorHandler->error
/inc/functions_post.php 474 eval
/showthread.php 880 build_postbit
Warning [2] Undefined array key "canonlyreplyownthreads" - Line: 660 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 660 errorHandler->error
/showthread.php 880 build_postbit
Warning [2] Undefined array key "showimages" - Line: 741 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 741 errorHandler->error
/showthread.php 880 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 746 - File: inc/functions_post.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions_post.php 746 errorHandler->error
/showthread.php 880 build_postbit
Warning [2] Undefined array key "invisible" - Line: 1506 - File: showthread.php PHP 8.1.27 (Linux)
File Line Function
/showthread.php 1506 errorHandler->error
Warning [2] Undefined variable $threadnotesbox - Line: 30 - File: showthread.php(1533) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/showthread.php(1533) : eval()'d code 30 errorHandler->error
/showthread.php 1533 eval
Warning [2] Undefined variable $multipage - Line: 33 - File: showthread.php(1533) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/showthread.php(1533) : eval()'d code 33 errorHandler->error
/showthread.php 1533 eval
Warning [2] Undefined variable $multipage - Line: 65 - File: showthread.php(1533) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/showthread.php(1533) : eval()'d code 65 errorHandler->error
/showthread.php 1533 eval
Warning [2] Undefined variable $addremovesubscription - Line: 79 - File: showthread.php(1533) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/showthread.php(1533) : eval()'d code 79 errorHandler->error
/showthread.php 1533 eval



FORUMS


The Form Tools forums are no longer active, but the old posts have been archived here. Please see the Help page on how to get help / report issues.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Export Manager: Custom Table View
#4
I'm so sorry for the long response time. I'm just trying to wrap up some work before I leave the country at the end of this month, and everything else is falling by the wayside.

When I first read your post I thought "no problem!" but when I just tried putting together a working example today, I was surprised how tricky it was - not just tricky, actually: downright complicated! The default Smarty content in the Export Manager code is really too complex by half. I'll have to simplify it in future versions.

So what I ended up doing was writing a helper Smarty function that *significantly* simplifies the job for us. I'll include this in the next version of the module for anyone in a similar situation.

Anyway, here's how to get it all done.

First off, since you need such a specific format, start by piecing together the HTML that you need for a *single* outputted submission. Just leave blank spaces where you want the values to be outputted from the database. Your HTML would just contain the main table layout and labels. When I look at your desired output, it'll clearly take some fiddling just to get the markup right with all the appropriate rowspans / colspans etc.

Once that's ready, it's a matter of putting it into the Smarty template and pasting in the appropriate variable into each spot in the field.

Download the attached file and upload it to your [form tools]/modules/export_manager/smarty/ folder. After it's been added there, it will be available to be used in your own Export Types Smarty content that you enter in the Export Manager module.

Here's a simple example of how it works. Instead of the loop-within-loop that the default HTML / Printer-Friendly "Table Format" Export Type smarty content uses (which is complicated, but fast), this works differently. It loops through each submission, but display explicit field values based on their column names. So, you just pass in the unique database column name for the field, and it will output the appropriate value for the current submission at the spot.

Code:
{foreach from=$submissions item=submission}

  
  <table>
    <tr>
      <th>Submission ID:</th>
      <td>{display_field_by_colname col_name="submission_id"}</td>
      <th>Field #1</th>
      <td>{display_field_by_colname col_name="col_1"}</td>
    </tr>
    </table>

    <br />

{/foreach}

In my case, I have a field called "Field #1", which has a column name of "col_1".

What you need to do is copy your markup into the Smarty Export Type content field and replace the <table> in the example above. Then, any place you want a value outputted for a field, just call the function, specifying the field you want:

{display_field_by_colname col_name="XXXXXX"}

And that's pretty much it!

Let me know how it goes.

- Ben


Attached Files
.php   function.display_field_by_colname.php (Size: 1.78 KB / Downloads: 57)
Reply


Messages In This Thread
Export Manager: Custom Table View - by heywood7 - Dec 29th, 2011, 2:08 PM
RE: Export Manager: Custom Table View - by Ben - Dec 31st, 2011, 12:24 PM
RE: Export Manager: Custom Table View - by heywood7 - Jan 2nd, 2012, 3:14 PM
RE: Export Manager: Custom Table View - by Ben - Jan 8th, 2012, 1:33 PM
RE: Export Manager: Custom Table View - by dedy - Sep 10th, 2012, 2:55 PM
RE: Export Manager: Custom Table View - by jgold723 - Mar 27th, 2014, 9:30 AM
RE: Export Manager: Custom Table View - by icehell - Jan 24th, 2021, 9:14 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)