Importing data xls postgres jobs

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to your proposals...

I am in need of a PrestaShop expert to assist with the specific task of importing products via cvs into my PrestaShop store. The ideal freelancer for this project should: - Have proven experience in working with PrestaShop - Be highly proficient in importing products via cvs into PrestaShop - Be well-versed with the complexities of ecommerce product data The product data that needs to be imported is relatively simple, including basic details like product name, price, and category. In your application, please include your experience working with PrestaShop and specifically with product imports. Your experience in managing product data in e-commerce platforms will be a significant advantage.

I am looking for a skilled Shopify designer to customize various sections of my website using the Kellas theme. Additionally, I need assistance in setting up automated email and SMS marketing, a discount popup, upsells, cross sells, down sells, scrolling announcement bars, importing reviews, and creating marketing funnels. Please send the links of websites you designed.

...Outstanding experience and expertise in Odoo implementation and project management. - Proven track record in integrating third-party software and adapting functionalities. - Exceptional familiarity with CRM, Inventory Management, Accounting, and us of Odoo apps to manage food delivery. Key tasks include: 1. Data Migration: -Taking CSV files of my exported sales data from Shopkeep and importing it into Odoo without loss of critical information in order to enable reporting on old sales data. 2. Odoo Implementation: - Doing initial setup for Inventory Management and Accounting, as well as direct to consumer food delivery provided by our own drivers, each with its relevant functions and tools. 3. Third-Party Apps Integration: - Seamless integration of spe...

...Graphic design and my budget for this project is $150 - $350 For the Brochure Design, I want a double folded A3 size brochure with 24 -  48 pages and I can only supply the TEXT CONTENT &  PHOTOS but all are with my project consultant, but the logo and brochure will be designed by you and the due date for the project is 20 of next month 2024. The company name is RANDAL FURNITURE INC and is based on importing and exporting of furniture. That is all i can provide from my end and I need a more perfect and Creative job?. HERE ARE THE DETAILS AND PROCEDURE OF THE JOB:     1)     MY WEBSITE IS UNDER CONSTRUCTION WHICH WOULD BE REGISTER VERY SOON     2)     I DON'T HAVE LOGO BUT NEED A CUSTOMIZED LOGO FROM YOU     3) &n...

I have an extensive .mbox mailbox file that I need to import into my existing Gmail account. Key Project Details: - The .mbox file is more than 5GB in size, so the job requires someone who is familiar with managing large data transfers. - The file was exported from Gmail, which means the importing process might have some intricacies that need to be navigated. Ideal Freelancer: - Proficient in working with .mbox mailbox files and Gmail. - Experienced with importing large data sets into Gmail without causing any issues. - Excellent problem-solving skills for potential roadblocks in the import process.

...online database and data entry interface from users + a local MS access file. Online Database and web I terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must be able to see and edit all after...

We are in the middle of migrating Django to a new server. - Both servers run Ubuntu 20.04, postgres 12, python2.7 - The Django Project is already transferred over - Nginx has been configured - Postgresql has been setup Our struggle is to get the actual application up and running again. Your job will be to: - help to perform a clean export of the postgres database on old server - help to import the postgres database on the new server - ensure the Django application is coming back up smoothly The work will be done using shared tmate ssh sessions.

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column nam...

Our existing CGI script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we ...

...between CPTs & Building Complex Queries: You will need to ensure that the relationships between Artists, Styles, and Portfolio Items are established correctly. While there are already queries and relations built, some of them might need updated as not everything imported in a way that shows the right things on the Elementor templates (e.g. since Elementor Listing Items have different page IDs since importing, those need to be selected in some cases). Similarly, while queries are built and imported, you should still have ability to build complex queries within JetEngine, so you understand the setup and can ideally in the future help refine and expand on it. - Visual and Functionality Fidelity: You will need to look at the other site from which this content was imported to see...

I am in need of a skilled freelancer who can help me extract all products from an online shop and import them into my Shopify store. Key Responsibilities: - Extracting all products from an existing online shop - Importing/copying these products into my Shopify store I expect the freelancer to: - Ensure all product information is correctly ported over like variants, prices, ean/gtin, description, collections,... - Maintain the quality of product listings - Ensure the product images are not lost during the import I'm looking to work with someone who has: - Experience with product extraction and import - Proficiency in Shopify - Attention to detail Please provide a timeline for completion when bidding. Please check the size of the shop and the number of products you need to c...

...(containers, global styles) and use your judgment to ensure things are visually in line with my site's design. Ideal Skills and Expertise: - Proficiency in Elementor and JetEngine, particularly in configuring CPTs, relationships, and complex queries. - Comfortable looking at the site from which - Experience working with Artists, Styles, and Portfolio Items or similar content types. - Prior experience importing and configuring dynamic content from other sites would be beneficial. - Strong problem-solving skills and attention to detail. Overall, I'm seeking a reliable and experienced professional who can assist in the final stages of my website's configuration of these content types. Attached are screenshots showing what these different content types look like on...

I have to transfer data and tables from oracle to postgres.

I'm seeking a reliable freelancer to import vendor pricing data into Sage. The data is currently stored in a CSV formatted Excel spreadsheet, with data cleaning required prior to import. The project will entail: - Cleaning the vendor pricing data as required - Successfully importing clean data into Sage Ideal Skills: - Proficient in Excel and its functionalities, especially CSV format - Experience in data cleaning - Demonstrated proficiency in Sage, particularly in data import functions - Attention to detail is crucial for this task This task requires a freelancer with the right blend of skills in Microsoft Excel and Sage software to ensure smooth, error-free integration of vendor pricing data.

I am in need of a one-time service to clean out my email database of invalid email addresses that generates too much soft bounce and hard bounce (and spam trap emails). Key Points: - **Objective**: The main goal of this project is to remove outdated or incorrect email addresses from the email database. - **Frequency**: This is a one-time project, not requiring ongoing maintenance. - ...ongoing maintenance. - **Current Platform**: I use Brevo as my email platform Ideal Freelancer Skills: - Experience with email marketing and database management - Familiarity with Brevo or similar email platforms - Proficient in identifying and removing invalid email addresses - Proven track record of improving email deliverability and marketing campaign results. I supply email addresses in CSV or XLS...

...approving changes and code for deployment/deploying code, managing pipeline and doing whatever it takes to ensure uptime of greater than 99.999%. The developer will play an technical role in the enhancement of a video social networking website, focusing on: - Optimizing back-end performance and scalability for the upcoming website launch. - Ensuring effective database structuring and management for Postgres database. - Administering server tasks for maximum uptime and security for Digital Ocean hosting - must have the ability to understand and recommend hardware scaling strategy as the site scales. - Acting as the senior "gatekeeper" and final authority for deploying changes and bug fixes by reviewing code and deploying changes to both Development and Production websi...

The aim of the system will be to develop a system where you can capture staffs performance on a daily basis and make notes as needed. Under the reporting section you will then be able to select an employee and date range and view any offenses that was made by the employee. Portal will consist of: 1. Work Category: This is where you can create the various categories in your business....Category and click on FILTER to search We then show all employees who has infringements under this category for the date range and categories. Sample Layout 5.2 Infringements by Employee: Fields to start will be Select Date Range Select Employee and click on FILTER to search We then show the specific employee with their infringements Sample Layout All reports in 5.1 and 5.2 can be exported to XLS...

I'm in need of a skilled PHP developer with experience in PrestaShop 1.6 to add new features to my eCommerce website. Your role will involve: - Implementing new features as dictated by the project roadmap, with one activity being importing orders from a CSV file - Possessing a thorough understanding of Prestashop 1.6 is vital, along with a sound knowledge of PHP development - Demonstrating previous experience with similar projects would give you an advantage - Being proactive and communicative, with the ability to work autonomously and efficiently Please include links or details of previous eCommerce websites and similar projects you've worked on in your proposal.

I need to export WordPress articles from one site and import them to another with Wp All Export and Wp All Import plugins. The posts must be exported by eliminating the visual composer shortcodes (present on the source site). The images included in each starting article must be imported into the new site's posts as a simple img src tag (they must therefore be included in the new site's media library). I can provide plugin documentation. In the WP all import/export Plugin it is necessary to insert a function both during the export to convert the ids into URLs and during the import to recreate the image ids. No ftp access is required. I can provide temporary access to both sites.

I am looking to hire an experienced data analyst, with a thorough understanding of EX-IM Export Import Intelligence, to carry out several tasks for starting my export business. Primary Duties: - Execute data cleaning and preprocessing, ensuring accuracy and consistency across different data sets - Carry out comprehensive data visualization, simplifying complex data to maintain comprehensible reports and presentations - Perform data modeling and forecasting that accurately reflects market trends Required Proficiencies: - Ability to interpret, analyze, and report data in format suitable for different stakeholders - Microsoft Excel, Python with Pandas, Tableau - these are essential software skills Key Roles: - Comprehensive market resea...

I'm in need of a skilled SAS software user to assist with specific tasks in data analysis, particularly centered around demographic and cluster analysis. Essential Skills & Experience: - Proficiency in SAS software - Strong background in data analysis - Familiarity with demographic and cluster analysis techniques - Experience in customer profiling and cluster analysis Key Responsibilities: - Importing, cleaning and preparing data for analysis - Conducting customer profiling using SAS - Executing cluster analysis techniques - Generating detailed, insightful reports - A keen eye for data visualization This project is ideal for a freelancer who has not only extensive experience with SAS software, but also a proven track record in demographic and...

I'm looking to import roughly 800 products into Woocommerce from a CSV file. The products don't have variations, but each one needs one or multiple image uploaded which are provided. Key Requirements: - Importing 800 products from a CSV file - No variation management required - Uploading images for each product Ideal Freelancer: - Proficient in Woocommerce - CSV file handling experience - Familiarity with uploading bulk images - Attention to detail to ensure that each product has its image correctly uploaded.

I'm in need of skilled Python developers immediately to help me run a python code to load the data to postgres DB The current script is throwing error need to modify it to check where the error is. Need quick response to check the code and respond

I'm looking for someone to assist me with data entry tasks related to product import on Shopify. The job involves importing products from a CSV file into my Shopify store. Key Requirements: - Proficient in working with Shopify - Expertise in handling CSV files - Attention to detail is essential to ensure entries are accurate

...Tasks: - Data Cleaning & Preprocessing: Streamlining the data cleaning process will be crucial to ensure accurate insights. - Data Integration & Transformation: Integration of data sources will be essential to provide a comprehensive analysis. - Data Visualization & Reporting: Building a robust reporting system will be necessary for clear, concise insights. - Automation & Migration: Implement RPA to automate repetitive tasks and ensure a smooth transition from PowerBI to Tableau. Skills Required: - Proficiency in PowerBI, Tableau, MicroStrategy, Excel, RPA, Data Bricks, Postgres SQL, and Python. - Experience in automating business analytics workflows. - Strong understanding of data cleaning, integration, and visua...

...different brands and avoid populating a category with mainly one brand. 2. Once you have identified the best products, import them into Dser and edit them (remove non-English language descriptions, images, or videos, shorten description by grouping them and removing irrelevant contents, place of origin, etc), Add tags, SEO-optimised content in each product description, categorise etc before importing them into Shopify. It is crucial not to push products to Shopify without first editing them on Dser. Add videos to the products for better customer engagement. 3. Import reviews and optimise SEO, as these are essential. 4. Also, do not list products with suppliers like AliExpress or Alibaba shop details and suppliers' websites, shop numbers, phone numbers, etc. Adverti...

We are a growing digital training academy, using the Moodle platform to manage and administer our courses and assessments. Currently, we are faced with the challenge of mass importing 100 exams, each composed of 50 to 100 multiple choice questions. Each question has two incorrect answers and one correct answer, with specific feedback. The scoring structure is critical: each correct answer adds 0.1 points out of 10, while each incorrect answer subtracts 0.5 points. Project Needs: Advice and Effective Execution: We are looking for a Moodle expert who can guide us and execute the import of these exams correctly and efficiently. Import/Export Troubleshooting: We need to overcome current bugs that prevent scores from being calculated properly and other glitches during the import and ex...

I run an instant grass company in South Africa, where we work on farming, delivering, and...grass company in South Africa, where we work on farming, delivering, and installing Kikuyu and LM Grass. Currently, I require a professional to set up the Bigin CRM system (Zoho) for my company. It should cater to 1-5 users. Key functionalities I'm looking for include: - Customer management - Task management - Sales funnel tracking - Importing leads from online platforms In terms of online platforms, the successful freelancer should set up importing leads from Facebook Ads, Google Ads, and our website contact forms. Ideally, you'll be experienced in CRM system setups and the Zoho platform. An understanding of online marketing platforms and lead generation will also be b...

...search for these products should begin on AliExpress, using Dser Optimiser to sort through the items. Be sure to select only those products with high-quality standards, top ratings, and good reviews (4.5 and above), and with the lowest price and the shortest delivery time frame to the UK (4 to 7 days). 2. Once you have identified the best products, import them into Dser and edit them before importing them into Shopify. It is crucial not to push products to Shopify without first editing them on Dser, including the SEO-optimised content in each product description. Add videos to the products for better customer engagement. Additionally, balance the different brands and avoid populating a category with mainly one brand. 3. Import reviews and optimise SEO, as these are essential. ...

I need immediate help with importing a .mbox file into my Gmail account. The .mbox file contains all my email data from a previous job and is very important to my work. I have attempted this myself before, but the process was too complex for me to complete. I'm specifically looking for support with: - A step-by-step guidance through the import process. - Ensuring all the emails are correctly transferred to my Gmail account. I do NOT need assistance with: - Organizing the emails into specific folders or labels. Ideal Freelancer for the job: - Proficient in Gmail and its import features. - Skilled in providing clear and easy-to-follow guidance. - Available for an immediate Zoom session to assist with the import. - Understands the complexity of .mbox file im...

I would like to add new features to excalidraw. When importing SVG, I would like to add a function that can accurately recognize SVG's paths and curves and change the color and border color of each object. excalidraw_official site

...import feature into our existing app, "Fuel Injection MSI CRDI Charts" (). Scope of Work: Develop a function to import data from Excel files (.xls or .xlsx) into the app. The import functionality should be similar to the existing "Fuel Injection Price List" section within the app. Ensure data integrity and proper handling of potential errors during import. Implement appropriate user interface elements for file selection and import initiation. Skills Required: Android development expertise (Java/Kotlin) Experience with data parsing and Excel file handling libraries Understanding of user interface design principles for Android Strong problem-solving and debugging skills We are open to discussing different implementation

I need to configure my Postgres database software to authenticate users with local Active Directory (AD) credentials. Key Requirements: - Authentication: Set up the database to authenticate users with their local AD credentials. This is crucial for security and access control. - Seamless Integration: Ensure that the connection between the database and the AD server is seamless and reliable. - User Management: The system should allow for easy management of user privileges, ensuring that the right people have the right levels of access. Ideal Skills and Experience: - Experience with Postgres: You should have a strong background in working with Postgres, particularly in a configuration and security context. - AD Integration: A deep understanding of Active Directory ...

I need someone who can research the regulations for importing and selling industrial RFID reader in Hong Kong. A brief report needs to be made with the following information: 1) Regulations related to the import of RFID reader ・ Approval and license that importer and distributor are obliged to obtain prior to the import and selling of RFID reader (such as OFTA license) ・ Related laws and regulatory authorities 2) Regulations and standards related to the sale of RFID reader, such as Quality standards or quality requirements, Environmental requirements (RoHS etc.) that need to be satisfied (if any) ・ Regulations regarding labels (labeling requirements, if any) ・ Each report needs to be made in English and will be of about 4 sheets of A4 paper (about 2,000 words). I want the reports...

I am seeking an experienced WordPress developer to help finalize the setup of my travel agency website. I have purchased the Travolo theme and need assistance with installation, configuration, and customization to ensure the site is travel-agent friendly. Key tasks include theme installation, importing demo content, setting up essential plugins (like booking systems), and customizing the site to match my brand's aesthetics. Additionally, I need to integrate functionality that supports booking, customer management, and inquiry forms.

...TALLY and BITRIX to assist in the development of a seamless module for data transfer between the two platforms. Key Objectives: - Develop a module for Real-time data sync between TALLY and BITRIX. - Establish Custom field mapping for data consistency across platforms. - Design and implement templates for CRM documents on BITRIX. Key Tasks: - Configure BITRIX for importing data from TALLY. - Ensure the module is capable of handling a medium volume of data transfer (several hundred records per day). Ideal Skills: - Proficiency in TALLY and BITRIX is essential. - Experience in developing integrated systems is a must. - Strong understanding of CRM processes and data handling. - Ability to create efficient and robust data transfer m...

I am in urgent...some extra columns in certain tables in the new database, so understanding the essence of the project is pivotal. Here's what I need assistance with: 1. Importing Data: I have a detailed list of specific tables and columns which need to be brought into the new setup. Your work will heavily rely on this list. 2. Data Combination: While importing the data, some of it requires merging. I won't be able to guide you on how this should be done, so it will fall under your professional judgment. Your proven experience and innovative strategies will come into play here. I am hoping to find someone who has extensive experience in MySQL, data merging, and database migration. Should you comprehend the project's subtleties ...

I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.

I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.

...make a payment. Rating page. Users will be prompted to login before accessing this. Star ratings will be filled in here, and the welcome text will have each users [first_name]. Generate a custom QR code to a rating page with pre-filled order number (unique identifier from above) Order confirmation email. With animated banner and QR code. SQL database. All data from the users, questionnaires, orders, and ratings will be stored in a postgres SQL. I have specified the database design (see below). Currently there is no API to warehouse/shipping (postage of orders are handled manually, but please set up the database with the future API integrations in mind). Manual order (in backend). Basically, I want to be able to look at the sample ratings for each sample order and manually ...

...specific project data from QuickBooks to SharePoint using Power BI Desktop. The primary goal is to leverage the integration capabilities of Power BI and create a seamless process for porting this data. Key Responsibilities: - Importing and transforming project data from QuickBooks to SharePoint - Setting up a system for recurring data transfer - Ensuring data integrity and security throughout the process Ideal Skills and Experience: - Proficiency in Power BI Desktop - Extensive experience in data integration and transformation - Prior experience with QuickBooks and SharePoint is a plus - Strong understanding of data security and compliance - Ability to create an efficient and scalable data transfer system Kindly note that...

I'm in need of a skilled Unity Developer, ideally with experience using Quest 3, to address several areas of my current XR Unity Scene. The scene contains some mild adult-themed content. 1. Hair Shaders: There are issues with transparency in the current hair shaders that need to be rectified. ALso would like the hair to have proper motion. 2. Model Importation: Your tasks will require importing 3D character models into the scene. They are coming from CC4. Will send the characters. 3. WebView: I need assistance integrating a WebView app, specifically to display a static webpage in the scene. It is already written and dynamically loads characters.

I am seeking a talented professional to lead a WhatsApp marketing campaign. The campaign will need to utilize a range of multimedia content including text messages, images, and videos, covering an extensive range of ma...extensive range of material. You'll be working on: - Creating and sending innovative marketing content to a pre-existing contact list, enhancing customer engagement and brand awareness. Ideal candidates should possess: - Proven experience in WhatsApp marketing and familiarity with its Web platform - Ability to develop and distribute text, image, and video content - Strong understanding of list importing and management methods. Being technology-savvy, able to handle digital tools, and having a creative skill set will highly increase your chances of securin...

- I have a PDF document. - The PDF document has 1090 questions in it. - Each question has 3 answer choices. - Each question has one correct answer (the choice in BOLD). - Some questions "refer to a figure". Most questions have zero or one figures, a few have more. I have provided Columns Figure A... FigureH for these as required. LOOK AT THE EXAMPLE. task is to put all 1090 questions into an excel file. I have put one question in there as a sample. I have also put one image which shows two additional questions. - If you win the project, you will get the full PDF. You will be able to cut and paste from the PDF. - To bid on this project, you must give me the excel file back with these two sample entries put in after the one that I did. The sample is a JPG file so you mus...

I’m seeking a data expert to scrape a specific database and transfer all available fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. -...

For my company, I need an expert with extensive experience in data consolidation and import to QuickBooks. - The project involves the migration of the company's financial data for the years 2022 and 2023 which is stored in Excel spreadsheets currently. - The data needs to be consolidated into a single file before importing into a new Quickbooks instance. As an ideal candidate, you should have: - Experience with Quickbooks data import - Excellent understanding of data consolidation - Proficiency with Excel spreadsheets - A keen eye for detail and the ability to maintain the integrity of financial data during the import process.

By using Import from file module, import data to Prestashop store from xls files.

Hi I need to very basic example on how to call a rest api from Aveva using a put command. It should be build importing .net libs.

Hello, I am in need of a developer capable of creating an Excel tool (.xls format) for efficient management of large amounts of data. The tool should have the following features: Storage of large datasets: The tool should enable storing a large quantity of data. Duplication removal: It should be possible to remove duplicates in Excel files to maintain a clean and organized database. Standardization of French numbers: All French phone numbers in the files need to be modified and put into the correct format, such as +33780000000. Editing and export: Users should be able to edit data in the Excel file and export the changes made. Archiving: Once the data is used, it should be possible to upload it to an archive for future reference. I would greatly appreciat...