Export to csv

Question

Export to csv

opensourcestough opened this issue 3 years ago · 10 comments

Would you please add the ability to export to csv.

Answer 1 · 2022-01-13T20:43:29.000Z

Sure, let me look into it and I'll get back to you with something.

Answer 2 · 2022-01-13T21:50:35.000Z

The version in the csv branch provides a new command export which will print the entire tree in csv (comma separated, with quoted fields) with the following content

name,type,path,size,md5

Can you give it a try and let me know if that matches your expectations?

Answer 3 · 2022-01-14T00:40:48.000Z

Thank you for the quick answer. It is close, would you be able to add md5 of the directory and the date? I am looking for the like the output of this export http://vvvapp.sourceforge.net/, just with added md5s.

Answer 4 · 2022-01-14T09:47:18.000Z

I updated the format which now looks like this:

name,type,path,size,indexed_at,maccess,md5

The fields are described in the README in the csv branch.

indexed_at: when this entry was indexed
maccess: the file modification date/time

I'm however not sure what you mean by md5 of the directory? Currently catcli doesn't calculate md5 sum of directories, only files.

Answer 5 · 2022-01-15T00:36:56.000Z

That is great, would it be able to add them as switches to the other items (e.g. ls and find). Yes, only if it is easily done. I do get an error when I output to the filename directly without redirecting stdout.

Answer 6 · 2022-01-15T13:50:27.000Z

I have added --format to ls and find which, when set to --format=csv, will output the results in CSV.
Note that the export command is equivalent to tree when using --format=native (which is the default now).

This hasn't been extensively tested though. I hope it matches what you need.

Answer 7 · 2022-01-15T14:34:33.000Z

Well I actually cleaned a bit and removed the export command but added --format to the tree command.

Now you can print results in csv for the following commands: ls, find, tree.

The csv header is never added but can be found in the README as well as when running the print_supported_formats command:

$ catcli print_supported_formats
"native": native format
"csv"   : CSV format
          name,type,path,size,indexed_at,maccess,md5

Answer 8 · 2022-01-17T00:19:03.000Z

I feel you need the header switch. Ideally the export command remains , and you just add a switches for csv and header to the rest

Answer 9 · 2022-01-17T21:32:38.000Z

tree now supports a switch -H --header to print the CSV header.

These changes will be merged in next version. Thanks for your inputs!

Answer 10 · 2022-01-17T22:11:37.000Z

A new version of catcli v0.8.0 has been released and contains all the updates to handle CSV outputs.