Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Plugins Page: 1... 17 18 19 20 21 ...52  Previous   Next
New Plugin: BulkEdit - Bulk Editing, XML and CSV Import of Profiles
Author Message
DVD Profiler Unlimited Registrantbogieboo
Registered: March 14, 2007
Posts: 18
Posted:
PM this userEdit postDirect link to this postReply with quote
Multiple Cast members are now imported but the Role and Credited as are still left out.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
Quoting bogieboo:
Quote:
Multiple Cast members are now imported but the Role and Credited as are still left out.

Ok, thanks. Of course I could have looked at the code - BORING. More fun to see people using the code and either laughiing or crying ... 
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited Registrantbtiltman
Registered: June 8, 2007
Posts: 15
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
The 'Edited' tags are causing me some problems with filters. I have now turned them off, but I would like to delete all 'Edited' tags on all my titles.

Is there an easy way to do this?
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
Quoting btiltman:
Quote:
The 'Edited' tags are causing me some problems with filters. I have now turned them off, but I would like to delete all 'Edited' tags on all my titles.

Is there an easy way to do this?

First flag all the relevant profiles. Then Collection - Flagged - Set Tags and Unset all the tags you want to delete. Then Edit Tags and delete them. Tags cannot be deleted while in use.

I think I have remembered this correctly. I'm sure you will figure out any adjustments needed.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited Registrantbtiltman
Registered: June 8, 2007
Posts: 15
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting mediadogg:
Quote:
Quoting btiltman:
Quote:
The 'Edited' tags are causing me some problems with filters. I have now turned them off, but I would like to delete all 'Edited' tags on all my titles.

Is there an easy way to do this?

First flag all the relevant profiles. Then Collection Set Tags and Unset all the tags you want to delete. Then Edit Tags and delete them. Tags cannot be deleted while in use.

I think I have remembered this correctly. I'm sure you will figure out any adjustments needed.


You gave me enough info for me to get it done!

Thanks a lot!
 Last edited: by btiltman
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
Quoting bogieboo:
Quote:
Multiple Cast members are now imported but the Role and Credited as are still left out.

I'm back looking at BulkEdit again, planning the massive changes needed for 3.6.

For the life of me, I have no clue how you got any cast/crew information from BulkEdit XMLimport, cause there is no code for that.    Perhaps you used a different tool for that?

Anyway, I am working on a few pre-3.6 changes now. Sometime in the future, I will probably add the cast/crew import during the 3.6 upgrade.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
Version 1.29 Available  (Edited)

- Recoded the "Save Validated Changes" process to run faster
- Added new menu: Collection\Flags\Flag between...

The new menu item will flag all profiles (boxset recursion) between a flagged profile above and a flagged (and selected) profile below, hence "between".

The process is (1) Flag the top profile, (2) Flag/Select the bottom profile, (3) Select "Collection\Flags\Flag between... "

As usual, uninstall the old version first, but hang on to it, in case I introduced new bugs, you can go back to the old one.

BTW, I do all my testing on 3.6 Beta now, but the plugin is still using the 3.5 API, and should basically run the same on that.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
so, after encouraging ( ) in another thread I tried a XML-Import.

1) small problem with the PurchasePrice, most likely a "comma versus dot" problem. My
<PurchasePrice DenominationType="EUR" DenominationDesc="Europe (Euro)" FormattedValue="€40,17">40.17</PurchasePrice>
gets converted to 4017€, which I don't recall to have payed on a single disc.

2) strange problem: the Notes, besides from being correctly inserted in the Notes-section, also wind up in the Note of the Events!
Only the first 60 characters, so I imagine the maximum length of a Event-Note is 60 characters.
On a side-note, the event-notes don't seem to be exported, never noticed this before coz' I don't use them, will bring this up in the technical support forum.

cya, Mithi

PS Windows 7 Home 32bit german, DVD Profiler 3.6.0 Build 1367, Bulk Edit 1.29
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
 Last edited: by Mithi
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
Quoting Mithi:
Quote:
so, after encouraging ( ) in another thread I tried a XML-Import.
PS Windows 7 Home 32bit german, DVD Profiler 3.6.0 Build 1367, Bulk Edit 1.29

Thanks for the feedback Mithi. I will try to fix all that when I do the upgrade for 3.6.

I don't remember whether I even attempted to handle the "comma vs dot" issue. I think there is some new stuff in the plugin toolkit for recognizing the user locality. Otherwise I guess I would need the user to tell me which format to use.

Edit: I found the Events notes bug. Seems like it has been there since day 1. Nobody has mentioned it, but I guess if anybody did an import where there were Notes, then the Events notes got filled in incorrectly. Maybe I need to make a "events notes cleaner" function in case somebody wants to delete them in the future.

I was looking at your XML example:

<PurchasePrice DenominationType="EUR" DenominationDesc="Europe (Euro)" FormattedValue="€40,17">40.17</PurchasePrice>

I notice that the formatted value and innertext use different formats. Is this the way XML is exported in German DVDP? Seems inconsistent. My code creates the currency symbol from the denomination type, but then uses the innertext for the value. Shouldn't that work? In this case I see why it doesn't. The error seems to be actually in the XML, not the import, IMHO. I should probably use the formatted text instead, then it will probably come out correctly for the locality.

(I also see now that I only try to handle a few of the major currencies.)
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
BulkEdit V1.30 Available

Due to the much appreciated feedback from Mithi, I have fixed a couple of problems:

(1) Information from imported Notes was inadvertently added to Events Notes: Fixed.
(2) Verifed that currency values are converted correctly. I'm not sure what the issue was here. The code I wound up with was identical to what I started with. Maybe a subtle typo somewhere, but this has been working for a long time now. Maybe something different happens in my code on German Windows, but the XML that Mithi sent is correctly processed on my Engish Windows system.
(3) Tripped over an ancient bug that I previously did not know how to fix - now fixed. The edit window crashed when the cursor was left in a dropdown edit position and "Save Validated ..." was selected.

Reminder on Retailers: They must be pre-defined, exactly as spelled in the XML. When BulkEdit is upgraded to work on the 3.6 API, this can be fixed, and new Retailers will be added to the database as discovered. Also, a bulk "Add Retailers" function is being planned.

BulkEdit still only support 3.5.1 level of functions and data, although it works and is supported on 3.6.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting mediadogg:
Quote:
(1) Information from imported Notes was inadvertently added to Events Notes: Fixed.
confirmed, the ghost-notes are gone.
Quote:
(2) Verifed that currency values are converted correctly.
Not for me unfortunately.
Solution for the time being: I just switched Windows to 'english (US)' prior to the import and everything went fine.

Yes, the XML seems a bit odd at this point, but I don't know enough about 'well formed XML' to really have an opinion on this matter.
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
Thanks Mithi. You can't imagine how nice it is to get feedback. Many times, I fix stuff or make some change in response to a request - then no reponse - nada. So, I really appreciate your comments.

Regarding the XML: <PurchasePrice DenominationType="EUR" DenominationDesc="Europe (Euro)" FormattedValue="€40,17">40.17</PurchasePrice>

I'm guessing that in an English system, my code sees the "40.17" innertext, probably in a European windows, the 40.17 gets translated to the formatted value, "40,17".
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
Version 1.31 Available

This is an emergency update that attempts to eliminate a conflict between BulkEdit and other plugins.

Just so users will know, it is virtually impossible for plugins to actually interact directly by accident. What hapened was kind of a communications issue, where one plugin that was bending the rules (mine  ) got another plugin confused (Mark's).

Anyway, it should be all good now, and we developers learned a bit to keep us more wary in the future.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting mediadogg:
Quote:
I'm guessing that in an English system, my code sees the "40.17" innertext, probably in a European windows, the 40.17 gets translated to the formatted value, "40,17".


This is a German OS speciality. We have the comma as decimal separator. This can be queried via GetLocaleInfo from the OS ("LOCALE_SDECIMAL").
The FormattedValue will always use the locality settings. The other value will always use "." independent of locality settings (this is made to be sure that there is a consistent standardized value in the XML).
Before you now want to use this value for setting the price via the API (i.e. for converting the string into a float value), you have to replace the "." with the local decimal separator (on English OS usually again the ".", but on German OS it would be ",").


 Last edited: by TomGaines
DVD Profiler Unlimited RegistrantStar Contributordee1959jay
Registered: March 19, 2007
Reputation: Highest Rating
Netherlands Posts: 6,018
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting mediadogg:
Quote:
Version 1.31 Available

This is an emergency update that attempts to eliminate a conflict between BulkEdit and other plugins.


Many thanks, mediadogg! 
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
Quoting dee1959jay:
Quote:
Many thanks, mediadogg! 

My pleasure.

And to TomGaines, I appreciate those details. I will certainly work that into future updates.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
    Invelos Forums->DVD Profiler: Plugins Page: 1... 17 18 19 20 21 ...52  Previous   Next