1 2 Previous Next 19 Replies Latest reply: Feb 7, 2014 10:32 AM by SGIII Go to original post
  • 15. Re: Dropping csv file into a cell?
    SGIII Level 5 Level 5 (4,130 points)

    Thanks for that, Badunit. Interesting what Automator can do to make life more convenient. I suppose one could do something that would allow dropping a CSV file onto an app as well (droplet?) but that would only make sense for processing of multiple files at once. Your right-click and contextual menu pick is more convenient.

     

    Since you are not (yet) an "identified developer" I was blocked from opening the workflow until I went to System Preferences > Security & Privacy and clicked 'Open Anyway'.

     

    Screen Shot 2014-02-06 at 8.44.44 PM.png

     

    I see some of the key modifications to make it a service include choosing receives 'files or folders' in 'Finder.app' and wrapping the script an on run() handler with the file parameter. Nice.

     

     

    Screen Shot 2014-02-06 at 8.46.40 PM.png

     

     

    Would love it to be able to recognize the separator (, ; | etc) automatically but that's beyond my abilities. It's working well here as is.

     

    SG

  • 16. Re: Dropping csv file into a cell?
    Badunit Level 6 Level 6 (10,815 points)

    I had never made a service that required an AppleScript script to receive an input. I took my best guess and gave it a shot and it worked.

     

    I am surprised the security won't let you open a workflow in Automator without expressly choosing "open anyway". I can understand it not letting you run the workflow but I'd have thought it would let you edit it.  Better safe than sorry I suppose.

  • 17. Re: Dropping csv file into a cell?
    SGIII Level 5 Level 5 (4,130 points)

    surprised the security won't let you open a workflow in Automator without expressly choosing "open anyway".

     

    That's because being a nervous Nelly (or perhaps that's the default, I can't remember) my Security & Privacy preferences were set to allow apps downloaded from 'Mac App Store and identified developers.'  If they had been set to 'Anywhere' I don't think there would have been a warning. No problem reading, and editing, after choosing 'Open Anyway.'

     

    SG

  • 18. Re: Dropping csv file into a cell?
    Cuky Level 1 Level 1 (0 points)

    Wow thanks SGIII and Badunit!

     

    That's a perfect solution for me

  • 19. Re: Dropping csv file into a cell?
    SGIII Level 5 Level 5 (4,130 points)

    And we all owe a debt of gratitude to Nigel Garvey, who wrote and posted the CSV converter handler (subroutine) here on macscripter.net.  If you want to explore the inner workings, his version there has abundant explanatory comments in the code.

     

    I've fossicked through forums on the web from time to time trying to find solutions to perennial csv headaches. Initial hope has inevitably turned into eventual disappointment. But this one is good. I don't fully understand how it does its magic, but like the results.

     

    SG

1 2 Previous Next