[REQ] TV series

If you made a script you can offer it to the others here, or ask help to improve it. You can also report here bugs & problems with existing scripts.
Post Reply
fulvio53s03
Posts: 764
Joined: 2007-04-28 05:46:43
Location: Italy

[REQ] TV series

Post by fulvio53s03 »

I need a script "to cumulate" multiple records in an AMC Data Base.
I have multiple records such these:

fieldMedia = serie 1
fieldOriginalTitle = story1
fieldTranslatedTitle = thisepisode1

fieldMedia = serie 1
fieldOriginalTitle = story1
fieldTranslatedTitle = thisepisode2

fieldMedia = serie 1
fieldOriginalTitle = story1
fieldTranslatedTitle = thisepisode3

fieldMedia = serie 2
fieldOriginalTitle = story2
fieldTranslatedTitle = thisepisode1

fieldMedia = serie 2
fieldOriginalTitle = story2
fieldTranslatedTitle = thisepisode2

at the end, I would like to obtain :

fieldMedia = serie 1
fielddescription = story1 - story 2 - story3

fieldMedia = serie 2
fielddescription = story4 - story 5

no matter about other fields, my problem is to recognize "new" records from "old" so that, in a next step, I could delete "old" records.
Sorry fon my english, I understand my difficulties to explain problem but I could give you examples of "new" and "old" DB .....

:hihi:
fulvio53s03
Posts: 764
Joined: 2007-04-28 05:46:43
Location: Italy

Post by fulvio53s03 »

Well, I think I have a good Idea:
1) I renumber records sorting them in increasing "media label & media type"
2) using a script, I cumulate "original title & translated title" in "description field" for every record with same "media label & media type" (last record with a certain "media label & media type" will contain all "original title & translated title".
3) I renumber records sorting them in decreasing "media label & media type"
4) Using a script, I clear "description field" in any record with "media label & media type" same than preceding
5) I group records by "description field" and I delete records with that field blank!!! :hihi:

Does my strategy is wrong?
Any suggestion to improve it?

:??:
fulvio53s03
Posts: 764
Joined: 2007-04-28 05:46:43
Location: Italy

Post by fulvio53s03 »

At the End:
I wrote two scripts to solve steps 2 and 4.
If someone is interested, I'll post them.
Happy Sunday!
;)
Post Reply