| Author |
Message |
| Registered: March 31, 2007 |  Posts: 662 |
| | Posted: | | | | Quoting mediadogg: Quote:
A future release will add more fields. Purchase Info has already been requested. MyLinks is also a candidate. I'm looking for MyLinks. | | |  |
|
| Registered: March 18, 2007 | Reputation:  |  Posts: 6,461 |
| | Posted: | | | | Repeating groups are tricky in CSV format. CSV Export has a clever way of doing it, but hard to replicate reliably by hand.
Any ideas?
In case my terminology is throwing you, the problem is how to handle multiple values for a field in CSV format. It is much easier in XML. All the fields I support in Personal Data Import have only one value per profile. Thinking .... | | | Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog. |
|
| Registered: March 18, 2007 | | Reputation: | | Posts: 6,461 |
| | Posted: | | | | I just remembered that I put My Links import into LoadDVD. You can take a look here. Would that be suitable? If so, I can put it into BE as well, unless of course you already use or willing to use LoadDVD. The method I used there avoids the issue I brought up in my last post by limiting the import to nothing but My Links, so you just keep repeating the ProfileID key in each row for as many links you want to add. The referenced document has an example. | | | Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog. |
|
| Registered: March 31, 2007 | | Posts: 662 |
| | Posted: | | | | Quoting mediadogg: Quote:
In case my terminology is throwing you, the problem is how to handle multiple values for a field in CSV format. It is much easier in XML. I thought about this, too. My idea was to add access to MyLinks and let the user build an xml inside the field. Here's what I want to do: I have links to some sites added to my notes, which I want to move to MyLinks. My notes look like this: Quote:
<IMDB=tt0120737 />
<OFDB=5462 />
<Rotten=lord_of_the_rings_the_fellowship_of_the_ring />
<YouTube=Bbp_z_m5Uu0>Englischer Trailer #1</YouTube>
<YouTube=8x5klDwI9ss>Englischer Trailer #2</YouTube>
<YouTube=t9jrM8WTQ7Y>Englischer Trailer #3</YouTube> So what I would have to do is: 1. Add <CustomLinks> to MyLinks 2. Add lines like <L URL="http://www.youtube.com/watch?v=Bbp_z_m5Uu0" D="Englischer Trailer #1" C="3" U="1" L="1"/> which could be done easily with regular expressions 3. Add </CustomLinks>But this would only work as long as MyLinks is empty. So maybe it's possible that BulkEdit will add the first and last line automatically and I'll only have to add the lines from step two. This way I could just add the lines to the existing MyLinks. Getting access to Online Profile Links would be nice, too - though I don't know if this is possible at all. Quoting mediadogg: Quote:
I just remembered that I put My Links import into LoadDVD(...) Is there an easy way to get my Notes exported into CSV? | | | |
|
| Registered: March 18, 2007 | | Reputation: | | Posts: 6,461 |
| | Posted: | | | | I think all of the bits are there, just not organized to make it turnkey for you.
(A) We could do it by coding a turnkey solution.
(B) Or, if you are willing to do a bit of cobble-together-with-existing-stuff,
here is an idea:
(1) Export notes using standard Invelos XML. Select options to exclude cast / crew and whatever else you don't need. (All you really need is ProfileID and Notes). Or you could use CSV Export plugin.
(2) Write a script to convert the URLs from Notes into the LoadDVD My Links Import CSV format (very simple format - see the document link)
(2a) Alternative - BulkEdit Regex+Scripts is powerful enough to parse your notes links and create a CSV file on disk, in LoadDVD format. I can help you figure out the code if you want. I think I already gave an example of loading and parsing an XML string in the BulkEdit thread. But it would be a good test, so I don't mind giving you a hand with it.
(3) Temporarily install LoadDVD to load the URLS into My Links. It is additive. It will automatically add the ones from the CSV to your existing ones.
I could work on a more tunrkey method, but if you don;t mind that small bit of hacking, I can put a better solution on my list for a more careful and complete solution sometime.
What do you think? | | | 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,461 |
| | Posted: | | | | LoadDVD has a bunch of added menus to work with My Links and Online Links. I am doing some (more) testing now. I don't anybody noticed or has used these menus, as I have not gotten any feedback or bug reports. The menus are documented in that same link I gave before. Drat: not working. Maybe I released the wrong version, or somehow the internal format changed without me noticing. But the LoadDVD Online Links Export is not working right now. You can assume that I will fix ASAP if you are willing to use this method. | | | Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog. | | | | Last edited: by mediadogg |
|
| Registered: March 31, 2007 | | Posts: 662 |
| | Posted: | | | | Quoting mediadogg: Quote:
Drat: not working. Maybe I released the wrong version, or somehow the internal format changed without me noticing. But the LoadDVD Online Links Export is not working right now. You can assume that I will fix ASAP if you are willing to use this method. Yes, that would be nice. I have just created the CSV-file from my notes Right now I'm creating a backup of my db.  | | | |
|
| Registered: March 18, 2007 | | Reputation: | | Posts: 6,461 |
| | Posted: | | | | Quoting StaNDarD: Quote:
Quoting mediadogg:
Quote:
Drat: not working. Maybe I released the wrong version, or somehow the internal format changed without me noticing. But the LoadDVD Online Links Export is not working right now. You can assume that I will fix ASAP if you are willing to use this method.
Yes, that would be nice. I have just created the CSV-file from my notes
Right now I'm creating a backup of my db. Oh cool. Go ahead and give it a try. The bug I found was with Export. The Import might be working, but I can't find my test files, and I am starving right now. After breakfast, I will check back to see if you tried it, otherwise, I will do some testing. | | | Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog. |
|
| Registered: March 31, 2007 | | Posts: 662 |
| | Posted: | | | | Import is running - maybe I should have tried with a small selection instead of my whole collection at once.
So this may take a while... | | | |
|
| Registered: March 18, 2007 | | Reputation: | | Posts: 6,461 |
| | Posted: | | | | Quoting StaNDarD: Quote:
Import is running - maybe I should have tried with a small selection instead of my whole collection at once.
So this may take a while... Yeah, but what the heck - you've got a backup. I just enjoyed a tall stack of pancakes, eggs and ham - oh man! Wife is out of town, so the breakfast I usually treat her to - I ate by myself.  Froze up the rest. She can eat it another day. Now, I'll go to work on the bugs I found and wait for your report. I usually test by doing an export-import round-trip, but now that the export has mysteriously stopped working ... I have to fix that first. | | | Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog. | | | | Last edited: by mediadogg |
|
| Registered: March 31, 2007 | | Posts: 662 |
| | Posted: | | | | Quoting mediadogg: Quote:
Yeah, but what the heck - you've got a backup.
I just enjoyed a tall stack of pancakes, eggs and ham - oh man!
Wife is out of town, so the breakfast I usually treat her to - I ate by myself. Froze up the rest. She can eat it another day.
Now, I'll go to work on the bugs I found and wait for your report. I usually test by doing an export-import round-trip, but now that the export has mysteriously stopped working ... I have to fix that first. Everything would have been OK, if my CSV-file would have been correct - damn, now all the trailers ended up in Rating-category. Well, I'm on my second try now - even if I have to do this a dozen times it's still a lot faster than doing this by hand...  I just tried to export online links: Sometimes I get an error: "Das Stammelement ist nicht vorhanden" ("The root element is missing"). Sometimes it works like a charm. Sometimes there's no error, but the CSV-file is empty although there are online links for the profile. | | | | | | | Last edited: by StaNDarD |
|
| Registered: March 18, 2007 | | Reputation: | | Posts: 6,461 |
| | Posted: | | | | Thanks for the report. I will focus on the Export bugs then. When they are fixed, you can get the Online Links exported out and bring them back in as My Links. Maybe you can do that inside DVDP, not sure. | | | Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog. |
|
| Registered: March 18, 2007 | | Reputation: | | Posts: 6,461 |
| | Posted: | | | | I see one problem. I use the built-in menu "Online \ Online Profile Links \ Copy Online Links" internally to grab links from the Clipboard. But that menu is mostly greyed out, so I get an empty Clipboard. I don't know what I have forgotten or misunderstood about that feature.
Anyway, if by "Online" links, you mean the ones that appear on the Profile Links page, I have an alternate method of getting them, but it requires loading that web page. That code is debugged and in use elsewhere inside LoadDVD, but I want to confirm that is what you are trying to export.
(I did a search - seems this is a known problem since Beta days. I'll just have to put some error traps in to prevent trying to process blank XML). | | | Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog. | | | | Last edited: by mediadogg |
|
| Registered: March 31, 2007 | | Posts: 662 |
| | Posted: | | | | Quoting mediadogg: Quote:
I see one problem. I use the built-in menu "Online \ Online Profile Links \ Copy Online Links" internally to grab links from the Clipboard. But that menu is mostly greyed out, so I get an empty Clipboard. I don't know what I have forgotten or misunderstood about that feature. Well, I guess this is a bug... Quoting mediadogg: Quote:
Anyway, if by "Online" links, you mean the ones that appear on the Profile Links page, I have an alternate method of getting them, but it requires loading that web page. That code is debugged and in use elsewhere inside LoadDVD, but I want to confirm that is what you are trying to export. Yes, that's exactly what I want to export / copy to MyLinks. | | | |
|
| Registered: March 18, 2007 | | Reputation: | | Posts: 6,461 |
| | Posted: | | | | Are you seeing that menu or is it greyed out?
The existing code should work if the menu is not greyed out, but I neglected to account for the null string I get when it is greyed out. The error then aborts the whole process and you get an empty output file.
But if you can find one or more profiles for which the menu is not greyed out, the existing code should work.
When I'm done recoding, it will be protected from the disabled menu, and try to grab the URLs directly from the Profile Links web page when the menu is not there.
Oh, BTW, did the Import of My Links work finally after you fixed the CSV file? | | | Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog. | | | | Last edited: by mediadogg |
|
| Registered: March 31, 2007 | | Posts: 662 |
| | Posted: | | | | Quoting mediadogg: Quote:
Are you seeing that menu or is it greyed out? It's greyed out in most cases. Quoting mediadogg: Quote:
When I'm done recoding, it will be protected from the disabled menu, and try to grab the URLs directly from the Profile Links web page when the menu is not there. That would be really great. Quoting mediadogg: Quote:
Oh, BTW, did the Import of My Links work finally after you fixed the CSV file? Well, the first import was totally correct regarding the data I've loaded. So, yes, second import was perfect. | | | |
|