videoDB

You could convert your Excel table into SQL statements (INSERT INTO ...) =
and
run this directly against the database...

Andreas Goetz
cpuidle@...
http://www.cpuidle.de
 =20

> -----Original Message-----
> From: videodb-devel-admin@...
> [mailto:videodb-devel-admin@...] On Behalf=20
> Of Andrew Ryder
> Sent: Sonntag, 7. M=E4rz 2004 02:14
> To: videodb-devel@...
> Subject: [videodb-devel] question about mass insertion
>=20
> Hi, I have an openoffice spreadsheet with around 1200 entries of:
>=20
> CD1 / Title / Format / CD# / CDOF (some things are two cds)
>=20
> And wondering if there is any easy way to get this into the database?
>=20
> VideoDB rocks - I was figuring I could add just the title in=20
> and sort out a mismatch later.
>=20
> Thanks.
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials Free=20
> Linux tutorial presented by Daniel Robbins, President and CEO=20
> of GenToo technologies. Learn everything from fundamentals to=20
> system=20
> =
administration.http://ads.osdn.com/?ad_id=3D1470&alloc_id=3D3638&op=3Dcli=
ck
> _______________________________________________
> videodb-devel mailing list
> videodb-devel@...
> https://lists.sourceforge.net/lists/listinfo/videodb-devel
>=20

Hi Andrew,

I would use the OO.o Dataconectivity using ODBC. Search the Archive of this 
list for a description on how to connect via ODBC using my OO.o template. The 
"Databrowser" (an Access lookalike) would let you copy and paste in those 
1200 entries of Calc. Try and see, I have not done it myself.

You might have to preformat your Cals sheet to meet the structure of videoDB.

Cheers,

Elkin
>
> Hi, I have an openoffice spreadsheet with around 1200 entries of:
>
> CD1 / Title / Format / CD# / CDOF (some things are two cds)
>
> And wondering if there is any easy way to get this into the database?
>
> VideoDB rocks - I was figuring I could add just the title in and sort out
> a mismatch later.
>
> Thanks.

Hi Andrew,

I have this same problem, but videoDB is the solution. It does not matter how 
many CDs a Movie has as long as they share the same DiskID (it is not 
unique). That way you can have 3 VCDs with one DiskID. 

I also use the DiskID to keep track of the Series I own. My code is XXXX-YY 
where X is the unique Series ID. 0001-01 is the first movie of the StarWars 
series 0001- 02 is the second etc. They have several DVDs in the case, and 
videoDB has an entry for each DVD, but with the same DiskID. I hope I 
explained it correctly.

So when you import 897,898,899 you take 00001-01 as the DiskID for all of 
them. That way, when you borrow it, all CDs get borrowed.

cheers,

Elkin

On Sunday 07 March 2004 17:10, you wrote:
> Hello,
>
> The only problem I see currently is that multiple entries seem to be a
> weird thing with VideoDB from using it in the past.
>
> The problem with many xvid/divx/etc is that there are two and sometimes
> three cds and I am not sure how to list these. All of mine are in order..
> say CDs 897,898,899 are a SVCD of X-Men or something.. but all are the
> same movie just parts 1-3 respectively.