Avatar of jana
jana
Flag for United States of America asked on

How can we automate our daily access of our website's daily report

We have a user that everyday has to log to our website and export a specific list.

We would like to know the viability to automate the process of directly accessing the specific web folder, supply the login info and download the CSV file.

Can this be done? Also what should we consider in using for developing?

(Moderator, please reassign question to proper zone if not correctly placed)
Visual Basic ClassicWeb Development SoftwarePHP

Avatar of undefined
Last Comment
jana

8/22/2022 - Mon
vb_elmar

Can you provide an URL?
jana

ASKER
we tried but wasn't authorized.

The first screen has a Login and Password.  The page is joomla and the list page is plain html and php.  The access is via SSL i think and the username is given access via joomla admin page.  Any other question give you more info?  (sorry about not providing the actual link, we know it would greatly help)
vb_elmar

I've found a joomla test page (Login and Password: demo/demo)

http://demo15.cloudaccess.net/administrator

Can you provide the source of your login page if the demo15-page is not the page you need help for?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
jana

ASKER
That is almost the page (our doesn't have the language field).  

The user enters the username and password, then goto couple of clicks to the list page then download the csv.  

We would like somehow, maybe by VB or some other development tool, develop a button on the desktop that when click, it would do all thos process and save the CSV on desktop.
vb_elmar

The snippet below is from the demo page. Is it identical to the page you want to login? If not please post the source.

<p id="form-login-username">
<label for="modlgn_username">Username</label>
<input name="username" id="modlgn_username" type="text" class="inputbox" size="15" />
</p>

<p id="form-login-password">
<label for="modlgn_passwd">Password</label>
<input name="passwd" id="modlgn_passwd" type="password" class="inputbox" size="15" />
</p>
jana

ASKER
yes
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
vb_elmar

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
nanharbison

vb_elmar

@Ramante
Did you try my sample ?
jana

ASKER
Yes.  But the main screen displays as if no web site found.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
vb_elmar

To get my sample (3.zip) to work you have to modify the username and password!
Please try my sample again with the

username/password

demo/demo.
jana

ASKER
Sorry for the delay.    It worked!!!
jana

ASKER
Hi  vb_elmar, it worked!

However, we made a mistake, we told you that the source for the login page was similar of the demo, but is not.  It is a framework.  We are getting the code so we can give it to you for your review.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
jana

ASKER
Ok, got the code for the frame page at the logon.  It's as follow:

<html>



<head>

<META HTTP-EQUIV="PRAGMA" CONTENT="NO-CACHE">

<meta http-equiv="Content-Type"

content="text/html; charset=iso-8859-1">

<meta http-equiv="PRAGMA" content="NO-CACHE">

<meta name="KEYWORDS"

content="sample; sample; sample">

<meta name="DESCRIPTION"

content="sample link">

<title>sample link</title>



<Script Language="JavaScript">

	function limited(days) {  

		var timein = new Date();                          

		var msEnXdays = eval(days) * 24 * 60 * 60 * 1000; 

		timein.setTime(timein.getTime() + msEnXdays);     

		return (timein.toGMTString());  

	}	  

	var search = window.location.search;

	var parametros = window.location.search.split(";");

	var bandera = parametros[0].substring(1, parametros[0].length);

	var indexOf = document.cookie.indexOf("imflat=1");

	var flat = document.cookie.substring(indexOf-1, indexOf+8);

	if(((navigator.userAgent.toLowerCase().match(/iphone/i)) 

		|| (navigator.userAgent.toLowerCase().match(/ipod/i))

		|| ((navigator.userAgent.toLowerCase().match(/android/i)) && (navigator.userAgent.toLowerCase().match(/mobile/i)))

		|| (navigator.userAgent.toLowerCase().match(/blackberry/i))) 

		&& (bandera != "imstr=1")

		&& (flat != "imflat=1")) {

			location.replace("https://mm.website.com:443/IM/view/");

	} else if (((navigator.userAgent.toLowerCase().match(/iphone/i)) 

		|| (navigator.userAgent.toLowerCase().match(/ipod/i))

		|| ((navigator.userAgent.toLowerCase().match(/android/i)) && (navigator.userAgent.toLowerCase().match(/mobile/i)))		

		|| (navigator.userAgent.toLowerCase().match(/blackberry/i))) 

		&& bandera == "imstr=1") {

			var newURL = window.location.href.substring(0, (window.location.href.indexOf("?")-1)); 

			//document.cookie = "imflat=1; path=/; secure";

			document.cookie = "imflat=1;";

			window.location.href = newURL;

	} else {

		document.cookie = "imflat=1;expires=" + limited(-1) + ";" + ";";

		var flagConnec=0;

		var flagBiblio=0;

		var flagAmbiente=0;

		var flagContenido=0;

		var flagListas=0;

		var PERL_RUTE = '/perl/';

		var PLSQL_RUTE= '/website/website/';

		var JAVA_RUTE= '/Servlet/'; 

		//var PERL_RUTE = '/Perl_bsampleLAT/';

		//var PLSQL_RUTE= '/sampleSA/samplesa/';

		//var JAVA_RUTE= '/Servletsamplesa/'; 

		function setLoaded(){

			if(flagContenido==1){

				if ((flagAmbiente==1) &&(flagListas==1))

					top.contenido.desplegar();  

			}    

		}

	}	  

</script>

</head>



<frameset framespacing="0" border="false" frameborder="0" cols="800,0,0">

    <!--frame scrolling="no" noresize src="websitebg.html"-->

    <frame name="contenido" scrolling="auto" noresize src="genDoc2.html">

    <frame name="titular" scrolling="no" noresize src="gen-titul.html">

    <frame name="listas" scrolling="no" resize="no" src="ib-listas.html">

    <noframes>

    <body bgcolor="#FF8000" text="#FFFFFF">

    <p align="center">&nbsp;</p>

    <p align="center"><font color="#000000" size="3"

    face="Verdana, Arial, Helvetica"><strong>bsample sampleHSA</strong></font></p>

    <p align="center"><font color="#FFFFFF" size="3">sample

    Browser</font></p>

    <div align="center"><center><table border="0" cellpadding="2"

    cellspacing="0" width="70%">

        <tr>

            <td align="middle" valign="top"><p align="center"><font

            size="1" face="Verdana, Arial, Helvetica, sans-serif">it

            recommended 3.0 o superior 

            navegator<br>

            Microsoft Internet Explorer o Netscape Navigator.</font></p>

            </td>

            <td valign="top" height="70"><p align="center"><img

            src="/images/ieget_animated.gif"

            alt="Internet Explorer" width="88" height="31"></p>

            </td>

        </tr>

    </table>

    </center></div><p>&nbsp;</p>

    <p>&nbsp;</p>

    </body>

    </noframes>

</frameset>

</html>

Open in new window