BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Sunset Ride 
Sunset Ride 

BOB has retired moved! Our current platform (the one you are reading right now) is over 18 years old. Rather than continue here, the community has moved to a new software platform! We are excited about the move and hope that you'll come with us.

The new community URL is https://bobj-board.org/.

User accounts have not been converted. In order to participate on the new platform you will need to create a new account. Existing posts have been retroactively assigned to your user name, but are associated with an anonymous account. No personal information (email address and so on) has been transferred to the new platform.

If you have any questions, the "About BOB" forum will remain open for the remainder of 2020, at which point it will be replaced by a static page directing folks to the new community.

Thank you for your support and participation for the past 18 years.

BOB 2.0
2 members found this topic helpful
Goto page 1, 2, 3, 4, 5, 6, 7, 8, 9  Next
 
Search this topic... | Search About BOB... | Search Box
Register or Login to Post    Forum Index -> About BOB  Previous TopicPrint TopicNext Topic
Author Message
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11524
Location: Manchester, UK


flag
PostPosted: Wed Dec 11, 2019 7:53 am 
Post subject: BOB 2.0

Dave,

Now my freelancing days are at an end, I have paid for hosting set to run for another 20+ months. I'm happy to trash that and start again with a blank canvas which would just support the latest version of phpbb3 and its supported underlying platform.

It will also give me an excuse to move away from a couple of other sports forums that I post on out of habit; I'll have something more relevant to work on and can evolve the site as required. My current employer is not using BusinessObjects (yet) so there is no conflict or confluence of interests but I want to keep my hand in as much as possible rather than let over 20 years of work on the tool go to waste.

If anyone else wanted to take on the forum, I'll happily stand aside; I just think that BI and in particular SAP BO needs an independent platform rather than each vendor telling us that their tool is the best.

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22111
Location: Dallas, Texas


flag
PostPosted: Wed Dec 11, 2019 11:21 am 
Post subject: Re: BOB 2.0

I would not restrict the options to just phpBB3. With all of the enhancements (phpBB calls them "mods") the conversion process from phpBB2 to phpBB3 will not work. I've actually tested it...years ago, to be sure...but at the time it did not work.

I haven't watched phpBB3 that much, so I don't know how many of the tech issues that I think we have (or will have) are fixed.

_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
kbrazell
Principal Member
Principal Member



Joined: 19 Aug 2003

Posts: 206
Location: DFW Metroplex (but mobile) I applied to Mars One


flag
PostPosted: Wed Dec 11, 2019 2:48 pm 
Post subject: Re: BOB 2.0

Dave Rathbun wrote:
I would not restrict the options to just phpBB3. With all of the enhancements (phpBB calls them "mods") the conversion process from phpBB2 to phpBB3 will not work. I've actually tested it...years ago, to be sure...but at the time it did not work.

I haven't watched phpBB3 that much, so I don't know how many of the tech issues that I think we have (or will have) are fixed.


I have been inside phpBB2 a lot (although note recently) and poked around with phpBB3 a little. If we had a clean install of phpBB3 we could write our own database migration script. Some parts of it like Forum creation don't have to be automated - those are small enough in number that they could be done manually, just to create the proper landing zones for the data. We don't even have to stay with phpBB.

Another idea has struck me. How large is the BOB DB? Instead of just putting up some website, what if we rolled out a stand alone VM (or Docker or alternative container) so that it could be hosted or mined anywhere.

_________________
Kyle Brazell
General Contractor
BI Developer.....................BOBJ XIr3, on Oracle 8, 8i, 10g, 11g, with HP-UX, AIX, Linux
IoT Developer
Web Developer
Embedded System Programmer
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11524
Location: Manchester, UK


flag
PostPosted: Thu Dec 12, 2019 6:03 am 
Post subject: Re: BOB 2.0

Dave Rathbun wrote:
I would not restrict the options to just phpBB3. With all of the enhancements (phpBB calls them "mods") the conversion process from phpBB2 to phpBB3 will not work. I've actually tested it...years ago, to be sure...but at the time it did not work.

I haven't watched phpBB3 that much, so I don't know how many of the tech issues that I think we have (or will have) are fixed.


Not a problem. I've worked with Invision Power Board too; there are plenty of modules on there that we can use. I've also had to work directly with the database on that when two forums merged, which was "fun".

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
julienbras
Principal Member
Principal Member



Joined: 25 Jul 2007

Posts: 131
Location: Montreal, QC


flag
PostPosted: Thu Dec 12, 2019 10:16 am 
Post subject: Re: BOB 2.0

Hello guys,

I think if we go on a BOB 2.0, we need to think it globally.

- What do we want to do ? simple migration to latest phpBB ? choose a different forum solution ? Do something else ?
- How to work with SAP Community around the place ? advantages vs SAP tooling ?
- How many time are we ok to invest ?

I am very interessed to spend time on this project and help on answering all of that.

Starting by the first question, I have xp with Discourse that is a very interesting solution.

My point of view is that BOB data is invaluable, and I am really sad to let it die. It's a community and it need to be handle by the community. But maybe it need to be expended?

- Social features to be able to link users ?
- KB features ?
- Download section ? (yes I am still in love with the fact that my little xls spreadsheet released in 2007 to export users & groups is still used and have been forked multiple times... This is exactly why community is a really good asset !)

_________________

Julien Bras -- Product Manager @ GB&Smith --- latest articles:
• 2020-05-03 Moving from Eclipse to VSCode by a Java Developer
• 2019-12-04 Temp acceptance systems on AWS
• 2018-09-30 Web Scrapping with Python
Back to top
kbrazell
Principal Member
Principal Member



Joined: 19 Aug 2003

Posts: 206
Location: DFW Metroplex (but mobile) I applied to Mars One


flag
PostPosted: Thu Dec 12, 2019 3:50 pm 
Post subject: Re: BOB 2.0

forum whitelist choices
Could we import data to reddit? I did a quick search and found someone with the same question. the answer though was not complete, but it does point out three is an API that can be used.

https://www.reddit.com/r/help/comments/14zoaz/migrating_forum_to_reddit/

forum blacklist choices
I'd avoid Facebook because it is a plague on mankind.

research links
Creating a subreddit

caveat
I've heard that you can lose a reddit if new moderators "take over" or a large and hostile community moves in. Avoiding that seems to require a full time permanent moderator - which I think is part of the reason that BOB is retiring.

questions
Mostly if it moves to reddit. While the goal to anonymize the migrated archival content is good, some users may want to retain ownership of their questions or answers. I've not checked if the reddit API lets you assign posts to other users. But if it does, perhaps the trnaslation table that connects a known BOB user to a name that is anonymous could allow some users to suggest their own reddit name. (The anonymous name could be in the form of BOB_nnnnn where nnnnn is the ID userlist number when sorted by join date [and have actually posted]. Wow, I just checked over 82,000 registered users! I had to add a fifth "n") (Supporting this might mean adding a reddit ID column to the Profile with the implication that if you fill it out, it will stick after the transfer [if it can be stuck])

_________________
Kyle Brazell
General Contractor
BI Developer.....................BOBJ XIr3, on Oracle 8, 8i, 10g, 11g, with HP-UX, AIX, Linux
IoT Developer
Web Developer
Embedded System Programmer
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11524
Location: Manchester, UK


flag
PostPosted: Fri Dec 13, 2019 4:40 am 
Post subject: Re: BOB 2.0

The big downside for reddit is that it is often blocked by corporate controls as it is seen as a social media site.
_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22111
Location: Dallas, Texas


flag
PostPosted: Sat Dec 14, 2019 10:07 pm 
Post subject: Re: BOB 2.0

kbrazell wrote:
Another idea has struck me. How large is the BOB DB?

Depends on how you want to measure it. The biggest table in the phpBB2 system is the search wordmatch table and any archive would not need to preserve that because it only supports the phpbb2 search process.

The users table would be eliminated due to the user account adjustment process I would be using that I mentioned earlier.

There are a number of non-technical forums that probably don't need to be preserved. For example we have a hidden forum where all of the spammer posts go, just in case I needed them for legal or technical reasons. There are 433 pages of topics there. cuss.gif

So if you just go by the number of posts, we have a database with just under one million rows in it. The number of rows in the topics table (think of that as the post header) is 219207.

There are 1.6GB of attachments.

_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22111
Location: Dallas, Texas


flag
PostPosted: Sat Dec 14, 2019 10:22 pm 
Post subject: Re: BOB 2.0

kbrazell wrote:
You'd also need to quash the .sig and other data elements form the Profile page

The user profile would be completely wiped. Only the username would be preserved using the "guest poster" function.

Quote:
Although I do suggest keeping the Country flag just to show how widely useful this site is/was.

Interesting, but would have to create a new field in the database to make that happen. I'll post more about this in the BOB 2.0 topic.

Here's the current table structure of the POSTS table.
Code:
+-----------------+-----------------------+------+-----+---------+----------------+
| Field           | Type                  | Null | Key | Default | Extra          |
+-----------------+-----------------------+------+-----+---------+----------------+
| post_id         | mediumint(8) unsigned | NO   | PRI | NULL    | auto_increment |
| topic_id        | mediumint(8) unsigned | NO   | MUL | 0       |                |
| forum_id        | smallint(5) unsigned  | NO   | MUL | 0       |                |
| poster_id       | mediumint(8)          | NO   | MUL | 0       |                |
| post_reason_id  | mediumint(5) unsigned | YES  |     | 0       |                |
| post_time       | int(11)               | NO   | MUL | 0       |                |
| poster_ip       | varchar(8)            | NO   |     |         |                |
| is_mod_post     | tinyint(1) unsigned   | NO   |     | 0       |                |
| best_answer     | tinyint(1) unsigned   | YES  |     | 0       |                |
| post_locked     | tinyint(1) unsigned   | NO   |     | 0       |                |
| post_username   | varchar(25)           | YES  |     | NULL    |                |
| enable_bbcode   | tinyint(1)            | NO   |     | 1       |                |
| enable_html     | tinyint(1)            | NO   |     | 0       |                |
| enable_smilies  | tinyint(1)            | NO   |     | 1       |                |
| enable_sig      | tinyint(1)            | NO   |     | 1       |                |
| post_edit_time  | int(11)               | YES  |     | NULL    |                |
| post_edit_count | smallint(5) unsigned  | NO   |     | 0       |                |
| post_attachment | tinyint(1)            | NO   |     | 0       |                |
+-----------------+-----------------------+------+-----+---------+----------------+

POST_ID is the unique key for the post.
TOPIC_ID is the foreign key for the TOPIC the post belongs to.
FORUM_ID is the foreign key for the FORUM that the TOPIC and the POST belong to. This is essentially for shortcut joins icon_smile.gif but also drives the "last post in the forum" logic.
POSTER_ID is the foreign key to the USERS table. It either contains a positive integer that is the USER_ID value, or it contains a -1 indicating that it's a guest (non-logged in) users. For BOB we never allowed guest posts.

I'll skip a number of the other fields, and talk about POST_USERNAME next. For a guest poster, they have to enter a username that will be used to display on their post. Since there is only one guest entry in the USERS table (with the ID of -1 as already mentioned) the username has to be stored on the post itself.

So the PII elimination process looks like this:

Step 1:
Code:
UPDATE POSTS_TABLE P
SET POST_USERNAME = (SELECT U.USERNAME FROM USERS U WHERE P.POSTER_ID = U.USER_ID)

That, or something like it, would transfer the user name from the USERS table onto the POSTS table.

Step 2:
Code:
UPDATE POSTS_TABLE
SET POSTER_ID = -1

That marks all posts as being from guest, showing only the username of the original poster. At this point I can drop the USERS table content and all PII - including the country flag - is gone.

Now if we wanted to preserve the country flag, I would add a flag_id column to the POSTS table and update accordingly. The column, as you might expect, is USERS.FLAG_ID. icon_smile.gif

If you look at the POSTS table information I included above, the following columns were added during various code modifications / enhancements here on BOB and are not part of a standard phpBB2 install.

POST_REASON_ID
IS_MOD_POST
BEST_ANSWER
POST_LOCKED

If you want a tech reference for the phpBB2 table structure, I built one years ago here:

http://www.phpbbdoctor.com/doc_tables.php

_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22111
Location: Dallas, Texas


flag
PostPosted: Sun Dec 15, 2019 5:19 pm 
Post subject: Re: BOB 2.0

The attached image shows the post count by month from BOB's launch in August of 2002 until now.
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
kbrazell
Principal Member
Principal Member



Joined: 19 Aug 2003

Posts: 206
Location: DFW Metroplex (but mobile) I applied to Mars One


flag
PostPosted: Sun Dec 15, 2019 7:03 pm 
Post subject: Re: BOB 2.0

2008 was a banner year for BOB. Must have been a lot of bad documentation or bugs from BO in those days.

And that initial adoption curve shows how badly this community was needed.

I see the issue with keeping the country flag.

I love that table structure meta data page. Did you build that manually or have a script build it for you? It's an easier interpretation of the structure that jumping into a full DB tool like phpMyAdmin.

_________________
Kyle Brazell
General Contractor
BI Developer.....................BOBJ XIr3, on Oracle 8, 8i, 10g, 11g, with HP-UX, AIX, Linux
IoT Developer
Web Developer
Embedded System Programmer
Back to top
Chris Pohl
Forum Addict
Forum Addict



Joined: 18 Jun 2002
ASUG Icon
speaker.gif
Posts: 2808
Location: da' burg


flag
PostPosted: Sun Dec 15, 2019 9:38 pm 
Post subject: Re: BOB 2.0

kbrazell wrote:
2008 was a banner year for BOB

icon_mrgreen.gif

kbrazell wrote:
reddit

cryin.gif

_________________
Chris Pohl
Follow me on Twitter
Search is Your Friend
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22111
Location: Dallas, Texas


flag
PostPosted: Sun Dec 15, 2019 11:25 pm 
Post subject: Re: BOB 2.0

kbrazell wrote:
I see the issue with keeping the country flag.

It's not impossible though. If the new team decides it's important, I can make it part of the same script that copies over the username.

Quote:
I love that table structure meta data page. Did you build that manually or have a script build it for you? It's an easier interpretation of the structure that jumping into a full DB tool like phpMyAdmin.

I built it (manually) as a reference for the phpBB2 community. I was quite active there back in the day as well. I even got a trip to London to meet some of the developers at a phpBB meetup. My presentation on fighting spam in phpBB2 was recorded and you can probably find the video if you know how to look. icon_cool.gif

What I probably did was download the table structures into Excel, populate the text there, and then upload it. You can tell by the color coding I had grander plans that never quite got finished. But it will help folks that might not be as familiar with the tables structures.

I also have a list (somewhere) of all of the modifications made to BOB. We have extra columns in some tables, some tables were dropped, and many new tables were added. That's the main issue with converting to phpBB3.

_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
Debbie
Forum Addict
Forum Addict



Joined: 01 Mar 2005

Posts: 2805
Location: Cheshire, England


flag
PostPosted: Tue Dec 17, 2019 5:50 am 
Post subject: Re: BOB 2.0

kbrazell wrote:
2008 was a banner year for BOB. Must have been a lot of bad documentation or bugs from BO in those days.


Probably just after XIr2 got going in earnest? I seem to recall we went from the old v6 to the new XI suite in 2007 - I was amazed as for once we were at the front-edge of the technology!

Debbie
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11524
Location: Manchester, UK


flag
PostPosted: Tue Dec 17, 2019 6:57 am 
Post subject: Re: BOB 2.0

Debbie wrote:
kbrazell wrote:
2008 was a banner year for BOB. Must have been a lot of bad documentation or bugs from BO in those days.


Probably just after XIr2 got going in earnest? I seem to recall we went from the old v6 to the new XI suite in 2007 - I was amazed as for once we were at the front-edge of the technology!

Debbie


Hate to disappoint you, Debbie, but XI3 came out in February 2008. icon_smile.gif

XIr2 was launched in November 2005.

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> About BOB  Previous TopicPrint TopicNext Topic
Page 1 of 9 All times are GMT - 5 Hours
Goto page 1, 2, 3, 4, 5, 6, 7, 8, 9  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.1021 seconds using 17 queries. (SQL 0.0028 Parse 0.0677 Other 0.0316)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo