FileMaker Snapshot link XML document creation

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

FileMaker Snapshot link XML document creation

Paul Moebius-3
Hi Guys

How would I create, download and open a text file from a record retrieved link?

<?xml version="1.0" encoding="UTF-8"?>
<FPSL><UIState><UniversalPathList>fmnet:/192.168.1.99/DatabaseName</UniversalPathList><Layout id="[field:'Layout_ID']"></Layout><View type="form"></View><SelectedRow type="nativeID" id=[field:'RecordID']></SelectedRow><StatusToolbar visible="True"></StatusToolbar><Mode value="browseMode"></Mode></UIState></FPSL>

The file would have to contain the above information and would be saved with a .fpsl extension so that FileMaker can open on a local computer


#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014

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

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: FileMaker Snapshot link XML document creation

maxwellk2
That’s an interesting idea Paul. I send a lot of emails from Lasso to FileMaker users, for instance, when a new order is placed via a Lasso website. It would certainly simplify the workflow if those emails contained an attachment that linked directly to the orders/records in question. Curious to hear how that might best be done.

On a similar note you might also look at the FileMaker FMP/URL/URI syntax, if you’re not already familiar:

        http://www.filemaker.com/help/12/fmp/html/sharing_data.16.7.html

It’s different from the Snapshot Link file, but might also suite your needs. It allows you to open an FM database on a specific server and call a script with a given script parameter. Just like any other URI/URL the link could be provided by a web page or contained within an email.

-Max


On Sep 20, 2014, at 12:52 PM, Paul Moebius <[hidden email]> wrote:

> Hi Guys
>
> How would I create, download and open a text file from a record retrieved link?
>
> <?xml version="1.0" encoding="UTF-8"?>
> <FPSL><UIState><UniversalPathList>fmnet:/192.168.1.99/DatabaseName</UniversalPathList><Layout id="[field:'Layout_ID']"></Layout><View type="form"></View><SelectedRow type="nativeID" id=[field:'RecordID']></SelectedRow><StatusToolbar visible="True"></StatusToolbar><Mode value="browseMode"></Mode></UIState></FPSL>
>
> The file would have to contain the above information and would be saved with a .fpsl extension so that FileMaker can open on a local computer
>
>
> #############################################################
> Attend the Lasso Developer Conference 2014!
> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
> http://www.lassosoft.com/LDC-newmarket-2014
>
> #############################################################
>
> 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]>

#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014

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

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: FileMaker Snapshot link XML document creation

Paul Moebius-3
Hi Max

I am using FM11Server with Lasso8.5

The clients will have the database open already and will be logged in....

I am retrieving schedule event records from filemaker and building a JSON Array to feed FullCalendar and that is being fed into the URL field in FileMaker

Everything works great and I can drag and drop calendar and gantt events but I want to click on the event link and open the filemaker project

How do you pass events variables from a URL Link to:

fmp7://192.168.1.72/SeedCodeComplete.fp7?-layout=Projects&-RecordID=178


On Sep 20, 2014, at 1:37 PM, Maxwell Klein <[hidden email]> wrote:

> That’s an interesting idea Paul. I send a lot of emails from Lasso to FileMaker users, for instance, when a new order is placed via a Lasso website. It would certainly simplify the workflow if those emails contained an attachment that linked directly to the orders/records in question. Curious to hear how that might best be done.
>
> On a similar note you might also look at the FileMaker FMP/URL/URI syntax, if you’re not already familiar:
>
> http://www.filemaker.com/help/12/fmp/html/sharing_data.16.7.html
>
> It’s different from the Snapshot Link file, but might also suite your needs. It allows you to open an FM database on a specific server and call a script with a given script parameter. Just like any other URI/URL the link could be provided by a web page or contained within an email.
>
> -Max
>
>
> On Sep 20, 2014, at 12:52 PM, Paul Moebius <[hidden email]> wrote:
>
>> Hi Guys
>>
>> How would I create, download and open a text file from a record retrieved link?
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <FPSL><UIState><UniversalPathList>fmnet:/192.168.1.99/DatabaseName</UniversalPathList><Layout id="[field:'Layout_ID']"></Layout><View type="form"></View><SelectedRow type="nativeID" id=[field:'RecordID']></SelectedRow><StatusToolbar visible="True"></StatusToolbar><Mode value="browseMode"></Mode></UIState></FPSL>
>>
>> The file would have to contain the above information and would be saved with a .fpsl extension so that FileMaker can open on a local computer
>>
>>
>> #############################################################
>> Attend the Lasso Developer Conference 2014!
>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>> http://www.lassosoft.com/LDC-newmarket-2014
>>
>> #############################################################
>>
>> 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]>
>
> #############################################################
> Attend the Lasso Developer Conference 2014!
> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
> http://www.lassosoft.com/LDC-newmarket-2014
>
> #############################################################
>
> 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]>

#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014

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

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: FileMaker Snapshot link XML document creation

Paul Moebius-3
I think the problem I am trying to get around is the fp7 url format does not allow for specifying scripts or layouts.



On Sep 20, 2014, at 4:31 PM, Paul Moebius <[hidden email]> wrote:

> Hi Max
>
> I am using FM11Server with Lasso8.5
>
> The clients will have the database open already and will be logged in....
>
> I am retrieving schedule event records from filemaker and building a JSON Array to feed FullCalendar and that is being fed into the URL field in FileMaker
>
> Everything works great and I can drag and drop calendar and gantt events but I want to click on the event link and open the filemaker project
>
> How do you pass events variables from a URL Link to:
>
> fmp7://192.168.1.72/SeedCodeComplete.fp7?-layout=Projects&-RecordID=178
>
>
> On Sep 20, 2014, at 1:37 PM, Maxwell Klein <[hidden email]> wrote:
>
>> That’s an interesting idea Paul. I send a lot of emails from Lasso to FileMaker users, for instance, when a new order is placed via a Lasso website. It would certainly simplify the workflow if those emails contained an attachment that linked directly to the orders/records in question. Curious to hear how that might best be done.
>>
>> On a similar note you might also look at the FileMaker FMP/URL/URI syntax, if you’re not already familiar:
>>
>> http://www.filemaker.com/help/12/fmp/html/sharing_data.16.7.html
>>
>> It’s different from the Snapshot Link file, but might also suite your needs. It allows you to open an FM database on a specific server and call a script with a given script parameter. Just like any other URI/URL the link could be provided by a web page or contained within an email.
>>
>> -Max
>>
>>
>> On Sep 20, 2014, at 12:52 PM, Paul Moebius <[hidden email]> wrote:
>>
>>> Hi Guys
>>>
>>> How would I create, download and open a text file from a record retrieved link?
>>>
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <FPSL><UIState><UniversalPathList>fmnet:/192.168.1.99/DatabaseName</UniversalPathList><Layout id="[field:'Layout_ID']"></Layout><View type="form"></View><SelectedRow type="nativeID" id=[field:'RecordID']></SelectedRow><StatusToolbar visible="True"></StatusToolbar><Mode value="browseMode"></Mode></UIState></FPSL>
>>>
>>> The file would have to contain the above information and would be saved with a .fpsl extension so that FileMaker can open on a local computer
>>>
>>>
>>> #############################################################
>>> Attend the Lasso Developer Conference 2014!
>>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>>> http://www.lassosoft.com/LDC-newmarket-2014
>>>
>>> #############################################################
>>>
>>> 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]>
>>
>> #############################################################
>> Attend the Lasso Developer Conference 2014!
>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>> http://www.lassosoft.com/LDC-newmarket-2014
>>
>> #############################################################
>>
>> 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]>
>
> #############################################################
> Attend the Lasso Developer Conference 2014!
> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
> http://www.lassosoft.com/LDC-newmarket-2014
>
> #############################################################
>
> 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]>

#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014

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

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: FileMaker Snapshot link XML document creation

Paul Moebius-3
This works to serve the fpsl file... but don't think FileMaker allows Lasso to access the <SelectedRow type="nativeID" id="11980">
pointer.


<?LassoScript

File_Create: 'myfile.fpsl';

var:'fpsl_data'=(string_concatenate: '<?xml version="1.0" encoding="UTF-8"?><FPSL><UIState><UniversalPathList>fmnet:/192.168.1.99/SeedCodeComplete</UniversalPathList><Layout id="14"></Layout><View type="form"></View><SelectedRow type="nativeID" id="11980"></SelectedRow><StatusToolbar visible="True"></StatusToolbar><Mode value="browseMode"></Mode></UIState></FPSL>');

File_Serve: $fpsl_data, -File='fpsl_data.fpsl', -Type='text/fpsl';
?>



On Sep 20, 2014, at 4:59 PM, Paul Moebius <[hidden email]> wrote:

> I think the problem I am trying to get around is the fp7 url format does not allow for specifying scripts or layouts.
>
>
>
> On Sep 20, 2014, at 4:31 PM, Paul Moebius <[hidden email]> wrote:
>
>> Hi Max
>>
>> I am using FM11Server with Lasso8.5
>>
>> The clients will have the database open already and will be logged in....
>>
>> I am retrieving schedule event records from filemaker and building a JSON Array to feed FullCalendar and that is being fed into the URL field in FileMaker
>>
>> Everything works great and I can drag and drop calendar and gantt events but I want to click on the event link and open the filemaker project
>>
>> How do you pass events variables from a URL Link to:
>>
>> fmp7://192.168.1.72/SeedCodeComplete.fp7?-layout=Projects&-RecordID=178
>>
>>
>> On Sep 20, 2014, at 1:37 PM, Maxwell Klein <[hidden email]> wrote:
>>
>>> That’s an interesting idea Paul. I send a lot of emails from Lasso to FileMaker users, for instance, when a new order is placed via a Lasso website. It would certainly simplify the workflow if those emails contained an attachment that linked directly to the orders/records in question. Curious to hear how that might best be done.
>>>
>>> On a similar note you might also look at the FileMaker FMP/URL/URI syntax, if you’re not already familiar:
>>>
>>> http://www.filemaker.com/help/12/fmp/html/sharing_data.16.7.html
>>>
>>> It’s different from the Snapshot Link file, but might also suite your needs. It allows you to open an FM database on a specific server and call a script with a given script parameter. Just like any other URI/URL the link could be provided by a web page or contained within an email.
>>>
>>> -Max
>>>
>>>
>>> On Sep 20, 2014, at 12:52 PM, Paul Moebius <[hidden email]> wrote:
>>>
>>>> Hi Guys
>>>>
>>>> How would I create, download and open a text file from a record retrieved link?
>>>>
>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>> <FPSL><UIState><UniversalPathList>fmnet:/192.168.1.99/DatabaseName</UniversalPathList><Layout id="[field:'Layout_ID']"></Layout><View type="form"></View><SelectedRow type="nativeID" id=[field:'RecordID']></SelectedRow><StatusToolbar visible="True"></StatusToolbar><Mode value="browseMode"></Mode></UIState></FPSL>
>>>>
>>>> The file would have to contain the above information and would be saved with a .fpsl extension so that FileMaker can open on a local computer
>>>>
>>>>
>>>> #############################################################
>>>> Attend the Lasso Developer Conference 2014!
>>>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>>>> http://www.lassosoft.com/LDC-newmarket-2014
>>>>
>>>> #############################################################
>>>>
>>>> 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]>
>>>
>>> #############################################################
>>> Attend the Lasso Developer Conference 2014!
>>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>>> http://www.lassosoft.com/LDC-newmarket-2014
>>>
>>> #############################################################
>>>
>>> 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]>
>>
>> #############################################################
>> Attend the Lasso Developer Conference 2014!
>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>> http://www.lassosoft.com/LDC-newmarket-2014
>>
>> #############################################################
>>
>> 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]>
>
> #############################################################
> Attend the Lasso Developer Conference 2014!
> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
> http://www.lassosoft.com/LDC-newmarket-2014
>
> #############################################################
>
> 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]>

#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014

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

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: FileMaker Snapshot link XML document creation

maxwellk2
In reply to this post by Paul Moebius-3
Correct, the URL link method for script and script parameters is limited to FM12 and higher, sorry I didn’t specify that.



On Sep 20, 2014, at 4:59 PM, Paul Moebius <[hidden email]> wrote:

> I think the problem I am trying to get around is the fp7 url format does not allow for specifying scripts or layouts.
>
>
>
> On Sep 20, 2014, at 4:31 PM, Paul Moebius <[hidden email]> wrote:
>
>> Hi Max
>>
>> I am using FM11Server with Lasso8.5
>>
>> The clients will have the database open already and will be logged in....
>>
>> I am retrieving schedule event records from filemaker and building a JSON Array to feed FullCalendar and that is being fed into the URL field in FileMaker
>>
>> Everything works great and I can drag and drop calendar and gantt events but I want to click on the event link and open the filemaker project
>>
>> How do you pass events variables from a URL Link to:
>>
>> fmp7://192.168.1.72/SeedCodeComplete.fp7?-layout=Projects&-RecordID=178
>>
>>
>> On Sep 20, 2014, at 1:37 PM, Maxwell Klein <[hidden email]> wrote:
>>
>>> That’s an interesting idea Paul. I send a lot of emails from Lasso to FileMaker users, for instance, when a new order is placed via a Lasso website. It would certainly simplify the workflow if those emails contained an attachment that linked directly to the orders/records in question. Curious to hear how that might best be done.
>>>
>>> On a similar note you might also look at the FileMaker FMP/URL/URI syntax, if you’re not already familiar:
>>>
>>> http://www.filemaker.com/help/12/fmp/html/sharing_data.16.7.html
>>>
>>> It’s different from the Snapshot Link file, but might also suite your needs. It allows you to open an FM database on a specific server and call a script with a given script parameter. Just like any other URI/URL the link could be provided by a web page or contained within an email.
>>>
>>> -Max
>>>
>>>
>>> On Sep 20, 2014, at 12:52 PM, Paul Moebius <[hidden email]> wrote:
>>>
>>>> Hi Guys
>>>>
>>>> How would I create, download and open a text file from a record retrieved link?
>>>>
>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>> <FPSL><UIState><UniversalPathList>fmnet:/192.168.1.99/DatabaseName</UniversalPathList><Layout id="[field:'Layout_ID']"></Layout><View type="form"></View><SelectedRow type="nativeID" id=[field:'RecordID']></SelectedRow><StatusToolbar visible="True"></StatusToolbar><Mode value="browseMode"></Mode></UIState></FPSL>
>>>>
>>>> The file would have to contain the above information and would be saved with a .fpsl extension so that FileMaker can open on a local computer
>>>>
>>>>
>>>> #############################################################
>>>> Attend the Lasso Developer Conference 2014!
>>>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>>>> http://www.lassosoft.com/LDC-newmarket-2014
>>>>
>>>> #############################################################
>>>>
>>>> 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]>
>>>
>>> #############################################################
>>> Attend the Lasso Developer Conference 2014!
>>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>>> http://www.lassosoft.com/LDC-newmarket-2014
>>>
>>> #############################################################
>>>
>>> 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]>
>>
>> #############################################################
>> Attend the Lasso Developer Conference 2014!
>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>> http://www.lassosoft.com/LDC-newmarket-2014
>>
>> #############################################################
>>
>> 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]>
>
> #############################################################
> Attend the Lasso Developer Conference 2014!
> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
> http://www.lassosoft.com/LDC-newmarket-2014
>
> #############################################################
>
> 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]>

#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014

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

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: FileMaker Snapshot link XML document creation

Paul Moebius-3
Is there a way to calculate the NativeID ?

<SelectedRow type="nativeID" id="11980">

Similar to calculating Layout number?
http://www.briandunning.com/cf/582



On Sep 20, 2014, at 7:10 PM, Maxwell Klein <[hidden email]> wrote:

> Correct, the URL link method for script and script parameters is limited to FM12 and higher, sorry I didn’t specify that.
>
>
>
> On Sep 20, 2014, at 4:59 PM, Paul Moebius <[hidden email]> wrote:
>
>> I think the problem I am trying to get around is the fp7 url format does not allow for specifying scripts or layouts.
>>
>>
>>
>> On Sep 20, 2014, at 4:31 PM, Paul Moebius <[hidden email]> wrote:
>>
>>> Hi Max
>>>
>>> I am using FM11Server with Lasso8.5
>>>
>>> The clients will have the database open already and will be logged in....
>>>
>>> I am retrieving schedule event records from filemaker and building a JSON Array to feed FullCalendar and that is being fed into the URL field in FileMaker
>>>
>>> Everything works great and I can drag and drop calendar and gantt events but I want to click on the event link and open the filemaker project
>>>
>>> How do you pass events variables from a URL Link to:
>>>
>>> fmp7://192.168.1.72/SeedCodeComplete.fp7?-layout=Projects&-RecordID=178
>>>
>>>
>>> On Sep 20, 2014, at 1:37 PM, Maxwell Klein <[hidden email]> wrote:
>>>
>>>> That’s an interesting idea Paul. I send a lot of emails from Lasso to FileMaker users, for instance, when a new order is placed via a Lasso website. It would certainly simplify the workflow if those emails contained an attachment that linked directly to the orders/records in question. Curious to hear how that might best be done.
>>>>
>>>> On a similar note you might also look at the FileMaker FMP/URL/URI syntax, if you’re not already familiar:
>>>>
>>>> http://www.filemaker.com/help/12/fmp/html/sharing_data.16.7.html
>>>>
>>>> It’s different from the Snapshot Link file, but might also suite your needs. It allows you to open an FM database on a specific server and call a script with a given script parameter. Just like any other URI/URL the link could be provided by a web page or contained within an email.
>>>>
>>>> -Max
>>>>
>>>>
>>>> On Sep 20, 2014, at 12:52 PM, Paul Moebius <[hidden email]> wrote:
>>>>
>>>>> Hi Guys
>>>>>
>>>>> How would I create, download and open a text file from a record retrieved link?
>>>>>
>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>> <FPSL><UIState><UniversalPathList>fmnet:/192.168.1.99/DatabaseName</UniversalPathList><Layout id="[field:'Layout_ID']"></Layout><View type="form"></View><SelectedRow type="nativeID" id=[field:'RecordID']></SelectedRow><StatusToolbar visible="True"></StatusToolbar><Mode value="browseMode"></Mode></UIState></FPSL>
>>>>>
>>>>> The file would have to contain the above information and would be saved with a .fpsl extension so that FileMaker can open on a local computer
>>>>>
>>>>>
>>>>> #############################################################
>>>>> Attend the Lasso Developer Conference 2014!
>>>>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>>>>> http://www.lassosoft.com/LDC-newmarket-2014
>>>>>
>>>>> #############################################################
>>>>>
>>>>> 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]>
>>>>
>>>> #############################################################
>>>> Attend the Lasso Developer Conference 2014!
>>>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>>>> http://www.lassosoft.com/LDC-newmarket-2014
>>>>
>>>> #############################################################
>>>>
>>>> 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]>
>>>
>>> #############################################################
>>> Attend the Lasso Developer Conference 2014!
>>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>>> http://www.lassosoft.com/LDC-newmarket-2014
>>>
>>> #############################################################
>>>
>>> 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]>
>>
>> #############################################################
>> Attend the Lasso Developer Conference 2014!
>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>> http://www.lassosoft.com/LDC-newmarket-2014
>>
>> #############################################################
>>
>> 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]>
>
> #############################################################
> Attend the Lasso Developer Conference 2014!
> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
> http://www.lassosoft.com/LDC-newmarket-2014
>
> #############################################################
>
> 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]>

#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014

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

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: FileMaker Snapshot link XML document creation

maxwellk2
In reply to this post by Paul Moebius-3
Lasso knows the “id” value as KeyField_Value after a search:

        http://reference.lassosoft.com/LassoReference.LassoApp?[KeyField_Value]

You can also expose the “id” value in FileMaker by creating a calculated field with Get(RecordID)

        http://www.filemaker.com/help/11/fmp/html/func_ref2.32.56.html#1030601


Hope that helps.

-Max

On Sep 20, 2014, at 6:14 PM, Paul Moebius <[hidden email]> wrote:

> This works to serve the fpsl file... but don't think FileMaker allows Lasso to access the <SelectedRow type="nativeID" id="11980">
> pointer.
>
>
> <?LassoScript
>
> File_Create: 'myfile.fpsl';
>
> var:'fpsl_data'=(string_concatenate: '<?xml version="1.0" encoding="UTF-8"?><FPSL><UIState><UniversalPathList>fmnet:/192.168.1.99/SeedCodeComplete</UniversalPathList><Layout id="14"></Layout><View type="form"></View><SelectedRow type="nativeID" id="11980"></SelectedRow><StatusToolbar visible="True"></StatusToolbar><Mode value="browseMode"></Mode></UIState></FPSL>');
>
> File_Serve: $fpsl_data, -File='fpsl_data.fpsl', -Type='text/fpsl';
> ?>
>
>
>
> On Sep 20, 2014, at 4:59 PM, Paul Moebius <[hidden email]> wrote:
>
>> I think the problem I am trying to get around is the fp7 url format does not allow for specifying scripts or layouts.
>>
>>
>>
>> On Sep 20, 2014, at 4:31 PM, Paul Moebius <[hidden email]> wrote:
>>
>>> Hi Max
>>>
>>> I am using FM11Server with Lasso8.5
>>>
>>> The clients will have the database open already and will be logged in....
>>>
>>> I am retrieving schedule event records from filemaker and building a JSON Array to feed FullCalendar and that is being fed into the URL field in FileMaker
>>>
>>> Everything works great and I can drag and drop calendar and gantt events but I want to click on the event link and open the filemaker project
>>>
>>> How do you pass events variables from a URL Link to:
>>>
>>> fmp7://192.168.1.72/SeedCodeComplete.fp7?-layout=Projects&-RecordID=178
>>>
>>>
>>> On Sep 20, 2014, at 1:37 PM, Maxwell Klein <[hidden email]> wrote:
>>>
>>>> That’s an interesting idea Paul. I send a lot of emails from Lasso to FileMaker users, for instance, when a new order is placed via a Lasso website. It would certainly simplify the workflow if those emails contained an attachment that linked directly to the orders/records in question. Curious to hear how that might best be done.
>>>>
>>>> On a similar note you might also look at the FileMaker FMP/URL/URI syntax, if you’re not already familiar:
>>>>
>>>> http://www.filemaker.com/help/12/fmp/html/sharing_data.16.7.html
>>>>
>>>> It’s different from the Snapshot Link file, but might also suite your needs. It allows you to open an FM database on a specific server and call a script with a given script parameter. Just like any other URI/URL the link could be provided by a web page or contained within an email.
>>>>
>>>> -Max
>>>>
>>>>
>>>> On Sep 20, 2014, at 12:52 PM, Paul Moebius <[hidden email]> wrote:
>>>>
>>>>> Hi Guys
>>>>>
>>>>> How would I create, download and open a text file from a record retrieved link?
>>>>>
>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>> <FPSL><UIState><UniversalPathList>fmnet:/192.168.1.99/DatabaseName</UniversalPathList><Layout id="[field:'Layout_ID']"></Layout><View type="form"></View><SelectedRow type="nativeID" id=[field:'RecordID']></SelectedRow><StatusToolbar visible="True"></StatusToolbar><Mode value="browseMode"></Mode></UIState></FPSL>
>>>>>
>>>>> The file would have to contain the above information and would be saved with a .fpsl extension so that FileMaker can open on a local computer
>>>>>
>>>>>
>>>>> #############################################################
>>>>> Attend the Lasso Developer Conference 2014!
>>>>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>>>>> http://www.lassosoft.com/LDC-newmarket-2014
>>>>>
>>>>> #############################################################
>>>>>
>>>>> 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]>
>>>>
>>>> #############################################################
>>>> Attend the Lasso Developer Conference 2014!
>>>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>>>> http://www.lassosoft.com/LDC-newmarket-2014
>>>>
>>>> #############################################################
>>>>
>>>> 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]>
>>>
>>> #############################################################
>>> Attend the Lasso Developer Conference 2014!
>>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>>> http://www.lassosoft.com/LDC-newmarket-2014
>>>
>>> #############################################################
>>>
>>> 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]>
>>
>> #############################################################
>> Attend the Lasso Developer Conference 2014!
>> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
>> http://www.lassosoft.com/LDC-newmarket-2014
>>
>> #############################################################
>>
>> 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]>
>
> #############################################################
> Attend the Lasso Developer Conference 2014!
> October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
> http://www.lassosoft.com/LDC-newmarket-2014
>
> #############################################################
>
> 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]>

#############################################################
Attend the Lasso Developer Conference 2014!
October 1-3, 2014 at Treefrog HQ, Newmarket, Ontario, Canada
http://www.lassosoft.com/LDC-newmarket-2014

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

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]>