[Gusdev-rad-issues] Re: [Gusdev-gusdev] prerequisites for RAD ArrayLoader

[Elisabetta M. <man...@pc...>]

Kevin,

> So, for instance, in an array load data file I got from CBIL 
> (HG-U133A.forRAD.txt), the ext_db_rel_id column is 2 for all rows, where 2 
> refers to a release id in CBIL's database that indirectly links to an 
> SRES.ExternalDatabase record that might represent GenBank?  (Is it Genbank, 
> in this case?) And the source_id column might contain the accession number of 
> a Genbank sequence (e.g. U48705) to which this probe row is related?

Yes, it's Genbank.

> Our GUS instance does not have GenBank loaded yet.

What do you mean by loaded? You do not have to have the actual data from 
Genbank in your database. You only need to have one entry in 
SRes.ExternalDatabase denoting the Genbank database and then one or more 
entries in SRes.ExternalDatabaseRelease pointing to the latter. (In our 
instance we only keep one general ExternalDatabaseRelease entry for 
Genbank.)

> Is it OK just to put in a placeholder record for GenBank in 
> SRES.ExternalDatabase and then replace '2' 
> with whatever our release id winds up being in the corresponding 
> SRES.ExternalDatabaseRelease record?

Yes, that's what you need to do.
Elisabetta