Rename multiple tables in sql server jobs
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium...
...new Linux STAGING ONLY server. 1) Linux staging server setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the ...
...for seamless remote control of ventilation systems. The ability to work across multiple platforms is essential as the application needs to be compatible with iOS and Android devices, as well as Windows computers. Primary Features: - Timer scheduling - Remote control of ventilation systems - Monitoring parameters including temperature, humidity, twilight, and weather - Real-time notifications and alerts - Scheduling system actions - Support for multiple users simultaneously Given the sensitive nature of the data and operations, the application must be secure. Your work will involve implementing advanced encryption to safeguard our communications and data. The ideal candidate for this project should be proficient in mobile and desktop application development, with ...
...WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. To qualify you must be full stack and work PROFICIENTLY with gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plu...
I'm looking for an expert in Fast Fourier Transformation and/or Wavelet Analysis to transform temperature readings into a frequency/bpm output. This project is intended for a research project I am undertaking. I am looking to see if FFT/Wavelets are able to produce acurate bpm readings so there is not definitive method to follow which is why I require your help/ Key requirements include: - Utilizing Fast Fourier Transformation and/or Wavelet Analysis to transform the raw temperature data. (Data is in the form of multiple .csv files with temperature readings and time stamps). Ideal skills for this project include: - Proficiency in Fast Fourier Transformation and Wavelet Analysis. - Strong command of R programming language for generating the output in...
I'm in search of an experienced and creative detective story writer. I'm keen on a mystery genre with a narrative that unfolds from multiple perspectives. The story must include: - Unexpected plot twists to keep readers engaged - Detailed environment description that appeals to the senses and begs readers to explore more - In-depth character development that makes readers emotionally invested Expertise in writing multi-dimensional characters and masterful world-building is a must. Proven history of captivating plot creation is a bonus. Please include writing samples, particularly those showcasing your ability to interweave plot twists and rich environment depiction. Your work should demonstrate mastery in sustaining suspense and developing int...
...video of raw footage. A document will be provided with all instructions what to add in stock footage, text animation, transitions etc. all the stock footages will all provided by me. I will provide this for both Instagram reel send YouTube video. I will also send you subtitles file for Instagram reel. You only have to follow the instructions and first send me the first draft of edited video. I will tell you the required changes in the video. After doing all the changes you have to send me the project file. The changes will be only 1 time not multiple times. REQUIREMENTS ADOBE PREMIERE PRO EXPERIENCE IN INSTAGRAM AND YOUTUBE VIDEO EDITING. TIMELY DELIVER VIDEO. REPLY AS SOON AS POSSIBLE. I have multiple number of clients and you have to wor...
I'm in search of a skilled Backend Node.js developer, proficient with , to manage two key aspects of a project. Key Responsibilities: - **Database Design and Implementation**: Your primary task will be to design and implement a database system. I prefer PostgreSQL, so experience with this DBMS is a must. - **API Development and Integration**: The project requires a complex API development and integration task. You should be comfortable dealing with multiple endpoints and third-party integrations. Ideal Candidate: - Proficient in Backend Node.js development with a focus on - Prior experience in designing and implementing PostgreSQL databases - Proven expertise in developing complex APIs with multiple endpoints and third-party integrations...
...life my brand’s unique identity and vision. Here are some key points about the project: The business is in Alice Springs so logo with outback and aboriginal feeling Please see the attached file for one logo i really like - Purpose: The logo should encapsulate our brand identity and visually enhance our website. In addition to the website, the logo may be used for different functionalities, which underscores the need for a versatile and scalable design. - Skills and Experience: Prior experience in logo design is essential. Please include examples of your past work in your application to demonstrate your competence and creativity. Experience in creating logos for websites and multiple platforms would be desirable. - Color Preference: ...
I'm looking for a skilled developer to help integrate the DropzoneJS library into my project in full. I have integrated demo vesrion only. The primary goal is to improve the user experience by allowing for drag and drop functionality for file uploads. Key Requirements: - Implementation of drag and drop functionality using DropzoneJS - Ensuring DropzoneJS supports multiple file uploads at once - Do not need integration within the existing project structure. PHP Upload script working just fine. - Adherence to best practices for user interface design and user experience Ideal Skills and Experience: - Proficiency in JavaScript and relevant libraries, particularly DropzoneJS - Proven experience with front-end development and UI/UX design - Ability to integrate new f...
I'm in need of a professional who can perfectly format my 100-page Word document. The document requires: - Adjusting the page layout - Ensuring consistent and appealing font styles and sizes are used throughout - Ensuring all tables are well-formatted and visually appealing In your application, please focus on showcasing your experience in Word document formatting. I don't need any graphics or images inserted into the document, just a clean and consistent format.
I need an experienced video editor to regularly produce high-quality and engaging video content for my social media channels, including LinkedIn, Online courses, website and Only Fans (If you are not comfortable with male nudity or medical procedures, this is not for you) We have multiple businesses and multiple channels: - One is a day spa - One is an injectables clinic - One is a penis Enlargement Medical Clinic - We will provide: Footage - Broken down in Dropbox folders Guidelines - As per Australian medical guidelines Ideas - List of ongoing topic ideas - Video Editing Needs: I require advanced video editing services, focusing on tasks like color correction and incorporating some special effects. Slight background music and some subtitles. - Timeline: The wor...
I'm seeking a skilled Senior Python Developer to assist with a project that involves a blend of web scraping and data analysis, with a focus on the following tasks: - Extracting data from multiple websites - Automating data extraction and parsing - Analyzing and visualizing scraped data The ideal candidate should have: - Proficiency in Python, with a strong understanding of AI and Machine Learning - Hands-on experience with web scraping, particularly working with diverse data sources - Ability to automate data extraction and processing efficiently - Adept at data analysis, with the ability to visualize and interpret data Although I haven't specified any particular tools or libraries, your familiarity with tools like BeautifulSoup, Scrapy and Selenium would be a bo...
I need a graphic designer who can handle multiple design tasks. Key Responsibilities: - Photo Editing: Enhancing and retouching images for both web and print. - Logo Design: Creating unique and professional logos. - Video Editing: Editing and enhancing video content for various platforms. There are no specific style requirements provided, so the ideal candidate should be versatile and able to adapt to different aesthetics. Please note that the specific requirements for the design tasks, such as color schemes, typography, and image resolution, will be communicated to you on a project-to-project basis. Skills and Experience: - Proficiency in Adobe Creative Suite (Photoshop, Illustrator, Premiere Pro). - Proven experience in photo editing, logo design, and video ed...
Field updation in promosion and rename field and allow promotion based on condition.
I am looking for a proficient software developer to build an all-inclusive student fee management software. Key Features: • Ability to track multiple types of student fees • Capability to generate detailed fee reports • An automated reminder system. The software must smoothly integrate with our existing systems which include the school management system, attendance system, and our accounting software. Ideal Skills: • Experience in educational software development • Strong background in systems integration • Skilled in automation and report generation.
...media manager to push my online presence on multiple platforms, making my brand more visible, generating leads, and forging stronger connections with our audience. The platforms to be managed include Facebook, Instagram, Pinterest, Youtube, and LinkedIn. Operating as much more than just a 'poster of content', the ideal candidate will also: - Create unique and engaging content that resonates with our audience. - Foster an active and engaged community, responding to comments, and driving discussions. - Provide analytics and reporting to monitor the success and reach of different content types and campaigns. The ultimate goal of this project is to generate leads. Therefore, special consideration will be given to those with a proven track record in converting socia...
Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking
I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription
...need a talented artist to create multiple political cartoons for a book I'm compiling. Your work must revolve around: - Political figures - Social issues - Satire These cartoons need to be impactful and carry a strong message related to the above themes. It's essential that you have a good understanding of how to use humor and satire to convey political and social commentary. Cartoons will be reproduced as: - Digital images - Printed illustrations I'm looking for a variety of styles – some cartoons should be in color, others in black and white. Ideal Skills: - Proficient in creating political cartoons - Comfortable with satire and humor as mediums to depict social commentary - Able to deliver in both digital and print...
...for a substantial number of products across multiple listed stores. - Avoiding Captcha and ad blockers: The tool should be designed to function effectively while avoiding common barriers like Captcha or ad blockers. - User-friendly filters: The tool should offer a variety of filters to help users refine their search results. - Display results directly on product pages: The comparison results should be integrated and displayed on the corresponding product pages. Or through a widget function. Project Scope: - Estimated 3,000 to 8,000 pages: The tool should be scalable enough to handle a substantial number of pages, ensuring it can support the growth of our product database. Ideal skills and experience for this project include: - Proficiency in web scraping and data p...
...will track product sales of multiple teams. This tool should conveniently reside on the same platform as my Shopify site and include a user-friendly dashboard with comprehensive sales data. Key Features: - Monitor sales from multiple teams at the same time, similar to the setup on Poppinpopcornonline.com. - User dashboard should display various metrics: * Total sales per team * Highest selling products per team * Breakdown of individual contributions per team and top three highest sellers * Top selling products for each team member * Ability for the individual team member to share their link via email and social media Ideal Candidate: - Proficient in Shopify development - Experience with integrating and/or building sales tracking tools - Skilled in...
I'm in urgent need of a skilled Webflow developer to retouch 5 websites. The work primarily involves adjusting the layout and spacing, and updating content and images. I need this project completed ASAP. Key Requirements: - Proficiency in Webflow: You must have a solid working knowledge of Webflow to efficiently retouch the websites. - Design Skills: Experience in web design and an eye for aesthetics to ensure the changes enhance the overall appearance of the websites. - Timeliness: As this is an urgent project, the ability to work quickly without compromising on quality is crucial. This is a great opportunity for a talented Webflow developer to showcase their skills and deliver impactful changes to multiple websites.
I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.
I am in need of a professional photographer who specializes in furniture photography. I have an apartment that I plan to host on Airbnb and require detailed, high-resolution photos of various furniture including chairs, tables, and sofas. This is a 1-2 rooms apartment, and it's essential to have photographs of every area, including the kitchen and bathroom. • Proven photography experience, especially in furniture photography • Ability to create attractive shots that capture the details • Experience in editing photos will be advantageous. • Responsibility to care for the furniture while working around it. • Proficient in effectively utilizing lighting to accentuate the aesthetics of the furniture. I want the potent...
I'm in need of a unique logo to represent my new educational institute that caters to international students, predominantly high school graduates. The logo should convey a modern feel, while remaining sophisticated and appealing to a younger audience. Key points: - The logo should be designed with multiple colours, reflecting diversity and the international theme - A modern, sleek and professional style is crucial - Considering the target audience, the design should be youthful but not overly playful Ideal skills and experience: - Proven experience in designing corporate, professional logos - A track record of creating appealing designs for young audiences - Understanding of colour psychology and its impact on different demographics, particularly high school gr...
I am in need of a skilled software engineer to develop a DICOM printer server software. This software should: - Be compatible with Windows operating system. - Have the capability to print to HP, Canon, and Epson desktop printers. - Support image printing and multiple printer use. Ideal candidates for this job should have strong experience in software engineering and a solid understanding of DICOM features. Familiarity with printer server software is a must, as is the ability to ensure compatibility with named printer brands and operating systems.
Information Collection on Vehicle Charging Systems <Request> Please collect product information of cars equipped with the technology explained in the “2. Technology Description” section below. *Note Do not collect information only based on the information listed in “1. Background” and “3. Reference Information” (Sections 1 and 3 are for reference only) 【1. Background】 This technology is related to vehicles and charging systems. Various proposals have been made for charging systems where the power storage device installed in the vehicle is charged. For example, in a certain charging system, an emergency stop button is provided on the charging device. As a result, the user can stop the charging device by pressing the ...
I'm looking for a Shopify expert to create a site that accommodates multiple pricing factors in order to sell my products online, while also ensuring that the design is consistent with my existing brand assets. Key requirements and considerations for the project include: - **Multiple Pricing Handling**: You will need to create a mechanism that can adjust product pricing based on various inputs like length, cuts, price per metre, and customer location. This is crucial for managing the diverse pricing needs of my business. - **User-Friendly Interface**: The site should be intuitive and easy for customers to navigate, select their desired product configurations, and see the corresponding pricing. - **Existing Brand Assets**: The design must align with my current br...
...Identify when there is any change in the DIV section of the webpage (every "x" seconds) and notify me of the change. It is not necessary to show what the change was. Just send the hyperlink by Telegram, including the subject of the flow. Requirements: Create a Node-Red project that can detect changes on multiple websites by creating flows. Include 2 example flows to demonstrate how the monitoring works. Provide detailed instructions on how to create a new flow for a different webpage, indicating what needs to be extracted/copied to set up the new flow. For example, on this web page, by pressing F12, you can see that the section to monitor for changes is the one highlighted in blue. What I need to know is which HTML code should be copied from the websi...
...difficulties with Hubspot, I'm interested on bringing in a seasoned and strategic freelancer for the task. Key Challenges: - Custom forms: clients details aren't saving correctly. If they are a repeating guest who have filled out this form in the past, their forms are coming up blank. - Email Database: Our email marketing campaigns are currently not as efficient due having no tags Your main tasks will include: - Rectifying form issue: providing a solution for why the clients cannot submit a form and why their details arent showing up. - Email database: upload our database into hubspot and create tags (location, birthdays, type of event, type of package they have previously booked in for) Our Goals: - Custom form: Clients can fill the form out multi...
I'm searching for a skilled individual who can help me scrape data from a website. The data I'm interested in is text content and tables, specifically contact information. Ideal Skills: - Proficiency in web scraping tools - Strong experience with scraping text content and tables - Expertise in extracting specific information - Familiarity with structured data formats The contact information on the website is in a structured format. Your ability to navigate this and provide me with a clean, organized dataset will be crucial. Looking forward to collaborating with a detail-oriented and reliable professional. Attached is a sample format. The site is: Final file must contain all records for all schools on all pages
I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offe...
I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.
As we're working with Salesforce Enterprise edition, I'm in need of a seasoned Salesforce developer who can step in and assist with various aspects of my current project. This project involves a high level of complexity, including advanced customisations and integrations with other systems. Key Tasks: - Customisation of objects and fields: This will require a deep understanding of how our organisation operates and what data is critical to our processes. You will need to not only create custom objects and fields, but also ensure they are integrated seamlessly into our existing Salesforce platform. - Workflow automation: Our goal is to streamline as many of our business processes as possible. Your role will be to identify areas that can be automated and implement th...
...supports multiple user roles, including admin, user, and guest. - Database Integration: The pages need to be connected to a database for smooth data handling and storage. - Payment Gateway Integration: I am specifically looking to integrate crypto payments into the system. - Header and Footer Pages: Each page needs to have well-structured, reusable header and footer components for consistency. Ideal Experience: - Proficient in Laravel framework - Strong understanding of database management - Extensive experience in payment gateway integration - Previous work on multi-role user systems Please feel free to send me your portfolio and any previous work you've done that is relevant to this project. It would be great if we could discuss your proposed approach an...
I'm looking for a qualified attorney to represent me as I seek justice for multiple types of fraud that were committed against me in Pennsylvania. I currently possess considerable evidence and documentation supporting my claims. Core Legal Matters: - Deprivation of rights under color of law - Executor fraud - Conspiracy to commit estate fraud - Real estate fraud - Tax fraud - Mail and wire fraud This case will involve local court proceedings. Therefore, experience and capabilities in this environment are essential. Ideal Skills: - Expert knowledge of estate and real estate law - Previous experience with fraud cases - Proven track record of successful litigations - Ability to work in local court proceedings in Pennsylvania I'm highly moti...
I'm looking for a Python develop...developer to help me set up a VONAGE API to send SMS messages. Key Project Details: - The main functionality I need is to set up the ability to send SMS messages. - The application should be efficient, reliable, and easy to use. - I'm not yet sure if I need two-way communication or if the application will need to support sending messages to multiple countries. Skills and Experience: - Strong experience working with VONAGE API is a must. - Proficiency in Python, with a focus on SMS messaging. - Ability to create a reliable and user-friendly application. - Familiarity with creating two-way communication systems and international messaging support would be an advantage. If you're a Python developer with VONAGE API experience...
I am in need of a service program that can effectively manage multiple accounts across various music streaming platforms. Here's a detailed overview of the project requirements: - Focused Platforms: The program should primarily target Spotify, Apple Music, Amazon Music, and Tidal you tube - Key Tasks: The program should be able to increase followers and streams, manage playlists, and track analytics on the said platforms. - Multiple Account Management: It's critical for the program to efficiently switch between different accounts on these platforms. - Automation: I'm looking for automation in scheduling posts and activities to ensure consistent engagement and growth. - Analytics Integration: The service program should have robust analytics integr...
...daily responsibilities. Hindi and English language are needed. Key Responsibilities: - Scheduling appointments: You'll be in charge of managing my appointments and ensuring they do not overlap. - Managing emails and correspondence: Your role will include managing my email inbox and responding to certain emails on my behalf. - Research and booking travel arrangements: You'll need to research the best travel options and accommodations for my trips and manage the booking process. This is a part-time job requiring less than 10 hours a week. A background in administrative tasks and excellent organizational skills are essential. Fluency in multiple languages and experience in customer service are a plus but not mandatory. I'm looking for...
I'm seeking a professional with experience in resolving Google Play account suspensions due to content policy violations. Key Project Details: - My account was suspended due to multiple violation of the content policy. - I have already reached out to Google for support. - I have received some documentation from Google regarding the violation and steps for reinstatement, but it's quite limited. Your Role: - Your primary role will be to guide me through the reinstatement process with Google, ensuring that all necessary steps are taken. - It's important that you have a clear understanding of the Google Play content policy and a track record of successfully reinstating suspended accounts. Ideal Skills and Experience: - Proven experience in handling Goog...
I'm in search of a full-stack developer to join me in building a scalable, multi-tenant web application. The project requires expertise in Golang and React for back-end and front-end development, respectively. Ideal Candidate: - Proficient in Golang, JavaScript (React) - Skilled in Cassandra, OKTA - Experience with Docker, Kubernetes - Familiarity with Google Cloud Platform -Apply with Github and sample projects The project entails creating a robust, multi-tenant web application that can handle multiple users with varying requirements. It is imperative that the selected developer is competent in ensuring the application's scalability and reliability. If you have previous experience building similar applications, please don't...
...video of raw footage. A document will be provided with all instructions what to add in stock footage, text animation, transitions etc. all the stock footages will all provided by me. I will provide this for both Instagram reel send YouTube video. I will also send you subtitles file for Instagram reel. You only have to follow the instructions and first send me the first draft of edited video. I will tell you the required changes in the video. After doing all the changes you have to send me the project file. The changes will be only 1 time not multiple times. REQUIREMENTS ADOBE PREMIERE PRO EXPERIENCE IN INSTAGRAM AND YOUTUBE VIDEO EDITING. TIMELY DELIVER VIDEO. REPLY AS SOON AS POSSIBLE. I have multiple number of clients and you have to wor...
I need a data studio expert to create a comprehensive report for my Google Ads and meta data. The report should focus on: - Click-through rate - Conversion rate - Cost per click - Conversi...studio expert to create a comprehensive report for my Google Ads and meta data. The report should focus on: - Click-through rate - Conversion rate - Cost per click - Conversions per key word The report should cover the last 30 days. I prefer a report that represents data in tables and numbers rather than through charts and graphs. Skills required: - Proficiency in Google Data Studio - Strong understanding of Google Ads and meta data - Ability to work with large data sets and visualize information effectively in tables and numbers - Strong analytical skills to...
I am in need of a professional and creative logo designer who can help me bring my makeup brand, Divine Makeup, to life. The ideal candidate would have experience in creating logos for beauty or fashion brands, and a deep understanding of modern, minimalistic design principles. Key Requirements: - Develop a fresh, modern, and minimalistic logo for my makeup brand "Divine Makeup". - Ensure the design is suitable for online use, particularly on my website and social media profiles. - Provide multiple options for me to choose from, as well as support for revisions. Ideal Candidate: - Prior experience in designing logos for beauty or fashion brands. - Proficiency in modern and minimalistic design. - A solid portfolio showcasing previous logo desig...
--- We are seeking appointment setters or companies with multiple agents experienced in the Janitorial/Commercial cleaning industry. --- We will pay you per qualified appointment you set. --- We have a high demand for at least 10~18 appointments weekly, and we have multiple areas we can assign you based on your results. So, you can easily earn $750 weekly if you provide quality appointments. --- We are looking for a long-term partnership. We have demand for multiple locations in the US, Canada, and Australia. --- You need to have your own dialer and leads (We have ppl working with us using Google Maps and --- Qualification criteria --- A business with the REAL possibility of becoming our client: NOT pushing appointments, NOT people just looking to...
...3h for 1h30 / 90 min => 3500 stocks 9 min => 350 stocks. Maybe we could do multiple queries of 350 stocks? Because what is in place stops after 1800 files out of 7000. And obviously it starts again each time at the beginning when we restart... so it is always the same stocks which are updated. It would be better if the already downloaded data was not deleted, but kept and downloaded only the missing delta. This would allow us to have large data If we downloaded 1 year of data 7 days ago and we select 1 year, then only the last 7 days are downloaded, which goes faster. The data is then aggregated and deduplicated if necessary. 2) In the "indicator" section, be able to add, modify, delete existing indicators. 3) In "Add an indicator"...
...nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are,...
