Jump to content

fseipel

Members
  • Content Count

    222
  • Joined

  • Last visited

Community Reputation

0 Neutral

About fseipel

  • Rank
    member
  • Birthday 11/12/1970

Profile Information

  • Gender
    Male
  • Location
    Columbus, Ohio
  1. Yes, you can either set up an event to run on open, every time the Excel file is opened, or have the on open event check for a signal file or registry entry to determine whether to run macro. There is no command line switch to run a macro in MS Excel. Alternately you can launch a VBSCRIPT which can run the macro. See http://stackoverflow.com/questions/2050505/way-to-run-excel-macros-from-command-line-or-batch-file Other Office apps, such as Access, DO allow you to run a macro from command line, but not Excel.
  2. Noël, one other comment on this, you can actually determine where the lines begin & end with iText, by parsing through the tokens. You should find 'l' for line or 're' for rectangle. I would think you could then simply have two arrays, one for the horizontal line positions, and one for the vertical line positions. The FilteredTextRenderListener class which accepts a rectangle parameter, could then be used to parse the text in each 'cell', albeit with a speed penalty of repeated calls. This would have the advantage of being cross-platform, and not requiring Acrobat Pro or the conversion
  3. Noél, that will run only on Windows. For Mac you'll need to use Applescript. Of course, Acrobat Pro 9.0 or above is still required for this approach. If converted to SM using JACOB COM library, it will still run only on Windows because Macs don't use COM.
  4. qube99: v7 is circa 2005 so that is a rather old version; I think they added export to Excel in ~v9 circa 2008. Current version is 11. I'm still using 10. Hi again Noél, The OLE isn't too bad, the Javascript Guide/Acrobat SDK covers this pretty well, I had to do work with footers/headers a while back. Sorry if original message wasn't very clear about this not being included in Reader (any version). This VB Script will convert a PDF to Excel. I'm assuming one could convert this to Java or Groovy and run directly in ScriptMaster; i.e. build it into a global field or variable,
  5. Yes, you can use SM run shell script with the VOL command or VOL C: as the 'command' argument. Alternately you can write out a batch file from FM, say to temporary folder, e.g. diskpart select disk 0 detail disk exit and then run shell script on that to get the manufacturer and hardware SN The hardware SN is fixed; the VOL SN changes when Windows is re-installed. Note diskpart requires UAC Also if you put diskid32 in a container, you can write it to a temp file & then run it using SM, it returns a wealth of information http://www.winsim.com/diskid32/diskid32.ht
  6. If you 'Save as Excel' (a function available in Acrobat X Pro, which from your message, you have), you will generate a cleanly formatted file you can import into Filemaker that preserves the row/column structure present in the PDF file. If this needs to run on computers with only reader, it still allows conversion, but you have to use Adobe's online service to do so and buy a subscription, i.e. it's not included as it is in Pro Acrobat. You will still need to import into a temporary table since there are several rows before table begins, so script will simply skip until it hits headings row.
  7. @john: Thanks for fleshing out the code example. In past I've also used Filemaker's string functions to parse HTML, but the Java libraries seem like a potentially better choice, less likely to break, and more readable/maintainable. I don't see how the OP will be able to tell if an image has changed, short of downloading it and doing a byte comparison against the last downloaded copy, or at least a file byte length comparison (less reliable). If it has to do that over a large number of users/pages, it may be quite slow and a bandwidth hog. If the site(s) offer web services, that may
  8. The first parameter should be "renamecontainer::container", in quotes, i.e. the fully qualified container name, rather than renamecontainer::container which is a reference to the container contents..
  9. I'd suggest using an HTML parser such as jsoup, you can then retrieve the image link list easily, e.g. import org.jsoup.Jsoup; import org.jsoup.nodes.Document; import org.jsoup.nodes.Element; import org.jsoup.select.Elements; String results = ""; String url = 'http://www.amazon.com'; Document doc = Jsoup.connect(url).get(); Elements media = doc.select("[src]"); for (Element src : media) { if (src.tagName().equals("img")) results = results + src.tagName() + ':' + src.attr("abs:src") + 'n'; } return results;
  10. Tim, It's not a certainty, but the problem is most likely caused by the server being set for key authentication and NOT password authentication. Can you connect to it with Filezilla or other sftp client software? You may need to add key authentication to the code provided. In you client software, are keys set (e.g. in Filezilla, Settings|SFTP|Private keys)?
  11. I had to interface a scale with MS Access yesterday. The main complication was they also wanted the lab scale connected to a titrator, so I used an A/B switch. With Win7, it took some time to find a free keyboard wedge that allowed the 7-E-1 data settings (I had to match Titrator, as it was not configureable on comm settings). If possible, can you simply use a keyboard wedge? If the scale is set up with a PRINT button to print the weight, this works nicely. If scale sends data constantly, with a delimiter, you should be able to read it using standard java libraries, see for example http:/
  12. This is pretty much trivial, at least using the 360Works ScriptMaster plugin. I implemented this a couple months ago, could definitely use clean-up, it simply follows http://forums.ebay.com/db2/topic/File-Exchange/Can-Someone-Please/2000170031 Input variables/parameters, e.g. filename_to_upload = e.g. C:\Users\Frank\Documents\single_item.csv my_token=your token from eBay -- get it here http://pages.ebay.com/sellerinformation/sellingresources/fileexchange_programmaticupload.html ---------------------------------------------------------- /** * This is a sample *fully
  13. I take it you are converting from .fp7 to FM12 to resolve the problem. The file will open upon conversion. You could include a startup script that checks if the first record in a dummy table is set to say 'close', and if so, unset it and close file, or simply have startup script interrogate the converted file's name to determine whether to close. On successive opens the file will open. You can also perform script in the converted file. Since some commands, such as perform script in second file, don't accept variables (e.g. filename), you may end up needing to rename files prior to running
  14. Try running a network cable between the robot (client) computer and the switch nearest the server, and/or replacing all cables/switches in that path. Despite all the advice against it, I have never experienced problems running a robot on a server computer. You cannot trap this error within Filemaker. Obviously, addressing the root cause is preferred. Absent that, you can use Applescript to detect the error dialog, send a key to acknowledge it, and re-open the file and run a script, similar to what 'Okey Dokey Pro' used to do in the OS9 era, at least the acknowledge part. So you would acti
  15. You can name the container field on a layout (layout mode|click on container field, Edit Menu|View|Inspect|Position Tab, input layout name (alias) for container field in Name text input box). You can then have a script loop through the records, using GetLayoutObjectAttribute("Container Alias Name","content"). For (properly) inserted files, content will be the text comprising filename, no path. For OLE objects dragged & dropped, it will be '?'; for records with empty container field, 'content' will be empty. So that will at least identify the offending records. If the record also indic
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.