There are 3 projects, which are complementary but independent (but the project 3 will be carried out if projects 1 and 2 are successful)
This involves working on a job offer flow: either to create another flow, or to integrate the flow into an excel spreadsheet.
PROJECT 1 :
- Create a new TARGET RSS feed based on one (or 2) existing SOURCE RSS feeds, but filtered on the exact criteria requested (criteria to be communicated). The SOURCE RSS feed (a series of job postings constantly updated in real time)
- Format the HTML description part of the TARGET RSS feed (using the formatting of a SOURCE RSS feed) to enable the customer to send a formatted e-mail every day (this part of the e-mail is just for IT purposes to explain the need) via Microsoft's powerautomate.com tool (the customer's environment is Microsoft).
- Development to provide a URL like: https://domaine.fr/fa/rss
- Back and forth for correction/validation
- Start-up, hosting on the customer's server corresponding to his technical environment (question to ask yourself, for example, at the start of the project: which server do I need to store the development? and can it run on the customer's environment?)
See specifications in attach files : Specifications_Feed 1_En_vFinale.pdf
PROJECT 2 :
- Scraping of email addresses (+ employer field) contained in the following SOURCE RSS feed : https://www.emploi-territorial.fr/rss?
(this SOURCE RSS feed is a series of job advertisement publications constantly updated in real time).
This scraping is used to insert the e-mail addresses into a Microsoft Excel spreadsheet stored on the customer's Sharepoint.
- Technical constraints: automatically update a Microsoft Excel spreadsheet online in the Microsoft environment from a URL pointing to the file, using the customer's SharePoint API keys to write to the target file.
- Take into account the following processing after scraping in Excel :
- Structure the file in Tab 1 with 4 columns: e-mail (column A), e-mail identifier before @ (column B), e-mail domain with @ in front (column C), employer field information in the feed (column D).
- Cleans up duplicates in column A with the list of emails created each time the excel file is completed.
- Update frequency: every 6 hours (starting at 8am - Paris time - for the first cycle, then every 6 hours). Cumulate information already in the file with new information (cumulative update)
- A tab 2 contains in column A a manually updated dynamic list of e-mail domains (with the @ in front): delete in tab 1 all lines whose column C corresponds to an e-mail domain in column A of tab 2.
- Correction/validation back and forth
- Start-up, hosting on the customer's server corresponding to his technical environment (question to ask yourself, for example, at the start of the project: which server do I need to store the development? so that it can run on the customer's environment?)
See specifications in attach files : Specifications_Feed 2_En_vFinale.pdf
PROJECT 3 :
- Scraping of 4 data items contained in one (or 2) existing RSS SOURCE feeds, but filtered according to the exact criteria requested (exclusion criteria to be communicated by the customer: criteria identical to the "Project 1" requirements described above).
(this RSS SOURCE feed is a series of job postings constantly updated in real time). This scraping is used to insert the data into a Microsoft Excel spreadsheet stored on the customer's Sharepoint.
- Technical constraints: automatically update a Microsoft Excel spreadsheet online in the Microsoft environment from a URL pointing to the file, using the customer's SharePoint API keys to write to the target file.
- Take into account the following processing after scraping in Excel :
- Structure the file with 13 columns: publication date (column A), employer name (column E), position name (column F), e-mail (column G), position URL (column H) - the other empty columns (at the head of the file in line 1, not to be touched).
- Update frequency: automatic every 24 hours (from 8 a.m. Paris time). Cumulate information already in the spreadsheet with new information (cumulative update)
- Correction/validation back and forth
- Start-up, hosting on the customer's server corresponding to his technical environment (question to ask yourself, for example, at the start of the project: which server is needed to store the development? and can it run on the customer's environment?)
See specifications in attach files : Specifications_Feed 3_En_vFinale.pdf
We'll take the time to explain and answer your questions!
Thank you
Hourly Range: $10.00-$40.00
Posted On: August 12, 2024 18:12 UTC Category: Data Extraction Skills:Data Scraping, Data Extraction, API Integration, Microsoft Excel, RSS, Developmental Editing, Automation
Skills: Data Scraping, Data Extraction, API Integration, Microsoft Excel, RSS, Developmental Editing, Automation Country: FRA
click to apply
Project ID:
3432682
Project category:
Data Scraping, Data Extraction, API Integration, Microsoft Excel, RSS, Developmental Editing, Automation
Remote Job Application Specialist Category: Admin Support, Appointment Setting, Customer Service, Data Entry, Excel, Real Estate, Technical Support, Time Management, Virtual Assistant, Web Search Budget: $2 - $8 USD
14-Aug-2025 04:03 GMT
Data Analyst for Insight Generation Category: Data Analysis, Data Analytics, Data Visualization, Power BI, SQL, Statistical Analysis, Statistics Budget: ₹750 - ₹1250 INR
14-Aug-2025 04:03 GMT
Professional Dashboard Creation Category: API, Data Analysis, Data Visualization, Data Warehousing, Excel, Power BI, Statistical Analysis, Statistics Budget: ₹600 - ₹1500 INR
14-Aug-2025 04:03 GMT
Estratega de Ventas en Redes Sociales Category: Content Creation, Digital Marketing, Facebook Marketing, Instagram Marketing, Internet Marketing, Marketing, Social Media Management, Social Media Marketing Budget: $250 - $750 USD
14-Aug-2025 04:02 GMT
n8n Workflow Configuration Expert Category: API Integration, Automation, Data Collection, Data Management, N8n, Process Automation, Project Management, Scripting Budget: $10 - $30 USD
14-Aug-2025 04:00 GMT
Mobile Application Development Needed Category: Android, API Development, IOS Development, IPhone, Logistics, Mobile App Audit, Mobile App Development, Mobile App Testing, Mobile Development, PHP Budget: ₹250000 - ₹500000 INR
14-Aug-2025 03:59 GMT
Store Account Registration Assistant Category: Account Management, Admin Support, Customer Service, Customer Support, Data Entry, Data Management, Internet Marketing, Virtual Assistant Budget: $30 - $250 USD
14-Aug-2025 03:57 GMT
Colorful Profit Tracking Android App Category: Android, Android App Development, Android SDK, Graphic Design, Mobile App Development, UI / User Interface, User Experience Research, User Interface / IA Budget: ₹600 - ₹1500 INR
14-Aug-2025 03:57 GMT
3D Animated Adventure Video Category: 3D Animation, 3D Design, 3D Layout, 3D Modelling, 3D Rendering, 3D Rigging, After Effects, Animation Budget: $10 - $30 USD
Tech Training Services Digital Marketing Category: Digital Marketing, Email Marketing, Facebook Marketing, Internet Marketing, Lead Generation, Search Engine Marketing (SEM), Social Media Marketing, Twitter Budget: ₹1500 - ₹12500 INR
14-Aug-2025 03:56 GMT
Modern Minimalist Logo Design Category: Adobe Illustrator, Photoshop, Creative Design, Design, Graphic Design, Illustration, Logo Design Budget: ₹12500 - ₹37500 INR
14-Aug-2025 03:56 GMT
Lawsuit Assistance Required Against Lazada in Mabalacat Category: Legal, Legal Analysis, Legal Assistance, Legal Consultation, Legal Research, Legal Review, Legal Writing, Litigation, Proofreading, Research Writing Budget: $30 - $250 USD
14-Aug-2025 03:56 GMT
Virtual Personal Assistant Category: Customer Support, Internet Marketing, IPhone, Testing / QA, Virtual Assistant Budget: $30 - $250 USD
