|
|
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 ...52 Previous Next
|
New Plugin: BulkEdit - Bulk Editing, XML and CSV Import of Profiles |
|
|
|
Author |
Message |
Registered: June 9, 2007 | Posts: 1,208 |
| Posted: | | | | 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? |
| Registered: March 18, 2007 | Reputation: | Posts: 6,460 |
| Posted: | | | | 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. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
| Registered: June 9, 2007 | Posts: 1,208 |
| Posted: | | | | 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? |
| Registered: March 18, 2007 | Reputation: | Posts: 6,460 |
| Posted: | | | | 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. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
| Registered: June 9, 2007 | Posts: 1,208 |
| Posted: | | | | Ok cheers MD. Still a huge timesaver as it stands |
| Registered: March 18, 2007 | Reputation: | Posts: 6,460 |
| Posted: | | | | 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. Hey, new product!!! BDPFrog. |
| Registered: March 18, 2007 | Reputation: | Posts: 6,460 |
| Posted: | | | | 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. Hey, new product!!! BDPFrog. |
| Registered: June 9, 2007 | Posts: 1,208 |
| Posted: | | | | 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! |
| Registered: March 18, 2007 | Reputation: | Posts: 6,460 |
| Posted: | | | | 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. Hey, new product!!! BDPFrog. |
| Registered: March 18, 2007 | Reputation: | Posts: 6,460 |
| Posted: | | | | 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. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
| Registered: March 18, 2007 | Reputation: | Posts: 6,460 |
| Posted: | | | | 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. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
| Registered: March 18, 2007 | Reputation: | Posts: 6,460 |
| Posted: | | | | 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. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
| Registered: March 13, 2007 | Reputation: | Posts: 2,005 |
| Posted: | | | | 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? | | |
|
| Registered: March 18, 2007 | Reputation: | Posts: 6,460 |
| Posted: | | | | 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. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
| Registered: March 18, 2007 | Reputation: | Posts: 6,460 |
| Posted: | | | | 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. Hey, new product!!! BDPFrog. | | | Last edited: by mediadogg |
| Registered: March 14, 2007 | Posts: 3,830 |
| Posted: | | | | 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 ...52 Previous Next
|
|
|
|
|
|
|
|
|