Optimize sql oscommerce työt
Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.
Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...
Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
our customers, our company is looking for website optimization skilled people. We want to hear your views on how you could implement for our customers tehokaita and affordable SEO solutions. What kind of tools you can use? Reporting tools, monitoring tools etc etc. In addition, we would like to hear your views on whether järkeävää our clients to set up a landing page for different domain and optimize the separate sites for different search words. Sell yourself to us! What to give and you have the know-how for our company, and how and where you work consists of Reward
I'm seeking a comprehensive solution to track and analyze your basketball team's performance data. I need a robust and beautiful Power BI matrix designed specifically for basketball coaches and trainers to efficiently manage player data and optimize performance strategies. Key Features: 1. **Data Input and Management:** Easily input and manage player data including RPE (Rate of Perceived Exertion), wellness readiness, workload monitoring, games played, minutes played, training sessions attended, injuries, match statistics, and performance metrics such as height, weight, body composition, vertical jump, hot zone shooting, bench press repetitions etc 2. **Organization and Visualization:** With Power BI's intuitive interface, all player data is systematically orga...
I'm looking for an expert in setting up a Kannel SMS Gateway with a SIM box. The purpose of this project is to send marketing messages on a large scale of betwe...text-only, they will include both images and links as well. Ideal Skills: - Extensive experience with Kannel SMS gateway and SIM box configuration - Understanding of marketing message composition with text, image, and link - Knowledge of Bulk SMS sending Key Requirements: - Ability to send between 1,000 and 5,000 SMS daily - Ensure efficient delivery of all text, image, and link content - Optimize the system while maintaining high deliverability rates Your ability to effectively set this up can make a huge difference in our communication strategy. If these parameters accomplish what you can deliver, I am eager to...
Please apply only if you can start immediately Based on the information provided, it appears you're seeking expert assistance in creating an AWS (Amazon Web Services) solution. While the project details are not specified, the potential scope of the project could involve various AWS services such as EC2, S3, and Lambda. This suggests a focus on cloud computing services to develop and potentially optimize a solution for a specific use case. Given the possibilities, requirements from you as a project manager might include: - Comprehensive understanding of AWS services - Experience in deploying AWS infrastructure - Strong analytical and report writing skills Developing an AWS solution without a specific service focus means the freelancer must have a holistic grasp of AWS. They ...
Please apply only if you can start immediately Based on the information provided, it appears you're seeking expert assistance in creating an AWS (Amazon Web Services) solution. While the project details are not specified, the potential scope of the project could involve various AWS services such as EC2, S3, and Lambda. This suggests a focus on cloud computing services to develop and potentially optimize a solution for a specific use case. Given the possibilities, requirements from you as a project manager might include: - Comprehensive understanding of AWS services - Experience in deploying AWS infrastructure - Strong analytical and report writing skills Developing an AWS solution without a specific service focus means the freelancer must have a holistic grasp of AWS. They ...
...profits from the store. Responsibilities: Product Selection: Utilize your expertise to choose products or categories that maximize profit. Your ability to identify and promote high-converting products is crucial. Store Design: Create a visually appealing and user-friendly layout for the store. A clean and minimalistic design is preferred to align with the aesthetic. Traffic Generation: Manage and optimize Search Engine Optimization (SEO) strategies to drive consistent and quality traffic to the store. Ideal Skills and Experience: Proven experience managing Amazon Affiliate Stores and driving growth. Strong understanding of SEO and its application in e-commerce. Proficiency in store design, particularly with a clean and minimalistic approach. A track record of successful produc...
I'm in need of a skilled developer who is proficient in a variety of programming languages and can work on two key areas of my website. - Basket Featur...registration, the user remains on the registration page. This is not the intended behavior, and I need a solution that will ensure that users are correctly redirected to their profile page post-registration. . This video helps what im trying to say. Ideal candidates for this project should have a strong command of HTML, JavaScript, CSS, PHP, and SQL. In addition, experience with Stripe payment integration and troubleshooting registration processes on websites is highly desirable. Please note that these two tasks are interdependent, and hence, need to be addressed simultaneously.
I am currently facing an issue with my website - when a user registers on the site, instead of being redirected to their profile page ...redirected to their profile page or login page, the system keeps them on the same page. Furthermore, upon this failure to redirect, it shows it is successful when registering but doesn't take to another page. I need someone with strong proficiency in HTML, CSS, JavaScript, PHP, and SQL to diagnose the problem and implement a solution so that after successful registration, users are seamlessly taken to their profile page. The ideal candidate should have: - Significant experience in PHP, HTML, CSS, JavaScript, and SQL. - Proven track record in troubleshooting and rectifying website issues. - Firm understanding of user authentication a...
I'm looking for a skilled professional to enhance my Google My Business profile. Key Responsibilities: - Ensure my phone number and business hours are correctly displayed. - Recommend and implement additional information that will benefit my business. Ideal Skills/Experience: - Experience in setting up and optimizing Google My Business profiles. - Knowledge of strategies to increase local search visibility. - Ability to enhance customer engagement. - Expertise in collecting and managing reviews.
I need an e-commerce website built on Shopify with a budget ranging from $500 - $1000. The website should target young adults aged 18-34, and will be selling a variety of products, primarily in the ...gateway integration - Mobile optimization Ideal skills and experience for this job: - Proficiency in Shopify development - Understanding of e-commerce and online consumer behavior, particularly for young adults - UI/UX design skills for an engaging e-commerce experience - Knowledge of product categorization and listing optimization - Prior experience with payment gateway integration - Ability to optimize the website for mobile devices Please provide examples of similar e-commerce websites you have built on Shopify, and a clear breakdown of your proposed approach and timeline for thi...
...ingenious web application using Angular + Laravel. Your primary task would be the initial creation of the application, yet this could potentially extend to long-term support. Key Responsibilities: - Create a robust, scalable, and highly interactive web application. - Develop efficient and reusable code that drives complex web applications. - Maintain a deep understanding of Angular + Laravel to optimize application capabilities. Ideal Skills & Experience: - Advanced proficiency in Angular + Laravel development. - Proven record of building highly interactive web applications. - Understanding of user roles for a web app is preferable. - Skilled in troubleshooting and improving existing and in-development applications. Time Frame: Since there were no specific answe...
... All the tables are fed from the main large table (secondly rate table - real time table). Details about the models: ML Model Development: Anomaly Detection Model: Develop a model using Random Forest algorithms to detect unusual patterns in energy usage. SARIMA Forecasting Model: Implement SARIMA models to forecast daily energy requirements, considering seasonal variations. Database: A cloud SQL real time database is preferred. Front end: After analyzing the data, I want to display the results to the user in Flutter with a very simple UI. I want to display: - Total energy consumption. - A graph for the total energy consumption by hour. - Energy consumed for each device. - Energy consumption compared to yesterday's. - Estimated energy consumption by end of the month. - Re...
I am looking for an experienced Android developer to help with a couple of key issues in my app. The primary focus should be on UI improvements. Key Tasks: token refresh functionality ignore battery optimize permission run at startups functionality UI change 2 new api's refactor code for easier maintenance currently displayes persistent notification dont want it Other requirements: - The app's token refresh mechanism must be revised and optimized - You should be able to ignore battery optimization permission I would ideally like a freelancer who is experienced with Java, Android Studio and UI/UX principles. Experience with token refresh mechanisms and battery optimization is also highly desirable. Please provide examples of previous relevant work.
I have a CS-Cart Multi-Vendor site that experienced a severe breakdown following a failed upgrade. This has led to a range of issues from broken layout to persistent error messages. Additionally, after the failed upgrade, the database is out of sync. The site needs urgent attention to get it back on track. Your primary role on this project will be: - Debug and fix the bad upgrade: This includes addressing the broken layout, error messages, and the out-of-sync database issue. - Server Configuration & Security Audit: Given that I've made changes to the server configuration and security settings post the failed upgrade, it's crucial to assess these modifications and ensure they're functioning optimally and not contributing to the site's issues. - Optimization: Your ...
Looking for a seasoned SEO expert who can effectively optimize the on-page SEO for my built website. In the application, kindly include: • Examples of your past work, particularly highlighting website projects built with you’ve worked on. Ideal skills and experience: - Solid understanding of and SEO techniques - Extensive background in on-page SEO best practices - Good eye for detail in identifying SEO opportunities within a website structure.
I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.
I'm looking to automate a process in my manufacturing setup. This involves controlling a servo and timer to carry out specific tasks. Key Responsibilities: - Develop a system that uses a combination of a servo and timer to automate a particular ...Develop a system that uses a combination of a servo and timer to automate a particular process in my manufacturing facility. - Ensure the system is able to operate efficiently and with high precision. Ideal Skills: - Proven experience in automation projects, particularly in a manufacturing setting. - Proficiency in programming and working with servos and timers. - Strong problem-solving skills to optimize the automation process. Note: I'm unsure about which platform would be the best for this project. I'm open to suggest...
I need an expert in SQL Server Report Builder 3.0 to help rejuvenate some lab reports. I require some amendments to be made to the current reports I have. Key Tasks: - Altering the way data is presented within the reports - Incorporating new fields to the current reports In the end, I need the same data results but with improved visibility and understanding. Ideal Skills: - Appropriate familiarity with SQL Server Report Builder 3.0 - Strong grasp of data visualization principles - Detail-oriented and precise to ensure report data remains accurate. Individuals that can deliver these changes precisely and quickly are highly preferred.
I need a Google Ads expert to set up and optimize Analytics 4 and AdWords campaigns for my online sales site. Key Requirements: - Proficiency in setting up and optimizing Google Analytics 4 and AdWords campaigns. - Proven track record in increasing website traffic and boosting online sales through successful campaign management. - Deep understanding of online consumer behavior and preferences for effective targeting. Please tailor your bid to reflect your relevant experience and expertise in these areas.
I am looking for a skilled freelancer who has extensive experience in managing ads on both Google and Facebook. The main goal of this project is to increase the traffic to my website, focusing on professionals aged between 35-54 years. The ideal cand...is to increase the traffic to my website, focusing on professionals aged between 35-54 years. The ideal candidate for this job should have: - Proven experience in managing Google and Facebook ad campaigns - A track record of achieving the goal of increased website traffic - A deep understanding of the professional demographic on these platforms - Excellent analytical skills to monitor and optimize the campaign's performance Please provide examples of your previous successful campaigns and details of how you plan to execut...
...email campaigns? Join our team to create personalized email marketing strategies that convert leads into loyal customers. E-Commerce Marketing Maven: Do you have a knack for driving sales in the e-commerce space? Join us to develop innovative e-commerce marketing strategies that drive revenue and growth. SEM/PPC Pro: Are you an expert in pay-per-click advertising? Join our team to manage and optimize PPC campaigns that deliver measurable results and ROI for our clients. Paid Advertising Aficionado: Are you experienced in managing paid advertising campaigns across various platforms? Join us to plan and execute paid advertising strategies that effectively target and acquire customers while maximizing ROI Requirements: Proven experience and expertise in your respective field o...
I'm in need of an experienced web designer to overhaul my website's outdated look and slow loading speed, while keeping it professional and authoritative. Key Requirements: - Address the outdated design by implementing modern and sleek design elements. - Optimize the site for faster loading speed. - Maintain a professional and authoritative look, aligning with my brand's personality. Ideal Skills: - Proven experience in redesigning websites with a focus on improving brand awareness. - Strong web design skills, with a keen eye for modern and sleek design elements. - Proficiency in optimizing websites for faster loading speed. Please include samples of your previous work in your proposal. I look forward to working with a talented designer who can transform my website...
I am looking for an experienced Android developer to help with a couple of key issues in my app. The primary focus should be on UI improvements. Key Tasks: token refresh functionality ignore battery optimize permission run at startups functionality UI change 2 new api's refactor code for easier maintenance currently displayes persistent notification dont want it Other requirements: - The app's token refresh mechanism must be revised and optimized - You should be able to ignore battery optimization permission I would ideally like a freelancer who is experienced with Java, Android Studio and UI/UX principles. Experience with token refresh mechanisms and battery optimization is also highly desirable. Please provide examples of previous relevant work.
I'm looking for a skilled DevOps Engineer experienced in AWS to help design a robust architecture for my Spark and Sagemaker Machine Learning models. Key Requirements: - **AWS Services**: Your primary focus will be...for the Machine Learning models. Ideal Skills: - Experience with Amazon S3 and Amazon Sagemaker are a must. - Proficiency in Python and R for fine-tuning or troubleshooting the models. - Familiarity with designing architectures for batch predictions and model training/retraining. - Strong understanding of DevOps principles and AWS best practices. I'm looking for a professional who can help me optimize the performance of my models while ensuring the scalability and reliability of the architecture. If you have a proven track record in similar projects, I'...
I'm seeking an experienced website designer to create an e-commerce platform for my bu...items. Key Project Elements: - An intuitive and attractive product listing and description feature, ensuring our customers can easily browse and understand our offerings. - A user-friendly and secure shopping system, giving clients confidence in their purchases. Ideal Skills Required: - Experience in web design, ideally with a portfolio of e-commerce sites. - Knowledge of SEO best practices to optimize product visibility. - Strong graphic design ability to ensure the site is visually appealing. - Experience in creating user-friendly interfaces for easy navigation. I'm excited to bring this project to life, and I look forward to hearing from designers who feel they could be the righ...
My website, , requires a thorough SEO overhaul as we aim for increased website traffic. You will be working on optimizing up to 50 keywords across Google, Bing, and Yahoo. Your tasks will entail: - On-page SEO Optimization: Enhance content quality, use relevant keywords, streamline site navigation, optimize metadata, and improve site speed. - Off-page SEO Optimization: Build high-quality backlinks, manage local listings, create engaging guest posts, and monitor social media mentions. The ideal freelancer should have a successful track record in delivering both on-page and off-page SEO strategies. I'm looking for data-driven individuals who have helped previous clients improve website visibility and increase website traffic. Proficiency in using SEO tools like Semrush
We are seeking a motivated and enthusiastic SEO Intern to join our team. This is an excellent opportunity for someone who is passionate about digital marketing and eager to gain hands-on experience in search engine optimization. Responsibilities: Assist in keyword research and analysis to identify new opportunities for content optimization Help optimize website content, including writing meta tags, meta descriptions, and optimizing on-page elements Support link building efforts by researching and identifying potential link opportunities Monitor and report on website performance using tools such as Google Analytics and Google Search Console Stay up-to-date with the latest trends and best practices in SEO and digital marketing Collaborate with team members on various SEO initiatives...
I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.
I'm seeking a Laravel developer who can integrate Dialogflow with my Laravel 7 application. Key Requirements: - The primary goal of the integration is to automate responses for user inquiri...account and project from scratch as I haven't done this yet. Your experience in Dialogflow will be instrumental in ensuring that the setup is seamless and optimized for my application's needs. Ideal Skills: - Proficiency in Laravel 7 or 8 - Extensive experience in Dialogflow, including setting up accounts and projects - Strong understanding of automation and how DialogFlow can be leveraged to optimize user inquiries I'm looking for a proactive and skilled developer who can efficiently handle this integration and ensure that the automation of responses works seamlessly wi...
...other changes necessary to achieve the >60% conversion target. A reference listing is: Ideal candidates will have experience in graphic design, copywriting and a good understanding of how to optimize the Google Play Store's listing requirements. An understanding of or background in South Asian classical music would be a bonus. Please only put forward a proposal if you are sure that you will be able to achieve a store listing conversion rate of >60%. If you are selected, your suggested changes will be made live on the Google Play Store and payment will only be made if the target is consistently
...charts, infographics, and tailored branding elements. Responsibilities: • Design visually appealing graphics that align with our brand identity. • Create detailed infographics that highlight product benefits and features. • Develop comparison charts to differentiate our products from competitors. • Work with our marketing team to ensure the content aligns with our promotional strategies. • Optimize content for mobile and desktop viewing to ensure a seamless customer experience. Requirements: • Proven experience in graphic design, specifically with e-commerce platforms like Amazon. • Strong portfolio showcasing expertise in digital content creation. • Excellent communication skills and responsiveness. • Ability to work to t...
I'm in need of a Junior Full Stack Engineer who is proficient with Java, with beginner level experience. The primary task will be to work on implementing Go Live for an assigned project. Ideal skills for the job: - Understanding of Java programming language - Ability to work collaboratively on a team - JSON - XML - SQL - Data Mapping Some experience with project implementation is a plus. Dedicated beginners are also welcome to take their first steps in a real project.
I'm in need of an experienced PPC specialist to help me generate leads for my business. The project will involve leveraging Google and Facebook Ads to target a broad audience within the age range of 18-44. Key Responsibilities: - Develop and execute PPC strategies to drive lead generation. - Optimize Google and Facebook Ads for maximum lead conversions. - Monitor campaign performance and identify opportunities for improvement. Skills and Experience: - Proven track record of successful lead generation through PPC campaigns. - Expertise in Google and Facebook Ads platforms. - Proficient in audience targeting, ad optimization, and campaign management. - Strong analytical skills to interpret campaign data and make data-driven decisions. Your goal will be to drive high quality ...
As a dedicated Amazon seller, my primary objective is to significantly boost my sales. To achieve this, I believe I need expert assistance in enhancing my inventory management. It's vital to underscore that my priority area is improving the SEO of my product listings - a mission-critical aspect of gaining visibility amongst the plethora of products on Amazon. Key Focus Areas: 1. **High-Quality Product Imaging:** A picture is worth a thousand words and, in the ecommerce space, it's worth more. The images should be sharp, well lit and from multiple angles to provide a comprehensive view of the product. 2. **Detailed Product Descriptions:** The descriptions need to be comprehensive and compelling, highlighting the key features and benefits of the product while simultaneously bein...
I am looking for a skilled and experienced Full stack developer with Hands-on experience in Java Hands-on experience in Angular/ REACT Hands on experience on AWS RDS/AWS S3/Oracle/AWS Athena/ SQL In-depth knowledge in Core Java, Spring framework and RESTful API Services, Apache Camel, CI/CD Jenkins, Containerization Experience with AWS Cloud and its services like EC2, Athena, Lambda, S3, SQS and Cloud Formation Experience in writing JUnit test cases Problem-solving abilities
I am looking for a YouTube expert who can help optimize my YouTube channel and track the analytics. Key Responsibilities: - Channel Optimization: You should be able to maximize the visibility and appeal of my channel. This includes improving the channel's aesthetics, metadata, and overall structure. - Analytics Tracking: Your expertise in tracking the channel's analytics is crucial. You will be responsible for analyzing the performance data and identifying areas for improvement. Requirements: - Experience in YouTube channel optimization and analytics tracking. - Proven track record of boosting video views. - Strong understanding of YouTube's algorithms and best practices. Ideal Candidate: - A YouTube expert with a history of successful channel optimization and anal...
I'm looking for an expert in EA (Expert Advisor) to optimize the performance of my current EA system. In particular, I'm interested in: - Enhancing the trading algorithm: You should have a profound understanding of trading algorithms, as this task will require you to optimize my EA's functionality substantially. - Implementing better risk management: Your work should focus on improving the risk management aspect of the trading algorithm. This means you have extensive experience with risk analysis and how it's applied in trading algorithms. Having background knowledge in finance would be beneficial for this task but isn't necessary. However, strong analytical abilities, problem-solving skills, and an eye for detail are a must. Bring your expertis...
...frame. #Requirements: - Extensive experience as a Data Engineer, Database Architect, or similar role with a strong focus on rapid project execution. - Expertise in handling tight deadlines and delivering complex projects quickly. - Strong understanding of API integrations and experience with RESTful services. - Proficient in relational database design and development, preferably with experience in SQL and NoSQL databases. - Experience with ETL tools and processes under strict time constraints. - Familiarity with CRM and MAP platforms like Salesforce and HubSpot. - Capable of creating detailed entity-relationship diagrams and data flow diagrams quickly. - Excellent problem-solving skills and ability to work independently in a fast-paced environment. - Fluent in English with outst...
