Hi Andreas<div>Yes, creation of new database from CSV files works perfectly - I overlooked the Parsing tab.</div><div><br></div><div>However - is there some easy way to mix imported formats in one database?</div><div><br></div>
<div>I would think of scenario like</div><div><ol><li>create database using XML data</li><li>add more documents, if needed, use CSV format (so parser shall be changed)</li><li>later add other XML (parser shall be probably changed back)</li>
</ol><div>Menu command &quot;Database - Add documents&quot; does not offer an option to change parser. I tested new database based on CSV parser and later added XML document. XML document was parsed using CSV parser, what was not what I needed (but was quite logical).</div>
<div>Of course I can use workaround to import CSV always into separate database and then either query with explicit database name for CSV data, or export imported CSV as XML and import into main &quot;XML parser based&quot; database.</div>
<div><br></div><div>Is there any way to switch parser in existing database?</div><div><br></div><div>Jan</div><div><br></div><div>PS: Be sure, that availability of any CSV import (the same will apply to text and html) is great service as is.</div>
<div><br></div><div><br></div><br><div class="gmail_quote">2011/1/18 Andreas Weiler <span dir="ltr">&lt;<a href="mailto:andreas.weiler@uni-konstanz.de">andreas.weiler@uni-konstanz.de</a>&gt;</span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">


  
    
  
  <div bgcolor="#ffffff" text="#000000">
    Hi Jan,<br>
    <br>
    i just tried it and it worked for me.<br>
    I did use the GUI and changed in the parsing tab to csv.<br>
    My csv has no header and i used semicolons.<br>
    <br>
    Kind regards,<br>
    Andreas<br>
    <br>
    Am 18.01.11 11:57, schrieb Jan Vlčinský (CAD):
    <blockquote type="cite"><div><div></div><div class="h5">Hi
      <div><b><u>BaseX 6.5 incl. rewritten web site is impressive</u></b>.
        Really.</div>
      <div><br>
      </div>
      <div>I go through it feature by feature and test it.</div>
      <div>Trying to import CSV file I have a problem</div>
      <div><br>
      </div>
      <div>
        <ol>
          <li>Creation of new database from xsv file or directory does
            not work (using default options, no changes)<br>
            Reports &quot;Line 1: Content is not allowed in prolog&quot;</li>
          <li>Adding document by Database - Add documents results in the
            same message</li>
          <li>Trying to SET PARSER CSV<br>
            did not change anything</li>
          <li>Trying to add header with field names into imported file
            does not help</li>
        </ol>
        <div>Questions</div>
        <div>
          <ol>
            <li>How to import CSV fle</li>
            <li>What CSV format is expected</li>
            <ol>
              <li>tab, coma, semicolon?</li>
              <li>header with field name allowed/expected?</li>
            </ol>
          </ol>
          <div>With best regards</div>
        </div>
        <div><br>
        </div>
        <div>Jan</div>
        <div><br>
        </div>
      </div>
      </div></div><pre><fieldset></fieldset>
_______________________________________________
BaseX-Talk mailing list
<a href="mailto:BaseX-Talk@mailman.uni-konstanz.de" target="_blank">BaseX-Talk@mailman.uni-konstanz.de</a>
<a href="https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk" target="_blank">https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk</a>
</pre>
    </blockquote>
    <br>
    <br>
    <pre cols="72">-- 

Andreas Weiler
Database &amp; Information Systems Group, U Konstanz
Room E 209, 0049 7531 88 4449 (phone) 3577 (fax)
University of Konstanz</pre>
  </div>

</blockquote></div><br><br clear="all"><br>-- <br><div name="sig_b0a60a250d" style="margin-top:2em;margin-right:0pt;margin-bottom:2em;margin-left:0pt"><b>Ing. Jan Vlčinský</b><br><small>
CAD programy<br>
Slunečnicová 338/3,  734 01 Karviná Ráj, Czech Republic<br>
tel: +420-597 602 024;
mob: +420-608 979 040<br>
skype: janvlcinsky;
GoogleTalk: <a href="mailto:jan.vlcinsky@gmail.com" target="_blank">jan.vlcinsky@gmail.com</a><br>
<a href="http://cz.linkedin.com/in/vlcinsky" target="_blank">http://cz.linkedin.com/in/vlcinsky</a>
</small></div><br>
</div>