...automáticamente pelo calculo da média do preço de compra dos fornecedores. - Atualização por arquivo xls ou csv via import. Arquivo do fornecedor campos: referencia fornecedor, quantidade, preço Necessário a inserção de mais colunas na base dados mysql para introdução das quantidades de prod...
I have a rough MySQL DB schema designed and need help with writing SQL statements to: 1. Create tables 2. Upload CSV data (thousands of records) 3. Dedupe the uploaded data 4. Merge records based on rules 5. Provide the SQL Statements and help implementing for uploading more data at a later time I have MySQL server running with Workbench on a
I need to pull data from a legacy Cobol application. I don't have much information about it, but...information about it, but I know it relies on .vix and .dat files for its database. What I need is a consulting about the better approach to extract data from those files and create csv files. The goal is to populate a SQL database with that legacy data.
...page you will find two things a. a set of long and lat defining a polygon for the city name provided. a: you will get those long and lat and put in a CSV file as one record in the following format City Name, Sub City Name, Date Retrieved, State, Points of polygon (would be lat , long | next point....)
***Design and Develop an "Automatic Time table Generator" with the below specifications: Database: mySQL User Interface-> ASP.Net Core Application: .NET Server: Ubuntu 16.04 Architecture: MVC ***Deliverables: 1. Installation Guide 2. Source Code of the Product & all rights of sales , lease, extension 3. 6 months of support ***Able to define the below
I need a PHP script that will allow a user to select and upload a csv file and then map the csv data to the correct fields in the database. During the import process I need the script to either insert a field into the csv file (subuserid) OR insert the subuserid into the imported records. The subuserid field is coming from a cookie. The data that
I need a script able to download every day the CSV data from a list of URLs and upload it to my Amazon Web Services RDS MySQL database (in one table the data of every link). This script must be hosted in the server and must be triggered every day automatically.
group the excel file by name,ip,cost insert int...[login to view URL],ext_prefix for every group you made - you will find same trunk id from mysql will match multiple ext_prefix in xls insert into trunks_rules (trunk_id,ext_prefix,add_prefix,strip,allow) Example mysql and example xls attached Keep in mind that i want this for csv, xls and also xlsx
I have a csv file which looks something like this with no headers: 1,Bill,bill@[login to view URL] 5,Susan James,sjames@[login to view URL] 7,Joe Smith,joe@[login to view URL] Here's the challenging part: Import the afore mentioned into multiple tables using the first row (The numbers) as the identifier of the table to be entered into AND when entering it into said tables, o...
...partially coded project in CodeIgniter which needs some additional work. 1. There are a number of pages set up to input fields of information about energy consumption into the MySQL database. The client would like to combine all of the separate input pages into a single page where all the input for a specific building can be entered. This provides for a
...need to be editable from main page. Must have a basic installer page that will connect to mysql and create database structure and set site name & URL... basic setup. This will be triggered if first hit on index... Admin Features: - Must be able to import .csv or pipe delimited files with videos. - Fields: Title, Embed Code or URL to media file (
...experience with PHP 7 + Laravel 5.4 + Mysql. - If you intend to use an external component in project, use composer. If your component conflicts with one of our components, it should not be used. You have our composed file attached. - Beware that you have to import same file columns in two different formats (xml / CSV). We expect a functional laravel
1. Create a complementing plugin for wpDataTables(plugin) adding a button to import tables from Excel or csv from Front-End. [login to view URL] time a new user register in the web, the plugin has to create a user's table in bd and add it to wpDataTables named with the username. [login to view URL] column 11 and 12 and 13 has to calculate %, and the value of column 10 equal 8+9
we need to read csv file. in row metadata wise need to create as document in one folder in filenet. we need to maintian mutliple version of docuemnts. For more details we will send email if u understand requirement.
...Task: 1. Download the distributors (currently 3 distributor) flat file from their respective ftp site to our server. Daily basis. Automation through crone job. Also able to import manually. Sub-Task: At admin panel there should be Top Menu like Focaas Distributors>Manage Distributors. Clicking Manage Distributors will open up grid. Able to add as many
...100 to 500 thousand shipments. 3. The system should allow scheduling for the future sending of the messages. 4. The system should allow the import of the database with the numbers of the phones, format csv, txt. 5. After importing, the system should separate the numbers that have whatsapp from what does not have whatsapp installed. 6. The system
We require someone to incorporate a third pa...these. We will need to build in dealer level csv stock import and export scripts. We also will require the image upload to be upgraded to automatically resize images. Required skill s are: Codeigniter HMVC php framework 2. Mysql 3. Bootstrap design 4. 3rd party API integration 5. Bulk importing from CSV
I need a complete Data Extraction from a Prestashop instance. Get me the data inside a CSV / XLS file I need the following fields: * Product Short Description * Product Long Descritpion Tab * Product Data Sheet exploded in separated fields