file ARDB & *.csv

09 Mar 2012 23:11 #25462 by Juggernaut1981
ARDB & *.csv was created by Juggernaut1981
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??

:bruj::CEL::POT::PRE::tha: Baron of Sydney, Australia, 418
The following user(s) said Thank You: david.tatu

Please Log in or Create an account to join the conversation.

More
10 Mar 2012 10:21 #25486 by drstrange26
Replied by drstrange26 on topic Re: ARDB & *.csv
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.

Please Log in or Create an account to join the conversation.

More
10 Mar 2012 12:56 #25502 by Adonai
Replied by Adonai on topic Re: ARDB & *.csv

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

Please Log in or Create an account to join the conversation.

More
10 Mar 2012 20:57 - 10 Mar 2012 21:13 #25543 by Juggernaut1981
Replied by Juggernaut1981 on topic Re: ARDB & *.csv
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.

:bruj::CEL::POT::PRE::tha: Baron of Sydney, Australia, 418
Last edit: 10 Mar 2012 21:13 by Juggernaut1981.

Please Log in or Create an account to join the conversation.

More
27 Mar 2012 06:56 - 27 Mar 2012 07:17 #26664 by Pascal Bertrand
Replied by Pascal Bertrand on topic Re: ARDB & *.csv

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.
Last edit: 27 Mar 2012 07:17 by Pascal Bertrand.

Please Log in or Create an account to join the conversation.

More
Moderators: AnkhaKraus
Time to create page: 0.079 seconds
Powered by Kunena Forum