OS X Technologies :: Automator - How To Batch Import TXT Files Into Excel
Mar 6, 2012
I have been using Automator to import hundreds of text files into one excel workbook using the "Import Text files to Excel Workbook" action. Automator works great for all files that are tab delimited. However I have another set of data that are output with a varying amount of spaces between each column. I cannot change the way they are output.
Automator gives me the option of choosing "space" as a delimiter, but it wont give me the option to "Treat consecutive delimiters as one" that Import within excel does. I also tried to record my actions within excel many times but it didn't work even with just one file. So what I need is a way to get these text files into one excel workbook as separate worksheets with the data separated correctly into columns.
Info:
MacBook, Mac OS X (10.6.8)
View 1 Replies
ADVERTISEMENT
Aug 7, 2010
I have a collection of .htm files saved onto my Mac hard drive. I want to convert them to .jpg files--all at once. I found a Windows program that could do it, but when it converted them, it would not retain the original file names. It gave them a sequential file name, i.e. _1.jpg, _2.jpg, _3.jpg ~ _263.jpg. There is no option to retain the original file names...:/
EDIT: (i.e. marketingtable.htm > marketingtable.jpg)
So my question is, is there an Automator process that could batch convert .htm files to .jpg? Or is there an app for Mac that can batch convert .htm files to image (.jpg) files?
I usually am able to find the answer to all my questions with Google, and this time I thought I had as well with the Windows app, but it brought upon too much of a feat for me to handle.
(Also, if there's an Automator process to batch rename files using a .txt file as a reference for the new names of the files, that'd be awesome as well.
View 2 Replies
View Related
Mar 11, 2012
I'm trying to create an Automator service for the Finder in Lion. It gives me an "error in shell script". I just created a similar script that uses "imguru" to upload images to [URL] which works great, so i'm thinking that it's must be the line with "unzip" that creates a problem.Â
Info:
MBP late 2009
View 4 Replies
View Related
Jun 25, 2014
I've set up an Automator to batch rename files. The renaming works fine. The problem arises when it renames a file which doesn't contain it's extension (a common MacOS practice). Is there some way to make sure it preserves the filetype? For instance, this works fine:Â
Original:
Output:
 And this results in an error:Â
Original:
Output (file type has been replaced with generic "document" type)
Automator logic, can be viewed here.
View 4 Replies
View Related
Apr 11, 2012
in the past I deleted Automator, can an update re-install an Automator?
View 1 Replies
View Related
Jun 10, 2012
Trying to set view of all subfolders of a multi-thousand image folder to 180 x 180, and yet Automator (in Snow Lep) doesn't seem to allow anything above 128:
View 5 Replies
View Related
Feb 8, 2012
I had been using automator quite successfully until recently now I'm unable to get automator to step through even the most basic setup. It refuses to step through to the second action and perpetually runs without producing any results as the image below shows.for any of my automator setups I get results for the first step and then an indefinate hang on the second leaving the step icon greyed out. I have tried this with numerous other actions like calendars etc but to no avail. Below are the very basic automator steps I'm using in this example.Â
Info:
iMac, Mac OS X (10.7.2)
View 10 Replies
View Related
Jun 20, 2012
i have an Automator "application" that i made with the help of people on this very board that worked flawlessly on Snow Leopard and previous OSs but doesn't work in Lion anymore.i was hoping if someone could look at the file (link below) and either tell me what needs to be changed, or go right in and change it for me! (i don't really have much experience with scripting). i have a txt file with a list of filenames. the script references this list, goes to the folder that contains these files (but the folder also has other files in it too) and copies the referenced files into a new folder. url...
View 14 Replies
View Related
Mar 22, 2012
I'm a new Mac user and was just reading about "Automator" My question is would it be possible to create a workflow etc, to save an excel or word file to two different locations or directories?
Info:
iMac, Mac OS X (10.7.2)
View 5 Replies
View Related
Mar 14, 2012
I'm updating an Automator workflow for OS X Lion that I initally developed and used, without issue, in OS X Tiger. The workflow asks for a name, creates a folder for the name, takes a digital image with a Nikon D50 connected to the computer, and saves the image to the new folder. This aspect of the workflow works fine.Â
I then have a prompt asking if we should take another. If the user says "yes," the script should take another image and save it to the folder. This is where I run into an issue. When I attempt to add another "Take a Picture Action" into the workflow, I get the cryptic (at least to me) error message in the attached screenshot. Â Â
Here's the text:Â
"Cannot update for observer <AMWorkflow 0x400458ac0> for the key path "parameters.name" from <TakePicture 0x403e3b0a0>, most likely because the value for the key "parameters" has changed without an appropriate KVO notification being sent. Check the KVO-compliance of the TakePicture class."Â
The language of this error would seem to indicate a bug.
Info:
MacBook, Mac OS X (10.7.3), White
View 1 Replies
View Related
Mar 20, 2012
I'm trying to automatically convert Excel files to PDFs using Automator. Although, every time the Excel file is opened, I get a message about links to other workbooks. I really don't care about these links and just want to convert the file to a PDF. I just can't get Automator to press the "Ignore links" button on the Excel message.Now I've found out that pressing the escape key on my keyboard activates the following buttons on the Excel message about the links:
- "Update links" (then there's a Finder window popping up)
- "Cancel" (the search for other workbooks) (another Finder window pops up)
- "Cancel" again
Then Excel opens up the file I need to convert, so I can actually convert it using Automator and do whatever I want with it.I have absolutely no experience using AppleScript.Is there a way to make a AppleScript that presses the escape key three times, so that Excel just opens my file?
Info:
Mac OSX Lion Server, Mac OS X (10.7.3)
View 4 Replies
View Related
Mar 20, 2012
I have got an email with an attached zip file. When I downloaded it to my computer it became a text ed file. This file contacts lots of names and addresses that I would like to make mailing labels for. To do that, I must merge it to excel.
Info:
Mac mini (Early 2009), Mac OS X (10.5.8)
View 1 Replies
View Related
May 27, 2012
I would like to transfer mail rules to another mac, but am not aware of how to do it. Where are mail rules stored?
Info:Mac mini, Mac OS X (10.7.3)
View 2 Replies
View Related
Apr 5, 2012
I would like to transfer my contacts from address book to an excel spreadsheet. Is this possible.
Info:
iMac (27-inch Mid 2011)
View 1 Replies
View Related
Jul 6, 2012
I've set up my mail accounts (me.com, and live.co.uk) and am sending and recieving emails just fine, however old emails were never imported over.How can I import all the emails in my webmail so that they show up in Mail? Its irritating having to sign-into my webmail to read an older email (I only set up Mail 3 days ago).
Info:
Mail, Mac OS X (10.7.3)
View 9 Replies
View Related
Sep 21, 2009
Is there a way to select all the files I want to rename and then hit a button the OS will rename them all in sequence for me such as: file 1, file 2, file 3..... etc? Windows XP does this....
View 7 Replies
View Related
Aug 28, 2014
I searched on this topic and just find old references to "Address Book" which i guess does not exist anymore.Â
I have an Excel worksheet of about 200 names, street addresses, and email addresses, one contact in each row. One column is the email addresses, which is all I want. If I could get the names too that would be nice. Â
I try the Contacts import command, but cannot import the section of the worksheet I want. I don't know what I'm doing wrong. I highlight the contacts column in the worksheet and go to the file with the Contacts import command and find it is "dimmed" -- I cannot click on it.
View 2 Replies
View Related
Apr 30, 2008
I have a digital photo frame to see my pictures, but it only plays photos secuencially, it can't be set on "shuffle". So if I could rename the photos with random names, then the effect would be the same, as I would be seeing them in "shuffle".
I know automator can rename files, and there are many many apps that also rename, but I haven't found one that can give the files a random name!
View 24 Replies
View Related
Mar 3, 2004
I've got a whole bunch of photos in various subfolders. Some of these photos have the same relative name (ie same file name but in different folders).
I would like to rename all these files like 000001.ext, 000002.ext etc, independently of file location so I can copy all the files back to one single folder (I can handle that bit in Terminal). There are many sub-folders so I need something recursive.
I've tried Renamer4Mac, but it isn't recursive. Does anyone know of a different app that would work, or even a terminal command/script/binary that would do the trick?
View 19 Replies
View Related
Apr 15, 2012
I am looking for the solution to batch rename multiple avi files simply. In iphoto, I just select a bunch of image files and using the ctrl+Shift+CMD keyboard shortcut, I input the name something like 'boat_trip_kids' I get the files renamed instantly wiith or without the suffix of a number.Thing is, how to do for vdo files ?I read a totorial and then tried using automator to do this but I have to input the name_of_the_file in the script construction. That's ok for hundreds of files but I will have many names to use for naming of small groups of files and this won't be practical.Is there some way I can achieve this in automator?
Info:
MacBook, Mac OS X (10.7.3)
View 1 Replies
View Related
Apr 8, 2009
My phone only plays .aac files, and I would like to convert all my DRM free iTunes songs to .aac so I can...well play them on my phone.
View 8 Replies
View Related
Jul 22, 2009
How can I see what encoding my files have and also batch convert them to ISO or UTF-8 i.e.?
View 1 Replies
View Related
Nov 15, 2006
Automator blows. I have worked for two days on this and can not make automator put a simple jpg image as a watermark on a selected bunch of PDF files and then save them as the same file name. This seems to be the consensus on the net too.
Any programs you can reccomend that would make this easy for me to do? I have to do over 500 files and there is no way I am doing this by hand.
View 7 Replies
View Related
Oct 24, 2010
How do I batch change files' UNIX settings? I have web sharing turned on and have it set up so it's serve up the files and folders on my hard disk. It works great, but when I look at the folders it's showing in the web page, approximately 1 in 10 folders just isn't being displayed. The OS X permissions on these folders is all set to "read and write" for everyone, so I presume there is some sort of other UNIX or Apache file/folder settings that are keeping these folders from being displayed in the webpage. How do I make these hidden folders show up in my web page's displayed directory of folders?
View 7 Replies
View Related
Jul 19, 2010
Is there an app that can batch convert multiple video files? I found one called mpegstream clip which is good, but it seems to only do one at a time, it there a feature in it that can do more than one at a time? One at a time is ok for 4 videos or less, but when I have more than that it can get a little tedious. Specifically, I need something that can batch convert my mpg movies files my point & shoot digicam can take to a format that imovie 09 will import & work with.
View 6 Replies
View Related
Mar 14, 2008
Problem:
I have a folder with numerous subfolders, each containing numerous files that i would like to batch unlock (vs tediously unlocking each individual folder).
failed attempts involve:
- tried the following terminal action: sudo chflags -R nouchg ( as suggested on this website (http://docs.info.apple.com/article.html?artnum=106237) but it did not work.
I did not try the other suggestions on the website because it started getting really complicated and i was afraid to do something that may cause damage/delete my files
- tried unlocking the folders and subfolders, however each individual file within the corresponding folder/subfolders remained locked
Partial but suboptimal solutions tried:
- i found a partial but not optimal solution to my problem on this site:
however, the option-command-I will only allow me to unlock files each subfolder at a time (as i need to actually highlight the files themselves).
is there a way where i could just unlock all the folder/subfolders/files within an entire directory in one fell swoop?
My system:
- the new MBP running Mac OS X 10.5.2
i am a new mac user and i apologize in advance if there is some simple solution to this problem that i have yet failed to discover,
View 9 Replies
View Related
Mar 13, 2010
I have a long list of files to unrar (I use unarchive).
View 2 Replies
View Related
Jan 13, 2010
I need to merge about 17 excel files. All have the same headers and are data from different individuals on the same topics.How can I merge into 1 master file without cutting and pasting all 17 files into a master. Also would be great to be able to break out new spreadsheets by individual columns. ( i.e. Location, Part Number , ect ). A friend wrote a little program for me that worked when I was using a windows based machine, but will not work in the Mac environment.
View 3 Replies
View Related
Apr 22, 2010
I am completely new to using Automator so I'm sure I've missed something very basic.
I created an action to automatically move music I download from a music site from the Downloads folder into the folder I want them in so I don't have to do it manually.
Problem is, the action moves everything that gets downloaded into the Downloads folder. What do I need to do to have only music files moved, leaving any other file type alone?
View 1 Replies
View Related
Jun 1, 2012
I'm traveling tomorrow to Europe and am only taking my iPad and camera. I'm planning on using an SD card reader to upload my photos/videos to my iPad, then use Dropbox on the iPad to copy my daily shots to my Dropbox account. I'm thinking that I'll have an AppleScript on my home computer's /Dropbox/europe/ folder to look for newly added data and then auto import that into iPhoto. What's the best way to handle this? I got it working with a couple of test images but when iPhoto sees photos that it's already imported it asks me if I want to import in the duplicates or skip them. I'd like to skip them or write the AppleScript in a way that handles this. I'm also fine with copying the photos out of the Dropbox folder into a separate folder elsewhere and not using iPhoto. I'm just trying to theft proof my data in case my iPad gets stolen or if my Dropbox goes goofy and deletes the photos. Maybe copy newly added data to a designated directory outside of the Dropbox folder? How can I do this?Â
Info:
iMac, Mac OS X (10.6.8)
View 2 Replies
View Related
