BulkEdit V2.37 Available

- First official support for DVDP 3.8.1 and beyond. Does Not support any prior DVDP release
- New DVDP fields supported: Color, Dimensions, CoO2, CoO3, Gift Received, Gift From, Contributable
- Legacy DVDP fields support enhanced: Edition, Retailer
- Faster loading of Custom Categories, due to new Developer features
- Improved GUI - progress bars and ability to stop operations
- Fixed bug in handling of Wish List
- Identifying icons added to all BulkEdit menus
- Optional Regex added to column copy
- Edition supported for column copy
- Column Copy now supports: Color, Contributable, CountryOfOrigin, CountryOfOrigin2, CountryOfOrigin3, Dimension
- Added Menu Item: Collection>Flags>Flag Gifts
- XML Import enhanced to support 3.8.1 format

How to edit Dimensions:

This field is supported by a dropdown box that contains the eight (8) possible values of this 3-attribute field, using all combinations of 2D, 3DBluRay and Anaglyph being on or off.

Hence, for example:
- blank = no dimensions checkboxes flagged
- 2D+3DBluRay+Anaglyph = all dimension checkboxes flagged
- 2D+3DBluRay = two corresponding checkboxes flagged
- etc.

How to edit Color:

This field is supported by a dropdown box that contains all sixteen (16) possible values of this 4-attribute field, using all combinations of C (color), B (black and white) , Z (colorized) , and X (mixed) being on or off.

Hence, for example:
- blank = no color checkboxes flagged
- C+B+Z+X = all color checkboxes flagged
- C+Z = color and colorized checkboxes flagged
- B+X = black and white, and mixed checkboxes checked
- etc.

CSV Import

This function remains unchanged until Mark Harrison's CSV Export plugin is updated for 3.8.1. At that point, I will make changes to BulkEdit to maintain compatibility with CSV Export.

Limitations

With this number of changes in support of a new release of DVDP, there are bound to be some rough edges. I will do my best tp keep up with bug fixes.

Quoting dtsig:

Quote:
I decided that I would create 5 tags of the various locations for my discs.

fairly easy:
1) MAKE A BACKUP OF YOU DATABASE (sorry for shouting, but in another forum recently a user failed to do so and shot himself in the foot)
2) In the Collectionlist right-click on the column-heads, choose "View Columns -> Disc Location" and click once on this new column to sort by it.
3) Flag the first and the last of the profiles of your 'Location 1', "Collection -> Flags -> Flag between" (BulkEdit has to be active) and all the profiles will be flagged.
4) "Collection -> Flagged -> Tags" and assign the appropriate tag.

repeat 3 & 4 for all different Locations.


cya, Mithi

Quoting Mithi:

Quote:
Quoting dtsig:

Quote:
I decided that I would create 5 tags of the various locations for my discs.

fairly easy:
1) MAKE A BACKUP OF YOU DATABASE (sorry for shouting, but in another forum recently a user failed to do so and shot himself in the foot)
2) In the Collectionlist right-click on the column-heads, choose "View Columns -> Disc Location" and click once on this new column to sort by it.
3) Flag the first and the last of the profiles of your 'Location 1', "Collection -> Flags -> Flag between" (BulkEdit has to be active) and all the profiles will be flagged.
4) "Collection -> Flagged -> Tags" and assign the appropriate tag.

repeat 3 & 4 for all different Locations.


cya, Mithi

thank you Mithi, i didn't see the Collection -> Flagged -> Set Tag

Worked great
David

Quoting DoubleDownAgain:

Quote:
Long story short I've worked through it and now have a spreadsheet of the information I want in DVDP.  I have just around 3000 profiles and the only fields I'm interested in updating are the Purchase Place, Purchase Date and Purchase Price.

Most important: does this spreadsheet have the UPCs? If yes, the whole thing should be fairly easy manageable via the csv-import of BulkEdit.
Just save the spreadsheet as csv, and in BulkEdit: "Load" => "CSV and validate" => set "Source" to "custom" and choose the appropriate fields.

cya, Mithi

Thanks for the answers!  I think part of my problem was assuming I had to update all my profiles... instead of just the ones I need to update.  I'll get my ducks in a row and check back.

Thanks!

I get a lot of error messages:

Quote:
English error text:

Could not load file or assembly 'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies.  The system cannot find the file specified

As you can see, I get the first error right before DVDP will draw its window (the eye is completely colored).
I can click it away and DVDP will continue normally - but the error shows up every time I switch to another profile.

I'm running v2.38 on Windows 8 pro x64.

Edit:
I was just looking into options and trying to close that window I could fetch some details:

Quote:
Informationen über das Aufrufen von JIT-Debuggen
anstelle dieses Dialogfelds finden Sie am Ende dieser Meldung.

************** Ausnahmetext **************
System.IO.FileNotFoundException: Die Datei oder Assembly "System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" oder eine Abhängigkeit davon wurde nicht gefunden. Das System kann die angegebene Datei nicht finden.
Dateiname: "System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
  bei System.Configuration.TypeUtil.GetTypeWithReflectionPermission(IInternalConfigHost host, String typeString, Boolean throwOnError)
  bei System.Configuration.MgmtConfigurationRecord.CreateSectionGroupFactory(FactoryRecord factoryRecord)
  bei System.Configuration.MgmtConfigurationRecord.EnsureSectionGroupFactory(FactoryRecord factoryRecord)
  bei System.Configuration.MgmtConfigurationRecord.GetSectionGroup(String configKey)
  bei System.Configuration.Configuration.GetSectionGroup(String sectionGroupName)
  bei System.Configuration.ClientSettingsStore.DeclareSection(Configuration config, String sectionName)
  bei System.Configuration.ClientSettingsStore.GetConfigSection(Configuration config, String sectionName, Boolean declare)
  bei System.Configuration.ClientSettingsStore.WriteSettings(String sectionName, Boolean isRoaming, IDictionary newSettings)
  bei System.Configuration.LocalFileSettingsProvider.SetPropertyValues(SettingsContext context, SettingsPropertyValueCollection values)
  bei System.Configuration.SettingsBase.SaveCore()
  bei System.Configuration.SettingsBase.Save()
  bei System.Configuration.ApplicationSettingsBase.Save()
  bei BulkEdit.Options.button1_Click(Object sender, EventArgs e)
  bei System.Windows.Forms.Control.OnClick(EventArgs e)
  bei System.Windows.Forms.Button.OnClick(EventArgs e)
  bei System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
  bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
  bei System.Windows.Forms.Control.WndProc(Message& m)
  bei System.Windows.Forms.ButtonBase.WndProc(Message& m)
  bei System.Windows.Forms.Button.WndProc(Message& m)
  bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
  bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
  bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

WRN: Protokollierung der Assemblybindung ist AUS.
Sie können die Protokollierung der Assemblybindungsfehler aktivieren, indem Sie den Registrierungswert [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) auf 1 festlegen.
Hinweis: Die Protokollierung der Assemblybindungsfehler führt zu einer gewissen Leistungseinbuße.
Sie können dieses Feature deaktivieren, indem Sie den Registrierungswert [HKLM\Software\Microsoft\Fusion!EnableLog] entfernen.



************** Geladene Assemblys **************
mscorlib
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.6400 (Win8RTMGDR.050727-6400).
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll.
----------------------------------------
DatabaseQuery
    Assembly-Version: 2.7.0.0.
    Win32-Version: 2.7.0.0.
    CodeBase: file:///C:/Program%20Files%20(x86)/DVD%20Profiler/Plugins/Database%20Query/DatabaseQuery.DLL.
----------------------------------------
BulkEdit
    Assembly-Version: 0.0.0.0.
    Win32-Version: 0.0.0.0.
    CodeBase: file:///C:/Program%20Files%20(x86)/DVD%20Profiler/plugins/BulkEdit/BulkEdit.DLL.
----------------------------------------
System.Windows.Forms
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.6387 (Win8RTM.050727-6300).
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll.
----------------------------------------
System
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.6400 (Win8RTMGDR.050727-6400).
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll.
----------------------------------------
System.Drawing
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.6387 (Win8RTM.050727-6300).
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll.
----------------------------------------
System.Windows.Forms.resources
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.6387 (Win8RTM.050727-6300).
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_de_b77a5c561934e089/System.Windows.Forms.resources.dll.
----------------------------------------
System.Configuration
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.6387 (Win8RTM.050727-6300).
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll.
----------------------------------------
System.Xml
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.6387 (Win8RTM.050727-6300).
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll.
----------------------------------------
gluhsx5-
    Assembly-Version: 0.0.0.0.
    Win32-Version: 2.0.50727.6400 (Win8RTMGDR.050727-6400).
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll.
----------------------------------------
DVDPca
    Assembly-Version: 1.0.0.0.
    Win32-Version: 1.0.0.0.
    CodeBase: file:///C:/Program%20Files%20(x86)/DVD%20Profiler/plugins/DVDPca/DVDPca.DLL.
----------------------------------------
mscorlib.resources
    Assembly-Version: 2.0.0.0.
    Win32-Version: 2.0.50727.6400 (Win8RTMGDR.050727-6400).
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll.
----------------------------------------

************** JIT-Debuggen **************
Um das JIT-Debuggen (Just-In-Time) zu aktivieren, muss in der
Konfigurationsdatei der Anwendung oder des Computers
(machine.config) der jitDebugging-Wert im Abschnitt system.windows.forms festgelegt werden.
Die Anwendung muss mit aktiviertem Debuggen kompiliert werden.

Zum Beispiel:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

Wenn das JIT-Debuggen aktiviert ist, werden alle nicht behandelten
Ausnahmen an den JIT-Debugger gesendet, der auf dem
Computer registriert ist, und nicht in diesem Dialogfeld behandelt.

OK, I should have given you a little more information:
This is a first-time installation of your plugin on my new Windows 8 machine. The first time starting DVD Profiler after the installing your plugin got me those messages. It's an Intel Core i5, 16GB.

I tried it a couple of times on Windows 7 Ultimate 32bit and got these errors too. That was an Intel Core 2 Duo, 2GB.

I get the same error whenever I try to use Database Query, but that plugin won't throw a message on DVDP-startup.

Is there a way to check, if installation has been successful? Maybe a list of files a can check?

I got 'BulkEdit.dll', 'BulkEdit.tlb', 'EditDiscs.exe', 'localities.dod', 'unins000.dat' and 'unins000.exe' in 'C:\Program Files (x86)\DVD Profiler\Plugins\BulkEdit'.

@DoubleDownAgain,

Thanks for the details. I see now that basically, you want to update a bunch of profiles that are already in the database. And, in fact, you have already made the updates in a spreadsheet, outside of BulkEdit. This is a scenario that I have not yet put into BulkEdit, but it makes a lot of sense: copy/paste by column from Excel to BulkEdit would be neat - but it is not there.

Here is what I do support, in case you can modify your plans to fit:

(1) BulkEdit will import from CSV (CSVExport format is the default), allowing you to create new profiles with personal data such as Purchase date, Notes, Location, Slot, etc. I know that BulkEdit will warn you when an imported profile already exists in the database. What I don't remember, is whether you can override the database profile data with imported data. Maybe you can try one. All you need is the Profile ID column, plus columns for any fields you wish to change. If my memory serves, you see the imported data, along with a bunch of log entries warning you that the profile already exists. Now, you can try running the "Save Validated Profiles" menu, and see if your changed data is applied. I think it works, but I can't recall trying it! 

The alternative is to go ahead and create new profiles in a temporary database, after which you need to refresh from Invelos (faster than importing all the fields from CSV), and then you can save/restore the updated profiles into your main database.


(2) BulkEdit will give a spreadsheet-like editing environment for most all fields, except Cast/Crew, which is covered by other plugins. Since you already made your changes, you would have to redo them in the BulkEdit spreadsheet. There are a bunch of editing tools (e.g. Multicopy), but you have to decide whether redoing the edits is worth your time.

I hope this hasn't been too confusing. It is sort of a busy time for me - otherwise I would offer to add some sort of differential update from Excel, but I don't have the time right now. I hope one of the other scenarios works out for you. Once you get the hang of BulkEdit, it can save a lot of time, if it has the feature that you need.

In case you didn't notice, the BulkEdit CSV import format is exactly what is produced by CSV Export. That is what I try to support. But you can also use any custom format and map your headings to DVDP field names, as part of the import process.