Lasso 8.5 and FMP Portal and PDF

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Lasso 8.5 and FMP Portal and PDF

Patrick Larkin-3

I never used Lasso 8.5 to show items in a Filemaker Pro portal.  (FMS 12)  I have code to produce a PDF and am trying to pull portal rows into a PDF table and nothing displays.  The original inline produces ‘No error’ but am I doing something wrong in my portal syntax?  Should this work?

The last table column is set to display a hard coded string and that does not appear either.  




[inline(
-inlinename='assign_fetch',
-database='staff',
-table = ‘myTable',
-username=$dbu,
-password=$dbp,
'Last First  MI' = ’Smith John',
-search)] [var('err') = error_currenterror]
[/inline]

        [var:'MyTable'=(PDF_Table:
        -Cols=4,
        -Rows=(found_count),
        -Spacing=0,
        -Padding=2,
        -Width=100,
        -BorderWidth=0.0,
        -ColWidth=(Array:'25.0','25.0','25.0','25.0')
        )]


[records(-inlinename='assign_fetch')]

[portal('Assignments')]



       
       
        [var('theText') = field('Position')]
        [var:'text3'=(PDF_Text:$theText, -Type='Paragraph',  -Font=$MyFont, -Leading=10)]
        [$MyTable->(Add:$text3, -Col=0, -Row=1, -HorizontalAlignment='left')]
       
        [var('theText') = field('School')]
        [var:'text3'=(PDF_Text:$theText, -Type='Paragraph',  -Font=$MyFont, -Leading=10)]
        [$MyTable->(Add:$text3, -Col=1, -Row=1, -HorizontalAlignment='left')]
       
        [var('theText') = field('Dis')]
        [var:'text3'=(PDF_Text:$theText, -Type='Paragraph',  -Font=$MyFont, -Leading=10)]
        [$MyTable->(Add:$text3, -Col=2, -Row=1, -HorizontalAlignment='left')]
       
        [var('theText') = 'DAYS']
        [var:'text3'=(PDF_Text:$theText, -Type='Paragraph',  -Font=$MyFont, -Leading=10)]
        [$MyTable->(Add:$text3, -Col=3, -Row=1, -HorizontalAlignment='left')]
       


[/Portal]
[/records]

       
       

[$MyFile->(Add:$MyTable)]




——
Patrick Larkin
Application Management Group
Information Technology
Bethlehem Area School District
https://www.beth.k12.pa.us


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8.5 and FMP Portal and PDF

maxwellk2
Hi Patrick,

I’m not so familiar with the PDF tags, but I think you’re just missing the portal name in front of the field names...

        [var('theText') = field('Position')] ...should be... [var('theText') = field('Assignments::Position’)]
        [var('theText') = field('School')] ...should be... [var('theText') = field('Assignments::School')]
        [var('theText') = field('Dis')] ...should be... [var('theText') = field('Assignments::Dis')]
        [var('theText') = 'DAYS'] ...should be... [var('theText') = 'Assignments::DAYS']

        http://reference.lassosoft.com/LassoReference.LassoApp?lassoscript/browse

FileMaker changed something in the XML response between FMS11 and FMS12 that causes issues with portals and Lasso 8, not sure yet about Lasso 9. I would suggest avoiding portals whenever possible and using inlines. If you need to use them in FM12, remove any related fields outside the portal than use the same relationship. Fields inside the portal must use the same relationship as the portal.

Thanks,
Max



> On Mar 20, 2015, at 8:50 AM, Patrick Larkin <[hidden email]> wrote:
>
>
> I never used Lasso 8.5 to show items in a Filemaker Pro portal.  (FMS 12)  I have code to produce a PDF and am trying to pull portal rows into a PDF table and nothing displays.  The original inline produces ‘No error’ but am I doing something wrong in my portal syntax?  Should this work?
>
> The last table column is set to display a hard coded string and that does not appear either.  
>
> —
>
>
> [inline(
> -inlinename='assign_fetch',
> -database='staff',
> -table = ‘myTable',
> -username=$dbu,
> -password=$dbp,
> 'Last First  MI' = ’Smith John',
> -search)] [var('err') = error_currenterror]
> [/inline]
>
> [var:'MyTable'=(PDF_Table:
> -Cols=4,
> -Rows=(found_count),
> -Spacing=0,
> -Padding=2,
> -Width=100,
> -BorderWidth=0.0,
> -ColWidth=(Array:'25.0','25.0','25.0','25.0')
> )]
>
>
> [records(-inlinename='assign_fetch')]
>
> [portal('Assignments')]
>
>
>
>
>
> [var('theText') = field('Position')]
> [var:'text3'=(PDF_Text:$theText, -Type='Paragraph',  -Font=$MyFont, -Leading=10)]
> [$MyTable->(Add:$text3, -Col=0, -Row=1, -HorizontalAlignment='left')]
>
> [var('theText') = field('School')]
> [var:'text3'=(PDF_Text:$theText, -Type='Paragraph',  -Font=$MyFont, -Leading=10)]
> [$MyTable->(Add:$text3, -Col=1, -Row=1, -HorizontalAlignment='left')]
>
> [var('theText') = field('Dis')]
> [var:'text3'=(PDF_Text:$theText, -Type='Paragraph',  -Font=$MyFont, -Leading=10)]
> [$MyTable->(Add:$text3, -Col=2, -Row=1, -HorizontalAlignment='left')]
>
> [var('theText') = 'DAYS']
> [var:'text3'=(PDF_Text:$theText, -Type='Paragraph',  -Font=$MyFont, -Leading=10)]
> [$MyTable->(Add:$text3, -Col=3, -Row=1, -HorizontalAlignment='left')]
>
>
>
> [/Portal]
> [/records]
>
>
>
>
> [$MyFile->(Add:$MyTable)]
>
>
>
>
> ——
> Patrick Larkin
> Application Management Group
> Information Technology
> Bethlehem Area School District
> https://www.beth.k12.pa.us
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8.5 and FMP Portal and PDF

Patrick Larkin-3
Yes, that was an oversight, thanks.  But the PDF still does not display the data.

If I remove the table and just display it using a
        [$MyFile->(Add:$text)]

it displays.  So there must be something wrong with the order of things in my code.  


PLEASE NOTE:  My e-mail address has changed to:  [hidden email]
——
Patrick Larkin
Application Management Group
Information Technology
Bethlehem Area School District
https://www.beth.k12.pa.us

On Mar 20, 2015, at 12:15 PM, Maxwell Klein <[hidden email]> wrote:

> Hi Patrick,
>
> I’m not so familiar with the PDF tags, but I think you’re just missing the portal name in front of the field names...
>
> [var('theText') = field('Position')] ...should be... [var('theText') = field('Assignments::Position’)]
> [var('theText') = field('School')] ...should be... [var('theText') = field('Assignments::School')]
> [var('theText') = field('Dis')] ...should be... [var('theText') = field('Assignments::Dis')]
> [var('theText') = 'DAYS'] ...should be... [var('theText') = 'Assignments::DAYS']
>
> http://reference.lassosoft.com/LassoReference.LassoApp?lassoscript/browse
>
> FileMaker changed something in the XML response between FMS11 and FMS12 that causes issues with portals and Lasso 8, not sure yet about Lasso 9. I would suggest avoiding portals whenever possible and using inlines. If you need to use them in FM12, remove any related fields outside the portal than use the same relationship. Fields inside the portal must use the same relationship as the portal.
>
> Thanks,
> Max
>
>
>
>> On Mar 20, 2015, at 8:50 AM, Patrick Larkin <[hidden email]> wrote:
>>
>>
>> I never used Lasso 8.5 to show items in a Filemaker Pro portal.  (FMS 12)  I have code to produce a PDF and am trying to pull portal rows into a PDF table and nothing displays.  The original inline produces ‘No error’ but am I doing something wrong in my portal syntax?  Should this work?
>>
>> The last table column is set to display a hard coded string and that does not appear either.  
>>
>> —
>>
>>
>> [inline(
>> -inlinename='assign_fetch',
>> -database='staff',
>> -table = ‘myTable',
>> -username=$dbu,
>> -password=$dbp,
>> 'Last First  MI' = ’Smith John',
>> -search)] [var('err') = error_currenterror]
>> [/inline]
>>
>> [var:'MyTable'=(PDF_Table:
>> -Cols=4,
>> -Rows=(found_count),
>> -Spacing=0,
>> -Padding=2,
>> -Width=100,
>> -BorderWidth=0.0,
>> -ColWidth=(Array:'25.0','25.0','25.0','25.0')
>> )]
>>
>>
>> [records(-inlinename='assign_fetch')]
>>
>> [portal('Assignments')]
>>
>>
>>
>>
>>
>> [var('theText') = field('Position')]
>> [var:'text3'=(PDF_Text:$theText, -Type='Paragraph',  -Font=$MyFont, -Leading=10)]
>> [$MyTable->(Add:$text3, -Col=0, -Row=1, -HorizontalAlignment='left')]
>>
>> [var('theText') = field('School')]
>> [var:'text3'=(PDF_Text:$theText, -Type='Paragraph',  -Font=$MyFont, -Leading=10)]
>> [$MyTable->(Add:$text3, -Col=1, -Row=1, -HorizontalAlignment='left')]
>>
>> [var('theText') = field('Dis')]
>> [var:'text3'=(PDF_Text:$theText, -Type='Paragraph',  -Font=$MyFont, -Leading=10)]
>> [$MyTable->(Add:$text3, -Col=2, -Row=1, -HorizontalAlignment='left')]
>>
>> [var('theText') = 'DAYS']
>> [var:'text3'=(PDF_Text:$theText, -Type='Paragraph',  -Font=$MyFont, -Leading=10)]
>> [$MyTable->(Add:$text3, -Col=3, -Row=1, -HorizontalAlignment='left')]
>>
>>
>>
>> [/Portal]
>> [/records]
>>
>>
>>
>>
>> [$MyFile->(Add:$MyTable)]
>>
>>
>>
>>
>> ——
>> Patrick Larkin
>> Application Management Group
>> Information Technology
>> Bethlehem Area School District
>> https://www.beth.k12.pa.us
>>
>>
>> #############################################################
>>
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso [hidden email]
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>