Nice plugin MD    I can see me using this alot.

One question, is there a way to copy and paste the locations from a bunch of profiles into the notes field?

Ideally, what I want to do is  copy the data from the location field into the notes field on multiple profiles at once.  Is that possible?

Ok cheers MD.

Still a huge timesaver as it stands 

Ok, bit the bullet and uploaded V0.84.

I might have bitten off a bit much with this release. There was no way to test every possibility, so I am prepared to jump on any issues that arise. Other than bug fixes, I will not make any more updates until those that are needed to support the next release of Profiler.

Feedback appreciated. It goes without saying (but I'll say it anyway) ... backup your database and everything associated with it, before using this plugin.

Quoting MarEll:

Quote:
Just had a quick play about with the new version.  With the previous version I was getting errors when editing the dual layer field, as far as I can tell this is not happening anymore 

Haven't had a go with the multi-cell copy function yet but I'll post any comments when I do.  Thanks for implementing it 

Is there any way to store the layout of the sheet data?  And/or make the notes column smaller.  Its a little annoying having to shift the columns around every time I load new data (the title is always last and off the screen), otherwise...spot on!

Thanks for the feedback. Persistence of the layout is now on the upgrade list!

Ok, I think V0.86 is quite improved:  (Please don't quote this long post ... thanks.)

- After testing, found and fixed a number of bugs
- XML processing has been improved. Now round-trip capable.
- Locks added to XML Import, so that except for Cast/Crew/Headshots, all Personal Information can be imported via XML and merged into a new or existing database
- Additional options on the Edit menu allowing for flexibility in deciding which profiles get changed during the Validation cycle

XML Import is provided primarily for loading the personal information for new profiles in a convenient batch way. Here is the scenario one would use for Excel/XML Import/Export:

(1) Export the records to be changed, either using the Profiler export or BulkEdit "To Excel" menu. The BulkEdit "To Excel" menu exports all profile XML except CAST/CREW info, in a format virtually identical to DVD Profiler, then "executes" the file. This means that whatever program is associated with XML on your system, will pop up - Wordpad, Excel, IE, etc. The file is called export.xml and is saved in \plugins\BulkEdit\.

If the profiles are new, you can create XML based on a sample template, or use Profiler export and re-import them later with personal information added.

(2) Edit the XML in whatever fashion you like - taking pains to retain the Profiler format. I don't have a lot of error checking.

(3) Import the XML using BulkEdit. If you are buildng new profiles, the only field you need to add for display is Purchase Place - it is not automatically updated. If you intend to update existing profiles (not recommended - use the BulkEdit, in edit mode, instead), you must select for display whichever fields you will need to overlay onto the existing profiles. Thie more fields you add, the slower it will go. Review the log for errors and for notations about Purchase Places. You must also "View My Purchase Places".  Make a note of any purchase places that are not in your Retailer list. Exit BulkEdit immediately and add those retailers, otherwise, there will be errors that the plugin cannot intercept or prevent.

(4) Restart BulkEdit. Your prior results will still be there. Now, you may either run the Simulation for changes to Purchase Places - just to check for errors, or run the Save Validated Changes. All of the other personal information will have already been created during the initial load. At this point, the profiles will be complete except for the Invelos (non-personal) information.

(5) Exit BulkEdit. All of the added profiles will have been flagged, so now you click Collections/Flagged/Refresh, and the remaining information will be added to the profiles by direct download from Invelos.

I would not attempt to use this process for tons of profiles. It was designed for occasional mass updates in Location/Slot, for example, or for adding a batch of new profiles after a major new purchase, or for quickly creating a bunch of Manual profiles to get a head start on entering special use profiles.

I have tested it, by starting with a totally blank database, importing collection.XML previously saved, doing a refresh, and the database was back. It took about 15 minutes for 300 DVDs - not a speed demon.

Please report any bugs or issues here.

Quoting mediadogg:

Quote:

My Rating                          Review - Video

I don't know CollectorZ, so I don't know the context a rating is given, but with the info given here I would assign it to "Review - Film". Wouldn't that be better?

If anyone can help me, I have a problem:

I'm basically done with the CZ import, but there is one thing I can't figure out how to do. When the personal info from CZ has been imported, the user of course does a "refresh" to bring down the profile data from Invelos. This works, except when locality not = US, because the refresh seems to be done on profile ID rather than UPC- but I might be confused on this.

Any ideas about how to determine "locality"? When locality = US, it works perfectly, and the CZ user is up and running on DVD Profiler in just a few minutes. If I can determine locality before the refresh, I can build the correct profile ID so the data will download with no errors. Otherwise, the locality has to be changed manuallly by the user.