Forgot password? | Forgot username? | Register

Appending multmedia to the catalogue

Appending multmedia to the catalogue

I'm trying to append emultimedia records to existing ecatalogue records using this csv with no joy. All the records exist in the relevant modules but only one attachment is made on record number 4 to irn 348310. The log file does not record any errors and so I am stumped. Anyone got ideas what I am doing wrong?

irn,MulMultiMediaRef_tab(+).irn,MulMultiMediaRef_tab(+).irn,MulMultiMediaRef_tab(+).irn
1808109,348321,,
1808087,348310,348536,
1808089,348536,348321,
1808074,348507,349155,348310

Sharon Grant
Technology Liaison to Science
useravatar
Offline
23 Posts
Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Appending multmedia to the catalogue

Hi Sharon,
To append existing mmr irns to ecatalogue records, you can use the following format.  You will notice that I have duplicated your irn values in the first column for each mmr attachment irn - because you are using the + (append) option the mmr irns will append and not overwrite (which is what is happening in your above example) - let me know how you go!
irn    MulMultiMediaRef_tab(+).irn
1808109    348321
1808087    348310
1808087    348536
1808089    348536
1808089    348321
1808074    348507
1808074    349155
1808074    348310

Cheers,
Donna

Donna Begg (Axiell Melbourne)
useravatar
Offline
25 Posts
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Appending multmedia to the catalogue

That works just fine and cuts down the import process from 13 pages to 3 steps!

Much appreciated.


Sharon

Sharon Grant
Technology Liaison to Science
useravatar
Offline
23 Posts
Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Appending multmedia to the catalogue

That's great Sharon!

cheers,
Donna

Donna Begg (Axiell Melbourne)
useravatar
Offline
25 Posts
Administrator has disabled public posting. Please login or register in order to proceed.
There are 0 guests and 0 other users also viewing this topic