Trouble inputting sales History in Portal 7

Submitted by inara60 on Fri, 08/05/2009 - 8:02am
Heya :) When I used the previous version of the portal, I used to copy my sales history onto an ancient MS Works spreadsheet every day, then when I had an entire day to process, I copied it from the spreadsheet into the portal and it worked like a charm. With the new portal 7, it no longer works pasting from the spreadsheet. When I try to do it I get an error saying it couldn't process my pasted sales history. I was just wondering if there is anything I can do to make it work like it used to, it was just simpler for me :P
Forums: 
Help & Support (Counter/Portal)
  • 12056 reads

Because your spreadsheet no longer has NP at the end of the price right? I added a error check that stops processing if the sales history wasnt inputted correctly So re-adding np will fix it, but maybe i can add a ignore error check feature
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
saudor | Fri, 08/05/2009 - 8:37am |

[quote=Dmitri]Because your spreadsheet no longer has NP at the end of the price right? I added a error check that stops processing if the sales history wasnt inputted correctly So re-adding np will fix it, but maybe i can add a ignore error check feature[/quote] I just looked to make sure, and tried submitting my sales history again, and the NP is still there when I copy it from my spreadsheet. I mean, NP is on my spreadsheet, and is still there in the window where you input the info. It will process it, but I get the error message when I press 'confirm'. An ignore error check feature would be wonderful :O
[hr] [url=http://www.neopets.com/browseshop.phtml?owner=inara60]Lucky Treasure Maps![/url]
inara60 | Fri, 08/05/2009 - 8:50am |

I CAN"T COPY MY SHOP FRONT!!! And I can't type it in! What do I do??? I would prefure if you neomailed me so I can get your nswer right away. :(
cullenscoven | Fri, 08/05/2009 - 11:43am |

@ inara60 - just pasted it via spreadsheet and it seems to work fine (at least from Opera 10) I'll give it a try from firefox later on (since i just cleared my sales history..oops) @cullenscoven you're gonna have to provide alot more details than that since there's a million and one possibilities
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
saudor | Fri, 08/05/2009 - 11:58am |

[quote=Dmitri]@ inara60 - just pasted it via spreadsheet and it seems to work fine (at least from Opera 10) I'll give it a try from firefox later on (since i just cleared my sales history..oops) @cullenscoven you're gonna have to provide alot more details than that since there's a million and one possibilities[/quote] WHAT? I just downloaded the thing and I can't COPY my shop front. AND when I type it in on the shop front thing that I downloaded it says error or something... I NEED HELP PLEASE.
cullenscoven | Fri, 08/05/2009 - 12:02pm |

Please follow the instructions found here: http://www.neomallers.com/node/18 It's pretty straightforward and nothing to type. Just CTRL+C and CTRL +V into the 2nd box in Portal
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
saudor | Fri, 08/05/2009 - 12:06pm |

Ok i see what's happening. Apparently, pasting from firefox to excel causes the entire thing to squish into one cell and hyperlinks it. I think even without the error checking, the portal should not be able to process hyperlinked data
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
saudor | Fri, 08/05/2009 - 12:16pm |

[quote=Dmitri]Ok i see what's happening. Apparently, pasting from firefox to excel causes the entire thing to squish into one cell and hyperlinks it. I think even without the error checking, the portal should not be able to process hyperlinked data[/quote] I don't have excel, just a very old version of MS Works, but it is probably pretty much the same thing? I can try using a different browser, to copy my sales history to my spreadsheet, and see if that helps. Thanks for trying to help Dmitri, I appreciate it :)
[hr] [url=http://www.neopets.com/browseshop.phtml?owner=inara60]Lucky Treasure Maps![/url]
inara60 | Fri, 08/05/2009 - 5:41pm |

Well i dont know but personally, you should just paste it directly into portal each time since Nicole tells me it screws up if you paste too much data
----------------------------- [color=purple]Protect your account[/color] http://www.neopets.com/~punchback_bob CG information & more
saudor | Fri, 08/05/2009 - 5:48pm |

It looks like I'm going to have to do that :P I just tried pasting it to my spread sheet then to portal using Internet Explorer, Safari, and Chrome and it didn't work with any of them. You said Opera worked though? Maybe I'll download that and try it. If that doesn't work, I'll just have to try to get used to doing it directly from the sales history. It's just easier for me (I have troubles with my hands) to do it the way I have been, but if I have to change, I will :) You don't have to worry about there being as much data with my sales history vs. Nicoles...I put my sales in daily, and it's generally never more than 100 - 150 items :P
[hr] [url=http://www.neopets.com/browseshop.phtml?owner=inara60]Lucky Treasure Maps![/url]
inara60 | Fri, 08/05/2009 - 5:57pm |

Pages