Data migrations specialist Juan Pablo Torres Herrera solves his employer's website problems.
I created budgets for HOA so funds are available to replace or repair commonly owned property, like tennis courts, roofs, pools, private streets, etc. When I go to a community, I currently use an excel form that I use to record measurements and quantities, and which provides calculated results. This data is manually copied and pasted into a proprietary Access-based software. It is a bit clunky, hard to see all the information and it's easy to lose data. Additionally, I would like to use this same form to keep track of several databases. I could possibly keep using excel and have a number of tweaks, but I think Access or another database program would work best. I would also like to be able to export the data onto a website. I want all functions broken down into very simple jobs for flexibility and ability to understand what is going on. I will also need very good documentation.
Project:Report and dashboard creation for financials System:SAP business one Database:sql server Summary: end user should be able to access reports and dashboards from the system. You can use any solution to create the reports and dashboards. Dashboards should be dynamic where you can select any dimensions and you should immediately see the result. Reports and dashboards on financial - e.g. Payroll, expenses, revenue etc 20-30 reports
I need to design a comprehensive database that will have the following features and will intergrate within the website for member login and sign up to include payment processing with digital contracts. See below for a full list of what I have come up with. I’d love for it to be done in using a system like Caspio or something similar that is easy to manage and run analytics on the data. Information and functions that need to be accomplished -their membership information -First and Last name -Address -Cell Phone # -Email -Email Alert subscriptions -their profile picture -allow them to see different things within the website based on user access level -Admin -Can see everything on the website and in the database -Can edit everything in the database and on the website -Manager -Can see all content on the website -Can see almost all content in the database except user private information such as credit card numbers, userpaswords, -Can see and do everything users below can see and do -Can suspend user account access for roles below manager level -Manage user roles below manager -CANNOT promote user to the same level as oneself -Escalate Support tickets to Admin Level -Support Tech -Can see support tickets -Answer Support tickets -Close Support tickets -Query Database -Merge Records -Escalate support tickets to Manager level -Manage Membership Status on member accounts -Office Staff -Query Database -Suspend a Member account -More permissions later to be determined -Active Member -Can see all available discounts and services to members -Can query vendor database by type of service aka vehicle maintenance, legal services, health, dental, vision, telecommunications, restaurants, also the query should be able to be filtered by their GEO location or address -InActive Member -Can see all vendors that are signed up with the The company but is unable to see the discounts provided to our members -Payment Hold -Can see all vendors that are signed up with the Company but is unable to see the discounts provided to our members but at the top of every page is a thick red banner that reads ACCOUNT ON HOLD FOR FAILED PAYMENT Also the database needs to have a lookup page for vendors to be able to authenticate a members active status by typing in the membership ID and then the vendor code and clicking verify We would also want this database to be able to house all vendors and a description of their services all in a table of course so that one column can show the normal price that vendor charges and then the next column can show either a set dollar amount for the services the vendor provides or a discount percentage. The discount or set dollar amount for services the vendor provides would need to be hidden from public view unless the person viewing is signed in with a member login and also has a member status of active. I would also like the database to be able to securely store the members payment method and have an auto billing method set up for membership renewal. I would also like this database to be mobile friendly so we can link it into a mobile app to be developed later What is the best solution for all of what I just described
What I need is an attendance tracking project for a seniors' center. This is for a charity, so the budget is limited. I started building it in MS Access, but my skills are limited. If you have suggestion for another platform it is totally welcome. Also, I was hoping this could be accessed on different PCs as roles for attendance recording and reports analysis are done by separate personnel. First we will need client information database and input form to hold name, and contact address and such. Clients have set schedule (e.g. Mo,We,Fr, or Tu,Fr etc.). We do daily attendance so, for example, on Oct 18, the attendance sheet(form) will have list of all the Wednesday clients and have the sheet ready. By default the clients will "attend" so the check box for this attendance will be "On". Similarly, the following needs to be tracked: -morning ride to the center (yes/no) -afternoon ride home (yes/no) -take out meal amount (#) -general notes (on why not attend or why they left early etc) The most important part now are all the reports. • Daily, date range, monthly, quarterly, annually attendance report • attendance records of each clients • Take out meal records • All active clients list • Membership status (Active/not paid) • Clients contact • Case manager look up • Guardians/care givers • Default day of week schedule o Able to rearrange o Nutrition restriction list by day
A 1000 node cluster with a replication factor of 5 such that most facts are replicated on just 5 of the nodes. For example the fact that a new node has joined the cluster, or a global clock synchronization event that must be shared across all servers in the cluster.
The purpose of this system it’s to read and generate full hardware report for laptops, desktop computers and servers. It will be made from 3 sub-systems. User Add, User View, Admin. All the documentation it's on the attached file. Please read it and ask for details BEFORE reading.
I have 3 Drupal Sites that are all powered by the same Database: [url removed, login to view] - English [url removed, login to view] - Spanish [url removed, login to view] - Italian I have to update prices every year. Currently I have to update the UK, ES & IT pages separately. I would like for the Database to be updated, so that when I update the UK page, the Italian & Spanish Pages get updated at the same time
You need to convert the entity relationship design into relational tables in the Oracle database environment. Add at least 10 rows of meaningful data into each table. Develop 8 SQL statements to produce meaningful query results from the data in the database to support business operations. Queries conditions: - Must use aggregate functions - Must use ORDER BY - Must use GROUP BY - Must use more than tables - WHERE clause using LIKE, IN, or BETWEEN - Must use logical operators (AND, OR, NOT) - Must use INSERT, DELETE, or UPDATE Database implementation: Create tables, insert data, and create queries (new) Tables must be in the 3NF. i. Include data dictionary tables that list table name, attribute names, attribute description, data type, required, and foreign key referenced table. ii. Include screenshots to show the data in the tables from SQL Developer. iii. For each query, describe a business purpose of the query and include a screenshot that shows the query and its result. iv. Attach SQL script files with the full report submission.
Hi, My name is Nichole Clarke and I work as a Laboratory Manger for a large winery in New South Wales. We are looking to move from a manual data recording system for field and laboratory testing to an automated platform which would be able to link with several other systems currently used to manage workflow. An overview of what is currently being used to what would be expected is provided below and in the attachments Vintage Sampling Officer (VSO) Program + Maturity Data Management System VSO program: * a database system designed to accept import from EZY Wine that provides base data on blocks * limited to use of updated data from EZY - i.e. program has no memory, so cannot exclude blocks sampled on that day or blocks for which data is not in or updated in EZY. This is currently overcome by manually checking and excluding * Manipulate data through a series of queries and filters to determine blocks to be sampled * Create run sheets of blocks to be sampled & number samples per block per subregion * Create associated sticker labels with ID barcode to go on bags of sampled grapes * VSO take printed run sheets and barcode labels into field * VSO record location of samples, who, date, time and comments on run sheets &/or stickers * Use iPad for navigation and block identification using GPS overlay on Google maps * Use iPad to take georeferenced photos where need to report anomaly (e.g. disease) to Grower Liaison Officer (GLO) * VSO deliver samples to lab that require colour and / or laccase testing * Colours lab process samples and record data on the go on the colour worksheets - refer to Lab flowchart * VSO process Baume only samples and record results on run sheets * Grower Services Admin receive run sheets from VSO + worksheets from Lab and enters the results into the colour spreadsheet for calculation, then final numbers into Ezy. * Number of hours spent on data input for maturity results requires addition of 1 casual vintage employee and regular weekend work to have data updated in Ezy for use in creating sampling and intake plans Upgrade of VSO program + addition of maturity data management into a live system means: * VSO run sheets move from paper to iPad for direct input of field data * Continuous update of blocks sampled and bags collected so lab can see incoming work load and VSO GLO can monitor what blocks have been sampled / not sampled * Relevant block data from VSO program flows into maturity data management system awaiting analysis results * For VSO processed samples, Baume’s to be entered into iPads - block averages calculated within system and results exported for uptake by Ezy. This removes one set of data input and one source of human error. * For lab processed samples, data is entered into system, predominantly direct ex equipment. System runs an update at a set interval (e.g. every 30 minutes), calculates average for blocks with all samples complete and results exported for uptake by Ezy. This removes a major set of data input and source of human error * Increased speed of data throughput means more up-to-date information available, and able to remove the need to highlight "final samples" for processing first - a time consuming step removed from the lab. * Maturity data - the results or just having confirmation they have been collected and are in process, feed into both the VSO program for sampling planning and the Intake Schedule for winery intake planning. * Use of info from Intake Schedule to identify blocks for sampling due to harvest (this is currently done manually and is very time consuming)
On this project we will be working together, live and simultaneously. The time and date for this assignment is 09.00 am, Friday 20th of Oct. 2017 (GMT +1). The project will be initiated by you receiving a series of tasks that will have to be solved within a given time-frame, usually no longer than 10 minutes each. It's very important that you don't lack any knowledge with respect to complex SQL statements. You will have to know how to write clean code, as well as optimizing it. Expect the total duration of this project to be approx. about two and a half hour.
Tenho um banco de dados encriptado usando o SQL Cipher, mas não estou conseguindo abrí-lo, pois o mesmo está encriptado pelo SQL Cipher. Gostaria que fizessem uma cópia do projeto para mim, sem a encriptação.
The project is to build an online MySQL database for Wordpress. There are 15 database fields. 12 fields are text, 2 fields are dropdowns and 1 field is date. There are 12 reports. The information is about radio stations in the US. They are being emailed. Each record is one company's contact information and the results of the email. Records are imported via Excel or CSV. An explanation and sample records are included.
Dear Respected Freelancers, I am working on an AR App on Unity 2017.2. As part of the App, there are couple f inputs, Name, Phone Number, Email, Feedback Message, and other inputs. Taking into consideration users would be using Android as well as iOS. What I want you to do is to create a Database (compatible with Unity 2017.2 + cross platform (for iOS devices and Android) and linked with a server ready, so that I can see the data has been input by users. Also I want it to be exportable to Excel. I need the Server and Database to be sustainable as it is expected to have at least 1000 data entry per day. In case you have not understand the project, please feel free to contact me. Price is so negotiable as I am not sure about the real price of it : ) let me know your price as well ^^ We are looking for quality though. Project Type: One-time project