VTES Utilities & The Unaligned

Current status of VTES Tools with regards to The Unaligned Official Cardlist: Open Anarch Revolt Deck Builder (ARDB): unknown (requires official cardlist?) Fragment of Elder Library Database (FELDB): updated with TU Secret Library (SL): Open (requires official cardlist) LackeyCCG: updated with TU Anyone has a status on the above utilities or knows about other tools already updated to TU?

I think ARDB updates from here: www.vekn.net/images/stories/downloads/vtescsv.zip Which doesn't appear to have been updated yet. The Danse Macab Images went up fairly quick last time round: code.google.com/p/ardb/downloads/list by Woodruffr1973? Ke Amaranth Deck Building Tool : VTES NZ : VTES ANZ Facebook

FELD with TU cards and images (filter by set doesn't work yet) www.lackeyccg.com/vtes/FELDB_2.6.3_Syd.zip Updated image pack with all images in hi-res (unzip inside FELD folder) mega.co.nz/#!TpglRZhZ!zTxUZ8zvETOuueZ9erPzAE4_iLtQJheGxogLWr7NIwA Fernando Cesar - Sydnelson LackeyCCG and OCTGN VtES Mantainer Prince of Rio de Janeiro Powerbase Rio de Janeiro

> extrala wrote: > Current status of VTES Tools with regards to The Unaligned Anarch Revolt Deck Builder (ARDB): unknown (requires official cardlist?) > I've quickly made a CSV for The Unaligned: www.veknfrance.com/ARDB/vtescsv%20-%20The%20Unaligned.zip Until the official CSV is ready (use File > Update database from File). Images for ARDB are available here: www.partage-facile.com/TRA2ZFZBH1/tu.zip.html (Thanks to Julien) Prince of Paris, France Ratings Coordinator, Rules Director

OCTGN has not been updated yet. Will it be?

how can I edit the csv file to correct errors? (for example, Omer is listed as having instead of ) I tried editing the vtescrypt.csv file with excel, then notepad, but when I update ARDB it keeps giving me an error.

csv files are uploaded. vekn.net/images/stories/downloads/vtescsv.zip (the date on the card lists page isn't correct, as Ginés is still locking that page :P) Also, the cardlist.txt now includes The Unaligned cards.

> Pascal wrote: > csv files are uploaded. > vekn.net/images/stories/downloads/vtescsv.zip (the date on the card lists page isn't correct, as Ginés is still locking that page :P) > > Also, the cardlist.txt now includes The Unaligned cards. > I tried to update ARDB database, but DB corruption was informed (so db was not updated). I use ARDB 3.1.1 Beta 2 on Windows 8. I'll check if latest ARDB version works on Windows 8. EDIT: Yeah, ARDB 3.2 refuses to update database as well. And, ARDB 3.2 can't be used at all on Windows (8) because you can't open your decks that you have created. ---- Banging trashcans, breaking windows We'll wake you up tonight We like the good time, we scream and shout And that's what fun's about

I'm thinking... ...is there a well formatted XML file available for deck and crypt? JSON formatted file would work fine as well. ---- Banging trashcans, breaking windows We'll wake you up tonight We like the good time, we scream and shout And that's what fun's about

> Jussi wrote: > I'm thinking... > ...is there a well formatted XML file available for deck and crypt? JSON formatted file would work fine as well. > No, there's only a well formatted CSV file. But it shouldn't be difficult to write some tool that does a conversion the way you want. Or open it in Access and export as XML. Prince of Paris, France Ratings Coordinator, Rules Director

> Pascal wrote: > csv files are uploaded. > vekn.net/images/stories/downloads/vtescsv.zip (the date on the card lists page isn't correct, as Ginés is still locking that page :P) > > Also, the cardlist.txt now includes The Unaligned cards. > doesn't work (ARDB 3.1.1 here).

> Ankha wrote: > > > Jussi wrote: > > I'm thinking... > > ...is there a well formatted XML file available for deck and crypt? JSON formatted file would work fine as well. > > > No, there's only a well formatted CSV file. But it shouldn't be difficult to write some tool that does a conversion the way you want. Or open it in Access and export as XML. > I don't have Access, but I'll try to convert CSV file using Excel. Thanks. ---- Banging trashcans, breaking windows We'll wake you up tonight We like the good time, we scream and shout And that's what fun's about

> Jussi wrote: > > > Ankha wrote: > > > > > Jussi wrote: > > > I'm thinking... > > > ...is there a well formatted XML file available for deck and crypt? JSON formatted file would work fine as well. > > > > > No, there's only a well formatted CSV file. But it shouldn't be difficult to write some tool that does a conversion the way you want. Or open it in Access and export as XML. > > > I don't have Access, but I'll try to convert CSV file using Excel. > > Thanks. > Likely, it won't work. Excel doesnt' support correctly the CSV format. Prince of Paris, France Ratings Coordinator, Rules Director

> Drugo wrote: > > > Pascal wrote: > > csv files are uploaded. > > vekn.net/images/stories/downloads/vtescsv.zip (the date on the card lists page isn't correct, as Ginés is still locking that page :P) > > > > Also, the cardlist.txt now includes The Unaligned cards. > > > doesn't work (ARDB 3.1.1 here). > I've fixed the CSV archive. You can download the new version at the same address. Prince of Paris, France Ratings Coordinator, Rules Director

done! nice work, thanks!

after some proofreading... Assamites Wise Frog - should not have Followers of Set Legba - should have instead of Glycon - should have instead of Ravnos Delizbieta of the Dark Eyes - should have instead of Ivan Krenyenko [Adv] - should have instead of and instead of Gangrel Mark Decker - should have instead of General all accented letters now generate random chars (Rosa Hernandez has become Rosa Hernández)

> Ankha wrote: > > > Jussi wrote: > > > > > Ankha wrote: > > > > > > > > > > > > > > > Jussi wrote: > > > > I'm thinking... > > > > ...is there a well formatted XML file available for deck and crypt? JSON formatted file would work fine as well. > > > > > > > No, there's only a well formatted CSV file. But it shouldn't be difficult to write some tool that does a conversion the way you want. Or open it in Access and export as XML. > > > > > > > > I don't have Access, but I'll try to convert CSV file using Excel. > > > > Thanks. > > > Likely, it won't work. Excel doesnt' support correctly the CSV format. > And it didn't. Well, I don't bother to write a csv parser myself. Thanks anyway. ---- Banging trashcans, breaking windows We'll wake you up tonight We like the good time, we scream and shout And that's what fun's about

I already have a csv parser (to generate the cardlist.txt file). Let me know what kind of fields you want in a a.xml

> Pascal wrote: > I already have a csv parser (to generate the cardlist.txt file). > Let me know what kind of fields you want in a a.xml > Ok, I'll post you an initial draft "sometime soon". I don't have much time, but then again it wouldn't be hard to figure out somewhat feasible structure for a simple XML formt. ---- Banging trashcans, breaking windows We'll wake you up tonight We like the good time, we scream and shout And that's what fun's about

I updated the cardlist.txt and the csv files with latest comments.

Pascal, can you generate JSON? (it was faster to figure out json format first) Attachment vtes_crypt_json.txt not found ---- Banging trashcans, breaking windows We'll wake you up tonight We like the good time, we scream and shout And that's what fun's about

Set <=> Artist isn't something we have. Can you include an example of an imbued card? does it have to be 0 for inf and 1 for sup, or could it be 1 for inf and 2 for sup? (and 0 for "doesn't have") should the same file contain both crypt and library cards?

> Pascal wrote: > I updated the cardlist.txt and the csv files with latest comments. > now the disciplines are all "shifted", just 2 letters and a quote. (for example, Legba now is listed as having "PR "SE "TH "ob)

I think Vincent just uploaded something messy ...

Ok, The csv files have been corrected. There are now two versions: www.vekn.net/images/stories/downloads/vtescsv.zip contains the csv in the ANSI encoding, so that ARDB will work. ARDB should be updated though, since ANSI can't encode some characters (such as 'č' as in Zahradníček). I don't know who's maintaining ARDB, but this has to be changed! www.vekn.net/images/stories/downloads/vtescsv_utf8.zip contains the CSV files in UTF-8 encoding. Prince of Paris, France Ratings Coordinator, Rules Director

> Ankha wrote: > Ok, > The csv files have been corrected. There are now two versions: > > www.vekn.net/images/stories/downloads/vtescsv.zip contains the csv in the ANSI encoding, so that ARDB will work. ARDB should be updated though, since ANSI can't encode some characters (such as 'č' as in Zahradníček). I don't know who's maintaining ARDB, but this has to be changed! > > www.vekn.net/images/stories/downloads/vtescsv_utf8.zip contains the CSV files in UTF-8 encoding. > the first file lacks the Unaligned cards, the second is ok but has the characters problem. sadly, I need the first file with the Unaligned cards (otherwise, ARDB don't recognize all vampires with strange characters like Zoe in all my decks)

> Pascal wrote: > Set <=> Artist isn't something we have > That's ok, then a list of set+rarity is sufficient enough (I'll update example file). > Can you include an example of an imbued card? > Yes, but not right away (I need to go fetch a kid from nanny) > does it have to be 0 for inf and 1 for sup, or could it be 1 for inf and 2 for sup? (and 0 for "doesn't have") > 0 for none, 1 for inf and 2 for sup is ok. > should the same file contain both crypt and library cards? > I would prefer two separate files, until I know for sure how large they are going to be. Of example file: There may be a syntax error in property naming (did json require double quotes in property names?). I need to check that when I'm able. And Thanks man! I appreciate your effort! ---- Banging trashcans, breaking windows We'll wake you up tonight We like the good time, we scream and shout And that's what fun's about

Gramle's "loader" sucks the CSV files into a mongodb database. Jussi if you want a "dump" of this to JSON, I could give it to you (although it doesn't exactly follow your format; I'll explain on IRC). The long-term plan for Gramle, once upon a time, was to expose a public JSON/Mongo API for querying searches rather than just my little-used IRC bot. I don't know if that's ever going to happen in reality, though. (And there are still some types of queries that have always been buggy and I never got around to fixing)

Ok, this should be the last technical update. The "old standard" csv files archive is here: www.vekn.net/images/stories/downloads/vtescsv.zip PLEASE DO NOT USE IT ANYMORE! It's only here for backward compatibility purpose (eg. so that ARDB can still work) but you should use instead: www.vekn.net/images/stories/downloads/vtescsv_utf8.zip This archive contains the csv files encoded in UTF-8 (without BOM) with UNIX-style EOL, double quotes (") as delimiters and comma (,) as separator. Prince of Paris, France Ratings Coordinator, Rules Director

I had passed this note to Pascal over email but it looks like it didn't make it to you before the "last technical update" version at 8:38: Imanna is still missing her "1 vote" title from the title column (just after the rarity column). I've also been compiling some "templating" questions, most of which I've already gotten answers to. The latest is: In older expansions, the text of Advanced vampires would start with the word "Advanced, " followed by the text. In The Unaligned, this leading word "Advanced, " is missing. Is that deliberate? It does affect the way my IRC bot displays information about Advanced vampires. If the word is officially absent (as it seems to be in the PDF versions of the vamps) then I will have to update my bot to display the word in another way. Thanks!

> jozxyqk wrote: > I had passed this note to Pascal over email but it looks like it didn't make it to you before the "last technical update" version at 8:38: Imanna is still missing her "1 vote" title from the title column (just after the rarity column). > Yes, but this is not technical File contents will probably be updated from time to time. > jozxyqk wrote: > I've also been compiling some "templating" questions, most of which I've already gotten answers to. > The latest is: > In older expansions, the text of Advanced vampires would start with the word "Advanced, " followed by the text. > In The Unaligned, this leading word "Advanced, " is missing. Is that deliberate? > It does affect the way my IRC bot displays information about Advanced vampires. If the word is officially absent (as it seems to be in the PDF versions of the vamps) then I will have to update my bot to display the word in another way. > Yes, it is deliberate. You should rely on the value in the "Adv" column (either empty for base version, or containing "Advanced" for advanced version). Prince of Paris, France Ratings Coordinator, Rules Director

> jozxyqk wrote: > Gramle's "loader" sucks the CSV files into a mongodb database. > Jussi if you want a "dump" of this to JSON, I could give it to you (although it doesn't exactly follow your format; I'll explain on IRC). > Thanks for the offer! I'm not sure if I want to use BSON, but you can post me the dump anyway so I can inspect it. I'll PM my email. I'm not currently using IRC, but if my hobby project is ever going to happen I'm sure that I'll begin to hang around there. > jozxyqk wrote: > The long-term plan for Gramle, once upon a time, was to expose a public JSON/Mongo API for querying searches rather than just my little-used IRC bot. > I don't know if that's ever going to happen in reality, though. > (And there are still some types of queries that have always been buggy and I never got around to fixing) > This sounds interesting. Since I have a plan to write a little deck design application using Qt5, I would be interested in having a good place to download latest card texts for local data storage. The plan, as it goes, is nothing but a plan. Currently I'm researching possibilities to acquire card data. ---- Banging trashcans, breaking windows We'll wake you up tonight We like the good time, we scream and shout And that's what fun's about

> Ankha wrote: > Ok, this should be the last technical update. > > The "old standard" csv files archive is here: www.vekn.net/images/stories/downloads/vtescsv.zip > > PLEASE DO NOT USE IT ANYMORE! It's only here for backward compatibility purpose (eg. so that ARDB can still work) but you should use instead: > > www.vekn.net/images/stories/downloads/vtescsv_utf8.zip > > This archive contains the csv files encoded in UTF-8 (without BOM) with UNIX-style EOL, double quotes (") as delimiters and comma (,) as separator. > Hey, this new csv has much better formalization as the old one! Thank you for that! ---- Banging trashcans, breaking windows We'll wake you up tonight We like the good time, we scream and shout And that's what fun's about

> Jussi wrote: > > > Ankha wrote: > > Ok, this should be the last technical update. > > > > The "old standard" csv files archive is here: www.vekn.net/images/stories/downloads/vtescsv.zip > > > > PLEASE DO NOT USE IT ANYMORE! It's only here for backward compatibility purpose (eg. so that ARDB can still work) but you should use instead: > > > > www.vekn.net/images/stories/downloads/vtescsv_utf8.zip > > > > This archive contains the csv files encoded in UTF-8 (without BOM) with UNIX-style EOL, double quotes (") as delimiters and comma (,) as separator. > > > Hey, this new csv has much better formalization as the old one! > > Thank you for that! > still, no Unaligned cards in the "old standard" csv file...

> Ankha wrote: > PLEASE DO NOT USE IT ANYMORE! It's only here for backward compatibility purpose (eg. so that ARDB can still work) but you should use instead: > > www.vekn.net/images/stories/downloads/vtescsv_utf8.zip > > This archive contains the csv files encoded in UTF-8 (without BOM) with UNIX-style EOL, double quotes (") as delimiters and comma (,) as separator. > So, for the less-than-computer-geeky amongst us... ARDB is 'old school' and shouldn't use the UTF8 file? Or ARDB is UTF8 functional and it should be all good? Retired Baron of Sydney, Australia, 418

> Drugo wrote: > > > Jussi wrote: > > > > > Ankha wrote: > > > Ok, this should be the last technical update. > > > > > > The "old standard" csv files archive is here: www.vekn.net/images/stories/downloads/vtescsv.zip > > > > > > color=#00ffff]still, no Unaligned cards in the "old standard" csv file...[/color] > > > > > You're wrong, they are present in the link provided (I checked again at this moment.) > > > > > Juggernaut1981 wrote: > > > > > > > > > > > > > > > Ankha wrote: > > > > PLEASE DO NOT USE IT ANYMORE! It's only here for backward compatibility purpose (eg. so that ARDB can still work) but you should use instead: > > > > > > > > www.vekn.net/images/stories/downloads/vtescsv_utf8.zip > > > > > > > > This archive contains the csv files encoded in UTF-8 (without BOM) with UNIX-style EOL, double quotes (") as delimiters and comma (,) as separator. > > > > > > > So, for the less-than-computer-geeky amongst us... > > > ARDB is 'old school' and shouldn't use the UTF8 file? Or ARDB is UTF8 functional and it should be all good? > > > > > ARDB (and all other softwares/websites relying on the csv file) should evolve to support the UTF-8 files, which is not currently the case. > > Prince of Paris, France Ratings Coordinator, Rules Director

Actually, the cardlist.txt which is noted to have TU cards doesn't seems to have any : vekn.net/images/stories/downloads/cardlist.txt

> Timo wrote: > Actually, the cardlist.txt which is noted to have TU cards doesn't seems to have any : > > vekn.net/images/stories/downloads/cardlist.txt > this file seems ok to me (TU cards are present)

OK, the old one was in my firefox cache and now that I have emptied it, I have he new file.

> Timo wrote: > OK, the old one was in my firefox cache and now that I have emptied it, I have he new file. > This is probably why Drugo don't see the correct files too. Prince of Paris, France Ratings Coordinator, Rules Director

> Ankha wrote: > > > Timo wrote: > > OK, the old one was in my firefox cache and now that I have emptied it, I have he new file. > > > This is probably why Drugo don't see the correct files too. > I don't know... I keep downloading it (from different browsers too) and always found the same file (the one without TU).

> Drugo wrote: > > > Ankha wrote: > > > > > Timo wrote: > > > OK, the old one was in my firefox cache and now that I have emptied it, I have he new file. > > > > > This is probably why Drugo don't see the correct files too. > > > I don't know... I keep downloading it (from different browsers too) and always found the same file (the one without TU). > Please try again by emptying your navigator cache first, and if it still doesn't work, please post the link you're using (I'm not exactly sure what file you're talking about). Prince of Paris, France Ratings Coordinator, Rules Director

Done! in the end i tried from another computer and now the file is correct! many thanks for the patience

vtescsv_utf8.zip updated with Imanna's title now appearing in the "title" column

Any update on when The Unaligned set will be added to secret library?

Is there a zipped version of this file that can be easily imported (along with previous expansions) into ARDB?

> XZealot wrote: > Is there a zipped version of this file that can be easily imported (along with previous expansions) into ARDB? > Do you mean Card Lists (in csv format, ANSI) for ARDB in the Card list section ? Prince of Paris, France Ratings Coordinator, Rules Director