...dBase: SQL based Domain and hosting: yes, provided after awarding FTP server data: yes, provided after awarding Sample database tables: yes, in hosting DB Contents of the database: all objects Category: Cities, streets, museums, theaters, bridges, rivers, lakes, cultural sites, history, etc. Convenience: convenience for downloading in Excel for translation
...automatically downloads (21) raw excel data files from this website, converts it to .sql files using the field names & field types that we need. We then manually take these (21) generated output .sql files and truncate the (21) corresponding tables in our database. We then re-upload these new (21) files manually. The excel files on this website are updated
...Identify differences in MS Excel spreadsheet cells compared to Oracle table data values. 2: Update Oracle table data with the values in MS Excel for all cells that are different Other details: - You will receive a MS Excel example, Oracle table structures + test data, and SQL script used to generate the original MS Excel files. From the early ...
...converter / script / batch file, which will import data from informix db and push to MSSQL DB ) source of data type from informix db may .csv or excel sheep. each 3 hours this must push ( to get most update data base (1-3 tables only) Requirement's : 1. GUi interface for management. 2. Able to schedule the date and time for update or force update u...
...an e-mail with a report that comes from an SQL Database on Microsoft SQL SERVER in .xlsx format (excel) . The query remains the same, and the SQL table updates automatically each minute. Process is: 0) Windows Task Manager to open .xlsx files at 05:50 am 1) Open .xlsx file and macro autorun 2) Update Table and make report. (take some minutes)
We need 350 rows of data imported into our Wordpress website as "Posts" from our excel. (As an update to the existing data) The excel sheet includes the Post ID, which hopefully you can match and import the new data for each record. Our excel sheet has the following fields / columns: Post ID Description Link Link Name Link 2 Link 2
Create software which will be used to import csvexcel files in to various ODBC connected databases. Connections will already be set up in the windows DSN servers ([url removed, login to view]) The program will have a section where you can define a routine like so- Set the routine name, select which fields in the csvexcel file goes to which field name in the database
...Visual Basic, C++, Pascal, Java, Java Script, Python, Ruby on Rails, Sinatra. .NET Framework: 2.0/3.5/4.0/4.5, WCF, [url removed, login to view] Web API, MS Enterprise Libraries (Blocks), [url removed, login to view] MVC 5, Web Forms, WinForms, WPF, Silverlight, NHibernate, Entity framework, Linq-to-SQL. Client Technologies: HTML5, CSS3, Java Script, JQuery (DOM / A...
...notification to the app - Admin Panel will also have file upload form which will take the Excel Spreadsheet file and upload the file to MySQL/MongoDB tables - XLS file upload SQL script will verify that data is valid and add/update the data into the db - SQL scripts to do basic calculation to extract data e.g. calculate percentage 3. Timeline:
...must be offered in PDF, Excel, csv, txt and then emailed. Excel, csv & txt are easy as PHP can retrieve and build the export (most of this is already written) but for PDF the layout needs to match exactly so needs some sort of headless browser (Phantom JS seems a good candidate) to generate the DOM and pass it to PHP 3) Script scheduling. There is
Excellent SQL guru needed to create a SQL script to be executed by us to update rows of two tables via a join using a Tab Delimited CSV file located on the root folder of the user. Script should pull the data from the excel file for upload. I can provide screen shots of the table structure and the Tab Delimited CSV file for your reference. Further
We have here to write one sql update script. See attached doc, we have excel with 2 sheet, one with data, and second with temple. First and second columns are Names. WP columns mean working places and ?? column we need to calculate and update. For example, we have in London 5 people in WP 1 and 4 people in WP 2. Now we need to split working places
...all my items in Excel sheets, so I can see exactly how much of each item and the values that I am holding. I need to be able to host this online on my OWN server, the php needs to be easily customizable and accessed by multiple users from any location. So it seems it could be a PHP script backed by a MySQL database. I need a script written with further
...items in Excel sheets, so I can see exactly how much of each item and the values that I am holding. What I want is a solution that I can host online, on the could be easily customizable and accessed by multiple users from any location. So it seems to me that the right idea might be a PHP script backed by a MySQL database. I need a script written
I have 2 SQL Server tables that need to be updated. Here are the definitions for each table. Table1 - Orders table ORDER_NUMBER LINE_NUMBER SEQN SUBSTITUTE_KEY PRODUCT_CODE QUANTITY_SHIPPED PASSCODE_ASSIGNED DATE_ISSUED Table 2 - Passcodes PROD_CODE PASSCODE SUBSTITUTE Basically, I need to update
...select products by motorcycle manufacturer .We currently have created an excel with parts but looking for an easiest way. VERY IMPORTANT !! WHAT WE DO NOW [url removed, login to view] application pdf from manufacturer .For example [url removed, login to view] [url removed, login to view] as excel [url removed, login to view] only the brands we want [url removed, login to v...
Hi Freelancers, I am looking for either an easy to use script or even better a little piece of software where we can select directories with Excel documents in them (2003, 2007 & 2010) which will mass update the connection string properties of the document from one server to another. So ideally we only need to see two fields; 1) Directories 2)
...module to select products by motorcycle manufacturer .We currently have created an excel with parts but looking for an easiest way. WHAT WE DO NOW [url removed, login to view] aplication pdf from manufacturer .For example [url removed, login to view] [url removed, login to view] as excel [url removed, login to view] only the brands we want [url removed, login to view] cc, ...
...document describing everything the final software will do (other than what was documented in the prototype.) Daily Updates: At the end of the day, email us a brief daily update about work completed on the project and access to system to allow us to view work completed. . Website Security: Best security methods against hacking and injections. Security