jair101
Clients-
Posts
1,217 -
Joined
-
Last visited
-
Days Won
1
jair101 last won the day on August 26 2018
jair101 had the most liked content!
Recent Profile Visitors
jair101's Achievements
-
jair101 reacted to a post in a topic: Changing Test Install URL
-
I am doing a new server and wanted to start from scratch, which is different from my previous test environment (I haven't used it in a while). In a hindsight, it shouldn't have been an issue to keep the old test url, but now I already have the lets encrpypt certificates, web server, etc configuration, all with the new url. I guess I can redo that if it is too much effort for you, I thought that the strict rule was just for the main website url, which won't change.
-
@Marc Stridgen, may I tag along here with the same request? My licensed URL is community.com, my current test url is devtest.community.com. I need to change it to devtest2.community.com and I am unable to do so. Appreciate the help.
-
jair101 reacted to a post in a topic: Migrate to cloud - how to handle updating additional database table.
-
Migrate to cloud - how to handle updating additional database table.
jair101 replied to jair101's topic in General Questions
Fair enough, this is the case for today. However, I already see that v5 is introducing major changes to the development, I vaguely remember that all plugins need to be made in an app. I've been also burned with custom plugins and apps before. Furthermore, I will be needing my database on regular basis regardless, simply to have a copy outside of IPS environment - as much as I trust their backups, it is a good practice to keep a recent copy at an independent place. Once a month I hope is reasonable. Anyway, thanks for the feedback all, my main question was whether this could be done with Pages or API, I guess it won't be easy, I'll think about it a bit more. -
Migrate to cloud - how to handle updating additional database table.
jair101 replied to jair101's topic in General Questions
No, I meant that I can execute my queries on the database copy that you provide, I won't be needing you to import it back. Once I have it, I can simply hardcode the values in the Pages block that vizualizes the chart. Now, if providing me a copy of the database once a month will also be expensive, I would have to reconsider my entire strategy from scratch. -
Migrate to cloud - how to handle updating additional database table.
jair101 replied to jair101's topic in General Questions
Thanks. This is my last resort and possibly unacceptable. Doing this on my own will be a bit of a challenge, depending on 3rd party as well. If there is no some creative solution, I would probably request my database monthly, run the queries offline and update the data manually. Or maybe stick to the self hosted for the foreseeable future. -
It is about time that we migrate our community to the cloud. I think it will be mostly fine, but there is one key functionality that right now we do through creating auxillary database table and updating it through an event on a daily basis. This is all done directly in the database and once moving to the cloud I won't have access to it... So I am wondering what is the best way to do that. OK, a bit more details. We are travel oriented community and I have created 200+ Yes/No profile fields the users can toggle for each country they have visited. It looks like this in the profile: https://imgur.com/cCeNNCm So once a day, I am executing a database request that imports the data from the custom profiles in an extra database table with the following columns: id,field_name,iso_code,count 1,field_27,AT,135 2,field_36,DE,1047 etc.. This extra table ensures the mapping between field name, iso code and number of users that have visited the particular country. The query that generates that looks like this: TRUNCATE countries_map; Insert into countries_map (ISO, cntvis) select 'AU', sum(field_27) from core_pfields_content; Insert into countries_map (ISO, cntvis) select 'AT', sum(field_28) from core_pfields_content; Insert into countries_map (ISO, cntvis) select 'AZ', sum(field_29) from core_pfields_content; Insert into countries_map (ISO, cntvis) select 'AL', sum(field_30) from core_pfields_content; Insert into countries_map (ISO, cntvis) select 'DZ', sum(field_31) from core_pfields_content; Insert into countries_map (ISO, cntvis) select 'AS', sum(field_32) from core_pfields_content; Insert into countries_map (ISO, cntvis) select 'VI', sum(field_33) from core_pfields_content; ..... I need this extra query and extra table (countries_map), because we tried to do it by joining the results of 240 queries together and the speed was not pretty. So this query is executed once a day, truncates and populates this table, we are not concerned with live updates for visited countries so once a day is fine. This is all then fed in to this page created with the help of Pages and google geocharts that shows the most visited countries by our members: https://magelanci.com/atlas/ This is a core functionality for our community and I definitely need to find a way to do the same in the cloud without direct database access. So what is the best way to do that? Some magic through the REST API? Store the auxiliary table in Pages database and somehow update/obtain data from it? I cannot think of how to do that... Maybe I can commission some developer to do an app for me for this functionality, however I have been burned a bit by disappearing developers, so I'd rather use core IPS functionality. All ideas and suggestions will be appreciated, this is kind of a blocker for our migration to Cloud, which I definitely need to do as I don't have the time to admin my dedicated server responsibly.
-
CheersnGears reacted to a comment: Spark more real time engagement with the Trending Content feature
-
AlexJ reacted to a comment: Spark more real time engagement with the Trending Content feature
-
SeNioR- reacted to a comment: Spark more real time engagement with the Trending Content feature
-
jair101 started following Spark more real time engagement with the Trending Content feature
-
Limit guest based access to topics more than 2 weeks old
jair101 replied to jair101's topic in Marketplace
OK, fair point. In this case I think I would take the hit of having the content indexed with 2 weeks delay. -
Limit guest based access to topics more than 2 weeks old
jair101 replied to jair101's topic in Marketplace
I think there is already a method for Google to bypass the restrictions, based on user agent. At least this mod have this functionality: -
jair101 started following Has member title been removed? and Limit guest based access to topics more than 2 weeks old
-
I am considering some actions to entice people to register/subscribe etc. based on the date availability of forum content. In a simplest terms imagine that guests will be able to see only topics and replies from up to 2 weeks ago. A large banner will inform them that if they want to access the latest content and engage with the community they need to register/become premium member, etc. Does this sounds like something that is easy to achieve through third party app/plugin? Tagging @DawPi as it seems that you have dived in to guest limits area, though not exactly in this respect ๐
-
Flybc.ca reacted to a post in a topic: Reactions Per User Group
-
Grafidea reacted to a post in a topic: Font awesome 5.0
-
Rogefeller reacted to a post in a topic: Pages SuperReviews (Support Topic)
-
OptimusBain reacted to a post in a topic: IPS Commerce: download invoices as PDF
-
AlexJ reacted to a comment: No-code automation with Zapier
-
OptimusBain reacted to a comment: No-code automation with Zapier
-
jair101 reacted to a post in a topic: Has member title been removed?
-
jair101 reacted to a post in a topic: Has member title been removed?
-
Seriously ๐ Custom member titles are part of the profile identify, please make sure there is an option we can preserve them somehow. I guess the query to copy them from member title to profile field shouldn't be overly complicated, can someone from the expirienced devs advise on that?
-
jair101 started following Post Before Registering - Statistics? , Drum roll pleaseโฆ announcing Achievements! , IPS Commerce: download invoices as PDF and 1 other
-
Going a step further, the invoice pdf can be sent as attachment via email, this is becoming a standard as it can be easily forwarded to the relevant department or event automated:
-
Hump Day: Sneak Peek at Achievements
jair101 replied to Jordan Miller's topic in Invision Community Insider
Looks awesome ๐ Are we going to be able to award users retroactively or all users will start from 0 once the system is enabled? Ditto for if/when new achievement rules are added later? -
Hump Day: Sneak Peek at Achievements
jair101 replied to Jordan Miller's topic in Invision Community Insider
Any further details how points can be obtained? Is it going to be through regular content creation - i.e. number of posts, articles, images, etc.? Or it will be more flexible, for example based on where the topic is located (post in professional category might be worth more than one in humor section), or based on word count or number of attachments? Even better if we can set the weight of points ourselves ๐ -
jair101 reacted to a post in a topic: Post Before Registering - Statistics?
-
Any idea how many of those are spam and how many legit accounts though?
-
jair101 reacted to a comment: No-code automation with Zapier
-
jair101 reacted to a post in a topic: Invision Community in Google Cloud (GCP)
-
Invision Community in Google Cloud (GCP)
jair101 replied to Cowboy Denny's topic in Classic self-hosted technical help
@Paul E., is SQL the only thing you have offloaded outside of Compute Engine? What about object storage, elasticsearch, redis?