Jump to content

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

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.

 

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? 

 

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.

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?

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?

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 

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????

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. 

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".

 

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? 

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?

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.

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. 

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?

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.

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? 

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?!

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...

Important Information

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