最近在建一个外卖送餐的网站，需要接入Xunhupay的（微信和支付宝）支付模块。 网站使用的是foodomaa的整站代码： 需要的技能有： Software Version: PHP 7.x Software Framework: Laravel File Types Included: JavaScript JSJavaScript JSON HTML CSS PHP SQL Layered PNG 如果您感兴趣，可以写信给我，价格好商量。 另外网站还有其它的一些改版工作要做，我们可以具体讨论一下能不能一并做。 等您回复哦……
程序是： 首先 第一步： 随机抽取5个phome_ecms_news里面的id和classid 第二步： 读取phome_ecms_news的id和classid，作为函数使用 第3步： 插入phome_enewspl_1新的内容到数据库 例子：$sql = "insert into phome_enewspl_1(plid, pubid, username, sayip, saytime,id,checked,classid,zcnum, fdnum, userid,isgood,saytext,eipport) values (NULL, '1000310000019701', '', '', unix_timestamp(), '$id', '0', '$classid', '50', '1', '0', '0', '评论内容', '48010')"; 第四步： 更新phome_ecms_news的字段plnum+1并且对应第一步读取的id值 例子：UPDATE phome_ecms_news SET plnum =plnum+1 WHERE id = 20488;
To develop OTD KPI reports on JobBOSS: Calculate OTD archive rate by daily, weekly, monthly, there are two conditions need to be fulfilled, one is quantity delivery fulfillment, the delivered qty should equal to requested qty, another condition is delivered date, the delivered date should equal or be earlier than promised day. Scope: all closed SO which closed on curren...qty, another condition is delivered date, the delivered date should equal or be earlier than promised day. Scope: all closed SO which closed on current day, current week and current month. Set the OTD target If SO was delivered earlier on last month , then the OTD need to be included in last Month’s OTD KPI. by SO + Project number Use Chart display the OTD by day,week and month. Data source: ERP SQL DB Tool: ...
该项目需要开发人员，主要技术为： ASP.net/CS/MVC/WCF框架, DIV+CSS，JS(easyui/jquery/native JS/Ajax/Json). 熟悉Oracle数据库, 精通SQL及PL/SQL. 该项目周期大概两个月，之后会有不定期项目需要开发人员 人员需驻场，地点深圳或者天津。
1、精通VB.net，使用以上语言独立开发或深度参与过项目； 2、掌握SQL数据库的使用，能实现复杂查询语句，具备编写存储过程、触发器和函数的编写能力； 3、熟悉ERP、BOM或者MRP。 联系人：陈经理 联系方式：[REMOVED BY FREELANCER.COM ADMIN]
用java写一个xml文档到csv文档的转换软件。 需要源代码，文档，软件使用文档。 需要文档描述为什么采用这个方法来实现这个功能，并且说明还有什么其他方法。有什么可以提高的地方。
在安居客网站上有几千个小区，每个小区都各有一个URL。比如，名字为“三湘海尚”的社区的URL就是。现在需要编一个网络爬虫程序（语言不限），把几千个社区的名称和URL都存下来到一张CSV表中。
需要开发一套库存及订单管理系统，要求基于数据库（mysql或sql server均可）开发。 库存管理部分，要求对商品的入库出库有良好的输入及确认界面； 订单管理系统，因为是从客户的服务器上下载txt文件（内容为订单），需要将订单纳入数据库，然后根据库存情况判断能否发货，并在最终确定发货日期及发货数量后生成txt文件并上传回客户的服务器。下载及上传txt文件，有客户提供的软件，只要以命令行方式调用即可。 需要按照客户指定格式打印交货单。
我公司现在用linnworks平台通过API,CSV分别对接美国亚马逊，ebay店铺，还有我们自己的购物网站，已实现通过linnworks一键发布产品到各接口，各接口库存即时同步更新，订单统一管理等交易环节的整合。我们现在需要开一个TB店铺，也同样接入这个linnworks平台。要求如下： 等级1：在TB店铺实现现有linnworks对接美国亚马逊的所有类似功能，包括产品上传，订单管理处理，库存同步更新等。 等级2：在TB店铺实现现有linnworks对接美国亚马逊的订单管理处理，库存同步更新功能。 等级3：在TB店铺实现现有linnworks对接美国亚马逊的库存同步更新功能。 等级4:不通过linnworks，利用类似一键复制APP之类的功能实现 美国亚马逊店 跟TB店双向库存同步更新。 本项目目前的可见难点： 1.语言，TB店铺所有生成的CSV或者数据都是中文，而Linnworks， 美国亚马逊店铺都是英文。 2.利用CSV表格发布产品时，美国亚马逊的产品图片可以直接使用网页照片的链接，而淘宝需要先上传到TB空间。 3.需要了解linnworks 跟美国亚马逊店铺，TB店铺的相关一些规则，知识。 对招标伙伴的要求： 有相应的TB店铺API开发经验的，并在了解linnworks平台之后再跟我们联系
android app & SQL/PHP web DB freelance job 詳情請email 查詢
我们目前有一个基于Windos Access 的一个内部应用软件， 我们希望能将其用WINDEV 来重新开发 以便于我们之后的应用。指定使用WINDEV 开发软件。在我们公司坐班工作，直到项目完成。
基本原始数据有，是csv格式的，将.csv格式的英文数据导入到drupal中，实现数据的查询、数据的下载以及后续数据的更新。
Drupal 模板实现数据库的建立，基本数据已经有。将.csv格式的英文数据导入到drupal中，实现数据的查询、数据的下载以及后续数据的更新。
*見附件"功能需求簡介" 功能1 1、輸入等級、國別、功能、代碼後，進而篩選出合適數據並呈現出圖表 2、代碼可打入多種進而讓不同數據比較、並呈現出圖表 功能2 1、輸入F、G或H、I按下Button後可篩選出所有符合的數值並呈現圖表 功能3 檔案來源為json或csv
SQL注入/代码审计/数据库权限/渗透测试技术 接渗透单子高手，联系电子邮箱：aqcp#（#改成@）语言要求：中文 熟练掌握各种内网渗透测试工具与相关知识，精通常见安全攻防技术：sql注入、xss、文件上传、文件包含、命令执行等漏洞 熟悉linux、unix、Windows、oracle、J2EE等各种环境下WEB的安全配置与安全检查及WEB漏洞防范； 熟悉各种脚本语言(asp,php,jsp,java,net、perl、python等)具备独立挖掘web安全漏洞与入侵手段 具备一定的网络安全知识，对网络安全结构、系统漏洞、入侵检测、病毒防护等有深入理论基础和实践经验； 熟悉渗透测试黑客攻防的步骤、方法、流程、熟练掌握各种渗透测试攻防工具有实际渗透经验者优先； 求大虾接单，脱裤，要求，电话，手机，姓名，邮箱，其他的一概不要。每笔单1000美金起步，根据站的难度而定价格,具体可以详谈，寻找长期合作. 态度认真、中介勿扰,请技术实力说话。
安全测试、漏洞发掘、漏洞渗透测试、安全审核、安全风险、服务器安全漏洞渗透测试评估与分析及加固； 联系QQ：840555737 2、对产品代码进行审视，找出安全漏洞并提出修改建议； 3、研究各种安全技术，编写和维护用于安全测试的攻击工具、防御工具和分析工具； 4、负责公司Web产品涉及到的安全性研究； 5、负责响应公司的安全事件； 6、为公司员工提供信息安全教育及培训。 岗位要求： 1、熟悉渗透测试的各类技术及方法，熟练掌握各种渗透测试工具；熟练操作各类操作系统、应用平台； 2、精通或熟练掌握php/perl/python/javascript/shell等多种脚本语言； 3、熟悉asp,php、jsp等主流的Web安全技术，包括SQL注入、XSS、CSRF等常见的安全漏洞利用； 4、熟悉国内外主流安全产品、工具，如：AppScan扫描器、wvs等； 5、对Web安全测试有自己的理解； 6、熟悉常见攻击和防御办法，熟悉web安全和渗透技术,能自行进行web渗透测试，恶意代码监测和分析； 7、熟悉ddos攻击类型和原理有一定的ddos攻防经验，能有效防御黑客挂马和恶意流量攻击，会熟练搭建负载均衡系统。
网站用途：园区展示官网 开发语言：php 参考网站： 具体要求： 需要设计的页面数量和网站功能参考附件。 代码要求： 无SQL INJECTION, XSS等漏洞；前端通过HTML和CSS有效验证，class和id等命名符合语义化规范；代码逻辑清晰有注释，方便后期修改升级。 网站维护： 服务商需要提供后期维护支持 其他要求： 服务商最好是成都公司，要有对公账号，可开发票。 请报价格、工期、设计师的portfolio以及在什么开源程序的基础上开发。 熟悉prestashop的优先。
网站建设要求是 网站程序语言是PHP 数据库为SQL Server 不需要做到也下几点： 1、网站界面大气大方 2、网站语言必须为 中午--英文 两种语言 根据访问者的IP来主动换语言 3、一般的交友网站的功能都要做到 4、网站主要功能有一下几点 1、在线聊天 2、在线动态 3、介绍好友 4、相册密码功能 5、在线音乐 6、签到 7、等级功能 8、举报-敏感词 5、这里有几个网站可以拿来参考 这是我的QQ号 929471701
I'm urgently in need of a qualified developer to create a pipeline utilizing DBT and SQLLITE. T...appropriate error logging and handling mechanisms Ideal Skills and Experience: - Strong proficiency in DBT and SQLLITE - Experience with data pipelines, specifically involving text file processing - Familiarity with data transformation techniques - Quality assurance and bug fixing capabilities Deliverables: ● A DBT project containing models for company_analytics and skills_analytics tables. ● SQL scripts or DBT models to process JSON files and populate the analytics tables. ● Instructions for running the DBT command to process the data and execute data quality checks. ● Documentation on adapting the pipeline for continuous file deliveries and suggested additional data quality me...
I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data includin...production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow column in Excel.
I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particula...in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, MySQL, O...
I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file handling - Experience in configuring hostin...
I'm looking for a skilled WordPress developer to assist me in creating a custom, multipage form using Contact Form 7. This form will have a unique require...address - Stored in a specific page inside WordPress dashboard, already configured Furthermore, I require the setup of an export mechanism for this incomplete data, specifically in a CSV format. This CSV should: - Have separate columns for each field to ensure easy data processing - Include timestamps for each form submission for traceability and analysis. The ideal candidate should be proficient in WordPress development, especially with Contact Form 7 plugin integration. Experience in setting up and managing multipage logic for forms is a plus. Additionally, knowledge of data handling and export in CSV ...
As a business user, I need assistance with the configuration of SS...WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above over the call since this is a secured environment. Also, this needs to be executed...
...business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate...
I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including t...number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in Excel.
...for the Snipepay Payment Plugin: WooCommerce Integration: Develop a payment plugin to integrate Snipepay into WooCommerce, allowing users to choose Snipepay along with existing options like PayPal and GoUrl for payments. Deliverables: A fully functional WordPress plugin for hosting management. A Snipepay payment gateway plugin for WooCommerce. Skills Required: Proficient in PHP, JavaScript, and SQL. Experience with WordPress and WooCommerce plugin development. Strong understanding of RESTful API integration. Knowledge in payment gateway integration, specifically Snipepay, PayPal, and GoUrl. Excellent problem-solving skills and attention to detail. Project Timeline: Please provide an estimated timeline for completion with your bid. Budget: Your bid should include the total cos...
Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )
...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...
I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.
I am seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criter...
I'm looking for a professional programmer, proficient in Python to craft a script. This script is for the main p...Python to craft a script. This script is for the main purpose of finding mobile numbers, identifying their carrier, and matching this information with corresponding zip codes. This process is vital for my verification purposes. Not only this, but your script must provide these details in a CSV file output format. Key requirements are: - Extensive knowledge and experience in Python - Experience in number location and carrier identification script writing is a plus - Knowledge of data presentation in CSV format This task requires high attention to detail and a strong understanding of number location matching technology. If you meet this description, I'...
As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately. I wil...
...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...
We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data ...
...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...
...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...
I'm looking to upgrade my current system, perhaps keeping the current Opencart (V1.52) system and working with it where possible... unless its deemed a rebuild is cost effective. The opencart system we use has been added and modified over time, hence it is not possible to simply upgrade to a newer opencart v... 4. Any other 3rd party systems (including internally) that the website communicates with (sending data either way) and any data grabs. NO 5. Confirmation of payment gateways used. Realex (redirect to payment interface), PayPal 6. How the databases (products, customers, orders) are stored and if the data can be exported. Standard OC table structure… yes it can be exported as SQL data dump and all the products to stock link via the export featur...
This is a Python-based project involving LinkedIn connections parsing using a cookie file. The target is to uncover and analyze mutual connections between my personal friend's list and a CRM file. Important Aspects: - The script needs to efficiently ...existing client database is distinctly relevant. - I also need the parser to generate records of connections between my LinkedIn friends and contacts in my CRM. - I would require the output to be well-organized and easy to navigate. It should be exportable and storable both as a CSV file and an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in Python for web scraping and data handling - Experience in working with LinkedIn's data structure and APIs - Demonstrated expertise in managing and exporting data in ...
I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be up...skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be uploaded by an excel spreadsheet or .csv file
...expert to create a flow that will automate the discount application process on my Shopify store from a Google Sheets CSV. Key Requirements: - The ZAP should identify new email addresses added to the CSV, and then add a customer tag "REGATHLETE" to them in Shopify. When the tag is added, they will be eligible to use that discount, as we have already created a customer segment for customers with the tag. - The ZAP must be able to add the tag both to new and existing customers in our Shopify database. Required Skills: - Proficiency in working with Zapier - Experience in creating Zaps with google sheets and matching CSV/data fields - Experience in automating processes and dealing with CSV files. The timeline is asap, and the budget for this is £...
Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.
I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.
I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.
I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.
...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....
...trigger to check if a new email is in another outlook 365 folder, if there is, save the attached excel file as a csv and rename the csv file the date of the email in YYYYMMDD format and save to a folder in onedrive for business. On successful completion send an email confirming success. >If there is no new email in the other outlook 365 folder, email our info@ email address notifying that it is not present. Repeat the checking process 2 days later until successful Flow 2: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, unzip the attachment using a password, save the attached excel file as a csv and rename the csv files the date of the email in YYYYMMDD format and save to a folder in ...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
