1

(150 replies, posted in Site Discussion)

Jorn86 wrote:
Russb87 wrote:

Ok... So I was thinking (this is dangerous stuff, I know). A nice feature would be to allow the users some sort of SQL interface to run custom queries (just basic select statements with "where" clauses and maybe some joins). This is assuming you are using a SQL database of some sort. Honestly, I'm more comfortable running a SQL query than I am using the existing filter system when I am searching for something.

You can do that using magiccards.info/search.html

I love that site but I meant more like actual select and join statements. Can you do that there? I didn't see anything where I could do that from there. I know that this is something that would be difficult to implement from a security standpoint but to get rather specific sets of data it would be nice.

Actually... Thinking about it I'm not sure that it can be practically implemented, we don't know the table names, we don't know the real column names, and we don't know the table schema(s). NVM, I guess it was one of those floating thoughts that I should have tossed away.

2

(150 replies, posted in Site Discussion)

Ok... So I was thinking (this is dangerous stuff, I know). A nice feature would be to allow the users some sort of SQL interface to run custom queries (just basic select statements with "where" clauses and maybe some joins). This is assuming you are using a SQL database of some sort. Honestly, I'm more comfortable running a SQL query than I am using the existing filter system when I am searching for something.

I know I can export to excel and then load it into my own database and do the same thing but that requires me to update my database every time I update deckbox (which I have a script to do now anyway).

Also, I noticed that if I export after I filter it still exports my whole inventory.

3

(150 replies, posted in Site Discussion)

MMJuno wrote:
Russb87 wrote:

First thing, since this is my first post on here, I want to say that this is an amazing tool and you have done an excellent job putting it together.

Feature suggestion:
When I (as well as some of my friends) buy a prebuilt deck we copy and paste the card list from the MTG site into the bulk uploader. The hurdle that we face with this is that it's difficult to enter the edition and other information for these cards because we then need to go find all the cards and modify them one-by-one (this is especially painful when we have duplicates that we have already done this for). What we would like to see is an option in the bulk uploader to set all of the cards to a specific edition, condition, etc.

In the meantime, if you do the bulk uploader, you should then be able to sort your inventory by date added to at least get the rows modified/added at the top of the list. You'll still have to do the details manually, but thought I'd mention that, in case you're not aware.

Yea, that's how we have been doing it. Thanks for the tip though.

4

(150 replies, posted in Site Discussion)

First thing, since this is my first post on here, I want to say that this is an amazing tool and you have done an excellent job putting it together.

Feature suggestion:
When I (as well as some of my friends) buy a prebuilt deck we copy and paste the card list from the MTG site into the bulk uploader. The hurdle that we face with this is that it's difficult to enter the edition and other information for these cards because we then need to go find all the cards and modify them one-by-one (this is especially painful when we have duplicates that we have already done this for). What we would like to see is an option in the bulk uploader to set all of the cards to a specific edition, condition, etc.