Trying to import a CSV file using the Import Metadata option as
administrator and keep getting the message
'123456789/X' is not a collection! You must specify a valid collection
fro new items
OK, crank up psql and look at
select * from collection;
the collection_id is 4, name Books
select * from handle;
handle_id | handle | resource_type_id | resource_id
-----------+-------------+------------------+-------------
1 | 123456789/1 | 4 |
3 | 123456789/3 | 3 |
2 | 123456789/2 | 4 |
4 | 123456789/4 | 4 | 3
5 | 123456789/5 | 3 |
7 | 123456789/7 | 3 | 4
8 | 123456789/8 | 2 |
6 | 123456789/6 | 3 |
9 | 123456789/9 | 2 |
(I've tried those handles -- /4, /9 and /10, no joy in Mudville).
dspace=> select * from item;
item_id | submitter_id | in_archive | withdrawn | discoverable
| last_modified | owning_collection
---------+--------------+------------+-----------+--------------+---------------------------+-------------------
19 | 1 | f | f | t |
2013-08-22 11:51:00.39-04 |
(which tells me nothing but that the collection exists (I think).
select * from collection;
collection_id | name | short_description | introductory_t
ext | logo_bitstream_id | template_item_id | provenance_description
| license | copyright_text
| side_bar_text | workflow_step_1 | workflow_step_2 |
workflow_step_3 | submitter | admin
---------------+-------+-------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------+-------------------+------------------+------------------------+---------+----------------
+---------------+-----------------+-----------------+-----------------+-----------+-------
4 | Books | <P>A Collection of Historical Books and
Documents</P> | <P>Historical books and documents from the
collections of Aeneas Constantine, MD originating in the 1940's and
conti
nuing through the rest of his life left to the people of
Harrisville, Michigan as a cultural resource</P> |
| | | |
| | | | | 5 |
I'm pretty sure that's telling me the same thing.
Right now, the CSV file (with only one row, the 600+ look pretty much
the same) looks like this:
id,collection,local.boxnumber,local.unitnumber,local.height,local.width,local.row,local.column,dc.language.iso,local.evaluator,local.origlocation,local.currlocation,local.date.created,local.usercreated,local.userupdated,local.date.updated,dc.contributor.author,dc.title,dc.date.issued,local.edition,dc.date.created,dc.date.available,local.originalprice,local.purchaseprice,local.presentvalue,local.condition,dc.subject.classification,local.preface,dc.contributor.illustrator,local.seller,local.sellerlocation,local.binderylocation,local.binderyname,dc.publisher,local.publisherlocation,local.notes,local.boxjpgnumber,local.asscopy,local.notesdoc
"+","123456789/10",1,1,11,9,,,"English","Roger Lemons","Study West
Wall","Peter's Room",2007-03-23,"lemonsr","jguy",2007-08-03,"Ives
Joseph lieutenant","Colorado Exploring
Expedition",,"",1861,,,,,"Good","Unknown","","","","","","","Government
printing office","","\nmaps , color plates of native american\n36th
Congress !st Session","","f","american indians...\nSpringfield City
library ... in NY"
And I have no clue what to do to get this stuff loaded (I do realize
that the "123456789/10" is wrong but... no clue).
--
A riddle, wrapped in a mystery, inside an enigma but that's my story and I'm
stickin' to it.
------------------------------------------------------------------------------
Introducing Performance Central, a new site from SourceForge and
AppDynamics. Performance Central is your source for news, insights,
analysis and resources for efficient Application Performance Management.
Visit us today!
http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
