Log in website, navigate trough menu, insert data, click button, export table

**323428** · 06-21-2017, 11:46 AM

Hey all,

I can't get it done, I ll update this thread (post #1) when i find a solution to any subject as listed here.

1. Log in website

Please Login or Register  to view this content.

2. Navigate trough menu

Dienstrooster - mijn rooster.png

3. Insert data

Datefrom - dateto.png

i got the following code, but cant see if it works yet because i fail at point 2.

Please Login or Register  to view this content.

4. Click button to change list style
click the button "Toon als lijst" as in the picture at point 3.

5. Export table

Export to excel.png

**323428** · 06-22-2017, 12:27 PM

Also appriciated if you only know how to solve step #2.

**323428** · 06-23-2017, 11:12 AM

Bump this thread, if i need to specify more info let me know please

**323428** · 06-25-2017, 09:43 AM

I would really appriciate help, even willing to pay for the solution. Pm me if interested

**323428** · 06-26-2017, 01:44 AM

Good morning all, there must be someone who knows how to solve this issue? Or is this site unable to automate?

**323428** · 06-27-2017, 02:00 PM

Bump this thread

**323428** · 06-28-2017, 09:32 AM

bump this thread

**323428** · 06-29-2017, 12:56 PM

bump this thread

**323428** · 06-30-2017, 10:22 AM

Bump this thread

**323428** · 06-30-2017, 06:14 PM

bump this thread

**323428** · 07-01-2017, 08:43 AM

bump this thread

**rpdDrp** · 07-01-2017, 09:28 AM

I dont know if the suggestion will help your case/problem at hand & i am not promoting, agent or otherwise but
take a look at this:
https://www.youtube.com/playlist?lis...VL4sWRWICj_clM

more specifically Video 48 & 49.

Again sorry to moderators for suggesting a youtube video, instead of trying to come up with solution.

**Kyle123** · 07-01-2017, 09:38 AM

You're checking the name property, you should be using getelementbyid

**323428** · 07-01-2017, 11:10 AM

Originally Posted by rpdDrp

I dont know if the suggestion will help your case/problem at hand & i am not promoting, agent or otherwise but
take a look at this:
https://www.youtube.com/playlist?lis...VL4sWRWICj_clM

more specifically Video 48 & 49.

Again sorry to moderators for suggesting a youtube video, instead of trying to come up with solution.

Thanks for your input, ill take a look at this later today and get back to you

Originally Posted by Kyle123

You're checking the name property, you should be using getelementbyid

The click items dont have ID's, or atleast i dont have acces to them.
getelementsbyname works for the login part.
i just cant figure how to click "Dienstrooster" and "mijn rooster" after that.

**Kyle123** · 07-01-2017, 11:15 AM

Don't click them, just fill them in, they're text boxes

**323428** · 07-01-2017, 11:18 AM

Originally Posted by Kyle123

Don't click them, just fill them in, they're text boxes

I can fill the text boxes but then i need to click the links as in the picture. They are marked orange and red

**Kyle123** · 07-01-2017, 11:42 AM

Sorry, I don't follow. Can't you just fill in the date fields and submit the form?

**323428** · 07-01-2017, 12:12 PM

Originally Posted by Kyle123

Sorry, I don't follow. Can't you just fill in the date fields and submit the form?

To get there i need to log in, and navigate to the right table where i can fill in the dates and submit the form.

I cant go straight to the right table because every login the site creates an Unique ID.

**Kyle123** · 07-01-2017, 12:16 PM

I understand that you need to log in. You've got that covered haven't you? Is the form in the page before you click the links and just hidden? It would appear that it is, you don't need to be able to see the text boxes to fill them in and submit the form

**323428** · 07-01-2017, 12:21 PM

Im not sure what you mean but i think the form isnt there straight after login. Check your pm

Edit: Yes i got the login working

**323428** · 07-02-2017, 02:50 PM

Originally Posted by Kyle123

I understand that you need to log in. You've got that covered haven't you? Is the form in the page before you click the links and just hidden? It would appear that it is, you don't need to be able to see the text boxes to fill them in and submit the form

The form is not in the page after login, i need to click the link in the menu to get there.

**323428** · 07-04-2017, 07:34 AM

Originally Posted by Kyle123

I understand that you need to log in. You've got that covered haven't you? Is the form in the page before you click the links and just hidden? It would appear that it is, you don't need to be able to see the text boxes to fill them in and submit the form

i understand your question now. the URL shows the same on every page, this is not the case. the URL changes and the form is on a different page, the problem is every visit the site gives me an unique ID which is in the URL aswell if i would navigate to that URL directly it would not open because its valid for 1 visit.

the menu in in a different frame which i think i need to refer to, i just didnt figure out how to do it.
brookhuis 1.png

brookhuis 2.png

**323428** · 07-06-2017, 04:16 AM

Bump this thread

**323428** · 07-07-2017, 11:35 AM

Bump this thread

**323428** · 07-07-2017, 10:28 PM

Bump this thread

**323428** · 07-08-2017, 07:55 PM

Bump this thread

**Chippy** · 07-09-2017, 06:28 PM

Originally Posted by 323428

i just cant figure how to click "Dienstrooster" and "mijn rooster" after that.

Your last post shows those links are in a frame named "menu", therefore try this:

Please Login or Register  to view this content.

And similarly for the "Mijn rooster" link.

The above code uses named classes in the MS HTML Object Library, so you must set a reference to that library - click Tools then References in VBA.

**Chippy** · 07-09-2017, 06:29 PM

Duplicate post deleted.

**323428** · 07-15-2017, 05:35 PM

Originally Posted by Chippy

Your last post shows those links are in a frame named "menu", therefore try this:

Please Login or Register  to view this content.

And similarly for the "Mijn rooster" link.

The above code uses named classes in the MS HTML Object Library, so you must set a reference to that library - click Tools then References in VBA.

Sorry for the late reply, will try this tommorow and get back to you

**323428** · 07-16-2017, 08:43 AM

it gives compile error at this part

Please Login or Register  to view this content.

Type's do not match is the error.

**323428** · 07-20-2017, 11:05 AM

Anyone knows why?

**323428** · 07-21-2017, 03:23 AM

Bump this thread

**323428** · 07-21-2017, 08:18 PM

Bump, still didnt figure why it errors at .links

**323428** · 10-18-2017, 08:43 AM

Originally Posted by 323428

it gives compile error at this part

Please Login or Register  to view this content.

Type's do not match is the error.

Cant get this part to work

**323428** · 10-18-2017, 04:23 PM

Bump this thread

**323428** · 10-19-2017, 10:03 AM

i could give my login credentials if it helps to inspect the site

**323428** · 10-19-2017, 03:48 PM

the selected bit is what i am trying to click.

Knipsel.PNG

**323428** · 10-21-2017, 01:36 PM

Originally Posted by 323428

the selected bit is what i am trying to click.

Attachment 543552

Anybody knows how? I cant refer to the link because every login i get a Unique sesion ID

**323428** · 10-21-2017, 06:51 PM

If you know this is impossible please also let me know, then ill stop searching

Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Re: Log in website, navigate trough menu, insert data, click button, export table

Thread Information

Users Browsing this Thread

Similar Threads

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions