Hi,

Is it possible to export the DVD in the database to Excel 2007?

Best Whishes

Quoting Jordi:

Quote:
Is it possible to export the DVD in the database to Excel 2007?

Not directly, there is however a Plugin to export to CSV, and a csv-file can be opened in Excel.

cya, Mithi

There is a sorta fix in place for this with release 3.0.3, it is hidden in the DVD -> edit -> Personal Information tab, bottom two fields, Location and Slot.  (this location is not to be confused with location of ?playable?, this location is how you use it, I use it for storage/file location.

Steps to edit the field for each dvd are : Click on title to edit, click on DVD, click on Edit, click on Personal Information tab, click in location field, enter location text, click on Slot field, enter text, click OK, repeat.  For 500 discs that is painful.  In excel is one fill down for all 500 discs (just a point to work on improving software)

Another point is that currently I can not edit the location and slot fields for all my movie’s.  for reason on about 5% of the movies I can not edit those fields.  Another issue is to use the data, to put it into a report do the follow (several hours to track this one down – and copying an existing report didn’t work.)  Go to Reports, click on report to edit, click on Edit Report, click on the content tab, click on the DVD tab, add icon “Disc Information”  (why your personal info is with disc information is beyond me), but not done yet, then with the attributes listed on the left side turn Show Location to true, repeat for Show Slot, or turn both on for application controlled togetherness.

So issues that I can not fix with the application are:
1.) can not edit the location and slot fields for all movie titles
2.) can not create a report with movies left to right, as is done in the English language
3.) can not create correct entry for a DVD that doesn’t exist in your db (so far, my copy of transporter 2, xmen 2 (did find looking at x’s to see it was started as X2, not x-men, and my copy of 10/Tarzan dual movie disc
4.) can not find movie by a word in title, as apposed to start of title, (problems with movies in your database starting with “adventures of” or “national lampoon” instead of “Buckaroo Bonzai”, or “Vacation” ; M:2 instead of mission, AeonFlux – well every title with foreign letters in it really, xmen2, can find others if I review listing, but that is the jest of it, and reason for wish)
5.) can not create reports dropping the box title, just print out dvd titles (can watch the box, but not very exciting cardboard.)
6.) can not print out both movie titles to a dual disc (may be there, haven’t looked far on this one, will not go with solution of having each title show up at different locations on the report, like 10 at start of report and tarzan at end of report, have to be similar to boxed set)
7.) can not export the data to another program  (like excel where I must still print out valid reports from.)  or for any other reason (I put this here, because I review the xml output, and it is not viable for use without writing a program to read it, I am asking for the ability to drop select fields of data per dvd, (can be xml formatted).  I as a user, should not care that you as a company have region information nested, and should not have to wade through the just info, I just want a few fields, like title, sort title, disc count, video time, location, rating, and maybe something else, but really just title and location to find it.
8.) Another thing that would be neat to see would be better handling of TV boxed sets.  I really like to see my Season 1 of Simpsons listed with # of episodes.

Issue that i can work around but causes the most pain
1.) setting location for every dvd

Issue that i can work around but causes the most pain
1.) setting location for every dvd


Edit your dvd and add disc id.........

Quoting lancedvd:

Quote:
wrong location :-)
i was refering to the storage location in the personal information tab.  I dont care about the other location info.

I know where your talking about, if the Disc ID area is blank Personllized will not let you put in the location.  It doesn't need to have the Id, but you need to add a disc and description.


Larry

should preview more: The csv plugin works great for getting your invelos video inventory into an excel spreadsheet.

@LanceDVD

Number 1) - already solved

Number 2) - Please elaborate? Not sure what you mean.

Number 3) - Under enter UPC type in the UPC then Click "add DVD" button. It will create a new empty profile. For cover images use amazon or similar website.

Number 4) - tick the box "Full Substring Filter".

Number 5) Modify the title name to include both titles.

Number 6) See Number 5!

Number 7) already solved.


HTH

Kevin

1) It's an undocumented design feature.....no disc, no location and slot information. Whilst it is a PITA, it is actually useful for me since for box sets and bonus discs etc.. I can assign a location and slot for each DVD in the jukebox.

2) Feature request.

3) UPC is on displayed on the bottom of the general info tab?  At least it is on my layout.

4) NP.

5) I thought so, don't use box sets....perhaps someone else can help.

6) Other alternative would be to use the Notes field, However this means having two title spaces for the sake of one or two DVDs.

The other option is two add two profiles, one for each movie and set the location info to the same for both titles.

7) Yep!

8) Not that I know off, many requests for DVD counts. Currently only count I know off is the one for DVD count (which is actually a profile count).