English > Development

Sorting using a Custom Field during export.

<< < (2/3) > >>

rick.ca:
If you're just using Barcode as a sort key, use Excel to append Title to Custom, and import that to Barcode.

John666:

--- Quote from: rick.ca on October 09, 2011, 12:02:50 pm ---If you're just using Barcode as a sort key, use Excel to append Title to Custom, and import that to Barcode.

--- End quote ---

Yes, I thought of that, but every time I enter a new record I would have to do the same thing and that would be very time consuming.

Is it a feature that is likely to be added to the new version?

rick.ca:

--- Quote ---Is it a feature that is likely to be added to the new version?
--- End quote ---

Only nostra sees the future. Seems like a rather obscure thing to me, but you haven't described the application.

John666:
It's a bit complicated, but here goes.

I am using the 'Release' field for storing UK Certifications e.g. 'U', 'PG', '12A' etc.
The reason for using the Release field is so that it appears in the List, formatted as '%T (%Y) %R' giving me 'Avatar (2009) 12A'.

I then found that if you sort by the Release field it sorts it into 12, 12A, 15, 18, PG, U which is out of age order.
I now use the 'Barcode' field in addition and enter 10 for U, 20 for PG, 30 for 12A, 40 for 12, 50 for 15 and 60 for 18.

This means that I can now sort the Certification correctly for output to a web page. The problem still remains that the names are out of sequence.
I have tried re-indexing the database but this does not help either.

Take a look at the images; maybe they can explain it better.

I also need to do this with the Year and IMDb Ratings so that my individual lists would appear as follows
    Type           Sort By        List Output
    Normal        Title             Avatar
    Cert            Barcode        12    Avatar
    Rating         IMDb            8.1   Avatar
    Year            Year             2009  Avatar

I have got all of these working, apart from the seemingly random order of the titles except where the title is the sort field.

[attachment deleted by admin]

rick.ca:
Have you considered using HTML Frames export template? Maybe svenne could add the filters you require, or explain a technique for doing something similar in your template.

[attachment deleted by admin]

Navigation

[0] Message Index

[#] Next page

[*] Previous page