I have a script that exports data from my database. It 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 .c...
I need a program or script that can be scheduled to import a spreadsheet daily into MYSQL. The spreadsheets are all the same format. row1 = title with date row 2 = field headings 6 columns of data. I need the data of each spreadsheet imported, with a 7th column added(date from row 1) The program should not import a spreadsheet if the date exists (already
...files to import user data (across 4-5 database tables) which requires: - Creating a user profile - Forcing certain data fields - Creating a repeated record that foreign keys back to the profile. It's in the sports industry, so any knowledge of Sports (specifically Hockey) will help you understand the terminology. Further details including the data file
...API and update catalog table. - Being able to import the ICECAT catalog file using a Async API call. API call will download the latest file using API and store it. Second it will import the file and update/insert into the table. In first instance we will use a vbs script and windows scheduler to import the latest file on a weekly base. - Being able
Hi, my .bat file which runs an .sql file to import an excel 97-2003 file into a windows 2012 server does not work. This script used to work on my old win 2003 server but now not on this one. It gives the error: Cannot initialize the data source object of OLE DB Provider "Microsoft.ACE.OLEDB.12.0" for linked server "my_excel" The OLE DB Provider &quo...
...received and read, history with date, time and map with graphics. • From anywhere, reach any platform. (Web / android / Iphone / Blackbarry..etc ...) • Import and export Excel / Csv, txt and Sql (phone number, full address) • Allow management of proxies or another solution to prevent channels from being blocked by whatsapp. • Allow channel managemen...
Need a developer skilled in php and sql to import sql data from one database to another, a basic script with the data fields is available but unfortunately it doesn't work on my site. It gives me an error on line 39: PHP Fatal error: Out of memory (allocated 33030144) (tried to allocate 20 bytes)
I would require someone to build a few queries for me. I already created MS database and imported the data, but I need some help with the MDX queries. If you prefer the .csv files, .sql script and python import program I can also provide you with that. The database is WTA Matches and Rankings. Problem is that I need it ASAP preferably today.
I would require someone to build a few queries for me. I already created MS database and imported the data, but I need some help with the MDX queries. If you prefer the .csv files, .sql script and python import program I can also provide you with that. The database is WTA Matches and Rankings. The queries wouldn't be too complicated. For example:
...control panel, I can see the attendee list. User login to the app, then download the attendee data from the web control panel into the app. User can read the QR code /barcode brought by event attendees. The app verifies attendee by matching the scanned data and pre-uploaded database. If it is successfully verified, "Check-in complete"message and the
Hi, Expert magento 2 and SQL needed! We have a list of 39000 products that we want to add to our magento 2 website, i need some one good who can write a script and import all this data, we don't have the cost and price, this will be added later through the same script. I want some one who can neatly and professionally. Thanks
...WooCommerce & WooCommerce Bookings plugin. I need a script to import data from an external bookings application. Data will be provided in csv format. A few issues to consider: - Although there are plenty of WooCommerce import plugins, there does not seem to be one that imports bookings data - Bookings data is created in an additional pos...
My project has 2 phases: 1) Code 2) Explain 1) I need a Windows PowerShell script developed that does two things: 1: Working with CSV files, it takes the filename and "date modified" meta-data from the windows system for each respective file and appends them as two additional columns in each given file (so each csv now contains a column with
...called "Import csv to MS SQL via Python Project Outline". Please make sure you read an understand everything completely before bidding. Ask any additional questions you need to. -We will provide 1 csv file for initial development and then three more to test once the project is done. -Import records from invoice .csv files into two MS SQL tables (header
...not be able to use the Export Tool to actually download the data, the area required for this project is too large. Step Four - Process your Dataset It is recommended that you start with the problem sets in your chosen course and modify them to suit your chosen data set. As you unravel the data, take note of problems encountered along the way as well
We have a legacy php app that is essentially one monolithic, convoluted script. It includes sql and excel modules for functionality. Users import Excel files to scrape data, then the php app creates giant data grids on screen based on filters.
I need you to develop some software for me. Basically we have a csv file store in a file server . The csv file generated ...have a csv file store in a file server . The csv file generated from some accounting system and will be refreshed every one hour . Is it possible to have a VB script to import the csv data into sql database server every one hour?
...systemd scripts for complete CartoDB stack in production mode including: (1) CartoDB editor http server (2) Carto editor background jobs (resque) (3) Maps API (windshaft) (4) SQL API (5) Redis server Systemctl scripts will successfully start up the whole server stack automatically on server reboot and save output to logfiles in /var/log. • documentation
...complete CartoDB stack including: (1) CartoDB editor http server (2) Carto editor background jobs (resque) (3) Maps API (windshaft) (4) SQL API (5) Redis server with a set of these scripts (or as a single script) for each of the two modes: development AND production. Systemctl scripts will successfully start up the whole server stack automatically