Import export sql database işler

We want to automatically update a "Master Stock excel file by either uploading an "Additional" Stock file or by subtracting a "Subtract" stock file. This inventory system would ideally: - use the item code/ID in the additional or subtract files as the key and match or lookup the corresponding ID on the Master file and update the stock by adding or subtracting (depending on the file). - Any items that cannot be uploaded or matched need to be highlighted to the user so they know the item did not upload or update correctly. - We want to be able to repeat this process many times buy adding and subtracting files while automatically updating the master file. - We then want to be able to download the latest Master Stock File whenever needed. Important: It needs to be ve...

I'm looking for an experienced professional to setup Azure Data Lake (ADL) or my SQL server and integrate it with Tally ERP. **Key Responsibilities:** - Configure Azure Data Lake or mySQL server for data storage and management. - Setup real-time sync of data from Tally to ADL. **Volume of Data:** - The ADL should be capable of handling and storing less than 1 terabyte of data. **Tally Integration:** - The data to be synced includes invoice details, inventory records, and financial transactions. **Ideal Skills:** - Prior experience with Azure Data Lake setup. - Knowledge of Tally ERP and its functionalities. - Experience with real-time data syncing.

I urgently require a SQL query for my php code. It should basically delete rows from two tables

Devo esportare dal sito del fornitore ed importare nel mio negozio woocommerce i prodotti. Voglio un plugin che mi permetta di importare in automatico e sincronizzare 1 volta al giorno i prodotti forniti dai files dei miei fornitori. “Export Web” interface This feature allows customers to export data in different file formats (csv, xml, json, etc.).

scraping 80k of data using python and export it into excel file

...- The scraped data should be stored in an MS SQL format. - The data needs to be scraped continuously (Every second), on an ongoing basis. Nature of Work: - Retrieve Data continuously (Every second) & update in to MSSQL - Add option to change MSSQL login & pwd details. Also Auto save the details in application - Attached Screenshots for Reference data Tables - Retrieve data continuously (every second) from below url's ,69,1081628,160,1,49776&curr-name-color=%230059B0&fields=15m,1h Gold & Silver Ratios Data from Kitco url (attached screenshot) : Skills and Experience: - Proficient in web scraping techniques and tools. - Experience with MS SQL databases. - Strong knowledge of data management

...to the serial key 7) Restructure user/database, something like this (a log_user shall only be allowed to INSERT/COPY into log_data in Postgres: REVOKE CREATE ON SCHEMA public FROM PUBLIC; REVOKE ALL ON DATABASE log_database FROM PUBLIC; CREATE USER log_user; GRANT USAGE ON SCHEMA log_schema TO log_user; GRANT COPY ON TABLE log_data TO log_user; 8) Change JSON to: {"serial": "AB10", "sequence": 23} and add a sequence field in the table. Sequence shall be a “small integer” – two bytes. 9) Change log_data to a hyper_table, may affect table structure. 10) Maintain a “” script with all initialization etc. 11) Restructure user/database is intended to safeguard for SQL injection? Do you also propose to...

...risk management company established in Asia since 2001, with offices in Indonesia, Thailand, and Malaysia. One of our main areas of expertise is Employment Background Screening. (For more information about our company profile, please visit the following link: ) Currently, we are seeking a local freelancer in Hong Kong to assist us in conducting media searches for database checks especially Credit check in your country related to background screening services. If this is feasible, we would require the following services from you: a. Conduct media searches in databases that can be used for verifying or get an information how to get a regarding the credit check in Hong Kong b. Provide us with information on the search results, including step-by-step details. If

I need a specialized utility add-on for Thunderbird v120. This add-on will help me export the content of select mail folders in my Inbox to a CSV file. This was written once before using the old Thunderbird API, we just need it updated to work with the current version of thunderbird. Here's a link to the old CODE... • The specified mail folders I want to handle are Personal, Work, and Projects. • The information that I want to export includes the Sender's name and email, Date and Time, Subject, Message Body, and all of the relevant content headers. • The desired resulting document is a well-formatted CSV file. The ideal freelancer for this task has deep understanding and experience in Thunderbird's architecture, .CSV manipulation and custom ...

File yang ingin di komputerisasikan Pembelian bahan baku Produksi Gudang Penjualan barang Bahasa pemrograman PHP ,HTML, MySQL berikut tampilan untuk web nya

I am looking to have a bash script developed that pulls variables from a remote MySQL database. These variables need to be stored in memory solely for the duration of the script, which will only be run once at the start. No constant refreshing or updating will be required. The main function of pulling these variables from the database is to automate certain tasks. - Must be proficient in bash scripting and MySQL - Experience in database-driven automation is a plus - Should understand the concept of variable use and storage in memory

We are transferring a podcast website from the podcast hosting platform to a WIX Cms. The podcast hosting platform uses RSS to share podcast episode information (e.g. to Spotify) and we would like to learn how to import episode information to WIX. As we would actually like to learn the skill rather than to have it done by an expert, we would like to set up a one-hour Zoom call with someone who can walk us through this. Please only bid if you are sure you know how to do this. We are looking for someone who can join for a one hour Zoom call to help with this and, if any time is left over, to provide some additional tips about WIX and SEO.

I am seeking an experienced freelancer to implement a collection data CSV import feature in Strapi CMS. The specific content of the CSV is currently undefined, but the successful applicant should be comfortable manipulating diverse data fields. Crucial skills and experience: - Proficiency in Strapi CMS - Familiarity with CSV functioning - Experience in data import and migration Successful candidates, please provide a summary of similar projects that demonstrate your experience with Strapi CMS and data importation.

Job Description: Freelancer Needed to Implement CSV Import Feature in Strapi CMS We are seeking a skilled freelancer to integrate a CSV import feature into our Strapi CMS. This feature should be developed as a plugin, ensuring seamless integration with our existing system and allowing for future use and updates. Responsibilities: Develop a plugin for Strapi CMS to enable CSV import functionality. Ensure the plugin integrates smoothly with our current system architecture. Implement validation and error handling mechanisms to ensure data integrity during import. Provide documentation and support for future maintenance and updates. Requirements: Proficiency in JavaScript, particularly with Node.js and React. Experience with Strapi CMS development and plugin cr...

Seeking a seasoned database developer, familiar with MySQL to design a database from scratch, specifically to store and display asterisked numbers on my website. What's Expected: - Design a MySQL database - Implement this to accurately store asterisked numbers - Enable the numbers to be viewed on my website Qualifications: - Profound understanding of MySQL - Strong experience in database design - Ability to work quickly, and with precision Candidates must have a proven track record working on similar projects and show a genuine ability to bring the requirements together into a functioning, efficient database. Efficiency, accuracy and speed are the benchmarks for this project’s completion.

I currently have a SQL Server database running on an on-premise server and I'm seeking assistance to back it up on Google Drive. - Experience with SQL Server DB management is essential - Comfortable working with on-premises servers and transferring large files offsite - Familiarity with Google Drive storage and its integration with server systems - Ability to guide and advise on maintaining backup processes moving forward. Your expertise will contribute to securing our system and ensuring data protection. Regards

Currently, I'm in search of a SQL administrator who can help me set up Tableau

I'm seeking a proficient professional with excellent data management skills. The project involves: - Data entry with primarily text data. - Utilizing Microsoft Excel for this data population task. - Reformatting the entered data into a well-organized database. Ideal Skills: - Proficiency in Microsoft Excel - Experience with data entry involving text-based data. - Familiarity with database design and management - Attention to detail - Strong organizational skills This project emphasizes accurateness and adherence to detail, hence the perfect candidate would be someone highly meticulous with a proven track record in similar projects.

I am in need of an expert with extensive knowledge in BigCommerce platform to help me build a store, based on an existing one that uses another CMS. It will use the images, colors and layout of the original site. The new site will only be a demo to showcase to the owners of the original site so they can see what can be achieved with another CMS, so it will not be functional and payment options...they can see what can be achieved with another CMS, so it will not be functional and payment options will be available only in sandbox mode. I don't have the source files of the original website, but it's online for you to visit as a regular user. The original website is robust and has thousands of products, but I would give you their title, description, image, etc. in a single file for y...

...Requirements: - Go through my attached brand visuals (my website home page, one of my analytics tools, and a general banner) for reference around styles and colors - Go through the attached widget examples and samples for reference - Open the provided link in looker studio and duplicate it (it is made with dummy data sets, just to provide you with something to start with) - Explore data studio visuals (import images, add text with colors, chart palettes, chart view settings..) and theme settings (should be really easy) - Customize theme and layout so that all charts reflect the theme styles - Propose Right now I just need to find the right talent and explore the potential, so I am just looking to see how this will look like. But the deliverable is 2-4 good pages that you will pr...

More details: What type of data do you want to store in the database? Pet information, Medical history How many fields do you need for pet information? 5-10 Pet owners information table Appointment information table Medical history table What kind of user interface do you expect for inputting the medical history data? Form-based entry

...Storage) (API) (SQL) (NoSQL) (RESTful) We produce radio frequency identification (“RFID”) readers and use several proprietary applications during production, fulfillment, software licensing and support of our hardware products. These applications are written in C++ and Java and run on Windows. Our contract manufacturers and fulfillment centers use these proprietary applications which produce a variety of files and data stored locally during production of each device. Information regarding post-production sales of software add-on features is also stored in the database. Each operations location generates local SQLite databases and other data files which are individually copied to our home office and merged to contain data from all locations. We want to mo...

...Workspace Platform - Event Calendar Pro Plugin - Tablepress Plugin - WP All Import Plugin Our website is built on automated processes comprising of both Wordpress and Jotform, interconnected through Zapier, with integrations with Google Sheets and automatic Tablepress imports. We have an automated membership process and automated event planning processes. High-level proficiency in PHP and HTML/CSS for maintaining and updating our existing design is a requirement. The specialist should be able to provide regular updates, optimization, troubleshooting, and offer advanced solutions in any arising tech-related issues. A solid understanding of Google Platform integrations, Event Calendar Pro Plugin, Tablepress and WP All Import will be a significant advantage. We anticipat...

We need a highly motivated freelance developer to complete a showcase/demo...project currently under development in Unreal Engine 5! Requirements: - good communication skills and work ethic. - experience in Unreal Engine 5 Editor, including Blueprints. - a PC with hardware specs sufficient for Unreal Engine 5. - a good internet connection. - some basic knowledge of Blender. - some basic knowledge of Photoshop. Task 1: Modify & adjust a new main building in Blender & import it into Unreal Engine - including area around the building + test if everything works. Task 2: For the new main building: add new texture + mesh variations/UI & adjust it so it looks/works decent, keep it optimized + test if everything works + upload UE project files. I'll send you the det...

I need to hire an export sales representive in marble and granite industry

As the owner of an existing MySQL database, I'm currently experiencing issues related to oversized databases which needs to deleted not needed files. While I'm currently unsure about the exact number of records or rows. Ideal candidate for this project will have: - Deep expertise and experience with MySQL databases - Proven track record of mitigating issues related to large data volumes - Ability to potentially develop a sustainable, long-term solution to prevent future issues - Strong communication skills to guide me through the process Tasks would include: - Assessing the existing database and identifying the main areas causing high data volume - Implementing efficient strategies to optimize the database - Testing the database to ensure the issue...

Hi Mubashar H., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm looking for a Hubspot professional who can assist with the following: - Establish and manage two webpages on my Hubspot account. The specifics of these pages are not yet determined, and I will be looking for your input in this area. - Import my contact database into the system. - Assist with setting up the Chat feature. While the exact type of chat function is undefined, your advice on this will be appreciated. - Set up a series of forms that can be used on other affiliated websites. Your design and implementation skills will be needed here. - Finally, create some working newsletter templates for my Hubspot account. The ideal freelancer for this project is someone with demonstrable experience in Hubspot, specifically in setting up webpages, chat features, and des...

...language which if not known to some extent and being easily understood - makes an otherwise simple task - impossible. Whilst the task itself is isolated to a great extent from the much larger project, unless the meaning of the words comes as second nature - it would take more time to document the task than to just do it. Further the tasks requires access to a database key that is not a toy. As per the auto generated blurb below - celery and sql skill sets are also required. Thanks for your consideration. - Being geographically placed in the US or Canada is not a skill per se, it is desirable to facilitate better communication and collaborative working, this is not a task you will be able to just "do" - although the right person will be able to do it very quick...

I need a freelancer with competent skills in text data entry. You'll be transferring details to an online database. Your Responsibilities: - Transfer textual data accurately - Ensure data consistency and quality check - Update data in the online database Ideal Skills: - Proficient in using an online database - Strong attention to detail - Excellent typing skills - Intermediate data entry experience Only freelancers who can confirm they have these skills and the required intermediate experience should apply.

I require a skilled professional to connect my Windows application directly to a private cloud Microsoft SQL server single database instance. My aim is to improve efficiency in data communication between the two entities. Key Requirements and Skills: • Extensive experience in cloud computing and SQL server database • Proficiency in Direct Connection of a Windows application to a private cloud platform • Knowledge in setting up Single database SQL Server Architecture • Ability to collaborate and provide effective solutions The right freelancer will work with me closely to ensure smooth and efficient functioning of this connection. Your communication skills, prompt responsiveness and understanding of this technology will be c...

This project requires a proficient Quickbooks specialist to: - Import varied financial data including bank transactions, past invoices, bills, payroll data, and all other financial transactions. - Set up a chart of accounts. - Configure the necessary sales tax settings. Specifically, expertise with U.S. tax regulations, particularly Delaware tax, is essential. In addition, there could potentially be ongoing bookkeeping work depending on the freelancer's knowledge and efficiency. A proven track record in Quickbooks setup and understanding of U.S. Delaware tax regulations is desired.

I am looking for a Power BI developer to help me make a new visual and table where elements are mapped together. Must work over teamviewer or anydesk. I cannot give out passwords for SQL

I am currently in need of expert C# programmers who could develop a software capable of user authentication and database integration. Key functionality includes: - User Authentication: The program should allow users to securely log in using a username and password. Experience in developing secure login systems is highly appreciated. - Database Integration: The solution must integrate with SQL databases, hence, proficiency in SQL database connections is mandatory. The developers must be experienced in C# programming, SQL databases, and secure user authentication. Candidates with a proven track record of similar projects will be prioritized.

I need assistance in creating a Power BI dashboard that clearly visualizes survey results data. Connecting to SQL databases forms the backbone of this project. The dashboard must be updated weekely with new survey results data. Ideal Skills & Experience: - Proficient in Power BI - Experience with SQL databases - Familiar with survey results data representation - Ability to schedule monthly updates in Power BI Your primary task will be to make the survey results understandable and accessible through a well-designed Power BI dashboard. Your expertise in SQL and Power BI dashboard creation is crucial for this job.

I'm urgently in need of a specialist who can help me in carrying out an in-depth study on the UV Coating industry in India Your job will be to present comprehensive data on: - A detailed cost analysis - The different application methods - Identifying domestic market competitors - Anticipated market growth - A detailed analysis of import / in-house manufacturing. An excellent understanding of the industry and a proven track record in the field of research is imperative. If you are highly analytical and have strong quantitative skills, your experience will be extremely valuable. This project is required as soon as possible, so I need someone who can get started immediately.

I'm in dire need o...need of a proficient professional with strong skills in Microsoft Excel, particularly with linking and integrating data across spreadsheets. The focus is on nutritional data, specifically numerical data. Key Project Requirements: - Experience in managing numerical data in Excel - Ability to flawlessly link different Excel sheets for seamless data retrieval - Hands-on ability to import nutritional data from a database to an Excel sheet - Strong attention to detail to ensure accuracy and consistency of imported numbers Your efforts will greatly simplify my day-to-day management of nutritional data. An understanding of nutritional data or related fields will be a strong advantage, though is not entirely necessary. Speed and accuracy are of utmost imp...

Need a web developer to create an ecommerce platform focused on a market for pet enthusiasts who own dogs and cats. Our physical product range is vast, aimed to cater for these specific types of pets, from nutritional food products to activity-specific...bring innovative ideas to appeal to our target market. - Has a love for pets and can relate to our drive behind the project. Responsibilities: - Design a user-friendly, engaging and easy-to-navigate website. - Ensure the platform is secure for seamless checkouts process. - Optimize for best Search Engine rankings to maximize reach. - All my account ebay & Amazon listed produtes need to be import on the website. We want you if you believe you can provide the above! We look forward to your interesting bids filled with paw-...

I need python expert for small task , Sql task and ftp task I need it to start now be done today if you can do it pls start your bid NOW

I am in urgent need of a dedicated virtual assistant fluent in data entry for text and numbers into Microsoft Excel. The task at hand will involve: - Populating an Excel database with text and numerical information. - Using five different fields for each entry. An ideal candidate should possess: - Proficiency with Microsoft Excel and an understanding of its usage for data management. - An acute attention to details to ensure data accuracy. - Proficient typing speed for quick data entry. - Data management and administration experience are beneficial. I will provide the sources from where the data is and can be accessed for input into an Excel workbook I have built. See attached workbook. The tabs are broken out by states here in the USA. Please note that this project wil...

...sources of my interest are platforms like Spark, AWS, Azure, GCP, and Hive. I want to understand effective methods for data extraction from these particular sources. Ideal Skills and Experience: - Expertise in ETL tools for data extraction - Hands-on experience with Spark, AWS, Azure, GCP, Hive - Profound knowledge in data engineering - Experience in career coaching or mentoring will be a bonus - SQL -Python This assistance will give me a competitive edge in my upcoming interviews by providing me with practical skills, knowledge, and confidence in addressing ETL-related questions. So, a mentor with over 10 years of experience in data engineering, particularly in ETL processes and in touch with modern data extraction techniques, would be ideal....

I need python expert for small task , Sql task and ftp task I need it to start now be done today if you can do it pls start your bid NOW

I need python expert for small task , Sql task and ftp task I need it to start now be done today if you can do it pls start your bid NOW

I need assistance in extracting specific elements from 250 Excel spreadsheet addresses - specifically, the city, state, and ZIP codes. The purpose of this extraction is ultimately to import this data into a specialized software. Ideal Skills: - Strong grasp of Excel - Experience in data extraction and manipulation - Familiarity with data importation process for software applications Deliverables: - Clean and well-organized list of city, state, and ZIP code data extracted from 250 addresses - Recommendations on best practices for importing this data into software.

...predetermined filters) - Samples: - Total number of active tours - Total number of active agents - Total number of completed contracts - Total number of complaints/issues - Total number of saved/pending tours - Reporting (access to all reports) - List all reports needed (ie. sales reports, user activity, etc.) - Determine filter settings for all reports (ie. dates to, dates from, etc.) - Determine export options for all reports (ie. CSV, XLSX, PDF, etc.) TourCart Dashboard List of all tour carts - Access to all tour carts (active, inactive, pending, cancelled, archived, saved, etc.) - Permission rights: activate, cancel, modify properties, modify date & time, modify agent attached to tour, etc. - Sort by active, inactive, pending, cancelled, archived, saved, etc. Li...

You need to collect a vast array of information on Wellness events in the upcoming four months (April till May) in Sydney For this project, your precision, attention to detail, and research skills will be of utmost importance. Key Responsibilities: - finding the events from various sources. Your team is to build a database of all the events. - Collect fields like data source, event name, location, event date, event time, link, description, ticket price, ticket link - Accumulating organizer details and contact information. Ideal Skills: Data compilation, research skills, attention to detail, understanding of the wellness industry, proficiency in English. Prior track record for doing the research is important.

write in python, no GUI need. Read from POS (example, square POS, clover Pos) API for the products/items. Read about: product name, barcode, price, discount price (if any), discount method (example, 10% off or buy one get one free), discount duration, etc. Per product per row. write to a database, barcode as index. And only write the discount price based on the discount duration. Code can be based on Square POS sandbox. or Clover sandbox.

...aimed at improving team productivity and collaboration. The app will feature user authentication, project tracking, task management, real-time messaging, and analytics. See attached designs for more details. Skills Required: - Expertise in HTML, CSS, JavaScript, and one of React.js/Vue.js/Angular - Proficiency with server-side programming (prefer Node.js or Python) - Experience with databases (SQL or MongoDB), RESTful APIs, and cloud services - Strong UI/UX design ability, with attention to responsive design Responsibilities: - Develop, test, and deploy the web app - Ensure cross-browser and device compatibility - Implement security and data protection measures - Collaborate on design refinement and functionality We're excited to work with a developer passionate about c...

I'm seeking a meticulous and prompt developer to do some bug fixes in my Android app. The issues include: - Functionality is not working as expected - Problems in saving to Excel - The app is supposed to export and save to Excel but is not working, i dont want Excel i want a period of times information exported and saved to pdf Want the ability to save a file to pdf for printing and sending to email You should have prior experience in diagnosing and resolving these kinds of problems in Android apps. Expertise in debugging, optimization, and programming for Android OS is a must. In your proposal, please include a summary of similar work you've done before. Effective English communication skills are critical for this assignment.

I am keen to employ an Arma 3 modding professional who has proven abilities and considerable understanding of scripting, particularly in creating new mods. We are building a mod for Arma 3, it consist to include a Vehicle with 2 weaponized variants, the vehicle is already modeled and just need someone to help me to import it into Arma 3, this work involve the knowledge to use Arma 3 tools and import new vehicles in the game so previous experience is a key. KEY TASKS: - Work mainly focuses on vehicle scripting to be integrated in the mod. SKILLS AND EXPERIENCE: - A deep understanding and mastery of Arma 3 modding mechanics. - Proficiency in scripting, especially those connected to vehicle control and gameplay mechanics. - Strong troubleshooting and problem-solving skill...