Search found 25 matches

by kevnad
Wed Nov 28, 2018 6:37 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

I did not forget about you ! Just got word back from support, and the solution is very simple... Basically, we need to use double quote instead of single quote (because there's a single quote in the text). and to use double quote in javascript, we need to use the \ as en Escaped character All we nee...
by kevnad
Fri Nov 02, 2018 12:04 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

OK, still a bit "strange" then... You nearly got "lucky" then that this Apostrophe/Single Quote (very common Char in French) only occurs once in the whole JSON File, and only after the Data you are interested in... I don't think your Analysis about the _'_ being treated as a 'Co...
by kevnad
Thu Nov 01, 2018 12:21 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

I test some of your exemple, but anytime I use the EVAL and the problematic character is in the string, then it fail. Must be something in the imacro browser. I will open a support ticket to let them know of this issue. seems like the ' character, once passe in the EVAL statement is seen as a remark...
by kevnad
Wed Oct 31, 2018 12:58 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

I'm trying to use the Search command with a REGEXP and EXTRACT option. Still trying to figure out the REGEX to get everything until the sondage section. I think it might work with that since the ' character will not be present. I'll let you know how it goes! THanks Think I got it SEARCH SOURCE=REGE...
by kevnad
Wed Oct 31, 2018 12:01 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

1- Do you still get the (full) Extract in the 'EXTRACT_TEST_POPUP'...? 2- Does "PROMPT _{{!EXTRACT}}_" work...? 3- Same Qt's with 'EXTRACT=HTM' instead of 'EXTRACT=TXT'...? 4- Does your 'PROMPT' on 'EVAL()' work using 'EXTRACT=HTM'...?: TAG POS=1 TYPE=BODY ATTR=* EXTRACT=HTM SET URL_nav E...
by kevnad
Tue Oct 30, 2018 7:19 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

I know you have not yet finish your post, but wanted to add this information. Even I do "nothing" in the EVAL statement, there still a problem. Like this exemple : TAG POS=1 TYPE=BODY ATTR=* EXTRACT=TXT SET URL_nav EVAL("var s='{{!EXTRACT}}';s;") PROMPT URL_nav:<BR>{{URL_nav}} I ...
by kevnad
Tue Oct 30, 2018 5:03 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

I found that the problem in the line is with the ' character : "texte":"La Caisse C.D. DU VIEUX-LONGUEUIL aimerait avoir votre avis sur l'utilisation de vos données pour vos offres Desjardins.", l ' utilisation I guess this make the rest of the line to be a comment, so that migh...
by kevnad
Tue Oct 30, 2018 12:24 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

My mistake about the Descr1 and 2 not fitting, I had change some stuff in the json that were more confidential. So, with the JSON file I have uploaded, here's the line that is needed : SET Descr_1 "yyyyyy-EOP" SET Descr_2 "C.D. DU VIEUX-LONGUEUIL" SET URL_nav EVAL("var s='{{...
by kevnad
Mon Oct 29, 2018 7:40 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

I found that if I remove this line from the "sondage" section : "texte":"La Caisse C.D. DU VIEUX-LONGUEUIL aimerait avoir votre avis sur l'utilisation de vos données pour vos offres Desjardins.", everything works good! Even if I only remove the weird character (that is...
by kevnad
Mon Oct 29, 2018 7:31 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

The Descr_1 is only one time in the extract So I tried with only this one with this EVAL : SET URL_nav EVAL("var s='{{!EXTRACT}}', d1='{{Descr_1}}', d2='{{Descr_2}}', x,y,z; x=s.split(d1); x;") And if I don't have the new section, it works, but if it's there, it does not. It is something w...
by kevnad
Mon Oct 29, 2018 7:22 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

Here's the extractv2 in zip.

I'll check your answer for all you wrote ;)

but basically, the EVAL was working flawlessly but the change on the page.
by kevnad
Mon Oct 29, 2018 5:56 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

There has been a change in the web page and now the EVAL statement does not work anymore. And whatever I do, I always have an error. I have uploaded extractv2.txt. This is the new extract. Still need the same extraction. If I do the same EVAL from iMacro, I have this error : Error -1250: JScript sta...
by kevnad
Thu Sep 20, 2018 11:53 am
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

yes everything good for now

some tweaking still to do, but I'll get it.

Yes I undertand the EVAL statement and will be able to use that in the future for other situation.

thanks a lot for your help!
by kevnad
Wed Sep 19, 2018 6:05 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

basically, it's because of links that require the mobile app and are not web link when using Internet Explorer, it ask if "do you want to allow this website to open an app on your computer" with the link need to put SET !ERRORIGNORE YES / SET !ERRORIGNORE NO before and after the GOTO and v...
by kevnad
Tue Sep 18, 2018 7:16 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Extracting data of JSON
Replies: 37
Views: 24577

Re: Extracting data of JSON

well the page is actually displayed correctly, but I still get the error. It might something weird in the page itself. This is a mobile site for the mobile apps that we test with imacros. So it might have a few glitch when using imacro browser I'll have people that know the site inside out tomorrow ...