Schedule CSV Export

[4real]

I'd like to schedule a CSV Export, overwriting the same file, of one of my saved searches. I see some stuff in the docs about using the command line for export, but I've failed to get it working so far. I'm not, generally a user of command line, so I probably doing something pretty basic wrong. I guess once I get it working from there I can set something up with Task Scheduler?

Any help appreciated!

[therube]

using the command line for export

So just what have you tried, & what happened with those attempts?

[4real]

I tried using what's in the help docs, but with 'mysearch' replaced with on of my bookmarked searches

es.exe "my search" -export-csv out.csv

[therube]

So "my search" is your Bookmark?

Did you add a colon (:) to the Bookmark name (& maybe quotes around it if it includes spaces ?) ?

Something like this, where blabla: is a Bookmark, works here (Everything 1.5 in case that matters):

es.exe blabla: -export-csv out.csv

[4real]

Finally getting a chance to come back to this.
I found one major issue was I was using the 'lite' version of everything.

Full verison installed and command line interface seems to be working, however, the docs say 'ES does not have access to bookmarks or filters.' and I'm finding calling on my bookmark name like you described does nothing, so I'm interested to hear how you got the above working.

Also, should I just type out the search manually, then I'm finding | doesn't work as expected.

does an 'or' argument works differently in es.exe?

[void]

ES uses Everything IPC to perform your search.

Everything 1.4 Lite version doesn't support Everything IPC.



Everything 1.4 does not support bookmarks or filters from ES.

Everything 1.5 does support bookmarks or filters from ES.

If you try Everything 1.5, please call ES with

-instance 1.5a

Please escape | with ^|
Escaping special command line characters when using ES

[4real]

ok, came back to this at last and I've nearly got it working using:

Code: Select all

es.exe L: ext:max^|fbx^|dwg^|obj^|rvt^|dxf^|jpg^|jpeg^|psd^|psb^|png^|tif^|tiff^|png^|tga -export-efu -size -date-modified C:\Users\me\Documents\Drive_reports\L.csv

Filename,Size,Date Modified,Date Created,Attributes
"L:\2D\Photographic_Elements\HDRI\PG_hdri\0000jpegs",,131614521331360462,132831956022599787,16
"L:\2D\Maps\Alpha Masks and Gradients\4991 Ansell and Bailey Harley Street Estate\MaxRender\_DWG.bak",,132919154096467970,132919154093655526,16
"L:\3D\Models\_PROJECT SPECIFIC\3393 Martin Ashley Beechwood House\Freelancer_Furniture\F28\Bathroom F 28 con objetos03",,129935889609062500,132832166293669799,16
"L:\2D\PS\Brushes\Beautiful_Flowers_by_coolwing",,129935835960000000,132832031534674311,16....

a couple of problems:

• I'm getting no value for the filesize (it's indexed)

• The date values are 18 digit strings - ultimately I want to read this as dd/mm/yyyy format in excel

[void]

I'm getting no value for the filesize (it's indexed)

Those items are folders. (attributes==16)
Folders do not have sizes.

-What version of Everything and ES are you using?
ES 1.1.0.33 with Everything 1.5.0.1397a+ should export folder sizes anyway.

The date values are 18 digit strings - ultimately I want to read this as dd/mm/yyyy format in excel

Please try including the following in your ES search:

-date-format 4

This will format dates using your locale settings.
Excel should understand your local date format.

-date-format

[4real]

thanks. I am on 1.4.1.1028, will update.

edit: I only get the option to upgrade to 1.4.1.1030

Does ES update automatically with that?

[void]

ES is a separate tool.

The official download link for ES is:
https://www.voidtools.com/downloads/#cli



ES 1.1.0.31+ are the development builds for Everything 1.5.
Development builds can be found here:
https://www.voidtools.com/forum/viewtopic.php?t=5762



You will need ES 1.1.0.31+ to show folder sizes.
Any Everything version will work (provided index folder size is enabled under Tools -> Options -> Indexes).