Importing sql database quickbooks 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 ;)
I'm seeking an experienced professional in data verification. The task primarily involves updating outdated information within an online database. Ideal Skills and Experience: - Proven track record in data verification - Proficiency in handling online databases - Attention to detail and accuracy - Ability to work independently and efficiently - Understanding of data management principles Tasks: 1. Review and verify data within the online database 2. Update any information found to be outdated 3. Ensure data integrity is maintained 4. Provide regular progress reports and updates Please bid if you have relevant experience and can provide a time estimate for this project. Your ability to work with minimal supervision will be a great asset.
DATA SCRAPPING DATABASE This is an interesting overview of the steps that might be involved in completing this project: 1. Develop a web scraping script using Python (e.g., BeautifulSoup, Scrapy) to extract data from relevant grant databases and websites (if possible, considering anti-scraping measures). Sites to be scraped: 2. Design a database schema to store the extracted data. 3. Write scripts to clean, transform, and load the data into the database. 4. Design a WordPress directory listing interface with search filters to display the grant information. 5. Develop a user interface to query and display the grant information based on customer criteria 6. Create a Python plugin for WordPress to automate the scraping
...Knowledge: Utilize knowledge of Australian Financial Planning Administration to ensure compliance and relevancy in task and workflow setups. Requirements Proven experience with ClickUp and workflow automation. Strong understanding of email integration within ClickUp and troubleshooting prepopulation issues. Experience with Xero and automating invoicing processes. Familiarity with managing and importing large contact lists. Experience with financial planning administration, specifically within the Australian context. Excellent problem-solving skills and attention to detail. Ability to create instructional materials and deliver training effectively. Additional Information Please provide examples of previous ClickUp automation projects you have completed, along with any relevant cer...
Hi I will work for 6 hours and get website leads as many as possible till Tomorrow. Thanks
I'm in need of a skilled Shopify developer with solid experience in data import from Excel. Specifically, you'll be dealing with: - Product data import into my Shopify site from a URL download of a CSV - Importing simple data, without dealing with variants or complex attributes. - syncing of the products in the CSV with Shopify products would happen every 24 hours automatically - If an existing product on Shopify is not found on the CSV download, its status on Shopify needs to be changed to "draft" or "inactive". The ideal candidate should have: - Strong Shopify development skills - Familiarity with Excel or similar data management tools - Experience with product data migration or import Success in this project would mean a seamless integration of t...
...that I need. The data columns listed above will be need to be automatically pulled into tables and columns and stored in Microsoft Excel. I need to be able to use SQL or a UI and ultimately easily import/embed into Microsoft Excel - the data finally must be pulled into Microsoft Excel. The freelancer must be Proficient in working with Amazon Seller Central and pulling back the relevant info for comprehensive, robust reporting purposes. Understanding of reporting data from Seller Central data and experience in data reporting and data analytics. Also ultimately this data is to be stored into a database and to where I can use SQL to create queries and tables for dashboard reporting purposes. Your work will be crucial in creating and enhancing reporting for acce...
I'm seeking a Power BI expert to create a Territory Map of both Zip and State. Key Project Requirements: **Mapping:** Your task involves creating the map with both zip and state information. **Data Update:** The map should be updated periodically, not in real-time. I'm using ARCgis in Power BI to create maps. I can create a good map based on zip codes, or based on state, but I can't seem to figure out how to combine the two. Our CA territory is divided by zip code, but some states are considered one territory. So, I need to apply first a filter by zip code, and then a layer based on state on top of that. Attached is the territory map by zip code that I created with Power BI. I need it to look like that but with New Mexico, Arizona, and Nevada fully colored in with...
I'm looking for an expert who can accurately retrieve data from an AWS RDS Database. The task includes: - Extracting text data, specifically all customer data - Precise collection of customers' names, emails, and membership dates - This project involves data extraction of all customers, not just active members Ideal skills and experience would include a comprehensive understanding of AWS, RDS databases specifically, and a stellar ability in data extraction and management. You should be meticulous and maintain the integrity of the data while handling extensive datasets. Familiarity with customer database management would be an added advantage.
I require a meticulous professional, experienced in the workings o...functional - Solve data type mismatch errors, ensuring seamless data integration - Add some of the small functionalities to the application. - Need the full application to run smooth without errors. Ideal Skills: - Commitment to meet tight deadlines as an immediate resolution is vital - Prior experience in troubleshooting errors in Microsoft Access 2007 - 2010 - Expert understanding of database structures and Sql syntax Ultimately, the freelancer should bring this software application back to its most optimal version in the earliest possible timeframe. If you're that hands-on problem solver with a keen eye for detail, you could be just what this project needs. *Some of the sub-application the softwar...
Se requiere un sistema diseñado en Python que trabaje en sistema operativo Wndows, el cual a través del uso del WebCam pueda hacer reconocimiento de rostros comparando el rostro en la cámara vs el rostro almacenado en formato digital en una base de datos en SQL Server 2016+. El resultados debe ser un True o False. El sistema debe trabajar localmente (No en la nube).
Mevcutta hibrit bir uygulamamız var. Sql üzerinden veri çeken bir servis mevcut Bu projeye rapor eklenecek
I'm in the business of importing and distributing promotional products. The goods are mainly made from plastic and aluminium. I'm keen to ensure that all products being dealt by my business are REACH compliant. Thus, I'm looking for an expert in REACH compliance who has experience with items such as these. Ideal skills would cover: - Expert knowledge in REACH compliance - Experience in the advertising and promotion products industry - Proficient in compliance for plastic and aluminium items - Detailed understanding of import and distribution sectors The role will involve scrutinizing the products I deal with to ascertain REACH compliance and advise or implement necessary actions. Your expertise will greatly contribute to the sustainability of my business, adhering ...
This project needs a skilled professional who is highly efficient with dbt, Databricks, Snowflake, Google Cloud Platform (GCP), Python programming, and SQL database management. Responsibilities: - Execute data transformation tasks using dbt - Process and analyze data using Databricks - Handle data storage and querying on Snowflake - Manage cloud platform setup and tasks on GCP - Implement Python programming for data manipulation - Write and manage SQL queries and database Ideal Skills and Experience: - Prior experience in the same field - Intermediate level expertise in dbt data transformation - Knowledge of Python and SQL - Understanding of cloud architectures, particularly Google Cloud Platform - Familiarity with Snowflake and Databricks Appl...
Having problems with Docker and need configurations 1 - 3 current running containers need proper ports assigned to them. The containers connect be lost as they are for production. 2 - set up and configure three additional separate Docker groups, each for a different entity which would contain sql, Apache, and file storage. Key Requirements: - Configure 3 isolated Docker groups for Entity A, Entity B, and Entity C isolated from each other. - The setup should be designed for scalability, load balancing, and security although specific requirements for each are not yet defined Ideal Freelancer: - Proven experience in Docker containerization - Familiarity with setting up and managing production environments - Strong understanding of port assignment and management - Capability f...
I need a simple C# Windows Forms management project. It has three classes: Service, Tourist and Tranzactions. It's for college and supposed to be for a tourism agency wanting to keep track of its services, tourists and tranzactions. Nothing complicated, a CRUD app connected to a SQL database, simple UI and the project has to meet the requirements from the screenshot attached below.
- Merging Persons Records on a Single Table - Fixing some bugs - Displaying "merge company" interface instead of the expected "merge person" interface - Merging Persons Records on a Single Table - Displaying the listed fields on merge person CRM section - Add a "Date-Added" field to CRM records for FirstPrint project. - Update image on CRM Instruction page for FirstinPrint project - Update the Input field and other Issues in the FirstinPrint project
I am in need of ...need of a Senior Financial Analyst to assist with our company's financial modeling, forecasting, and data analysis and reporting. The ideal candidate must be familiar with various financial concepts, data analysis, and proficient in the use of Microsoft Excel, Tableau, and QuickBooks. Key Responsibilities: - Develop and maintain financial models for our operations and future forecasts - Analyze and interpret financial data - Prepare regular reports on financial performance - Utilize Microsoft Excel, Tableau, and QuickBooks for data management and analysis. The candidate must have significant experience in financial modeling and data analysis, preferably in a senior role. The ability to communicate complex financial information in a clear, concise ma...
Need a college B. Tech student who is studying and want to earn something.
I am in need of a data mining expert proficient in Python, machine learning, and Selenium to facilitate a data mining project. If you are interested, so there would be 2 contract fix rate $50/country flow, and $3-5/hr for code's maintainance. Depends on your profile’s experience. $5/script for easier works (like scrap-data transferring between GS&SQL), Purpose of the project: The primary objective is to extract valuable information from a large set of data. The specific type of data to be mined will be shared with the successful candidate. - Skills and Experience: - Proficient in Python - Hands-on experience with Selenium - Thorough understanding of machine learning algorithms - Experience in handling large sets of data - Strong knowledge of d...
Need freshers who want his first job with good visibility.
I've already installed QuickBooks Online on my computer and I'm ready to streamline my USA-based S corporation's financial records. Key tasks include: - Setting up my QuickBooks Online for optimum functionality in accordance with my business structure. - Transferring all necessary financial documents and records to QuickBooks. I am looking for a freelancer who has: - Proficient experience in setting up QuickBooks Online. - Familiarity with the financial nuances of an S corporation. - Ability to provide guidance on how to effectively manage my business finances using QuickBooks Online. Your expertise in these areas will be greatly appreciated.
...previous experience in dealing with customer data specifically. Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a major plus. Proficiency in using data visualization tools like Tableau would also be beneficial in conveying the results of the database analysis. The ultimate goal of this project is to use data effectively to inform business decisions regarding o...
I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.
Need freshers who want his first job with good visibility.
I need an experienced data entry professional to update contact emails in 3 databases All of them are updated I need someone to crosscheck & update if they are incorrect & highlight if it is incorrect. DB 1 MC- 5972 DB 2 H- 754 DB 3 AC- 1033 Bid with the exact price you can do this for. I will go with the lowest bid as its an easy task.
I am looking for skilled and enthusiastic salespersons to promote and sell our rigging hardware. The products we offer include shackles, turnbuckles, wire rope clips, and steel wire ropes We are company Based in china ?? and we need people who can find us Importers or suppliers of Rigging Hardware which are interested in Importing it from China. This is a commission based job Key responsibilities: - Actively engage with potential buyers from the construction, marine, and oil and gas industries to understand their needs and promote our range of rigging hardware. - Utilize your expertise in rigging hardware to provide suitable solutions to clients. - Drive to close sales and maintain strong relationships with clients for future business opportunities. Requirements: - Proven experie...
...experienced application developer who can build a robust database application. The application will need to provide the following functionalities: - Data storage and retrieval: The application must be able to store and retrieve data efficiently, ensuring the integrity and security of the data at all times. - Data analysis and reporting: It should have built-in analytics features to generate and visualize reports based on the stored data. Understanding of statistics and data analysis tools is preferred. - User authentication and access control: The application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the type of data this database application will manage, this r...
...into my Crystal Report PDFs within my web application. This will serve the purpose of authenticating the reports. The signed reports should be saved into a SQL Server database. Key Requirements: - Implement a digital signature feature on Crystal Report PDF files. The purpose of this is to ensure the authenticity of the reports. - The digital signing process should be automated after an approval process. - Save the signed reports into a SQL Server database. Ideal Skills and Experience: - Proficiency with ASP.NET Web Forms and C# is a must. - Experience working with Crystal Reports would be a plus. - Familiarity with SQL Server database management. - Understanding of digital signature implementation and security in web applications. I'm l...
Currently using .Net Framework 4.5 and looking to upgrade project. The main goal for this upgrade is to ensure compatibility with modern systems. I don't require any specific performance improvements, just upgrading the framework is the main focus. The code base is for a Web API that integrates with SQL Server. There is a separate UI front end that is not included. The current version is .Net Framework 4.5 with the following target techical Stack • ASP.NET Core 8.0 (with .NET 8.0) • ASP.NET WebApi Core • ASP.NET Identity Core • Entity Framework Core • FluentValidation • Swagger UI • GIT Key requirements: - Expertise in C# - Strong understanding of .Net architecture - Previous experience in upgrading .Net projects to ensure compatibility with...
I'm in need of an experienced developer who can build a completely custom database website that primarily serves as a customer relationship management (CRM) tool. In addition to the standard CRM functionalities, I'm looking for the following: - Expertise in complex Java and YAML scripting - Ability to create custom database scripts - Proficiency in API integration for seamless data transfer and communication - Prior experience in designing and implementing CRM front-end and back-end relations The most crucial aspect of this project for me is the user interface design and experience. I want a website that not only functions efficiently, but also looks and feels intuitive for users. I'm looking for someone who: - Is an advanced-level developer - Has a strong...
in your Bid, clearly answer this questions: 1. how many years of experience do u have? 2. Are you an independent freelancer? 3 do you know how to fix sql injections? - Give 2 example of how to fix sql injections in forms 4. what are the ways you can secure a payment api to protect it from spamming charges- considering that the api information is secured and spamming is not happening by any registered users but through external users 5. what are the ways you can protect smtp apis to protect from email spamming?- considering that the api information is secured and spamming is not happening by any registered users but through external users 6. What are the ways you can show thousands of data on a page? how will you implement it so that it doesn't have load on server and...
I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able ...
I'm seeking a knowledgeable writer to update an under 500-word article on Visuals SQL. Key tasks include adapting the article to a manufacturing context and replacing outdated information with the latest industry trends. The desired freelancer would have experience in technical writing, specifically within the manufacturing industry, with an in-depth understanding of Visuals SQL.
I need a simple web application developed using the Scriptcase platform. The main functionality of the project will be integrating a database into the application. This will include data for user profiles and product listings. Key Requirements: - Development experience with the Scriptcase platform is a must - Proficiency in PHP and web application development - Experience in integrating databases into web applications Other Details: - The application must be user-friendly and intuitive - No specific user roles or permissions are required, all users will have the same level of access.
...Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphical representation. o Data Source: Multiple MS SQL databases. 2. Collection Reports o Daily Receipt Report: Display daily receipt data with graphs. o Monthly Receipt Report: Display monthly receipt data with graphs. o Annual Receipt Report: Display annual receipt data with graphical representation. o Data Source: Multiple MS SQL databases. 3. Inventory Management o Full Inventory List: Display a comprehensive list of inventory items. o Export Functionality: Export inventory data to PDF or Excel files. 4. Customer Data Analysis o Outstanding Amount...
...need of a skilled computer expert to help me develop a database. This database will essentially serve as an accounting tool for food. It's crucial for me to keep track of various aspects of my food-related transactions, including purchases, sales, and expenses. I require a professional who can translate these needs into a well-structured database. Key requirements include: - Data on food purchases, sales, and expenses should be efficiently stored and easily accessible - The database should be designed to facilitate clear accounting procedures - The system should be user-friendly and reliable, making it easy for me to input data and generate reports as needed Ideal skills and experience for this project are: - Proficient in database design, part...
...and customize WordPress themes - Ensure all code is high quality and maintainable - Troubleshoot and debug complex technical issues - Collaborate with other teams to create successful project outcomes - Maintain a high level of awareness of industry trends and technologies Ideal Skills and Experience: - Proven work experience as a WordPress Developer - Proficient in PHP, JavaScript, HTML, CSS and SQL - Excellent knowledge of WordPress, plugins and themes - Experience with RESTful APIs - Strong problem-solving skills - Good understanding of website architecture and aesthetics - Ability to manage priorities and work in a fast-paced environment - Excellent communication skills This is a long-term project, so I'm looking for someone who is dedicated and can work well also in a...
...component should be able to effectively manage and respond to external inputs from the project that imports it. - Output handling: I need the shared component to emit events, facilitating the communication of relevant data back to the importing project. - Integration with project selections: The shared component should be able to adapt its behavior based on selections made within the importing project. Data Handling: - Inputs and outputs should be managed through a data binding approach. - For output, event emitters should be used to communicate back to the importing project. - The component should utilize a state management system to handle data and selections, ensuring smooth integration with the various projects that will import it. Ideal Skills and Experience:...