SobekCM Repository Community Help | |
Project Home | User Help | Technical Help | Download Center | Code Details | mySobek Home |
SMaRT Tool : Import from a SpreadsheetOverviewBatch processing allows the data from a spreadsheet or comma-seperated value (CSV) file to create METS files. The top row (or line) of each input file must be a header row which contains the names of each column. These columns should be named in english if possible, as the mappings often may be auto-generated in this case. The processor will step through each of the remaining rows (or lines) in the input files and will perform the following two tasks:
This import process is very similar to the spreadsheet batch process included in the SobekCM METS Editor, except you do not need to provide the next SobekCM system identifier, since it can be provided directly from the database. In addition, the METS files are immediately placed into the incoming queue for the system (specified in your system-wide settings). If you have not specified the 'Main Incoming Folder' in your system-wide settings through the web application, you will not be able to perform importing here. Process InstructionsOnce the option to import from a spreadsheet has been selected, the Spreadsheet Import form will launch:
Select either an excel spreadsheet or a CSV file as the input file. Then, you will be prompted to select the worksheet within the workbook to import. If you selected a CSV file, there will only be one sheet (named 'Sheet 1') which you must select. Once you select the sheet, the column names will be read from the first row in the input file, and any automatic mappings will be applied.
You will want to verify the mappings and correct any mappings which were incorrect. You may also enter up to eight constants from the second tab under step 3.
If you do not have any column mapped to Material Type, you will need to select a value from the drop down. Press the EXECUTE button once you are ready to proceed. Process DescriptionOnce the process is initiated, the processor will step through each row in your input file and perform the following steps:
Since most of your defaults are not included in the resulting metadata files, you will want to include these values in your input file. Once complete, some very simple information will be displayed in the results form, including the newly assigned Bibliographic Identifier (BibID) and Volume ID (VID) which combine to form the METS ObjectID's.
If your input file was an excel spreadsheet, a new worksheet named OUTPUT will be added to the workbook, which includes all the original fields as well as two new columns with the new BibID and VIDs.
Preview ModeThe process can also be run in preview mode. This mode performs all the same operations that would be performed in a full process, without doing the actual adding to the database or adding the METS files into the system inbound folder. It does look for de-duping and will alert you if you are updating an existing record or adding a new record. In addition, the output METS can then be found in a \SMaRT\Temporary directory under your documents folder. Related LinksAdditional help is available on the following topics: |