[FILE] Process Lines in Text File

Macro Library
10

@VWKM, sometimes it can be a challenge to get things just right.

I have fixed your Macro, but for educational purposes, let me first explain the problems and changes. Note: All of your original Actions are shown as dark grey (disabled), and my replacement Actions are shown in teal.

First, there was an error in @peternlewis' post:[quote="peternlewis, post:3, topic:2936"]
Set variable Index to 1
[/quote]

should have been:
Set variable Index to 0

Actually, a new index variable was NOT needed, since in my original macro I already had:

In any case, I made this correction:

Next, this Action has two problems:

  1. It occurs before the index is updated.
  • The "to:" field is wrong

The correct "to" field is shown below.

Next, you used "Set Variable to Text" for the "Index" variable.
It should be "Set Variable to Calculation"

Now you are ready to create the new "Var" variable, and assign the current line from the file to it:

I added this Action to log the results:


So, now, when I run your macro with my corrections, the result is:

<img src="/uploads/default/original/2X/d/d571be1c8454660bf96606ba1a2229dbe6b4f7c9.png" width="510" height="265">

Here's the corrected Macro:

###MACRO:&nbsp;&nbsp;&nbsp;[FILE] Process Lines in Text File -- @VWKM version with @JMichaelTX Corr

~~~ VER: 1.0&nbsp;&nbsp;&nbsp;&nbsp;2017-05-07 ~~~

####DOWNLOAD:
<a class="attachment" href="/uploads/default/original/2X/b/b132d17273f88af1facb72ae9cf86a4dfbaacac3.kmmacros">[FILE] Process Lines in Text File -- @VWKM version with @JMichaelTX Corr.kmmacros</a> (13 KB)

---

###ReleaseNotes

REVISED 2017-05-07  3:34 PM CT BY @JMIchaelTX
to correct problems in version by @VWKM

---

<img src="/uploads/default/original/2X/5/5b138254f972424c1d20bbca4de192b247986e1d.png" width="389" height="2000">
1 Like
11

@troy and @VWKM: I'm curious. May I ask you guys a question please?

Why do you want the lines from the file into separate KM Variables?

IME, this makes it harder to deal with the data, unless you always know that each line represents the same entity, like
Name = Line 1, Phone = Line 2, email = Line 3
Then I get it.

But you end up with Variables named "Var1, Var2, Var3". Not so useful. Even so, this approach is very unforgiving. Sometimes using RegEx can be a better solution.

If you don't mind sharing your purpose/intent of using KM Variables, we might be able to suggest alternate methods.

12

Hey Victor,

Ah, I see...

I didn't realize we could create variables dynamically this way, so I misunderstood the issue.

It looks like JM has you covered though.

-Chris

13

This is very powerful, but hard to understand at first (for most) and tricky to use. :wink:

14

I have trouble with the Macro
When I try it fresh out of the box, I get an error message:

Action Failed
Read File action failed because source is not a full path obj[7871]: Class FIFindferSync etc. etc.

15

I just tested this macro again in it is running fine with Keyboard Maestro 8.1.1 (8.1.1) on macOS 10.12.6.

This sounds like you may have selected a non-text file.
After you run the macro, please do this:

  1. Make a screenshot of the actual error msg, and post here.
  2. Open the KM Editor Preferences, and get the value of Variable "myFilePath", and post here.
16

180320_1951FullPathObject
180320_1951FullPathObject.png705×135 28.4 KB

Above is the error message.

I was correctly opening a text file. That was not my problem.

I found the "cause".

I was using the Try button in Editing mode to launch the Macro. That a resulted in the error. When I launched the Macro in the conventional way (not in Editing Mode but using the Status Menu), it worked fine.

I appreciate your very prompt response. Sorry for not having figured this out. I did not realize that the Try button could cause trouble in this way.

When launching using the Try button, the value of myFilePath is seen below, in case you are interested,

objc[9358]: Class FIFinderSyncExtensionHost is implemented in both /System/Library/PrivateFrameworks/FinderKit.framework/Versions/A/FinderKit (0x7fff92deeb68) and /System/Library/PrivateFrameworks/FileProvider.framework/OverrideBundles/FinderSyncCollaborationFileProviderOverride.bundle/Contents/MacOS/FinderSyncCollaborationFileProviderOverride (0x113b33cd8). One of the two will be used. Which one is undefined.
/Users/owl/Desktop/SomeTest.txt

17

The reason it failed when using the Try button was because the Try button only executes the current action, not the whole macro, so the previous actions that the selected action expected to have been run before it was executed had not yet been run (don't worry, you're far from the first one to assume that that button is for the whole macro rather than just the action). In KM8, the button to execute the entire macro is this one, at the top of the editor window:

5

18

First of all, I appreciate learning about the Entire Macro Run button and how it differs from the Try button. But if NO action is selected, the Try button seems to run the entire Macro.

So if you leave the Edit mode (click to deactivate the Edit button) and then click it again (activate the Edit button) there is no single Action that is selected. If you hit the Try button at this point, it seems to run the entire Macro. Since I did not understand/appreciate the Entire Macro Run button that you pointed out to me, I would go through this little dance often.

Currently, I still will get the error even if I use the Entire Macro Run button.

The sad thing is that I thought the issue was being in Edit mode. I had had success with invoking the Macro using the Status Menu. But when I retry the whole thing now, I get the error also when I use the Status Menu. I do not know what has "changed". Rarely, it will work. Confounding.

When I run the Macro: [KM]Display Macro Error that JMichaelTX provided to help with debugging, it also throws an error.

180320_1949Regex

So somehow something weird is going on with the state of my Mac in terms of this Macro. Most commonly it fails totally after I select the text file. Sometimes it will work and several windows will open up showing the various lines. Sometimes only the first window will open up showing the first line and then I will get the error. It is all bizarre.

19

I also get this same error when i run [KM]Display Macro Error
I run it immediately after an error, so i have no clue why. Or at least: it can’t match with the regex…

High sierra 10.3.3
KM 8.1.1

EDIT: Don’t want to go off topic. Just affirming rlivingston isn’t the only one :wink:

20

I assume you are referring to the macro at the top of this topic:
MACRO: [FILE] Process Lines in Text File

Just to be clear, that button is called "Run Selected Macro"
image

Please be sure you are selecting a TEXT file with multiple lines in it, like this:

qqqq
wwww
weee
errrr
rttttt
yyyyy
uuuu

If you get an error, please make a screenshot of it and post here.

OK, I can help with that, but not in this thread. That is a completely different issue. Please post your comments/issues about the Display Macro Error macro in its topic:
MACRO: [KM] Display Macro Error

But for now, to debug your issue with " [FILE] Process Lines in Text File", don't bother with the "Display Macro Error" macro.

21

57 PM
Screen Shot 2018-03-21 at 3.11.57 PM.png1416×744 127 KB

Here is the file that I will be using which you suggested. The Macro is running and I am just about to select the file.

180321_1517Error
180321_1517Error.png898×262 89.1 KB

Here is the error message that transiently appears in the right upper corner pf the screen

Previously, I have run the Macro with an extra Action inserted by me to capture the value of %myFilePath%

57 PM
Screen Shot 2018-03-21 at 3.24.57 PM.png1210×312 26.1 KB

What that Alert box shows is

21 PM
Screen Shot 2018-03-21 at 3.12.21 PM.png1100×580 108 KB

At the end, you can see the correct Path name for the file that was selected. I do not know the meaning of all the "other stuff"

I could make a screen video of all this if necessary although I do not know hw to upload such a thing to the forum.

Thanks for the correct name of the Run Selected Macro button

22

Thanks for posting that Alert screenshot. Clearly there is some major issue.
I've never seen such an error.

What versions of KM and macOS are you running?
I'm running Keyboard Maestro 8.1.1 (8.1.1) on macOS 10.12.6.

In a new Macro try this:
image

Select the file path by clicking on the folder button.

Let us know how that goes.

23

Sorry for the bug guys. Hopefully this will fix it.
Please update to this new version.

24

If you search for the “Class FIFinderSyncExtensionHost is implemented in both” issue on the net you'll find a bunch of references to it - basically this is an Apple issue, and the result is that when running an AppleScript, the system is pointlessly complaining about this issue, and that complaint is being returned from this action:

20180322-101833
20180322-101833.png1080×624 188 KB

The solution here is to turn off the option to include errors in the gear menu for that action. Well, the solution is for Apple not to pollute the world with their errors, and to fix the errors like this when they happen, but that is somewhat beyond out control.

1 Like
25

KM 8.1.1
Mac 10.13.3

In a new Macro try this:

Select the file path by clicking on the folder button.

Let us know how that goes.

Works fine. I see the contents of the file.

Peter the Elder's suggestion to turn off Include Errors works and the Macro now functions properly.

Thanks to all for the help with this.

1 Like
26

Don't know why, I just can't process this macro through. But earlier days it was totally ok.

I got the following message using this Macro :point_right: Display Last KM Macro Error - Macro Library - Keyboard Maestro Discourse

/Users/as/Downloads/111 copy 2.txt

2018-04-02 20:31:09 Read File action failed because source is not a full path objc[15833]: Class FIFinderSyncExtensionHost is implemented in both /System/Library/PrivateFrameworks/FinderKit.framework/Versions/A/FinderKit (0x7fffad677b68) and /System/Library/PrivateFrameworks/FileProvider.framework/OverrideBundles/FinderSyncCollaborationFileProviderOverride.bundle/Contents/MacOS/FinderSyncCollaborationFileProviderOverride (0x10e4f5cd8). One of the two will be used. Which one is undefined.

/Users/as/Downloads/111 copy 2.txt In macro “[FILE] Process Lines in Text File” (while executing Read File to Variable “myLines”).

27

I think that is the same error, and has the same fix as above.
Please make sure the "Include Errors" option in the Gear menu is UNCHECKED in the "SCRIPT: Get Last Error Made to KM Log [JXA]" Action:

image

28

@JMichaelTX Thank you! Sorry for not going throgh the post before.

1 Like
29

A post was split to a new topic: Open Files Using Paths Copied to the Clipboard