Sql automatic backup 2008 jobs
I need to move my ASP.NET 3.5 application from a 2008 server to a dedicated server. Key Requirements: - Migrate ASP.NET 3.5 application: The current application is running on ASP.NET 3.5 and needs to be seamlessly moved to the new dedicated server. - Hosting Environment: The application should be set up on a dedicated server. Experience with dedicated servers is crucial. - Identify Specific Requirements: I'm unsure of any dependencies or specific requirements the application might have, so the ideal candidate will need to assess this and make necessary recommendations. Ideal Skills & Experience: - Proficiency in ASP.NET 3.5: Extensive experience with ASP.NET 3.5 and above is essential. - Server Migration: Proven track record of smoothly migrating applications from one se...
I am in need of a versatile developer who can build an integrated messaging system that ties together Facebook Messenger, Slack, and Instagram. The key features ...need of a versatile developer who can build an integrated messaging system that ties together Facebook Messenger, Slack, and Instagram. The key features of this project include: - Ability to both manually and automatically respond to the received messages. - The automatic response should apply only to text messages. Desired Skills & Experience: - Extensive experience in API integration. - Deep understanding of Facebook Messenger, Instagram and Slack platforms. - Experience in designing systems that handle both automatic and manual responses to messages. - Familiarity with algorithms to effectively auto...
...appointments. * Automatic Reminders – A system that generates reminders for clients' appointments. * Personalized Booking Page – Each client should have their own dedicated booking page. A standout aspect of this site is the Resources section, which must include: * Regularly updated articles and blog posts about relevant therapy topics. * A catalogue of recommended books and resources. * A comprehensive FAQs section addressing common queries about the practice and therapy in general. Ideal Skills and Experience: Freelancers should have proven experience in web development, with a portfolio showcasing their ability to create engaging, user-friendly interfaces. An understanding of the therapy industry and appointment-based businesses would be beneficial. Experien...
...done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automatic calculation of the total payment owed to each installer based on the number of jobs completed. 3. **Customer Information:** - Columns for customer name, address, and account number. 4. **Summary:** - A summary section that provides totals for jobs completed and payments owed for easy reference. **Additional Features:** - Th...
As the owner of a Magento 2 website, I am facing a set of challenges requiring urgent attention. Primary Issues: - Checkout process errors: Our sales are dropping and people complained they can't pay. I found one solution: if we revert configurations from the backup that should be resolved. We sold last yesterday at 7 pm and there are no sales after that even though we can monitor customers who are going on the checkout page but aren't able to shop. This never occurred! Ideal Candidate: I am looking for a freelancer with extensive experience in Magento 2 who can accurately diagnose and resolve these issues. This project will be done through anydesk as we can't share access and please bid if you can fix these issues in a couple of hours. Thank you
I need a Pptx document translated from English to Simplified Chinese as soon as possible. The file has 2000 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word Pptx format maintaining the formatting and layout of the source file. Price: 30 fixed. Deadline: 24 hours max Don't bid if you don't agree the price and timeframe. Thanks!
...troubleshooting steps so far. Fortunately, I maintain a full system backup, which could be utilized for restoration. Key Points: - The disappearance of the bookmarks was sudden and unexplained, so this may require more advanced recovery methods. - Expertise in macOS is crucial, as the recovery should be compatible with this operating system. - The presence of multiple accounts on Chrome might complicate the recovery process, so understanding how to navigate this is essential. - Your deep understanding of Google Chrome's architecture is required to successfully retrieve the lost bookmarks from my full system backup. Ideal Skills: - Proficiency in Google Chrome browser's architecture. - Strong experience in macOS and its system backup restoration. - Expert...
Hi, I am looking for expert to connect SQL database togoogle looker studio so we can analise data and creat reports, it is a long term coopartion. Please provide implementation cost and hourly charge. Best.
...programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation fro...
We are seeking an experienced freelance developer to design and develop an online service booking platform targeted at legal professionals. The proj...for three distinct profiles: clients (bailiffs), service providers (drivers, couriers, movers, locksmiths), and administrators. Integrate a real-time booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in front-end and back-end technologies (e.g., React, Node.js).Experience with SQL or NoSQL understanding of UX/UI design to meet deadlines.
...embed a clean, sortable, and filterable table into my personal blog, which will continuously pull data from a Google Sheets document. The key points of the project are: - **Table Embedding:** The primary task is to take the data from my Google Sheets and convert it into a visually engaging table on my blog. This table should be easily filterable and sortable based on different columns. - **Automatic Updates:** The data in the Google Sheets will be changing daily. I need to ensure that the table on my blog automatically updates whenever the Google Sheets data changes. Ideal candidates should have experience with: - Data handling and visualization - Google Sheets API - Web development (specifically embedding tables) - Automation and real-time data updates on websites. Please...
...standards of code quality and push for continuous improvement. **What You Need:** - BS/MS in Computer Science, Engineering, or related field. - 2-3 years of full-stack development experience, with significant focus on mobile apps. - Strong proficiency in Flutter or similar, front-end technologies (HTML5, CSS3, JavaScript), and backend development (Node.js, Django). - Experience with databases (SQL & NoSQL), cloud services (AWS, Google Cloud, Azure), and versioning tools like Git. **Why Join Us?** - Flexible working hours and a chance to work in a dynamic, fast-paced environment. - Continuous learning and professional development opportunities. ? **Apply Now!** Send your resume, a cover letter, and work samples/portfolio demonstrating your expertise relevant to the role. ...
Hello^^^^. I'm using Amazon AWS and would like to request server maintenance. First of all, I would like to ask you to do as much as possible for server security and privacy, such as SSL installation, automatic backup once a day, DDOS attack prevention, system performance optimization, hacking prevention, encryption between data transmissions, real-time monitoring, data recovery, backdoor checking, backdoor checking and deletion of compromised files, attack root identification and blocking, suspicious process occupation identification and recovery, server hacking analysis, server access history tracking, password recovery and complexity setting, virus and malicious software checking,,data leakage prevention.....etc My current monthly budget is about $50, Please send me...
I am experiencing a recurring issue with my WordPress website where plugins are being automatically deactivated. Every time I activate them, they are found deactivated again the following day. I need assistance with creating a backup of the website and safely updating WordPress along with all plugins, including Elementor, to ensure the website functions correctly without any plugins deactivating unexpectedly. Your expertise in resolving this issue and restoring full functionality to my website would be greatly appreciated. The primary task is to identify and fix the issue that's causing the plugin deactivation. Ideal freelancers for this project should have: - Strong experience with WordPress plugin development. - Proficiency in troubleshooting and debugging WordPress issues....
...user login/signup, in-app messaging, push notifications, photo and file upload. Advanced features should also include GEO Fencing, QRCODE/Barcode scanning and face recognition. The app should be supported by SQL and allow user details to be saved and retrieved from a database. Furthermore, the app needs to integrate with Google services like Maps and Calendar. The design of the app should be minimalistic but seamless for easy user interface. Therefore, a developer with design skills would be perfect for this task. - ESSENTIAL SKILLS: - Android app development - Knowledge of SQL - Minimalistic app design - Experience in GEO Fencing, QRCODE/Barcode scanning, Face Recognition - API integration with Google services This project will require rigorous testing to...
...efficient way to manage these transactions. Requirements: Main Sheet: Buttons: Treasury Deposit/Withdrawal: A button that, when clicked, presents a dialog or an input field directly on the sheet to enter the deposit or withdrawal amount. Shipment: A button that allows users to input the following details: gangName memberName itemOrdered itemQuantity weightUsed currentWeight weightAfter orderedBy Automatic calculation of the total weight and price for each item (a list of items, their prices, and weights will be provided). TreasuryDB: A dedicated sheet to track all deposit and withdrawal transactions. ShipmentDB Sheet: A dedicated sheet to store all shipment records, including item details, quantities, weights, and prices. Additional Details: User-friendly interface for ea...
...appealing to visitors. The main feature of the site will be a live tracking page that provides real-time updates. This tracking page will need to be updated manually at times and also have the ability to automatically update information. Key Requirements: - 6-page personal website - Classic and traditional visual style - Functional, user-friendly layout - Live tracking page with both manual and automatic updating capabilities - Automated email alerts sent at specific intervals - The tracking page should include live updates Ideal Skills: - Proficiency in front-end and back-end web development - Experience in building personal websites - Knowledge of email automation and tracking systems - Ability to create a visually appealing, classic and traditional design - Strong understand...
I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The p...Search Functionality: The application will have a search feature that allows users to find specific content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that demonstrate your expertise in these areas. I'm looking for a reliable, communicative individual who can deliver a high-quality...
...diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQL - Experience with ER diagram creation - A...
I'm currentl...Azure. Post-Migration Assistance: - Azure Active Directory Setup: I'll require help in setting up Azure Active Directory to ensure smooth authentication and authorization processes. - Azure Backup and Site Recovery: Assistance in configuring Azure Backup and Site Recovery will be needed post-migration, to ensure the safety of my data and business continuity. Ideal Skills and Experience: - Extensive experience in migrating on-premises databases to Microsoft Azure. - Proficiency in cost optimization strategies within Azure. - Prior experience with setting up Azure Active Directory and configuring Azure Backup and Site Recovery would be an added advantage. Looking forward to working with a skilled professional who can deliver cost-effective mig...
I'm looking to set up a digital product sales platform. - I require the ability for customers to make their purchases using credit or debit cards. - Customers should have automatic and immediate access to their digital products post-purchase. - The platform needs to be user-friendly, secure and reliable.
I need a solution that can automatically insert page numbers onto every A4 page in my document at the bottom. Key Requirements: - The system should work with A4 format. - It should be able to insert these page numbers automatically and consistently on every page. - The page numbers...numbers onto every A4 page in my document at the bottom. Key Requirements: - The system should work with A4 format. - It should be able to insert these page numbers automatically and consistently on every page. - The page numbers should be placed at the bottom of each page. Ideal Freelancer: - Experience working with PDF manipulation and automation. - Proficient in software that can perform automatic page numbering. - Attention to detail in maintaining consistency in design and positioning of the pag...
As a Python Developer, I'm intent on automating specific repetitive tasks related to file management and organization. Key Responsibilities: - Develop scripts in Python to automate repetitive file management tasks. These tasks are slowing down our productivity and we need a solution to streamline them. - Implement an effective, reliable and user-friendly automated system that requires minimal manual intervention. - Ensure the system is highly secure and can handle large volumes of data effectively. The ideal candidate will have: - Proficiency in Python programming language and experience in automation.
I need an expert in Power Automate who can automate my data entry and reporting processes, notably form and workflow management. Among the tasks will be: - Creating automated workflows that take the data from Microsoft Forms responses primarily for accounting use and emailing the responses and notifications. - Setting up automatic email notifications as a response after the forms are filled out. The perfect candidate for this project should have strong proficiency in Power Automate as well as a good knowledge of accounting processes. They should demonstrate experience with data automation, report generation and workflow management. Understanding the sensitive nature of the data being collected, a strong sense of data privacy is certainly desired.
I'm looking for a seasoned AWS Data Engineer with over 8 years of experience to support me in handling data extraction and transformation tasks. Key Responsibilities: - Data Extraction: The engineer will be responsible for extracting structured data held in SQL databases. - Data Transformation: You will be required to transform the extracted data into a usable format for our analytics and reporting. Skills and Experience: - 8+ years of experience as an AWS Data Engineer. - Proficient in working with structured data, in particular, SQL databases. - Extensive experience in data transformation. - Expertise in AWS services, especially Amazon S3 and Glue. Your support will be essential in ensuring the smooth flow of our data processes. Please provide examples of your past ...
...should provide practical and actionable advice on how families can set up and adhere to a budget. The guidance should be clear and easy to follow, helping readers to better manage their finances. - Strategies for saving money: The blog post should also outline various strategies families can use to save more effectively. This can range from cutting back on non-essential spending to setting up automatic savings plans. - Investment options for long-term financial planning: As the main topic is investing in stocks, the blog post should provide a comprehensive overview of different investment options available for long-term financial planning. This should include a discussion on the potential risks and rewards associated with each option. In addition to being well-versed in the fi...
...page. - Cora PHP programming: The ideal candidate should have experience with Cora PHP programming, specifically related to integrating website content with Facebook. - Facebook page sharing: The articles should be shared only on my business page, ensuring they reach my target audience. Your duties will include: - Developing the automation process: You'll be responsible for creating a seamless, automatic procedure that shares the articles to my business Facebook page as soon as they're uploaded to my website. - Testing and debugging: After setting up the automation, you will need to test it thoroughly to ensure it works as intended. Any issues that arise will need to be identified and resolved promptly. This is a crucial project for me, as I am aiming to maintain a co...
**NO OR LIMITED EXPERIENCE IS OK - FEEL FREE TO APPLY. DO NOT USE GENERIC BID TEXT (NO COPY PASTING)*** Role is perfect for motivated and learning individuals who are eager for feedback and want to grow skills. Duration is 30 days internship. Those who surpass expectations will receive a serious offer to s...have no confidence here in a working tool with proof as you need to communicate. 2. What key strengths that you bring to the table that make you the right fit. 3. Your experience / skills 4. Set the duration of your bid to 30 days. 5. Bid your rate for a total of 30 days, NOT hourly or daily. The budget is ~$10 a month (per 30 days) for internship. Compensation increase after 30 days. Automatic or generic bids will be ignored. No agencies or firms, only individuals. Happ...
...Betting Interface: • A user-friendly interface where users can view upcoming games and place bets. • Options to bet on Team A to win, Team B to win, or a draw. • Real-time updates of betting odds based on the total amount bet on each outcome. 3. Bet Placement: • Users place bets using the platform’s native cryptocurrency token. • Users can bet any amount they wish. • Confirmation of bets and automatic deduction of tokens from the user’s wallet. 4. Pot Distribution: • After the game concludes, the total pot (the combined bets of all users) is distributed. • The winning selection’s pot receives the total amount from the losing selections’ pots minus a 5% fee. • Winnings are distributed to users in the w...
The project is deleted automatically by freelancer.com. Now I have created hourly project, because in hourly will be less commission deduction by freelancer. But I will turn off automatic tracking for us to make it smooth and lift out the time restriction. Please bid on the project and just bid with minimum hourly rates. Thanks.
...elements appear as they should. Lastly, there is a problem with the automatic update of monthly posts on the homepage. It's visible only when you click ‘read more’ whereas it should appear readily on the homepage. I’m looking for a way around this, so viewers do not have to take the extra step of clicking 'read more' to see the recent posts. Skills and Experience Required: - Experience with WordPress AND GoDaddy platform - Expertise in mobile web design and troubleshooting - Strong understanding of responsive design - Proficiency in rectifying content display errors - Ability to ensure automatic updates on homepages. Overall, I need someone who knows WordPress, can adjust layouts, fix content display errors, and ensure automatic...
I need a skilled developer to integrate our custom in-house software with Oracle TimeCard. This is to allow for automated time entry. Key Requirements: - The integration should allow for automatic time entry from our custom in-house software to Oracle TimeCard. - The system should also enable the creation, updating, and deletion of timecard information in Oracle TimeCard. Ideal Skills: - Proficiency in Oracle TimeCard integration. - Experience with automated data transfer between systems. - Strong understanding of custom software integration.
A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...
I'm looking for an expert in Microsoft Power Apps to develop...the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be able to deliver a high-quality, functional solution w...
I'm in immediate need of a talented professional who can help with the restoration of my server. I have experienced some issues with the server and after thorough review, I believe the best approach would be to restore the server data from a full backup. Key responsibilities: - Diagnose server issue(s): The tasks require the freelancer to identify the root cause of the server malfunction. - Conduct server restoration: The main task at hand is to effectively restore the server from a full backup. The ideal candidate should: - Have extensive experience in server restoration, with a specific focus on full backups. - Demonstrate a high level of proficiency in diagnosing and solving server problems. - Be able to work quickly yet effectively to minimize downtime and data lo...
I'm in need of a membership portal that will store and display user profiles and membership levels. Key Requirements: - Data Display User profiles should be displayed in a detailed view Membership Levels Management I need the portal to support automatic upgrade/downgrade of membership levels Analytics: The membership portal should include analytics tracking to monitor membership trends and engagement. Ideal Skills: Proficiency in backend development Experience with data storage and retrieval - UX/UI Design skills for sophisticated data display - Knowledge of membership management systems - Understanding of analytics implementation in web applications Your involvement in this project would contribute significantly to my business's efficiency in managing and unde...
I need an adept freelancer who is skilled at using to help me set up automatic transfer of data from our Airtable booking system to Sage Business Cloud to automate invoicing. The data in question includes booking details and invoicing line items. Most of the system is up and running but we are currently stuck sending the invoices line items correctly. A deep understanding of both Airtable and Sage Business Cloud will be highly beneficial for this project. Applicants with experience in similar projects have an added advantage. Efficiency, accuracy, and attention to detail are vital for this task.
...assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, in...
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-sized project: The data needing in...
...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 4) gitlab 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 first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on
I'm in need of a membership portal that will store and display user profiles and membership levels. Key Requirements: - **Data Display**: User profiles should be displayed in a detailed view. - **Membership Levels Management**: I need the portal to support automatic upgrade/downgrade of membership levels. - **Analytics**: The membership portal should include analytics tracking to monitor membership trends and engagement. Ideal Skills: - Proficiency in backend development - Experience with data storage and retrieval - UX/UI Design skills for sophisticated data display - Knowledge of membership management systems - Understanding of analytics implementation in web applications Your involvement in this project would contribute significantly to my business's efficiency in m...
...gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plugins, so PHP and understanding of woocommerce plugins is a plus but not a necessity. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) If awarded, accept and start work IMMEDIATELY 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 5) Be available to work on weekends. Our projects use: GITLAB so you need to be proficient and be able to use our existing pipelines and also create your own. Our stack: , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product s...
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 you...Strong command of R programming language for generating the output in R code. Maximum budget for this project is $100 USD. Required turn around will be approximately one week (the sooner, the better). Unfortunately I have had a lot of bad luck with people not completing the requirements/promised end result, so please only contact me if you fit the above brief and have the required skillset. Any automatic bids will be immed...
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
As part of my urgent project, I'm looking for an AI developer proficient in automatic scoring and evaluation with a strong understanding of the IELTS exam format. The aim is to build a comprehensive system capable of: - Precisely grading the speaking and writing sections of the IELTS exam - Identifying areas of improvement for each test-taker - Providing detailed individual feedback - Including evaluations for reading and listening sections For success in this project, familiarity with Natural Language Processing (NLP), Machine Learning, language testing, and proficiency in various AI programming languages is essential. Previous experience in educational AI software development such as automated grading systems will be highly regarded. Required Skills: - AI development - ...
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 offer solutions according to the...
...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, in order: Shipment, Rush order, Mo...
