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??

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.

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.