Export CSV with timestamp?

[dedupeit]

Based on a different post, I learned to use this to get a single field/column with Date Taken (pictures) or Media Created (videos):

Code: Select all

<regex:tostring:datetaken:(.+)>|<regex:tostring:datemediacreated:(.+)>

I'm exporting the results to CSV format so that I can get this custom field/column in the export. It's exported as readable date/time such as "2016-03-01 18:26:03". Is there a way to get it to export the epoch timestamp? Similar to when you export to the EFU format?

[therube]

I'm not familiar with that, but what happens if you remove "tostring:" ?

[void]

Does including the following in your search help:

<datetaken: column1:=datetaken:> | <mediacreated: column1:=mediacreated:> | <column1:=> addcolumn:column1

[dedupeit]

Does including the following in your search help:
<datetaken: column1:=datetaken:> | <mediacreated: column1:=mediacreated:> | <column1:=> addcolumn:column1

This does create a column named "column1" but it is empty for all of my files.

I'm not familiar with that, but what happens if you remove "tostring:" ?

Interesting idea but if I remove "tostring", I get no data. I'm not verify familiar with the syntax and functionality that's being used here...I was just lucky enough someone else had shared that

[void]

I should have mentioned, column1:= will only work with the latest alpha (1318a).
What version are you using?

[void]

Another option is to enable detailed CSV exports:

• Copy and paste the following into your Everything Search box:
  /csv_type=1
• Press ENTER in your Everything Search box.
• If successful, csv_type=1 is shown in the status bar for a few seconds.

csv_type

[dedupeit]

I should have mentioned, column1:= will only work with the latest alpha (1318a).
What version are you using?

Ah, I was running an older alpha version. This works perfectly! I don't know what kind of sorcery this is but I love it

Thanks void!

EDIT: hmmm, the data doesn't look like normal epoch timestamps. I'll see if I can figure out what it means.