git.rot13.org Git - webpac/blob - import_xml/excel.xml

   1 <?xml version="1.0" encoding="ISO-8859-2"?>
   2 <!--
   3         parametars for M$ Excel import from spreadsheet
   4
   5         column letters must be in UPPER CASE
   6         end_row configuration option is optional, but you should use it,
   7                 because it will use Excel MaxRow property which is
   8                 often set at 31999
   9 -->
  10 <config
  11         excel_codepage="windows-1250"
  12         sheet="Sheet1"
  13         start_row="2"
  14         end_row="500"
  15 >
  16
  17 <!--
  18         <isis type="swish|display|index">_pre_000x_sep_000x_sep_000x_post_</isis>
  19 -->
  20     <indexer>
  21         <headline>
  22                 <column type="display">|A|</column>
  23                 <config>
  24                         <delimiter> ---> </delimiter>
  25                         <value>materialtype</value>
  26                 </config>
  27                 <config>
  28                         <delimiter> u knji¾nici: </delimiter>
  29                         <value>library</value>
  30                 </config>
  31
  32         </headline>
  33
  34         <IdentificationNumbers name="ISN">
  35                 <column type="swish" filter="isn_swish">|B|</column>
  36                 <column type="index">|B|</column>
  37         </IdentificationNumbers>
  38
  39         <ISSN name="ISSN: " order="11">
  40                 <column type="display">|B|</column>
  41         </ISSN>
  42
  43         <TitleAndResponsibility name="Naslov: " order="20">
  44                 <column>|A|</column>
  45                 <column type="index">|A|</column>
  46         </TitleAndResponsibility>
  47
  48         <library name="Knji¾nica: " order="85">
  49                 <column>|C|</column>
  50         </library>
  51
  52         <type name="Vrsta graðe: " type="display" order="100">
  53                 <!-- added via xml tag in .conf -->
  54                 <config>materialtype</config>
  55         </type>
  56
  57
  58     </indexer>
  59 </config>