File Ordering in Magix

Fergal1 wrote on 11/8/2014, 3:26 PM

If I have a list of photos or files numbers say Photo1 to Photo100 Magix orders them as Photo1, Photo10, Photo100, Photo101, Photo102 ...... Photo2, Photo20, Photo201, Photo202 ....

I can't understand why it sorts like this.

If I go to detailed view and sort by Changed it losing it when I go back to large Icons it loses the sort.

I find it very frustrating and cant' find the relevant section in Help.

I'm using Magix for years and multiple version.

It's always been annoying but I'm doing a project with thousands and photos and this sorting / file ordering problem is making it almost impossible to find the files in order.

Any help, tips or suggestions would be helpful.

Thanks

Fergal

Comments

browj2 wrote on 11/8/2014, 6:24 PM

Hi Fergal,

First off, you have posted this in the Music Maker discussion forum. Is Music Maker the program that you are referring to? If not, which program and version?

Sorting an alpha-numeric field on a computer always works the way that Magix has done it. It sorts by the first character, then by the second, then third, etc. So when you sort Photo1, the computer will find all Photo1 files first, then it will use the next character, starting with blank, then 0, 1, 2, etc. To do what you want, you need to determine approximately how many files will have a similar prefix and then pad it with zeros appropriately. For example, if you think that you will have more than 1000 but less than 10,000, then use Photo0001, Photo0002, Photo003...etc. The sort on file name will now be correct.

johnebaker wrote on 11/9/2014, 11:43 AM

. . . . Sorting an alpha-numeric field on a computer always works the way that Magix has done it. . . . .

It is not just Magix software that does this - any program which runs on Windows will do the same - it is Microsoft Windows that handles a lot of the softwares functions including sorting.

John

Fergal1 wrote on 11/9/2014, 2:04 PM

Thanks for the answers. I'm surprised but I guess it probably is Microsoft thats dictating the sort.

Apologies for being in the wrong section.

browj2 wrote on 11/9/2014, 6:02 PM

Hi Fergal,

Actually, this is the way that it is done with databases; it is standard in the industry and logical when you think about it.