Register
Welcome to the Stormspire.net WoW Gold Forums!

Greetings, guest! Welcome to Stormspire.net, your #1 resource for WoW and Diablo 3 Gold, Professions, and everything in between!


Enjoy what the site offers? Consider Premium Membership if you wish to get the most out of the site. Premium Membership benefits include the acclaimed Goblineer's World of Warcraft Gold Guide, private forum access, a complimentary high-quality avatar, and much more!


If this is your first visit, make sure to check out the Stormspire.net Survival Guide for a quick site orientation. You may also register to unlock all standard forum features, and to get rid of these lovely ads!


We proudly host the Official forums for TradeSkillMaster, The Undermine Journal, and WoWuction.

Results 1 to 6 of 6
  1. #1
    Apprentice
    Ready2r's Avatar
    Posts
    3
    Reputation
    0
    Tagged in
    3 Posts
    Add to this user's reputation

    Importing CSV for both Alliance and Horde...GoogleDocs

    I have been trying to load both alliance and horde's (same realm) CSV in 1 Worksheet. It will load all of the Alliance items, but when it goes to load the horde, it will only load the first 100. I have even made separate worksheets for Alliance and Horde...resulting in them both loading fine...but when i go to reference (importrange) it does the same thing...will load alliance but only the first 100 horde.

    I know google has a 400K cell limit...but i am no where near that. When i import the data...i only import the Name/market price/quantity which is only 84K cells (for my realm)

    Im fairly new when it comes to Google docs...so im wondering if i am doing something wrong? is there a cap on how much data can be imported in google docs?

    On a side note..i tried doing the Blizzard API into google docs but i cant seem to get it to work. "TypeError: Cannot call method "getSheetByName" of null. (line 8)"

    Any help would be amazing. Thanks

  2. #2
    US-Emerald Dream(Both)
    Your Favorite Goblin
    Kathroman's Avatar
    Posts
    5,254
    Reputation
    279
    Blog Entries
    17
    Tagged in
    2064 Posts
    Add to this user's reputation
    Quote Originally Posted by Ready2r View Post
    I have been trying to load both alliance and horde's (same realm) CSV in 1 Worksheet. It will load all of the Alliance items, but when it goes to load the horde, it will only load the first 100. I have even made separate worksheets for Alliance and Horde...resulting in them both loading fine...but when i go to reference (importrange) it does the same thing...will load alliance but only the first 100 horde.

    I know google has a 400K cell limit...but i am no where near that. When i import the data...i only import the Name/market price/quantity which is only 84K cells (for my realm)

    Im fairly new when it comes to Google docs...so im wondering if i am doing something wrong? is there a cap on how much data can be imported in google docs?

    On a side note..i tried doing the Blizzard API into google docs but i cant seem to get it to work. "TypeError: Cannot call method "getSheetByName" of null. (line 8)"

    Any help would be amazing. Thanks
    If you feel comfortable sharing the link, perhaps we could be of more help...
    Like what you see? Become an Ethereal Contributor to help support the site and gain access to additional perks.

        

    Guides: Thunder Bluff Vendor Supply Route | Entry Level JC Strategy | Alternative DMF Guide

    TSM 2.0: TSM 2.0 Groups & Operations GUIDE | TSM 2.0 Basic JC Shuffler | TSM 2.0 ADVANCED JC Shuffler

  3. #3
    Apprentice
    Ready2r's Avatar
    Posts
    3
    Reputation
    0
    Tagged in
    3 Posts
    Add to this user's reputation
    Quote Originally Posted by Kathroman View Post
    If you feel comfortable sharing the link, perhaps we could be of more help...

    Yea, no problem.

    Currently maxed out my 10 TUJ access for the 24 hours...dont know if they will effect your viewing, or if its IP based.

    Here is the main Workbook:
    https://docs.google.com/
    Ignore the 2nd page...it is still formatted to grab the data from the CSV imports that used to be in that workbook...they have been deleted and not changed to grab the data from the ImportRange sheets.

    The 3rd and 4th pages are ImportRange from the next 2 workbooks.

    Here are the 2 Workbooks with just the 2 CSV imports (Horde/Alliance)
    https://docs.google.com/spreadsheet/ < Alliance
    https://docs.google.com/spreadsheet/ < Horde
    ^like i said...both of these will load everything fine...its just when i try to importrange to my main Workbook where the horde one wont full load (caps at 100)

    I know there is prob 100 easier ways to go about my goal. I just got into Spreedsheet/excel and im kinda having fun doing it.

    Im usually able to google any problems i have...but this one is WoW related..so no luck there :X
    Last edited by Kathroman; November 10th, 2012 at 08:07 AM.

  4. #4
    US-Emerald Dream(Both)
    Your Favorite Goblin
    Kathroman's Avatar
    Posts
    5,254
    Reputation
    279
    Blog Entries
    17
    Tagged in
    2064 Posts
    Add to this user's reputation
    Quote Originally Posted by Ready2r View Post
    Yea, no problem.

    Currently maxed out my 10 TUJ access for the 24 hours...dont know if they will effect your viewing, or if its IP based.

    Here is the main Workbook:
    https://docs.google.com/spreadsheet/...kllUTR0UnVLTHc
    Ignore the 2nd page...it is still formatted to grab the data from the CSV imports that used to be in that workbook...they have been deleted and not changed to grab the data from the ImportRange sheets.

    The 3rd and 4th pages are ImportRange from the next 2 workbooks.

    Here are the 2 Workbooks with just the 2 CSV imports (Horde/Alliance)
    https://docs.google.com/spreadsheet/...UU4SmM1Y3k0Unc < Alliance
    https://docs.google.com/spreadsheet/...WtDUHR2YWFfWVE < Horde
    ^like i said...both of these will load everything fine...its just when i try to importrange to my main Workbook where the horde one wont full load (caps at 100)

    I know there is prob 100 easier ways to go about my goal. I just got into Spreedsheet/excel and im kinda having fun doing it.

    Im usually able to google any problems i have...but this one is WoW related..so no luck there :X
    the CSV pulls are limited based on your unique code (IIRC), which will be in your SS

    If you've set most of this up yourself, I'm going to assume you're relatively proficient with the programs involved/learning new ones, so why not describe what you'd ultimately like to accomplish with this, because you're probably right - there will be better ways of doing this. If we know what the end goal is here, we might be better able to steer you in the right direction.

    Also, have you been able to check out any of the other threads on the site about CSV/Excel/Google Docs/API? If so, which ones?

    I've also edited out the links in your post, since they have your TUJ code in them.
    Like what you see? Become an Ethereal Contributor to help support the site and gain access to additional perks.

        

    Guides: Thunder Bluff Vendor Supply Route | Entry Level JC Strategy | Alternative DMF Guide

    TSM 2.0: TSM 2.0 Groups & Operations GUIDE | TSM 2.0 Basic JC Shuffler | TSM 2.0 ADVANCED JC Shuffler

  5. #5
    Apprentice
    Ready2r's Avatar
    Posts
    3
    Reputation
    0
    Tagged in
    3 Posts
    Add to this user's reputation
    Quote Originally Posted by Kathroman View Post
    the CSV pulls are limited based on your unique code (IIRC), which will be in your SS

    If you've set most of this up yourself, I'm going to assume you're relatively proficient with the programs involved/learning new ones, so why not describe what you'd ultimately like to accomplish with this, because you're probably right - there will be better ways of doing this. If we know what the end goal is here, we might be better able to steer you in the right direction.

    Also, have you been able to check out any of the other threads on the site about CSV/Excel/Google Docs/API? If so, which ones?

    I've also edited out the links in your post, since they have your TUJ code in them.
    The main goal of this one was to grab the prices of each of the DMCs...then give me a price based on if i were to buy and build them from alliance or horde. Then i was going to set it up to take the lowest from each faction and give me a new price based on if i were to utilize both factions. (the other day i made a DMC for 11K buying using both horde and alliance and i was able to sell the Relic for 23K)

    I know it isn't hard to log into to my Horde alt and Alliance alt and write down or screenshot the prices using Auctionator [of the serpent,of the tiger, etc but like i said..i was just getting into google docs and was having fun playing around with it...figured this would be an easy one to set up.

    As far as other threads...the only one i really saw was the API one stickied at the top of this forum. Tried messing around with it for about an hour but kept getting the same error. Since i don't know anything about scripting and its coding...i haven't really tried to troubleshoot why it wouldn't work.

    I just discovered the TUJ forum on this board and ill def. be checking it out.

  6. #6
    US-Emerald Dream(Both)
    Your Favorite Goblin
    Kathroman's Avatar
    Posts
    5,254
    Reputation
    279
    Blog Entries
    17
    Tagged in
    2064 Posts
    Add to this user's reputation
    Quote Originally Posted by Ready2r View Post
    The main goal of this one was to grab the prices of each of the DMCs...then give me a price based on if i were to buy and build them from alliance or horde. Then i was going to set it up to take the lowest from each faction and give me a new price based on if i were to utilize both factions. (the other day i made a DMC for 11K buying using both horde and alliance and i was able to sell the Relic for 23K)

    I know it isn't hard to log into to my Horde alt and Alliance alt and write down or screenshot the prices using Auctionator [of the serpent,of the tiger, etc but like i said..i was just getting into google docs and was having fun playing around with it...figured this would be an easy one to set up.

    As far as other threads...the only one i really saw was the API one stickied at the top of this forum. Tried messing around with it for about an hour but kept getting the same error. Since i don't know anything about scripting and its coding...i haven't really tried to troubleshoot why it wouldn't work.

    I just discovered the TUJ forum on this board and ill def. be checking it out.
    I'd definitely recommend checking out the post towards the end of @Pliaksi 's thread on Google Docs imports, then - as there was a member who was working on a script that would only pull a certain range of items into his SS. Since you're only working with DMCs, it would probably be beneficial to limit the number of overall calls you're making, since google definitely imposes a limit (somewhere around 100-150, IIRC)
    Like what you see? Become an Ethereal Contributor to help support the site and gain access to additional perks.

        

    Guides: Thunder Bluff Vendor Supply Route | Entry Level JC Strategy | Alternative DMF Guide

    TSM 2.0: TSM 2.0 Groups & Operations GUIDE | TSM 2.0 Basic JC Shuffler | TSM 2.0 ADVANCED JC Shuffler

 

 

Similar Threads

  1. Add button to easily switch between horde/alliance auction houses?
    By taro in forum Official Forum of The Undermine Journal
    Replies: 1
    Last Post: July 4th, 2012, 02:09 PM
  2. New Statistics: US Alliance Market Price & US Alliance Mean
    By KaliopeLlane in forum Official Forum of The Undermine Journal
    Replies: 1
    Last Post: March 16th, 2011, 03:07 PM
  3. Battleground: Horde/Alliance Win Ratio Statistics
    By Sinshroud in forum Off Topic
    Replies: 8
    Last Post: February 22nd, 2011, 06:37 PM