SC + WordPress

Albert - do you have a link so I can take a look ?

Arthur

I hope to make a visual sample sometime as these questions come regularly. The samples I talked about are on a corporate medial intranet and not accessable.

I asked because so far I haven’t seen one serious project (which consists of more than one grid and one form) working well in iFrames. There is a problem with passing parameters and also adjusting frame size.
I do not have any programming experience with WP, that’s why I have asked to eventually avoid any pitfalls. Basically integrating SC projects with any CMS systems would be a big plus, however I do not see much activity in this area from NetMake. Obviously in many cases plain SC project is not enough for the customer or end user.

I am new to the side by side world too. I would like a to find a diesel one as well. The problem that I am finding is that nobody makes one that will keep up with the gas ones. I have been looking at the Intimidator web site, and I think one of these and a turbo retrofitted on would make a snappy*

Is this spam?

Yep that is common forum spam… In fact it is probably from india or china or russia. It should be verifiable on the ip number from the user.

Hi Aka, I download the Jscriptcase but I don’t have good luck with the test. And in the web of this product I don’t receive any answer :(. With wich Joomla versi?n Works fine this product? Do you find another options to do this?
Thanks!

Their extension work only with Joomla 2.5 (but it has few minor bugs). For simple projects i.e. GRID -> FORM Joomla wrappers are quite sufficient, but when you need to manipulate links etc or better yet get a nice look and feel like your Joomla site you are out of luck. You can check my DEMO site here: http://www.essentialdatabase.com it shows some simple Apps implemented into default Joomla site (if I remember this is J3.5) and I used wrappers only.
Here is the problem with wrapper. You can only activate the App within the wrapper if you call it from the Joomla menu, so if you want to open certain App in the project within the wrapper but your link is inside the SC App you have problem. I think one solution would be to wrap each App inside the module (another words make a Joomla module for each App within your Project). The problem with this solution is that if you have i.e. 250 or more Apps doing this manually would take days (and I do not have that time).
I was thinking about creating a tool that will convert SC project into Joomla extension. It is possible but the main task to resolve is to deal with CSS/HTML which is created upon code generation and there is no easy way to match project CSS with Joomla template CSS.
I think I’ve herd that SC8.1 allows to create veriable inside the templates but never saw any example of how this is done. If it is possible then it would make a job of matching CSS from CSS and SC-CSS much easier.

Hi Arthur, good example site. I copy for your in other post the answer of Illerian about they are working in new version of JScriptcase. I don’t know details about this new release.
I think other problem to deal with it, is about to manage dual security.
Thanks

OK Albert - so how can I mix the SC table with the CMS page content ?
This is my major concern. jScriptaces have had a nice component (Joomla module) which allows to convert any SC app into module. There is also another component called “Module Anywhere” which allows you to place a module anywhere within CMS. It worked like charm, but unfortunately jScriptcase is no longed under development so unless one uses Joomla 2.5 or older it will not work anymore. O course I can create a module from SC App manually and this might be good for one or two Apps but when project is dealing with several hundreds of them it would take forever to do so. I also saw an SC component for WordPress but never tried that so I would appreciate if somebody could share the opinion on that one.

Arthur

Arthur, I have no Idea, I can only tell what I am doing. I’m just putting a scriptcase application in an iframe in my cms (E107), as you did on your website. I change templates so that it’s not that obvious that the page is coming from another source.
It’s done by a wrapper plugin, and I’m sure that Joomla and WP has similar plugins. In that plugin you define an url and with some minor tweaks I can have that url dynamic controling my sc application. As Canvinha stated, I do have other places that call scripcase, and I use a blank application for that. returning json or xml. It’s straight forward just call the module and pass parameters as you useually do with php, $_GET and $_POST. If you need to access Joomla or WP variables than you must find them in your cms and make them global if they aren’t already, or pick that data up by a cookie. But out of the cookbook I cannot tell you what to do. Sorry. I don’t like WP nor Joomla so never went very deep into them. Fully integrating your apps in the structure is a real challenge, so I try to avoid that.

If you need to access Joomla or WP variables than you must find them in your cms and make them global if they aren’t already, or pick that data up by a cookie.

and that is the hardest part. I"m not a PHP programmer and even if I am I would rather not override original CMS code. Yes we can use INCLUDE files but when new CMS release is ready this might require re-coding everything. The bottom line is that I’m really looking for solutions not the general statements that that it is hard to do.
If there is a CMS system that will integrate better than Joomla or WP I would be happy to try, but only if it allows me to do more than just a simple grid/form data manipulation and will integrate with site contents.

For Joomla, you can include the platform and access his API. Is not needed to recode anything.
For example. II have an application where login check against Joomla users. Because Joomla encrypts password iin it’s own way, you have to use their API to validate.


function checkJoomlaPass($pass, $dbPW) {

   include "../ktglobales.php";

   define( '_JEXEC', 1 );
   define('JPATH_BASE', $ktglobales["ktjoomlajpath"]);
   define( 'DS', DIRECTORY_SEPARATOR );

   require_once ( JPATH_BASE .DS.'includes'.DS.'defines.php' );
   require_once ( JPATH_BASE .DS.'includes'.DS.'framework.php' );

    if(JUserHelper::verifyPassword($pass, $dbPW))
   {
      return true;
   }
   else
   {
      return false;
   }
    
}

https://api.joomla.org/cms-3/classes/JUserHelper.html#method_verifyPassword

If you want to change a user password from SC:
JUserHelper::hashPassword($password)

and so on…

If there is a CMS system that will integrate better than Joomla or WP I would be happy to try, but only if it allows me to do more than just a simple grid/form data manipulation and will integrate with site contents.

Basically you can integrate every CMS with SC, but is not automatic. Every CMS has it’s own Framework/API, and you have to do things manually. Is not a problem of SC, is the way it works.

The bottom line is that I’m really looking for solutions not the general statements that that it is hard to do.

And I wrote you the way to go.

not the general statements that that it is hard to do.

I hope I didn’t understood you correctly, because, IMHO, I see this statement very disrespectful to whom spend it’s time answering you for Free. I answer when I have time to do it, and I spend the time I have in this moment. If you don’t like our, maybe, “open” answers, you can always hire me/us, thath allows me/us to get the time to give you a complete answer, or the job done, or both. I’m sure this goes for me and Albert and every other active forum member.

But I’m sure, you didn’t wrote what I understood, english is not your native lang, me either, and “chat” sometimes is misunderstood

Actually I think that if you want to integrate SC with any cms you cannot avoid diving into the code. Since Arthur is not a php programmer showing sample code won’t do, he’s looking for an out-of-the-box solution. I don’t have that, and I only can point to possible solutions. If it’s not helpful, then so be it. I described how I integrate E107 and SC and how I transfer CMS data to my SC application.

No Albert I disagree with you (you do not have to dive into coding) or at least not very deep (if at all). I also disagree with you that showing sample will not do!
In this case GIU posted very constructive message which helps not only me but others as well.

So far I used jSCRIPTCASE for Joomla. No coding required. It worked well. The only problem is that development stopped and it is only available for J2.5 but not for 3.5+.
Seems that the same thing happened to WP. The plugin dates 2 years old so it simply looks like not many people want to use SC. Since there is no market then no wonder the plugins die and are abandoned. Albert - I do not want to criticize but your CMS system rates quite low on the CMS list, although it might be god for what you need it.
It is not only the fact that I’m not a PHP programmer (like you) but also the fact that I want things done fast and have no time for tedious coding. We all look for fast solutions - aren’t we ? Therefore we use SC because it allows to do things much faster.

GIU - I really appreciate your time and I say thank you for your post. I just get a bit frustrated when one asks question then the reply says “…it is hard to do” or “I do not know how to do it”. I will try to play with your code sample.

One question now. AFAIK Joomla uses MD5/SALT encryption and so SC so isn’t it enough to use SC library to encode/decode password ?
I remember that SC MD5 generated script have had some bugs and I’m not sure it it has been fixed, but I also remember there was some work around which allowed it to work.

Also - do you know how can I read/pass Joomla session variables to SC App ?

User synchronization is not the only issue and it can be eventually resolved with jFUSSION component. If you use Joomla how you handle situation when the grid shows 20 records, you show the grid through wrapper, then user changes the records per page from 20- to 100 ?
In that case the wrapper will generate scroll bars or truncate part of the grid making all very unprofessional.

If I do not know how to help someone why would I make a post in a first place ? I simply appreciate if those who cannot help or do not know the answer help their posts or opinions to themselves.
I’m also thankful for those who do help in constructive manner. At times I have feeling like some users post messages here just to create traffic but really have no solution.
Anyway I THANK YOU ALL INVOLVED IN THIS TOPIC !

I understand, but think thath sometimes is enough to answer something short, because maybe you don’t want to invest the time.
I mean, FOr what you want, you need:

  • Medium PHP knowledge.
  • Knowledge (or time to invest on study) about how Joomla Framework works.

Maybe, you can/want to do it anyway, maybe not. For this reason, First, is interesting to ask how you want to bet on this.

One question now. AFAIK Joomla uses MD5/SALT encryption and so SC so isn’t it enough to use SC library to encode/decode password ?
I remember that SC MD5 generated script have had some bugs and I’m not sure it it has been fixed, but I also remember there was some work around which allowed it to work.

SC use a simple MD5 conversion. For Joomla, I had to integrate once to validate users from a Mobile Application against a Joomla 1.5 database, and the formula was something like:
MD5(password+salt):salt

I think this changed. And in our last integration against Joomla Database (this time v3), IIRC, we opted to integrate the framework because is not possible on a easy way to calculate outside it.

Also - do you know how can I read/pass Joomla session variables to SC App ?

Maybe an explanation of how you want to achieve exactly could help me to understand you better. Including Joomla framework and use it’s functions is very straightforward.

User synchronization is not the only issue and it can be eventually resolved with jFUSSION component.

Sorry, I didn’t sync users. I just use Joomla Users table directly.

If you use Joomla how you handle situation when the grid shows 20 records, you show the grid through wrapper, then user changes the records per page from 20- to 100 ?
In that case the wrapper will generate scroll bars or truncate part of the grid making all very unprofessional.

This problem don’t comes from Joomla or SC itself. It’s a “web technology” problem. TO integrate a SC grid on a Joomla page, you must do it using iFrames, and iFrames are not responsive per se. There are ways to make iframes responsive, wrapping the iframe into a div. Check this: http://www.smashingmagazine.com/2014…onsive-design/

If I do not know how to help someone why would I make a post in a first place ? I simply appreciate if those who cannot help or do not know the answer help their posts or opinions to themselves.
I’m also thankful for those who do help in constructive manner. At times I have feeling like some users post messages here just to create traffic but really have no solution.
Anyway I THANK YOU ALL INVOLVED IN THIS TOPIC !

Sometimes one answer to not have a 0 answers topic. I don’t like to left a topic with 0 answers if my time allows me to do. I don’t own the complete knowledge, and I can assure sometimes I have to document a lot about the topic before to answer, or test, and so on…, and finnally, my answer sometimes are not concrete. It all depends the time of everyone.You have to understand too thath we don’t know the knowledge of everyone. Maybe I answer something taking into consideration thath who asked has some web development profile. I can’t dive into very concrete answers due to time obviously, but sometimes, I have the time to do it.

And remember:
How to ask for help? If you expect good answers, ask better questions

If you don’t ask concrete questions, is very hard to help, and you will not get concrete answers.

EDITED:

OK Albert - so how can I mix the SC table with the CMS page content ?

I just readed this. To show a grid, for example, on a Joomla Article, you just have to add an HTML iframe tag calling the grid:

[iframe src="path-to-your-project/gridcustomers/" /]

Change [ and ] symbols with < and >

Probably you have to add this code on HTML code view of the WYSIWYG, and you have to give permissions to the user to use iframe tag.

Yes I’m always to busy doing other things to get into Joomla framework details. I know a bit but probably not enough and I do not know PHP (or know very little). Of course I use other programming languages so have general knowledge but PHP is kinda cryptic language and not easy to learn (memorize). At this moment I’m not so concerned about mobile view of the SC Apps in Joomla, although I’m concerned about grid, form sizing. For example if you change the number of records to display in a grid the iFrame does not adjust automatically and the height remains the same making it look bad. There are other issues as well. I was thinking about using some extension for Joomla which allows to paste plain HTML/PHP even stripping CSS (or with CSS), but I haven’t tried that yet so have no results if this would work. I know this is recommended method on Joomla forums.

GIU - how about this. I have a Joomla DEMO site here: http://www.essentialdatabase.com How about creating an example on how to integrate SC with Joomla users table ?
The sample Apps you find on this site use iFrame but the use is limited. I can give you admin credentials to this site and then when it is working I create a video or document how to do it and will share it on NetMake site (or forum). Everybody will benefit. The example would show how to use logged in Joomla username.

Arthur

PS>
personally if there are posts with 0 replies I would rather see no replies instead replies that say “…I do not know the answer, or I haven’t tried it”. IT just creates unnecessary confusion for other people hoping the the question is answered (while it is not). This adds extra clicking and time for the user who searches for the answer. If feels like (not being a doctor) you go to every clinic and hospital and announce “you are not a doctor”.

I must be honest, I feel a bit restrained to answer your questions. Can never be sure if it meets your criteria. But IFrames do not adapt automatically to it’s content. That means that if you have content that is larger then your IFrame you will get scrollbars. Of course I can point you to sites that gives work-arounds but that would require changes in your cms. Since you stated you didn’t want to do that… To others: http://stackoverflow.com/questions/153152/resizing-an-iframe-based-on-content

Yes Albert, that is why I stated from the beginning that iFrames are more like a workaround not the professional solution.