Hi, I've prepared what I think is a reasonable set of fields, both "dc" and "local" for importing a FoxBase data base.
I'd appreciate any hints about what I've done wrong and I'd appreciate any hints about the first field, which is SERIAL data and how that might be accomplished as well as the two TEXT fields that are free-form text containing line feed (do they need to be <P></P> codes, will DSpace accept multi-line text), and date stamps? I assume that I'll need to edit the DSpace field names into the input data file before importing? Thanks FoxBase Field Name, Type| DSpace Field Name| Example (note) 1 books (books NUMERIC(8),| local:books| SERIAL data type 2 box_no NUMERIC(6),| local:boxnumber| Storage box number 3 unit_no INTEGER,| local:unitnumber| Unit number 4 height NUMERIC(5, 2),| local:height| Height (inches) 5 width NUMERIC(5, 2),| local:width| Width (inches) 6 row INTEGER,| local:row| Row 7 books_column INTEGER,| local:bookscolumn| Column 8 language VARCHAR(10),| dc:language.rfc3066| en (English), fr (French), de | | (German), gr (Greek), la (Latin), | | es (Spanish), it (Italian) (others) 9 curr_evalu VARCHAR(40),| local:evaluator| Name of evaluator 10 orig_locat VARCHAR(30),| local:origlocation| Original location 11 curr_locat VARCHAR(30),| local:currlocation| Current location 12 date_creat DATE,| local:datecreated| Date record created 13 user_creat VARCHAR(15),| local:usercreated| User created record 14 user_updat VARCHAR(15),| local:userupdated| User updated record 15 date_updat DATE,| local:dateupdated| Date record updated 16 author VARCHAR(75),| dc:contributor.author| Fielding, Henry 17 title VARCHAR(75),| dc:title| History of Tom Jones A Foundling, | | The 18 pub_date NUMERIC(4),| dc:date.issued| 1749 19 print_edit VARCHAR(10),| local:edition| 1st, 4th, 1850, 1910 20 print_date NUMERIC(4),| dc:date.created| 1749 21 purchase_d DATE,| dc:date.available| 1951-02-15 (date purchared by | | Constantine, Aeneas MD) 22 original_p NUMERIC(9, 2),| local:originalprice| Publisher price 23 purchase_p NUMERIC(9, 2),| local:purchaseprice| Purchase price paid by Constantine, | | Aeneas MD 24 present_va NUMERIC(9, 2),| local:presentvalue| Present value 25 book_condi VARCHAR(10),| local:condition| Poor, Fair, Good, Excellent, Other 26 subject VARCHAR(40),| dc:subject.classification| Free-form subject 27 preface VARCHAR(40),| local:preface| Yes, no, autor/editor 28 illustrato VARCHAR(40),| dc:contributor.illustrator| Cruikshank, George 29 book_selle VARCHAR(40),| local:seller| Selling dealer 30 seller_loc VARCHAR(40),| local:sellerlocation| Selling dealer location 31 bindery_lo VARCHAR(40),| local:binderylocation| Bindry location 32 bindery_na VARCHAR(40),| local:binderyname| Bindry name 33 publisher VARCHAR(40),| dc:publisher| Publisher name 34 publisher_ VARCHAR(40),| local:publisherlocation| Publisher location 35 notes TEXT,| local:notes| Free-form evaluator notes 36 box_jpg_no VARCHAR(10),| local:boxjpgnumber| Box image number 37 ass_copy BOOLEAN,| local:asscopy| Assocation copy (t, f) 38 notes_doc TEXT);| local:notesdoc| Free-form notes by Constantine, | | Aeneas MD -- A riddle, wrapped in a mystery, inside an enigma but that's my story and I'm stickin' to it. ------------------------------------------------------------------------------ Get 100% visibility into Java/.NET code with AppDynamics Lite! It's a free troubleshooting tool designed for production. Get down to code-level detail for bottlenecks, with <2% overhead. Download for free and get started troubleshooting in minutes. http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
