1 Reply by t3chnomanc3r

(150 replies, posted in Site Discussion)

Yeah, not the most helpful thing for me to track what I want to get rid of as part of my actual collection IMHO. Still the issue of not being able to import edition, condition, foil, etc... also defeats this being viable same as it does for just importing all the hard work you exported back into inventory.

Sadly can't even kludge a workable solution of separating my trades from main collection by creating a new account because I will still have to manually set at least edition, foil, & condition on the import. Seems limited import functionality is defacto with every collection manager site & app (android) I've looked at.


Frank wrote:

hey,

easiest way is to view your tradelist as "print" and then copy & paste that wall of text to an save location. now you can delete your whole inventory and re-import the whole list as your tradelist. that way, you get the cards tradeable and in your inventory.

had to do that as well when i started out wink

Go to forum: Site Discussion

2 Reply by t3chnomanc3r

(8 replies, posted in Reddit MTG Trades)

That's just an  ebay seller looking to cash in at any price to make happy sales & boost their ratings. Still $36 is kind of insulting when looking at 2 main pricing sites where basically 4x $12 + free ship is best price:

http://store.tcgplayer.com/magic/Produc … rupt+decay
http://www.cardshark.com/Magic-the-Gath … tion/34158

Sorry, no interest here at $44 (very fair price IMHO) either as I got my own among others to put up for sale when I finish inventorying all the Ravnica boosters I cracked this week.

iamsolipsism wrote:

http://item.mobileweb.ebay.com/viewitem … 5626166499

http://item.mobileweb.ebay.com/viewitem … 5626166499

http://item.mobileweb.ebay.com/viewitem … 5626166499

http://item.mobileweb.ebay.com/viewitem … 6173273170


sorry for the mobile links; im on a iphone.

Go to forum: Reddit MTG Trades

3 Reply by t3chnomanc3r

(11 replies, posted in Site Discussion)

maybe this thread should be closed? I can always raise the other issues again later if the next update still has them.

Go to forum: Site Discussion

4 Reply by t3chnomanc3r

(11 replies, posted in Site Discussion)

Looking again I see I missed something reading the output when I posted originally and used short circuit logic vetting the issue's validity. There is in fact no issue (other than my blindness), it was that one basic land of different condition in the Mercadian edition tripped me up thinking somehow Subterranean Hanger was be listed as a generic basic land in the exports. Any rate, just did an export with Details + Type and quick look over says it's accurate so I'll shy back to lurk mode with a red face! sad

sebi wrote:

Hello t3chnomanc3r, sorry for the delay in looking at this issue.

In your inventory csv export there is indeed a Mercadian Masques Mint condition Swamp, but that is correct, as you have it listed as such in your inventory.

1 Subterranean hangar is also present in your inventory, with mercadian masks listed as edition, and is also present in the export.

Can you please clarify why you think the csv is not correct?

Go to forum: Site Discussion

5 Reply by t3chnomanc3r

(11 replies, posted in Site Discussion)

OK, guess PM me when the other fixes happen if you can.

Meanwhile let me add this cosmetic error to the stack: choosing no columns options from Dropdown menu results in string "u" rather than "Columns" or some other descriptive text.


      <div id="columns_container" class="_button_container">
        <div id="columns_button" class="_button _dropdown"><span>u</span></div>
      </div>
      <script type="text/javascript">
          var _d_c = new DropdownMulti([["Type","t"],["Cost","c"],["Power","p"],["Toughness","o"],["Last Added","l"],["Edition","e"],["Price","i"]], {
              id: 'filter_values_columns', persistent: false,
              applyBtnTxt: 'Apply', onApply: function() { Tcg.set.setColumns(_d_c.selectedValues.values()); },
              button: { id: 'columns_button' },
              initial: ["u","n","a","r"]
          });
      </script>

Go to forum: Site Discussion

6 Reply by t3chnomanc3r

(11 replies, posted in Site Discussion)

Additional note:

Filter by Edition shows "2013" twice in the drop down list, also shows as selected twice after "applying" filter.

Go to forum: Site Discussion

7 Reply by t3chnomanc3r

(2 replies, posted in Site Discussion)

Good to know, I could not force it when I wrote my question but have since seen https flash by quickly during login.

Go to forum: Site Discussion

8 Reply by t3chnomanc3r

(150 replies, posted in Site Discussion)

No one in their right mind is going to give you programmatic level access to their SQL engine, too much risk for exploits.

Russb87 wrote:

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.

Go to forum: Site Discussion

9 Reply by t3chnomanc3r

(150 replies, posted in Site Discussion)

--->

gmabber wrote:

http://ajfek.pl/mlc-banner.gif

LOL, like we android users have had for awhile now (with even more features)? Seems to make sense to join up and do a port rather than reinvent the wheel. Maybe you could even bring an inventory feature to the project? wink

https://code.google.com/p/mtg-familiar/

Go to forum: Site Discussion

10 Reply by t3chnomanc3r

(11 replies, posted in Site Discussion)

Follow up details:

For no Column I get:

1    Subterranean Hangar

Add "Edition" Column:

1    Subterranean Hangar    Mercadian Masques

Lastly Add Edition + "Type" get:

1    Swamp    Mercadian Masques    Basic Land  - Swamp

So what are you doing differently in the 3rd to result in a different card name? seems to me these queries build on one another thus would be one chunk of code with conditional adds for extra parameters but clearly these are 3 distinct, separate code chunks to get these results.

Go to forum: Site Discussion

11 Topic by t3chnomanc3r

(11 replies, posted in Site Discussion)

It took me all week to to input inventory and now I am exporting to backup my labor (to a degree). Problem is that the export is listing at least one card with the wrong name and I only caught it because of the weird multiple entry for same Name+Edition. I have not vetted all of the export yet to see if this is the only discrepancy.

12    Swamp    Mercadian Masques    Basic Land  - Swamp
1    Swamp    Mercadian Masques    Basic Land  - Swamp

My guess is that the single card is in fact http://deckbox.org/mtg/Subterranean%20Hangar

This brings up the question of just how much "cooking" are you doing to the DB queries since the card lists correctly as Inventory but not as Export? I assume you are storing index values in the main table and using lookup tables for the text but then clearly doing the lookup differently for inventory vs. export.

On same thought path I discovered while looking into this that Filter for Color DOES NOT work for land cards, rather it considers them to have Color = colorless and on same token searching for non-numerical cost can not be done i.e. Cost = x yields no results. There are likely more examples that did not jump out at me. My guess that it's an oversight that Land should have color values or that Cost is more than integer values?

Not sure what the DB backend is but I'm aware from my Coldfusion developer days the peril of using the UI strings directly in backend SQL queries w/o exposing yourself to code injection but mitigating it increases the work load on developers trying to prevent inevitable user frustration over "lost in translation" or "can't express".

That said, the question on everyone's mind seems to be why import still does not do the natural reverse of export for the 3 key unique values of a record: Qty, Name, Edition much less the 2 lesser values of Language & Condition? Seems to me there's no difference in the complexity of site code or the SQL statement for using Qty & Name from user input while defaulting to latest Edition (or leaving it blank) vs. going the extra mile to use the user supplied values! Sure it takes a sanity check (as it does for card name anyway) to verify the card exists in the edition listed but it just makes it a multi-criteria lookup. As it stands I'm doing all this data entry and the best I can hope for if I have to import from this "backup" is that all my card names & total numbers will be there but I will still have to do the tedious (lacking SQL like access or batch commands never mind a proper import function) card by card edit to set Edition, Condition, Language by hand. Heck it seems that the code for Inventory and Export might even benefit from working on this if they are currently producing different results for seemingly the same lookups.

Thank you for this free solution and please consider integrating these changes into the site's functionality.

Go to forum: Site Discussion

12 Topic by t3chnomanc3r

(2 replies, posted in Site Discussion)

Is there HTTPS in general or at least for login process? Being on cafe style open wifi makes this a big issue IMO.

Go to forum: Site Discussion