ARDB & *.csv

I'm trying to tinker with ARDB (to possibly use it for things like storing my own Storyline Cards and my own VTES creations, of which there is a LOT realistically). I'm having issues with the CSV and importing it into ARDB. This is the Log: 11:04:12: Query was: CREATE TABLE Crypt ( name TEXT, type TEXT, clan TEXT, adv TEXT, groupnumber int, capacity int, disciplines TEXT, cardtext TEXT, edition TEXT, title TEXT, banned TEXT, artist TEXT, 11:04:12: SQL error: near " ": syntax error 11:04:12: Query was: CREATE TABLE cards_crypt_unsorted ( card_name INTEGER, clan INTEGER, adv INTEGER, groupnumber INTEGER, capacity INTEGER, disciplines STRING, superior STRING, inferior STRING, title STRING, card_text INTEGER, release_set INTEGER, release_date INTEGER, rarity INTEGER, artist STRING, url STRING, 11:04:12: SQL error: near " ": syntax error 11:04:12: Query was: UPDATE Crypt SET groupnumber = 0 WHERE groupnumber = '*'; 11:04:12: SQL error: no such table: Crypt 11:04:12: Cancelling changes to prevent database corruption Any help?? Retired Baron of Sydney, Australia, 418

I am more than willing to help. I am assuming that you have edited the. Csv. Yourself. The csv uses dual. "" when the csv is created and if you edited then the " seperaters are not there. Also it looks like you've left an entry for crypt groupnumber blank. Contact me here or my email at. ARDB website Dr.

> drstrange26 wrote: > I am assuming that you have edited the. Csv. Yourself. > Nope. The new CSV put together by Pascal is the source of the error. See also: Pascal 02-25-2012

Thanks Adonai. I'll try get a previous edition and edit that one. EDIT: I am getting my problems from vtessets.csv at the moment. Retired Baron of Sydney, Australia, 418

> Juggernaut1981 wrote: > Thanks Adonai. > I'll try get a previous edition and edit that one. > > EDIT: I am getting my problems from vtessets.csv at the moment. > Found the error. I'm updating the csv files. Done. There was an extra " at the end of the first line... Something's still wrong, but I can't find what.