Exporting files to a .CSV file.
Posted: 2024-09-15 13:48:01
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
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