Advertisement:

Author Topic: excel rows to posts  (Read 387 times)

Offline H.D.V.

  • Semi-Newbie
  • *
  • Posts: 10
  • Gender: Male
excel rows to posts
« on: July 31, 2019, 11:29:47 AM »
I have an xls sheet with 1000 rows. Can i create 1000 posts automatically?

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,228
    • StoryBB/StoryBB on GitHub
Re: excel rows to posts
« Reply #1 on: July 31, 2019, 11:37:48 AM »
There is nothing built in to support this, it would have to be implemented from scratch for you.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,399
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: excel rows to posts
« Reply #2 on: July 31, 2019, 01:03:36 PM »
I did one years ago https://www.simplemachines.org/community/index.php?topic=555200.0 that could be adapted.

I would save the xls to csv file which is easier to work with.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Online Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,333
  • Gender: Male
    • Kindred-999 on GitHub
Re: excel rows to posts
« Reply #3 on: July 31, 2019, 02:14:02 PM »
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,028
Re: excel rows to posts
« Reply #4 on: July 31, 2019, 02:27:09 PM »
https://theenemy.dk/table/


they mean to import the data from excel into many posts, not to post a table into a post.

Online Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,333
  • Gender: Male
    • Kindred-999 on GitHub
Re: excel rows to posts
« Reply #5 on: July 31, 2019, 03:19:16 PM »
oh yeah...   reading comprehension on a phone is less than  ideal
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline shawnb61

  • Support Specialist
  • Sophist Member
  • *
  • Posts: 1,275
    • sbulen on GitHub
Re: excel rows to posts
« Reply #6 on: July 31, 2019, 10:13:16 PM »
How difficult this is will depend on what's in that spreadsheet...

Member names?  IDs??? 

Also, Excel does some funky things with UTF8...
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp