<HTML dir=ltr><HEAD>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.2900.2995" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#000000 size=2>First, I love the interface of Kexi. </FONT></DIV>
<DIV><FONT face=Arial color=#000000 size=2>Second, I enjoyed setting up a new kexi database up to the point where feature issues stopped me.</FONT></DIV>
<DIV><FONT face=Arial size=2>Third, I don't code C but could help with doc and the wiki migration (i'll come back to that later). We (mankind) really need a good open source db manager app.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have used foxpro, dataease, pervasive, ms-access, MS-SQL manager and more; I am not a full time database guy.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Short version: is there a roadmap, etc. regarding importing?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>That is the feature that is holding me back, as I need to train a non-technical user to import a database we buy on a bi-weekly schedule. In particular:</FONT></DIV>
<DIV><FONT face=Arial size=2>1) appending to an existing table would solve all my issues.</FONT></DIV>
<DIV><FONT face=Arial size=2>2) currently the import assumes the field type and is guessing incorrectly (changing my data).</FONT></DIV>
<DIV><FONT face=Arial size=2> I have a CSV line like: </FONT></DIV>
<DIV><FONT face="Courier New" size=1>2006,20,"042639","MRK29","Scanda-Lash Hook Up Mascara","Winegloss",,-1,-1,0,$5.00,$5.00,"R",0,"N"</FONT></DIV>
<DIV><FONT face=Arial size=2>Kexi makes the third field a number, stripping the leading zero(s) from the SKU.</FONT></DIV>
<DIV><FONT face=Arial size=2>3) I originally had the field separator as the pipe character, or "|" but couldn't specify it on the import. used a text editor to search/replace the pipe to a comma.</FONT></DIV>
<DIV><FONT face=Arial size=2>4) She would be running windows so the CopyCenter python script is out (right?).</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>So she cannot use Kexi to get the data into a table it seems. I dual boots SuSE but this tool is suppose to free *me* to do other things. :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Any suggestions?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Great work, will lurk on the list for a while. </FONT></DIV>
<DIV><FONT face=Arial size=2>John Fields</FONT></DIV>
<DIV><FONT face=Arial size=2>Dallas, TX USA</FONT></DIV></BODY></HTML>