So the idea is to create a visual studio app that when load if would download a excell .CSV file from the web and then append that .csv info into and access database or SQL database then deleting the file once information has been append
...gram/v48d-4e3e/data I need two things to happen: 1. Grab the data on a scheduled basis 2. Be able to download the file in CSV format and save to a folder on a scheduled basis 3. Automatically load it to a target table in a Oracle SQL database This is a test project, and if successful and quality work is done, there are several similar projects that
...pre-created SQL Server DataTable (that you define based upon the columns) * Ability to process all CSV Files in a folder (easy - recursive) Datatables needed: 1. Node Database with Unique Identifier and all information in the first 2 rows (see example spreadsheet) 2. Tags Database will use the Unique Identifier for the node to determine which CSV file the
...way solution/platform for bulk service in Brazil. We have own gateways, servers and data centers in Brazil. SMS Messages shall be logged to SQL DB (preferred MS SQL Server) for reporting and billing. Two SQL DB can be used, one for short term (less than 3 days) and one for longer storage - up to 60 days. After this period most of the logs can be deleted
...linux machine. I have a CSV file with around 400,000 entries of the following format: (We'll call this MAIN table) name1, color, date created, notes name2, color, date created, notes name3, color, date created, notes I would want a python script that can take the format above and import the data automatically into the given sql database. From there you'll
This is a prototype for a bigger project. I am trying to find who is the most capable of doing the job. I have some data in a CSV file, I want this data to be hosted on a web server with a database (MySQL), then visualized using public access web such as D3.js This is very similar to Forex Trading websites but in a much simpler way. I usually prefer
...to upload the transactions from our SQL database tables to the Quickbooks file. SQL 2008R2 to Reckon Accounts 2018 Premier (QB 2018) via QODBC 2018. transactions are invoices, item receipts and purchase orders. solution needs to be capable of running as a scheduled job, no user interaction, with a summary csv file generated of transactions performed
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
...generates files based on the table's name in the sql query. Each .csv is supposed to have only THAT TABLES data but, when generating the files, it exports all data from the query and it's joins. I also have a script that's supposed to import into another database, based on the .csv file names, those .csv files will import into tables in the new...
I need to pull data from a legacy Cobol application. I don't have much information about it, but I know it relies on .vix ...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....)
...database for display in the UI Technical Requirements • Utilize existing Google Cloud Engine instance to host components, development, testing • Utilize existing Google Cloud SQL database • Migrate existing app to dedicated directory (~/query) and modify nginx configuration • Deploy SPA under separate directory on same port using the same nginx server
...Ocean, with some scripts that download large zipped csv files (one at a time), it then unzips the file and extracts the data in the file into my database tables. One of the files it downloads is very large (millions of rows, usually) and is causing a few problems with my scripts. i need a PHP and SQL expert to go in an optimise it. The errors I get
Requirement - I need you to develop a simple software which can transfer data from Excel or CSV file to sql, these file may carry 50 column and 10k rows . I would like this software to be developed using SQL , java or any other language its a B to C
I have a functioning webpage which used d3 to update charts based on individuals moving sliders. At the moment the file pulls in data using D3.csv. To improve security, I'd like to change the input so the data is pulled in from an SQL database. If you are interested in the project please let me know what additional information you would need from
Hello, One of my vendors has an inventory feed. Their system allows access/download ...at the local warehouse, 2) would mean it is at any of the other 5 warehouses. They have a "file download" with username and password. They offer download of the file (zip with two csv files), as well as sample code for C#, php, and Java. OSCommerce uses SQL/PHP.
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