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 2 3 4 ...47  Previous   Next
New Plugin: BulkEdit - Bulk Editing, XML and CSV Import of Profiles
Author Message
DVD Profiler Desktop and Mobile RegistrantMarEll
Registered: June 9, 2007
United Kingdom Posts: 1,208
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
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?
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,706
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
Quoting MarEll:
Quote:
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?
Thanks. I hope so. It has been a lot of work to make it.

I sorta botched the Notes field. In an attempt to make an editable Rich Text field, I lost the standard right-click context menu. All the other text fieilds have it. So, you could right-click Copy from Location or Slot, and then (until I fix it), use Ctrl-V to paste into Notes - that works OK. The standard windows copy / paste works between all the other text fields.

Also:
- soon I will have my own copy / paste multiple cells context menu (planned 0ne-> Many in the same column: Are you asking for Many -> Notes? - if so, is it "Copy" or "Move", and is there a CRLF after each field?)
- you can also right-click "Edit Personal Info", and paste directly into the native editor if you want. It's just about as fast because the native Notes editor is better than my datagrid version. Of course that change is immediate: main program needs no validation from me!
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
 Last edited: by mediadogg
DVD Profiler Desktop and Mobile RegistrantMarEll
Registered: June 9, 2007
United Kingdom Posts: 1,208
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
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?
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,706
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
Quoting MarEll:
Quote:
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?
Not yet, but my multi-cell copy might not be that powerful. (Of course, you could tab down the column, using shortcut keys for copy/paste. Once the copy operations are done, then "Save" will commit them all at once.) But your idea is a good one. Alternatively, my original goal on providing the pop-up Excel export, was to allow scripted changes that could be imported back. That would be a lot more efficient than for me to try replicating all of Excel. I am working on the import and multi-cell copy now.

On the other hand, along the lines of Database Query, I could provide a few canned bulk changes on a menu. Not sure if there are enough general purpose ones ...
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
 Last edited: by mediadogg
DVD Profiler Desktop and Mobile RegistrantMarEll
Registered: June 9, 2007
United Kingdom Posts: 1,208
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Ok cheers MD.

Still a huge timesaver as it stands 
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,706
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
Quoting MarEll:
Quote:
Ok cheers MD.

Still a huge timesaver as it stands 
I am hoping that V0.84 will be even better. Update pending ... hopefully today or tomorrow. I will update this post. Web site already has the description, but new code not uploaded yet. Still running a few tests.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,706
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
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.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
DVD Profiler Desktop and Mobile RegistrantMarEll
Registered: June 9, 2007
United Kingdom Posts: 1,208
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with 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!
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,706
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
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!
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,706
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
Finding bugs in Multi-Copy - Notes field, but not always. Trying to sort it out.

Edit: Should be fixed in V0.85. Also added profile selection option: single click on Profile ID cell wll select the profile displayed in the main program. Double click should always be enabled to bring up profile editor (also via right-click).
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
 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: 4,706
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
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.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
 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: 4,706
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
CollectorZ Migration (Import XML to Profiler)

It is easy to recognize CollectorZ XML, so I plan to add this feature, but I need help on the mapping. Here is what I have so far. The question marks are places where I'm not sure what's best. Suggestions would be appreciated.

Status as of 9/4/2008:
Done
  (*)  CollectorZ             DVD Profiler
    *  Boxset Parent              Boxset Parent
    *  Title                          Title - for convenience - will be overwritten by Refresh
    *  Collection Status
    *    Not In Collection        Wishlist
    *    Wanted                    Wishlist
    *    In Collection              Owned
    *    For Sale                    Tag = ForSale
    *    On Order                  Ordered
    *    UPC                            UPC
    *    Notes                          Notes
    *    Tags                          Tags
    *    Usertext1                    Tag = Usertext1/{usertext1}
    *    Usertext2                    Tag = Usertext2/{usertext2}
    *    Location - Profile level    Tag = Location/{location}
    *  Purchase Info
    *    Store                        Purchase Place
    *    Purchase Date            Purchase Date
    *    Purchase Price            Purchase Price
    *  Owner                        create dummy return event with owner as user
    *  Condition                    Tag = Condition/{condition}
    *  Seen It (Flag)              Watched Event (use owner as user)
    *  Viewing Date                Watched Event
    *  Seen Where                Watched Event Notes
    *  Links
    *    Local                        URL in Notes
    *    Online                      URL in Notes
    *    Index                        Collection Number
    *    Quantity                    ? - skipped for now
    *    Tape Label                  ? - skipped for now
    *    Starting Position          ? -skipped for now
    *    Tape Speed                ? -skipped for now
    *    My Rating                    Review - Film
    *    Storage Slot                Slot
    *    Storage Device            Location
    *  Loan
    *      LoanedTo                  Borrowed Event
    *      Title                          Borrowed Event
    *      Due Date                  Borrowed Event
    *    Return Date                Returned Event

(Edited to reflect suggestions, comments and coding status)
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 1,972
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:

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?


DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 4,706
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
Handling of CZ links:

I plan to handle CZ links this way: data from CZ is {URLtype}, {URL}, {description}. Note, in some cases, {URL} is actually a windows filepath.

URLtype = "URL"

<a href="http://{URL}">{description}</a> (assuming URL contains a web address)

if "youtube" is contained within {URL}, I will use:

<videos youtube=Trailer@{trailerid} />,

if I can find the trailer id, so that the popular HTML section solution in the Layouts Forum will work.


URLtype = "image"

<a href="file://{URL}">{description}</a>

URLtype = "movie"

<a href="file://{URL}">{description}</a>

URLtype = "other"

<a href="file://{URL}">{description}</a>


Any comments?

(Edit: Deferred until / unless I get feedback)
(Just was reading the Layouts forum again, and I see there is also google video and videodetective and myspacetv - I will try to do as many as possible, so any trailers from those sites saved as CZ links will work automatically with Addicted2DVD'ss HTML code - is that a good idea, because then they will not work as URLs?).
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
 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: 4,706
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
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.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantStar Contributor?
?
Registered: March 14, 2007
Posts: 3,830
Posted:
PM this userVisit this user's homepageEdit postDirect link to this postReply with quote
locality is stored in a number, the list has been published somewhere.
this shown on the contribution note
Contribution comments for [5035822216167.4] UPC/EAN dis-id followed by .number
link for locality
Nehterlands:
I93595D3D76434346.9
Italy
8010020092284.13
Belgium (disc-id)
IB806D356FFCA004F.30
UK
5035822216167.4
US
043396086517 (odd one out no number) but it should be 0 see the IMG tag below
DVDIMG UPC="043396086517" LOCALITY="0"
Sources for one or more of the changes and/or additions were not submitted. Please include the sources for your changes in the contribution notes, especially for cast and crew additions.
 Last edited: by ?
    Invelos Forums->DVD Profiler: Plugins Page: 1 2 3 4 ...47  Previous   Next