Need a project partner
Forum rules
iMacros EOL - Attention!
The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.
Thank you again for your business and support.
Sincerely,
The Progress Team
iMacros EOL - Attention!
The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.
Thank you again for your business and support.
Sincerely,
The Progress Team
-
- Posts: 69
- Joined: Wed Dec 20, 2017 10:00 am
- Location: New Delhi, India
- Contact:
Need a project partner
Hello iMacros Developers,
I have been working on a project for a while that uses PaleMoon browser with iMacros 8.9.7.
The code is written in Javascript and Google Sheets is used as the database.
I am working on automating form-filling on a job portal. Since job applications are being done on multiple sites, there is a lot of pending work.
Let me know if anyone is interested in helping me with the application. Note that it is a long-term project. For further details, you can send me an email.
Regards,
Vivek Agrawal
I have been working on a project for a while that uses PaleMoon browser with iMacros 8.9.7.
The code is written in Javascript and Google Sheets is used as the database.
I am working on automating form-filling on a job portal. Since job applications are being done on multiple sites, there is a lot of pending work.
Let me know if anyone is interested in helping me with the application. Note that it is a long-term project. For further details, you can send me an email.
Regards,
Vivek Agrawal
Last edited by Tom, Tech Support on Mon Mar 29, 2021 6:46 pm, edited 1 time in total.
Reason: Fixed typo in title
Reason: Fixed typo in title
Robust iMacros development with quick turnaround time. Drop an email at "access2content@gmail.com" with your project details.
Re: Need a project partner
access2vivek wrote: ↑Sun Mar 28, 2021 5:35 pmHello iMacros Developers,
I have been working on a project for a while that uses PaleMoon browser with iMacros 8.9.7.
The code is written in Javascript and Google Sheets is used as the database.
I am working on automating form-filling on a job portal. Since job applications are being done on multiple sites, there is a lot of pending work.
Let me know if anyone is interested in helping me with the application. Note that it is a long-term project. For further details, you can send me an email.
Regards,
Vivek Agrawal
Yep, sounds like an interesting Project indeed..., but hum..., don't you notice the ugly Typo in your Thread Title...? (Corrected in my Reply...)
OK, Good Luck, and post some Update maybe in the Thread once you'll have found your "perfect Partner"...
(I'm not "interested" for myself, I don't do '.js' Scripts, and I'm just "Happy" with helping Users for Free on the Forum... )
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE'/'Trial').
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
- thecoder2012
- Posts: 446
- Joined: Sat Aug 15, 2015 5:14 pm
- Location: Internet
- Contact:
Re: Need a project partner
Without video chat and desktop sharing (except it's required for bugs) ?
I have seen this project request but only with desktop sharing, video chat and more in my last email contact.
Join 9kw.eu Captcha Service now and let your iMacros continue downloads and scripts while you sleep. - Custom iMacros? Contact me!
-
- Posts: 69
- Joined: Wed Dec 20, 2017 10:00 am
- Location: New Delhi, India
- Contact:
Re: Need a project partner
I am not quite sure that I understood what you are asking @thecoder2012. I had asked the owner of the project to contact you, but I don't know any other detail about that interaction.thecoder2012 wrote: Without video chat and desktop sharing (except it's required for bugs) ?
I have seen this project request but only with desktop sharing, video chat and more in my last email contact.
Let me know if you are interested in the project and a way to connect with you. I would be happy to share the demo, code, and everything else with you.
Robust iMacros development with quick turnaround time. Drop an email at "access2content@gmail.com" with your project details.
-
- Posts: 69
- Joined: Wed Dec 20, 2017 10:00 am
- Location: New Delhi, India
- Contact:
Re: Need a project partner
I think I was in a hurry which is why I didn't spot thatchivracq wrote: Yep, sounds like an interesting Project indeed..., but hum..., don't you notice the ugly Typo in your Thread Title...? (Corrected in my Reply...)
Will most definitely update the thread.chivracq wrote: OK, Good Luck, and post some Update maybe in the Thread once you'll have found your "perfect Partner"...
I found '.js' scripts to be more powerful and easier to maintain (Just my opinion). Thank you for always helping people in the forums.chivracq wrote: (I'm not "interested" for myself, I don't do '.js' Scripts, and I'm just "Happy" with helping Users for Free on the Forum... )
Robust iMacros development with quick turnaround time. Drop an email at "access2content@gmail.com" with your project details.
Re: Need a project partner
Google Sheets is used as the database
Can you share code to read data from Google Sheets?
Can you share code to read data from Google Sheets?
Re: Need a project partner
Hum, yep indeed..., I was also "wondering" how you (@OP) had implemented "that"..., so I would be "curious" as well to see that part of your Script...
'Google-Sheets' are always a bit "problematic" to use with iMacros, doesn't "really" work with the "standard" 'TAG' Mode in my "Experience", or you need to use 'EVAL()' to re-isolate all Data Col by Col / Row by Row / Cell by Cell..., which is a bit cumbersome of course...
=> Need to use the 'EVENT' Mode, or the 'TAG XPATH' Mode..., I would think..., or will need to extract/access the Data "directly" from JS with 'getElementByID()' etc..., which will also be a bit cumbersome, I would think...
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE'/'Trial').
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
Re: Need a project partner
if you have a working iMacros code to read google sheets then you can share and I will help you in return in code if you get stuck.
-
- Posts: 69
- Joined: Wed Dec 20, 2017 10:00 am
- Location: New Delhi, India
- Contact:
Re: Need a project partner
Ok, so I use a simple trick to use Google Sheets as the database. I use the Google Apps Script to create two methods - "doGet" and "doPost" to fetch and push data to the sheet. Once the doGet and doPost functions are written (which is pretty simple), you can deploy the script as "web app" and you will get a URL which is used as an endpoint by the iMacros code. The URL would be something like - "https://script.google.com/macros/s/XXXX ... XXXXX/exec".
Here is the Google Apps Script (GAS) code for doGet(). You will need to pass the name of the sheet as the parameter while calling the API with a 'GET' request.
Code: Select all
function doGet(e) {
let sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(e.parameter.sheet);
var data=sheet.getDataRange().getValues();
var headers=data[0];
var output=new Object();
output.row=[];
var row;
for(var i=1;i<data.length;i++)
{
row=new Object();
for(var j=0;j<data[0].length;j++)
row[headers[j].replace(/ /g,"")]=data[i][j];
output.row.push((row));
}
return ContentService.createTextOutput(JSON.stringify(output));
}
Code: Select all
function doPost(e){
var postData = JSON.parse(e.postData.contents);
let sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(postData.sheet);
var input=[];
for(var i=0;i<postData.data.length;i++)
input.push(postData.data[i]);
sheet.appendRow(input);
return ContentService.createTextOutput("OK");
}
Code: Select all
const XHR = Components.Constructor("@mozilla.org/xmlextras/xmlhttprequest;1");
let XHRRequest = XHR();
const api="https://script.google.com/macros/s/XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/exec?sheet="+sheet;
XHRRequest.open('GET',api,false);
XHRRequest.send();
return JSON.parse(XHRRequest.response);
To save data to Google Sheets, you can do the following in iMacros
Code: Select all
const XHR = Components.Constructor("@mozilla.org/xmlextras/xmlhttprequest;1");
let XHRRequest = XHR();
XHRRequest.open('POST',"https://script.google.com/macros/s/XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/exec",false);
XHRRequest.setRequestHeader("Content-Type", "application/json;charset=UTF-8");
XHRRequest.send(JSON.stringify(data));
This way, you can essentially use Google Sheets as a database for storing and retrieving data. I hope that this post becomes a good use-case for the iMacros community.
I know its hard to explain the concept in a thread. But I hope I am able to at least guide you in the correct direction. I hope it helps
Robust iMacros development with quick turnaround time. Drop an email at "access2content@gmail.com" with your project details.
Re: Need a project partner
Thanks.
-
- Posts: 3834
- Joined: Mon May 31, 2010 4:59 pm
Re: Need a project partner
access2vivek wrote: ↑Sun Apr 04, 2021 7:48 pmOk, so I use a simple trick to use Google Sheets as the database. I use the Google Apps Script to create two methods - "doGet" and "doPost" to fetch and push data to the sheet. Once the doGet and doPost functions are written (which is pretty simple), you can deploy the script as "web app" and you will get a URL which is used as an endpoint by the iMacros code. The URL would be something like - "https://script.google.com/macros/s/XXXX ... XXXXX/exec".
Here is the Google Apps Script (GAS) code for doGet(). You will need to pass the name of the sheet as the parameter while calling the API with a 'GET' request.Here is the Google Apps Script (GAS) code for doPost(). You will need to pass the data object as string while calling the API with a 'POST' request.Code: Select all
function doGet(e) { let sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(e.parameter.sheet); var data=sheet.getDataRange().getValues(); var headers=data[0]; var output=new Object(); output.row=[]; var row; for(var i=1;i<data.length;i++) { row=new Object(); for(var j=0;j<data[0].length;j++) row[headers[j].replace(/ /g,"")]=data[i][j]; output.row.push((row)); } return ContentService.createTextOutput(JSON.stringify(output)); }
Now, to fetch the data, you can do something like the following in your iMacros code:Code: Select all
function doPost(e){ var postData = JSON.parse(e.postData.contents); let sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(postData.sheet); var input=[]; for(var i=0;i<postData.data.length;i++) input.push(postData.data[i]); sheet.appendRow(input); return ContentService.createTextOutput("OK"); }
Note: I use the "sheet" parameter to specify the sheet from which I want to read data. This needs to be defined in the doGet function in the Google Apps Script.Code: Select all
const XHR = Components.Constructor("@mozilla.org/xmlextras/xmlhttprequest;1"); let XHRRequest = XHR(); const api="https://script.google.com/macros/s/XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/exec?sheet="+sheet; XHRRequest.open('GET',api,false); XHRRequest.send(); return JSON.parse(XHRRequest.response);
To save data to Google Sheets, you can do the following in iMacros
Note: "data" here is a Javascript object.Code: Select all
const XHR = Components.Constructor("@mozilla.org/xmlextras/xmlhttprequest;1"); let XHRRequest = XHR(); XHRRequest.open('POST',"https://script.google.com/macros/s/XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX/exec",false); XHRRequest.setRequestHeader("Content-Type", "application/json;charset=UTF-8"); XHRRequest.send(JSON.stringify(data));
This way, you can essentially use Google Sheets as a database for storing and retrieving data. I hope that this post becomes a good use-case for the iMacros community.
I know its hard to explain the concept in a thread. But I hope I am able to at least guide you in the correct direction. I hope it helps
Very clever, awesome that you shared this! The only thing I would clarify is that this is not an iMacros-specific solution, and in fact requires no iMacros code at all - it is all being done via Javascript. But otherwise, I understand what you mean when you say "you can do the following in iMacros". It is the iMacros scripting interface that enables the Javascript to load and execute.
Regards,
Tom, iMacros Support
Tom, iMacros Support