ARDB ERROR

Can somebody help me? I tried to update the ARDB database to see if it would grab the hunter data but I got this message instead. Table has 13 columns but 14 values were supplied

It did this when Lob came out dude, It comes from the addition of disciplines, or in this case powers. Last time it took about a week to fix up, but i'm sure it will be fixed. PS: Mr G, thanks for the work on ARDB, I think its the best deck builder out there.

Unfortunatly François said he would stop updating it since LOB. So unless someone else tries to work on it there won't be any update of ARDB.

[ quoted text not captured ] Thats a real shame. Can't blame the guy, he's done it out of love for the game for quite a while now so Kudos to him for doing so. If anyone was prepared to show me the coding and teach me how to update it properly I sure would. The ARDB has been responsible for most of my deck construction since I started playing V:Tes and it would be a shame to see it go away. If anyone has the code and the "know how" to make it work, let me know, I'm happy to continue it in Francois' name as long as someone would tell me how to do it. Merci Francois, for all your work Viva La ARDB!! (apologies now for screwing up the language, Thanks alot for your work) Long live the ARDB!! Sutekh_23

You have all you need here : http://wiki.vekn.org/index.php/Anarch_Revolt_Deck_Builder Francois also created a mailing list here : http://lists.nongnu.org/mailman/listinfo/anarchdb-devel Not sure that it still works though.

[ quoted text not captured ] Open the CSV file in MS Excel or whatever, find the column that is new (the labels should provide a clue) and delete it (or merge it with another suitable column, if that's your thing). Then ARDB can import it.

"XZealot" <xze...@cox.net> wrote in message news:1145407054....@i40g2000cwc.googlegroups.com... > Can somebody help me? I tried to update the ARDB database to see if it > would grab the hunter data but I got this message instead. > > Table has 13 columns but 14 values were supplied > Since Francois doesn't update ARDB any more you could try Fragment of the Elder Library Deck Builder (FELDB). You can get it here: http://web.interware.hu/bala0/feldb.htm Bala updated it for NOB around WEdnesday last week. I tried both the ARDB and the FELDB and I liked the FELDB better. The big plus is the inventory feature. Over the last few versions Bala added some nice features: So in the mean time FELDB is a lot better than ELDB ever was. Note that the latest version still has some minor bugs. The plan was to release the NOB edition fast and to correct the bugs later on. See also: http://groups.google.com/group/rec.games.trading-cards.jyhad/browse_thread/thread/749c5fee7597eafb/1866eb1567afc8d4?hl=en#1866eb1567afc8d4 -- regards pallando --------------------- pallando(at)gmx(dot)at

pallando wrote: <snip> > Since Francois doesn't update ARDB any more you could try Fragment of the > Elder Library Deck Builder (FELDB) ...which however doesn't have a Mac version. Grmbpwlll... :-((( I really hope someone will take care of the ARDB! Emiliano

[ quoted text not captured ] > pallando Does the new version of FELDB already gained the online database updater tool? Because if it doesn't have any, even if the software can cook, fly and pay my taxes, I still won't use it alone if I can get any version of ARDB around too. FELDB's database has too many errors yet, specially regarding Rarity and card text. ARDB has no such problem since it updates its database from the official one at WW's website. Of course, if ARDB doesn't get a new version to account for the new column added for NoR, we'll never be able to update it, but still, its database is accurate on all sets released before, so I'll never abandon it until Bala fixes either the database for good or adds an online updater tool. I appreciate Bala's efforts on making FELDB the best software overall (which it is), I really do. But these database errors are a major problem, and newbies shouldn't download it without knowing that they simply can't use FELDB to check for card texts and rarity indicators. Fabio "Sooner" Macedo

Hi, If someone has made a working vtescsv.zip this way could he please send it to me as a email. Since I have the german excel version he uses ; instead of , as capacitator in the files and can't save them back right too :( my email adress would be xc...@gmx.net. thx xcver

[ quoted text not captured ] We, the ARDB development team, are currently working on a new version. This has been slower than we would have hoped due to real life concerns for those involved. Please have patience, we hope to have something for you soon.

[ quoted text not captured ] Is there an "ARDB development team"? Wow, that's very good news!!! You have all my gratitude! Now becoming a little more egoistic, is mantaining a Mac version part of the commitment of the development team? Ciao, Emiliano

Emiliano Imeroni wrote: > Karl Schaefer wrote: > > XZealot wrote: > > > Can somebody help me? I tried to update the ARDB database to see if it > > > would grab the hunter data but I got this message instead. > > > > > > Table has 13 columns but 14 values were supplied > > We, the ARDB development team, are currently working on a new version. > > This has been slower than we would have hoped due to real life concerns > > for those involved. Please have patience, we hope to have something > > for you soon. > > Is there an "ARDB development team"? > Wow, that's very good news!!! You have all my gratitude! Yes. The number of active members of that team is in question, but there is a team. > Now becoming a little more egoistic, is mantaining a Mac > version part of the commitment of the development team? OS X support is a goal. I know Francois is concerned about it and he still helps out. For those of you interested, we can use more help. See the ARDB development site: https://savannah.nongnu.org/projects/anarchdb

[ quoted text not captured ] Good call. But I'm tryng that right now and I've noticed one thing: somehow the .csv file has line breaks (or something that Excel interprets as such) before all [MERGED] tags. This makes all the values after those tags appear in a subsequent line when the data is imported to Excel. So I see something line this (using commas to indicate column separation): Line N: Alan Sovereign, Vampire, Ventrue etc. etc. Line N+1: [MERGED] (Alan's Merged Text), etc. etc. I had to open the .csv file in Notepad and get rid of those line breaks marks. Also, the new column is crypt card type, right? I think we can live without it for a while ;) Wait. Now that I checked the library file, I noticed it has tons of line breaks inside some columns' content. It comes before [] tags, after some periods into card text, and other cases. It's a dauting task to find all of them without merging the contents of one line with another. Of course, these seem to be usual line breaks you find in card texts (after things such as "+1 stealth action.", per example), but anyone has a clue how I can make Excel ignore these if they appear into text delimitator? ("") Fabio "Sooner" Macedo

Fabio 'Sooner' Macedo schrieb: [ quoted text not captured ] Hi I had exactly the same problems and couldn't get it to work :(

Fabio 'Sooner' Macedo wrote: > LSJ wrote: > > XZealot wrote: > > > Can somebody help me? I tried to update the ARDB database to see if it > > > would grab the hunter data but I got this message instead. > > > > > > Table has 13 columns but 14 values were supplied > > > > Open the CSV file in MS Excel or whatever, find the column that is new > > (the labels should provide a clue) and delete it (or merge it with > > another suitable column, if that's your thing). > > Then ARDB can import it. > > Good call. But I'm tryng that right now and I've noticed one thing: > somehow the .csv file has line breaks (or something that Excel > interprets as such) before all [MERGED] tags. [...] > Wait. Now that I checked the library file, I noticed it has tons of > line breaks inside some columns' content. It comes before [] tags, > after some periods into card text, and other cases. It's a dauting task > to find all of them without merging the contents of one line with > another. Of course, these seem to be usual line breaks you find in card > texts (after things such as "+1 stealth action.", per example), but > anyone has a clue how I can make Excel ignore these if they appear into > text delimitator? ("") Yes. There are many linebreaks embedded in text fields. Such text field are wrapped with quotes, per standard .csv conventions. Excel should handle these appropriately. Recent versions of Excel (Windows Excel 2000 or Mac Excel 2004) do, at any rate. If your csv reader doesn't rise to the occassion, you could try editing it by hand, but you'll probably need something stronger than Notepad. In vi, open the .csv and join every line that doesn't begin with a double quote to the previous line with the following command (just start typing -- when you press the colon, the colon-prompt will appear at the bottom of the screen, allowing you to enter the rest of the command). :g/^[^"]/.-1j (Note that the header line will be spared, even though it doesn't begin with a quote, since there is no previous line). Then save the file and exit vi by typing :x You can get vim (a vi clone) for windows and other platforms here: http://www.vim.org/download.php Or you can try using MS Word: First replace all paragraph marks with manual line breaks: Search for: ^p Replace with: ^l [Replace All] Then check the "Use wildcards" box in the search-and-replace extended dialog and replace the manula line breaks with spaces if the line that follows doesn't begin with a quote: Search for: ^l([!"]) Replace with: <spacebar>\1 [Replace all] NOTE: Use a space before the \1. Then save the document as text.