slick run append to csv file issue

[tom61781 6361]

Hello,

 

I happily used Slickrun on my Win XP Vista and 2007 machines but I am having some difficulty implementing the same setup and wonder if anyone has some ideas for me.

 

In addition to the standard commands I created a series of commands that would allow me to append to a csv file with a time and date stamp.  For example, I could type the magic word “log” and then “started project” and the command would append to a prespecified csv file with the date, time, and started project in column A B and C respectively.  I also had a file I could add a tag to in an additional column by using the first word typed after the magic word as the tag.

 

 

 

I did this by using the cmd command and a path to where the file was locationed.  The parameter was:

 

"/c echo %DATE%,%TIME%,$i$ >> add2file.csv"

 

When trying this in Windows 8 I receive first a UAC promt.  If I allow the prompt or turn off UAC I hear the Slickrun success sound, but upon checking the file find neither the timestamp or the text item.

 

I have upgraded to the latest Slickrun version and I have tried checking the “run as administrator” box in the magic word dialogue.

 

Does anyone have any idea how to fix this?  Alternatively, I’m trying to do something pretty cimple by adding to this log file.  Any other ideas using Slickrun or launchy etc would be welcome.  If I get this set up right I should be able to add to the log using both slickrun as well as the Drafts app on my iphone.

 

Thanks

 

Tom

 

[EricLaw]

Where is the file located? If it's in somewhere in your user profile (e.g. your Documents folder) it shouldn't require a UAC elevation.

If you use the same command from the Windows 8 command line directly, does it work as you expect?

Also, I trust that you've got a typo above? $i$ won't work, it must be uppercased like $I$

[tom61781 6361]

yes switching to the user directory resolved any UAC issues.  I can now get the command to work at a DOS prompt but still don't get anything when the command is in the magic word parameters.  I have the path to the user docs directory and in parameters I can simplify it to dir >> text.txt and it still isn't working.  The command I am using is cmd.  I have run as administrator checked.

--
You received this message because you are subscribed to the Google Groups "Bayden" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bayden+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[tom61781 6361]

Eric,

I forgot to mention I am using a 64 bit machine.  Would that make a diffference?  In trying to research this I found the following link:

http://www.heckler.com.br/blog/2010/03/16/how-to-open-a-64bit-command-prompt-from-a-32bit-application/

On 2/4/2014 6:13 PM, EricLaw wrote:

--

[EricLaw]

Using a 64bit machine generally shouldn't matter, as both 32bit and 64bit cmd.exe shells both work. The bitness only matters if you're trying to write to a folder like "System32" or "%ProgramFiles%" which behaves differently based on the bitness of the command prompt.

Stepping back a bit, please confirm that you're using $I$ rather than $i$ (lowercase).

Maybe try changing the /c at the front of the MagicWord to /k then look for any error messages in the console.

For what it's worth, this MagicWord works great for me on Windows 8.1:

MagicWord: MARKTIME
Filename: cmd.exe
Path:
Parameters: /c echo %DATE%,%TIME%,$I$ >> C:\temp\whatIamdoing.csv
Notes: Record current status into the WhatIAmDoing file

[tom61781 6361]

Eric,

I got it! Thanks for your help.   I don't know why this worked, but I moved the file path to the parameters field like in your example.

By the way, I tried using strf formatting for the time but it broke the command so I guess sr doesn't support this.  Is there an alternative way to format the date/time? 

[tom61781 6361]

Somehow the Slickrun append to command stopped working.  Eric- moving the path to the parameters got it to work temprarily but now it is just opening a command prompt at c:\Windows\system32 with no additional result.  I am also    running Windows 8.1 so I am not sure what is going on.

Anyone have any ideas?

On 2/6/2014 11:54 AM, EricLaw wrote:

[EricLaw]

In your MagicWord, the tokens %DATE% and %TIME% aren't SlickRun features, they're features of the command interpreter.

Based on what you're trying to do, you might be better off writing a few lines of VBScript and invoking that script with cscript.exe or wscript.exe

What exactly does your MagicWord look like right now?

[tom61781 6361]

Thanks for your offer to check out my command.  Somehow the parameters I set up started working again.  Now I have Drafts on my iPhone and Slickrun on my PC going to the same csv file on Dropbox.

 

One more question: I use a csv file because then I can not only add a note to the file but a tag also.  I use it like this “magicword tag,thing I want to log” so that when I open the csv I have a column with a tag that can be sorted on in addition to the item itself.  The problem with this method is obviously that the item can never contain commas.

 

Can you think of another solution or could Slickrun somehow define two separate columns?  Would there be a way to put tabs in the parameters and then create a text file with a .tab suffix? 

[Vladimir Castro]

I love Slickrun. It's awesome! Thanks Bayden.

El martes, 04 de febrero de 2014 06:13:06 p.m., EricLaw escribió:
> Where is the file located? If it's in somewhere in your user profile

> (e.g. your *Documents* folder) it shouldn't require a UAC elevation.

>
> If you use the same command from the Windows 8 command line directly,
> does it work as you expect?
>
> Also, I trust that you've got a typo above? $i$ won't work, it must be
> uppercased like $I$
>
>
> On Tuesday, February 4, 2014 6:09:12 PM UTC-6, Tom Apple wrote:
>
> Hello,
>
> I happily used Slickrun on my Win XP Vista and 2007 machines but I
> am having some difficulty implementing the same setup and wonder
> if anyone has some ideas for me.
>
> In addition to the standard commands I created a series of
> commands that would allow me to append to a csv file with a time

> and date stamp.For example, I could type the magic word “log” and

> then “started project” and the command would append to a
> prespecified csv file with the date, time, and started project in

> column A B and C respectively.I also had a file I could add a tag

> to in an additional column by using the first word typed after the
> magic word as the tag.
>
> I did this by using the cmd command and a path to where the file

> was locationed.The parameter was:
>
> "/c echo %DATE%,%TIME%,$i$ >> add2file.csv"
>
> When trying this in Windows 8 I receive first a UAC promt.If I

> allow the prompt or turn off UAC I hear the Slickrun success
> sound, but upon checking the file find neither the timestamp or
> the text item.
>
> I have upgraded to the latest Slickrun version and I have tried
> checking the “run as administrator” box in the magic word dialogue.
>

> Does anyone have any idea how to fix this?Alternatively, I’m

> trying to do something pretty cimple by adding to this log

> file.Any other ideas using Slickrun or launchy etc would be
> welcome.If I get this set up right I should be able to add to the

> log using both slickrun as well as the Drafts app on my iphone.
>
> Thanks
>
> Tom
>

> --
> You received this message because you are subscribed to the Google
> Groups "Bayden" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to bayden+un...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.

--

*Atentamente**,*

/Ing. Vladimir Castro/

/Grupo Servintegra S.A de C.V//de El Salvador/

/C//el: (503)////7628//- //4812//| //Tel: (503) 2560 - 1400 //|
//http://servintegra.com/

/Col. Escalón 81 Av. Nte. No 808 El Salvador, San Salvador///