Jump to content
Geoff

Can you copy and post lists on the forum?

Recommended Posts

This one's been a question of mine since the new format and it's time I address it. When I copy and paste from a spreadsheet, it looks like this;

1    .    Ted Poley     -    Modern Art 2    .    Station     -    More Than The Moon 3    .    No Sleep for Lucy     -    Until the End 4    .    Nitrate     -    Real World 5    .    Don Vedda     -    Hell of a Night 6    .    Self Deception     -    Self Deception 7    .    Imperium     -    Beyond the stars 8    .    W.E.T.     -    Earthrage 9    .    Gioeli, Castronovo     -    Set the World on Fire 10    .    Sapphire Eyes     -    Breath Of Ages

But how do I get it to look like this (after a sit here for 48min pressing Enter before every number);

1    .    Ted Poley     -    Modern Art

2    .    Station     -    More Than The Moon

3    .    No Sleep for Lucy     -    Until the End

4    .    Nitrate     -    Real World

5    .    Don Vedda     -    Hell of a Night

6    .    Self Deception     -    Self Deception

7    .    Imperium     -    Beyond the stars

8    .    W.E.T.     -    Earthrage

9    .    Gioeli, Castronovo     -    Set the World on Fire

10    .    Sapphire Eyes     -    Breath Of Ages

Share this post


Link to post
Share on other sites

Geoff,

What are you using for your spreadsheet? Excel, Google Docs, or something else?

Testing a copy and paste from Excel...

Enrolled Room Capacity Day Quota
57 120
52 120
90 300
88 300
33 150
29 150
75 210
73 210
103 230
102 230
106 128
111 128
97 220
95 220
87 135

 

Seems to retain the table structure at my end.

 

Share this post


Link to post
Share on other sites

How do you do this?! I also use Excel. 

If I hit Cmd V (on the Mac) a pop up message comes up to tell me that what I am trying to copy is too large. 

So I opt for Shift/Cmd/V (paste and match style) where it pastes in that first way in my post. 

How did you do your one? Do you use a PC? Is it somehow a Mac thing? 

 

Share this post


Link to post
Share on other sites

Ctrl+c, Ctrl+v on the PC, but Cmd+c, Cmd+v on the Mac should work the same. How large of a spreadsheet are you truing to copy and paste? There might be a byte limit on what the board will accept as a paste.

Try just copying and pasting the top 10 or 20 entries and see if that works. If it does, then you might have to copy and paste in batches.

Share this post


Link to post
Share on other sites

Yeah, so when I try the Cmd+v option I get the message 'You are only allowed to upload 10.24kb. And yep, just trying to copy and paste that top 10 list (for the sake of this experiment). So barely any more data than you copy and pasted above. Let me try just the top 5 entries. 

image.png.b1095889f0f6a30dba1393817c0b9339.png

Okay, so that's how it looks when I just copy and paste the top 5, which is still far less than ideal. I am just hoping to have it look like you did above.

Stupid thing is, I think I somehow did it when I posted my "Best Of 2017" list last year, but I haven't been able to do it since and can't for the heck of me think how I might have done that?

Share this post


Link to post
Share on other sites

Hmm... I can post much larger amounts than that, and I don't see anything in group settings that would limit you. The normal file upload limit is many multiples of 10K. Perhaps paste is handled different from file upload, but I can't find it.

What about doing a screenshot of the spreadsheet and uploading that as an image?

Share this post


Link to post
Share on other sites

aside from the technical knowhow, the more pressing question is how that average as hell Station release is still residing at no 2 ;)

jeez 

Share this post


Link to post
Share on other sites
3 hours ago, Glen said:

aside from the technical knowhow, the more pressing question is how that average as hell Station release is still residing at no 2 ;)

jeez 

And how the hell is Ted Poley #1????

Share this post


Link to post
Share on other sites
Just now, AlphaMale said:

And how the hell is Ted Poley #1????

different tastes I guess.

None of the songs do much me. Ted's voice does not fit Degreeds music in my opinion. 

Share this post


Link to post
Share on other sites
3 hours ago, Glen said:

different tastes I guess.

None of the songs do much me. Ted's voice does not fit Degreeds music in my opinion. 

I'm with you. It's not awful by any means, but as you said, Ted singing Degreed-type music just doesn't sound "right".

 

Share this post


Link to post
Share on other sites
12 hours ago, heavyharmonies said:

Hmm... I can post much larger amounts than that, and I don't see anything in group settings that would limit you. The normal file upload limit is many multiples of 10K. Perhaps paste is handled different from file upload, but I can't find it.

What about doing a screenshot of the spreadsheet and uploading that as an image?

Yeah, I could probably do that I guess... would love for it just to post like it did in your first post, lol. ;) Any other technically inclined folk have any reason why it's not working for me? Everyone else can posts lists normally?

Just even looking at my list compared to yours, Dan, when I entered after each line - is it even odd for me to have those spaces between each line like I do, when yours is just posted as a straight list with no spaces between lines? 

Share this post


Link to post
Share on other sites

Just did another test - posting list in Word and then trying from there - identical results. Could this be some cookie related thing or something?

Share this post


Link to post
Share on other sites
30 minutes ago, Geoff said:

Yeah, I could probably do that I guess... would love for it just to post like it did in your first post, lol. ;) Any other technically inclined folk have any reason why it's not working for me? Everyone else can posts lists normally?

Just even looking at my list compared to yours, Dan, when I entered after each line - is it even odd for me to have those spaces between each line like I do, when yours is just posted as a straight list with no spaces between lines? 

When you manually add hard returns, it turns each line into a "paragraph" which adds extra space below the line.(s).

I'm afraid I'm not any help with respect to the differences between Mac and PC and the usage of clipboard data on one vs. the other. The last time I used a Mac was in 2005.

Share this post


Link to post
Share on other sites

Cool, no worries. Out of curiosity, does any use a Mac and have this issue too? I just logged onto Safari to see if it might be different - nope. Same. Grrr. Very frustrating. 

Share this post


Link to post
Share on other sites

Just tested posting a list on another forum I frequent (a photography one - not music related) and it worked perfect. As it did on the old HH website. Is there some little tweak that's changed that I can alter somehow from the last site to now?

Share this post


Link to post
Share on other sites

What software and version is that board running? There are a myriad of forum software packages out there (phpbb, mybb, vbulletin, etc.) and they're all different on how they handle uploads and attachments, plus they can all be configured differently.

Unless it's Invision Power Board v4.3.x, you can't really draw any conclusions.

Share this post


Link to post
Share on other sites
Just now, heavyharmonies said:

What software and version is that board running? There are a myriad of forum software packages out there (phpbb, mybb, vbulletin, etc.) and they're all different on how they handle uploads and attachments, plus they can all be configured differently.

Unless it's Invision Power Board v4.3.x, you can't really draw any conclusions.

Oh shit, how do I find that out? The website is ausphotography.net.au - don't know if you can tell from that, but that's beyond my realm of understanding. ;)

So when this board was updated to the new format, it was changed from the old one and now handles these lists differently? Or is it really somehow just me and something I'm doing here? 

Share this post


Link to post
Share on other sites

It's in the footer of the board homepage. They're running vbulletin. Completely different software package.

Share this post


Link to post
Share on other sites
i especially hands
enjoy  if and 
sex they hair
with  have and 
men nice teeth

 

i    especially    hands
enjoy     if    and 
sex    they    hair
with     have    and 
men    nice    teeth
 

Okay, so it's definitely a Mac issue as I just jumped on my wife's PC and it works fine. Grrr. Why is Apple so f*cking difficult?!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

By using this site, you agree to our Terms of Use.