There is a simple AWS MySQL database set up. There is also a Shiny visualisation script already implemented that takes local CSV data file and then hosts the visualisation on shinyapps.io. The goal is to have Shiny Server OpenSource on AWS powering a Shiny visualisation on a custom domain. And the data powering this visualisation will need to be
I need to pull data from a legacy Cobol application. I don't have...application. I don't have much 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....)
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
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.
Main 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
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
I have the following code that when writing csv will split csvbody by comma, CSVWriter writer = new CSVWriter(new FileWriter(datasheet), CSVWriter.DEFAULT_SEPARATOR,CSVWriter.NO_QUOTE_CHARACTER); [login to view URL](csvBody); but my csvBody which is a List<String> looks like "a","b","c", "e,f,g" so after splitting, "e,f,g" wi...
Every day I have around 10-15 CSV files. They all have the same colums and can be easily merged into one txt. file. I have already a script for this. What I want now is for someone to deliver me a solution so that I can automatically delete certain rows, that contains certain values. The CSV files are saved on a FTPS. I want to extract them, and
...currently run a python code to download a csv of todays stock data and update an excel database with todays stock data. I want to be able to run my program on my computer but have some sort of script (preferably php) that would allow me to easily update a mysql database to be the same as my excel database with the updated information. So in s...
...CRUD application with this function : Create (in a pop up form), edit, update and delete posts with MySQL database for three tables example: (products , category , attribute ). Also with this features: 1- print 2- export to Excel , PDF (with custom header) , CSV 3- upload CSV file 4- search (results in table) 5- pagination Also i need a form
...- Cat 1, ImportId1 Row 3 - Cat 2, ImportId1 Row 4 - Company B, ImportId2 Row 5 - Cat 2, ImportId2 I want some code which can be run in a console or Azure function to update the SQL Azure tables with new customers and categories, linking up the company to categories. New Customers should be added to a Customers Table New Categories should
...Overview: We need a simple relational database developed that has search and download functionality. This database needs to be written in MySQL. This database needs to be built to accommodate a large number of user accounts. Searchable Relational Database Functionality: Our data is contained in 500+ CSV files totaling over 30 gigabytes in siz...
...somebody who is skilled in PowerShell scripting. We get an *.xls file, which your script should: 1. convert to csv 2. one column (A3, B3, C3 and so on) contains values like 1,2 or 3. these should be multiplicated by 5; so add a column to the csv file where x = A3 * 5 3. save it as csv We have a lot of these small projects and tasks so if you are
Tasl: Convert an CSV data file into MT940 format for Rabobank The CSV file contains bank transactions. This needs to be converted into MT940 format. Prefer Freelancers who work in the banking and finance industry and thos ethat are experts in SWIFT messaging and MT940. Computer experts and payments experts please apply. Please qualified
I want to create PHP CRUD application with this function : Create, edit, update and delete posts with MySQL database for three tables example: (products , category , attribute ). also with this features: 1- print 2- export to Excel , PDF , CSV 3- upload CSV file 4- search 5- pagination and the page should be two part the first part is the