akappy

When I use FTPeek_ConnectSFTP from a Mac, I connect with no problem. Using the same script on Windows returns an error on the public key. The FTPeek_GetPublicKey returns slightly different results on the two platforms as noted below. Neither format seems to work in the Windows script. FTPeek_GetPublicKey on Mac returns: ssh-rsa AAAA[...] FTPeek_GetPublicKey on Windows returns: ---- BEGIN SSH2 PUBLIC KEY ---- AAAA[...]---- END SSH2 PUBLIC KEY ---- Andy Kappy

David, If I understand correctly, I'd need a more complex relationship with the target of the post to use the functions in ScriptMaster. Passing the URL into a web viewer is not available as a server-side scripting function. Is your Web Assistant able to run in a server-side script? Andy

I've been running a script that imports orders from our client and posts a response in the format: http://company.stage.program.com/updateOrderXml.asp?xml=12345RECEIVED BY PRINTER11/4/2010 9:30:06 AM > I need to run the script server-side, so I want to use scriptmaster to post the URL. We've registered the PostDataToUrl and the result of our script using the function is only "Error" Not having a "Key" or "Value", I formatted the setfield to: PostDataToURL( "" ; "" ; URLField ) Any suggestions? Andy

Valentin, This is resolved. As per your recommendation, uninstalling, rebooting and reinstalling Java on the server did the trick. FTPeek plugin enables on the server and the serverside script now runs successfully. Thanks, Andy

I downloaded and installed the latest java. Still cannot save enable for FTPeek.

We're now at the most current version. Works fine on FMPA 10,11 workstations. FMSA 11 won't load the plugin, won't save the check box as checked. I have sent the "bug report". I had to let this issue be on back burner for a while as I had turned to other responsibilities. Andy

Be wary of update to FM Server Adv 11. Server side script schedules are getting user permission errors, regardless of user rights. As of Jul 12th FM support says they are working on it. There are messages in Tech Talk dating back to at least May 2nd on this. Andy

I haven't completed all of my testing yet, but it appears that the latest update to FTPeek fixed the problem.

Recording the errors was a good suggestion. I put a get(lasterror) to a separate field after each FTPeek step and each one produced a "0" result. Tried again, this time using FTPeek Last Error and got "?" as a result for each FTPeek step.

My script was working for weeks. Then the FTP transfers stopped. If I run the script from a client on the server and it runs fine. The server indicates that the script ran OK, but no transfer occurred. Any suggestions for diagnosing the problem? Andy Kappy

There is no 360Plugin Logs folder in ...FileMaker ServerLogs (there is a Troi Log folder there, so I'm sure I'm looking in the right place) I've set full control to the fmserver user on the folder in question, no help. I set write privileges for the Guest user, still no help.

When I run as a server scheduled script, it succeeds in getting the file list from the FTP site, and moving the files to another folder on the FTP site. It fails to download the files. The same script works fine when running from a client on the same box as the server. Does FTPeek write a log anywhere? Any suggestions on how to analyze the failure?

Thanks once again.

That did the trick. I was not returning to the BaseImportXML table when I should have been. Problem solved. Any suggestions on a better way to create these records in the Inserts table? I thought about using a Portal, but I don't see how to script a new record in the Portal Thanks, Andy

Still no joy. Whether I use my original calculation (single variable), the two variable version, or the custom function, I only get exactly as desired if I put an actual number for the Occurrence in the Position function. If I use 1 I get "firstpdf", if I use 2, I get "secondpdf". That works just fine. However, if I try to use the variable, $pdfnum or $$pdfnum, I get the first instance just fine in $$insert, the rest return a blank to $$insert, which I'm watching in Data Viewer. In the script example below Line #16 (and disabled #17) are the lines of interest. Line #17 was my last sample of the calculation using separate variables for the start and end positions. Line #16 is using the custom function from NRGSoft, which I've named ExtractXML. Here is a snippet of the XML source which is imported into the field: "BaseImportXML::RAW Text". ------------------------- 24517 CT 13 2 15 TEST True firstpdf secondpdf first insert second insert third insert fourth insert fifth insert ----------------------- Here is the relevant portion of the script: ------------------ 1 • Go to Layout [ “BaseImportXML” (BaseImportXML) ] 2 • Perform Find [ Specified Find Requests: Find Records; Criteria: BaseImportXML::InsertFlag: “0” ] [ Restore ] 3 • Go to Record/Request/Page [ First ] 4 • Loop 5 • Set Variable [ $$orderid; Value:BaseImportXML::OrderID ] 6 • Set Variable [ $$totalquantity; Value:BaseImportXML::TotalQuantity ] 7 • Set Variable [ $$ordinal; Value:1 ] 8 • Set Variable [ $pdfnum; Value:1 ] 9 • Set Variable [ $pdfnum2; Value:1 ] 10 • Set Variable [ $$insertnum; Value:1 ] 11 • Set Variable [ $$date; Value:BaseImportXML::EntryDate ] 12 • Set Variable [ $$pdfcnt; Value:BaseImportXML::PDFCnt ] 13 • Set Variable [ $$insertcnt; Value:BaseImportXML::InsertCnt ] 14 • #Get PDFs 15 • Loop 16 • Set Variable [ $$insert; Value:ExtractXML ( BaseImportXML::RAW Text ; "PDF" ; 1 ) ] 17 • // Set Variable [ $$insert; Value:Middle ( BaseImportXML::RAW Text ; Position (BaseImportXML::RAW Text;"";1;$pdfnum)+5; Position (BaseImportXML::RAW Text;"";1;$pdfnum2)-Position (BaseImportXML::RAW Text;"";1;$pdfnum)-5) ] 18 • Go to Layout [ “Inserts” (Inserts) ] 19 • New Record/Request 20 • Set Field [ Inserts::OrderID; $$orderid ] 21 • Set Field [ Inserts::Insert; $$insert ] 22 • Set Field [ Inserts::Ordinal; $$ordinal ] 23 • Set Field [ Inserts::Type; "PDF" ] 24 • Set Field [ Inserts::DateStamp; $$date ] 25 • Set Field [ Inserts::PageCount; 4 ] 26 • Set Variable [ $pdfnum; Value:$pdfnum+1 ] 27 • Set Variable [ $pdfnum2; Value:$pdfnum2+1 ] 28 • Set Variable [ $$ordinal; Value:$$ordinal+1 ] 29 • Exit Loop If [ $$pdfnum>$$pdfcnt ] 30 • End Loop ---------------------

Comment and Fitch, thanks to you both. You've given me a lot to chew on, I'll work with these suggestions and let you know how I make out. Andy

The calculation has no trouble with "tag" vs "tag2" and this is a fair representation of the actual data. If I use a specific number, ie. 1, 2 or 3, instead of $num, it works correctly and extracts WORD, WORD2 or WORD3 respectively. My only issue is getting the variable to work. I am actually parsing a short XML file as I do not have the skills to build an XSLT to import using XML functionality. The real tags look more like and . All other aspects of the parsing work correctly.

I have a looping script to extract a series of words from some raw text. Sample Text: tagWORDtag2 tagWORD2tag2 tagWORD3tag2 I should be able to extract, WORD, WORD2 and then WORD3 in three iterations of the loop. I set the variable "$num=$num+1" before each iteration. I am trying to use a calculation to extract the text as follows: Middle ( Fieldname ; Position ( Fieldname ; "tag" ; 1 ; $num) +3; Position ( Fieldname ; "tag2" ; 1 ; $num) - Position (Fieldname ; "tag" ; 1 ; $num)-3 ) The first iteration does get the first occurrence, "WORD", each additional iteration is returning a blank. Any suggestions?