Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:
Attach:
(Clear Attachment)
(more attachments)
Allowed file types: gif, jpg, png, txt, tpl, lng, ini, pvd, psf, ini, cfg, csv, zip, xml, pas, 7z
Restrictions: 4 per post, maximum total size 1024KB, maximum individual size 1024KB
Note that any files attached will not be displayed until approved by a moderator.
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:
How many words are in this question?:

shortcuts: hit alt+s to submit/post or alt+p to preview


Topic Summary

Posted by: rick.ca
« on: December 27, 2011, 11:37:03 pm »

Quote
You must remember to include the record ID as one of the import/export fields.

...Or anything that will uniquely match records on import, if there is no ID. Using [Title] and [Year] usually works fine for movies.
Posted by: John666
« on: December 27, 2011, 11:12:40 pm »

Hi, sorry to disappoint. I entered the certificate info myself into the ‘release’ field but it could have been any custom field.

The easiest way if you have a lot of them is to export them to a .csv file, edit the appropriate field content and then import the changes. You must remember to include the record ID as one of the import/export fields.

I then use the export expression #stringreplace to convert the text into a number for sorting etc. for a website. See the Screen Captures.

[attachment deleted by admin]
Posted by: handytouch
« on: December 27, 2011, 04:13:07 pm »

Hi John,

How did you manage to pull the certification into PVD? I am trying that as well to pull Certification: Singapore as well.
Posted by: John666
« on: October 10, 2011, 12:12:20 pm »

WOW, thanks for that. I have been having a look at it for hours now. It's way over my head but a good place to start.

Thanks.
Posted by: rick.ca
« on: October 09, 2011, 10:20:43 pm »

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]
Posted by: John666
« on: October 09, 2011, 12:59:02 pm »

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]
Posted by: rick.ca
« on: October 09, 2011, 12:23:30 pm »

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

Only nostra sees the future. Seems like a rather obscure thing to me, but you haven't described the application.
Posted by: John666
« on: October 09, 2011, 12:12:29 pm »

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.

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?
Posted by: 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.
Posted by: John666
« on: October 09, 2011, 09:56:55 am »

Quote
Yes. Export the custom field (along with Title and Year to identify the record), then import it to Barcode.

Thanks, that will save me a lot of time.

Any suggestions on sorting by more than one field in templates?

What I am trying to do is first sort by the contents of the 'Barcode' field and then by 'Title'.

The reason for this is that I am using the Barcode field to group specific types of records but I want them to be sorted by title within the groups.

If I just sort by the barcode field the titles are out of order.
Posted by: rick.ca
« on: October 09, 2011, 09:39:29 am »

Quote
Just another thought... Is it possible to copy the information I have entered into the custom field over to a standard field, for example I don’t use the Barcode field.

Yes. Export the custom field (along with Title and Year to identify the record), then import it to Barcode.
Posted by: John666
« on: October 09, 2011, 08:14:06 am »

Thanks for letting me know. Is it something that will be implemented in the new release?

Just another thought... Is it possible to copy the information I have entered into the custom field over to a standard field, for example I don’t use the Barcode field.

I have over 1000 entries and it would take hours to go and modify all of them manually.

And, is it possible to sort by more than one field in templates, so that you have a primary and secondary sort in differing directions?
Posted by: nostra
« on: October 09, 2011, 12:34:04 am »

It is not possible
Posted by: John666
« on: October 08, 2011, 11:23:31 pm »

In the %OPTIONS% section at the beginning of the template files there is an entry for ‘sortby=’. My question is… How do I sort on a custom field?

I have tried everything I can think of but all that happens is the output is sorted by some other method, I assume the ID.

Is this possible or have I been wasting my time trying?