Page 1 of 1

Exporting files to a .CSV file.

Posted: 2024-09-15 13:48:01
by boristhecat
When I export a list of files in my catalog to a csv file, they are organised differently to a windows file list of the same files in a folder.
I can't upload an image on here so I will try to show. The first column is directly from AMC's export function. The second column was generated in DOS using a file list command. My question is, what formatting is AMC using in it's export function so I can try to match it for the other list? I've tried the obvious ones but none work.

AMC list
#SquadGoals (2018)
1 Buck (2017)
222 (2017)
3 Days to Kill (2014)
5 Days of War (2011)
5th Passenger (2017)
6 Balloons (2018)
6 Below Miracle on the Mountain (2017)
6 Days
7 Days in Entebbe (2018)
7 Guardians of the Tomb (2018)
7 Splinters in Time (2018)
10 Items or Less
10x10
1155
12 Feet Deep (2016)
12 Pound Balls (2017)
12 Strong
13 Cameras (2015)
13 Demons (2016)
21
21 Jump Street
22 Jump Street (2014)
24 Hours to Live
28 Days
28 Days Later...
28 Weeks Later
30 Days of Night
30 Days of Night 2 Dark Days (2010)
47 Meters Down (2017)
68 Kill
96 Souls
200 Degrees
300 (2006)
500 Days of Summer (2009)
1922 (2017)
2036 Origin Unknown
A Christmas Carol (2009)
A Christmas Horror Story (2015)


Second column

Disk list
#SquadGoals.mp4
1 Buck.mp4
10 Items or Less.mkv
10 X 10.mp4
1155.mp4
12 Feet Deep.mp4
12 Pound Balls.mp4
12 Strong.mp4
13 Cameras.mp4
13 Demons.mp4
1922 (2017).mkv
200 Degrees.mp4
2036 Origin Unknown.mp4
21 Jump Street.mkv
21.mkv
22 Jump Street (2014).mp4
222.mp4
24 Hours to Live.mp4
28 Days Later.mkv
28 Days.mkv
28 Weeks Later.mkv
3 Days to Kill.mp4
30 Days of Night 1.mkv
30 Days of Night 2 Dark Days.mkv
300.mkv
47 Meters Down.mp4
5 Days of War.mkv
500 Days of Summer.mkv
5th Passenger.mp4
6 Balloons.mp4
6 Below Miracle on the Mountain.mp4
6 Days.mp4
68 Kill.mp4
7 Days in Entebbe.mp4
7 Guardians of the Tomb.mp4
7 Splinters in Time.mp4
96 Souls.mp4
A Christmas Carol (2009).mp4
A Christmas Horror Story.mp4

Re: Exporting files to a .CSV file.

Posted: 2024-09-17 01:38:09
by fulvio53s03
Maybe this question is related to your other Post about adding Year to filenames? :) :??:

Re: Exporting files to a .CSV file.

Posted: 2024-09-18 07:16:18
by antp
You can try to disable the "use natural sort" option that I mentioned in another thread.
It is supposed to sort numbers more like Windows does, but it does not seem to always work.
And your second list looks like a basic text sort, so AMC would normally do the same without the natural sort option.

Re: Exporting files to a .CSV file.

Posted: 2024-09-24 19:19:25
by boristhecat
fulvio53s03 wrote: 2024-09-17 01:38:09 Maybe this question is related to your other Post about adding Year to filenames? :) :??:
No that's a different thing and that's all sorted now thanks to Python and ChatGPT. But it can take hours to sort out the sorting when AMC's export is so different to a list of directory from Windows.

Re: Exporting files to a .CSV file.

Posted: 2024-09-24 19:52:55
by boristhecat
antp wrote: 2024-09-18 07:16:18 You can try to disable the "use natural sort" option that I mentioned in another thread.
It is supposed to sort numbers more like Windows does, but it does not seem to always work.
And your second list looks like a basic text sort, so AMC would normally do the same without the natural sort option.
I have just done a new list using the natural sort and it is much, much better! Thanks :)