Get a Freelance Job

Hello all,

We have 2 websites www.jappie.eu and www.muurtattoo.nl
for those website both os Commerce we need a script to clean the product option tables.

We had an product import php script that imported the products but after i found many dubble entrees in the option tables.
so we need a script to clean that tables and filter out the dubble option values and correct that on the products.

Thanks

Bert Niesing

The enclosed PDF document contains several tables of data, which I need accurately converted to an Excel document.

Tables of data are available in pages 9,10,11,12,13 and 14

Tables 1 and 2 in each of these pages need to be merged together. Same for tables 3 and 4. How? Just by Putting table 2 to the right of table 1, and table 4 to the right of table 3.

This is because these tables represent prices per height (in rows) and widths (columns). Tables 2 and 4 contain widths that complement…

Project considers to create 3 new tables with the referenced forms for ADD, SEARCH, MANAGE (see) and UPDATED records in the referenced tables.

Service required:
- Created functionality as per the PDF document attached.
- Support on Testing and upload to my server.
- Post-Implementation support.

Please find attached the functional specifications for the tables.

Rgds
Jorge

Need someone to migrate all database tables from existing website to a new host and new template. It will include but not limited to the following table users, categories, orders, products, etc.

Hello,

in several mysql tables are data about products, actually product descriptions

the data are in english language, you shall write a php script in which I can choose what tables to translate to another language in utf-8.

it is always the same column but in different tables that have to be translated, the result shall be as following:

original text
empty line
info sentence (that sentence will always be the same)
empty line
translated text

the translation shall be made by l…

I am looking to create a virtual trade meet where users can setup shop at a table and then have other virtual members come and browse what they have available. I’m thinking of a table setup like joining a game on pogo to play with other members… the host sits down and than others can join them at the table to discuss a trade.

Members can select items from a predefined list of 1500+ items available in a separate database to add to their tables for trade but there would be a visual represent…

I am not sure if this is possible but we have had a large site done which we are not satisfied with and they have used SOLR and DJango for the datafields.

What I would like to do is publish individual articles for each page and have each table appear below the content on the page and be able to sort into different tables for searches and displays. For example.

Article Title

Article Description

Article Synopsis

Article Result etc.

Each Article is quite large and we have 4000 art…

An educational app for android to quiz on times tables (multiplication tables).

Has 8 screens that link together, including main menu, quiz screen, results screen, screen with answers, progress chart screen.

Very simple design, no animations, focus on functionality.

Similar in design to ‘Maths Workout App’ but with enough variations to be different and improved.

Will send proper design in Word Format when terms are agreed.

Lab 4-7 Building the Physical Model
Scenario/Summary
Lab #4-7 will introduce the various aspects of the SQL select statement and the methods of retrieving data from the database tables. The lab will utilize a set of tables found in the script file (LeeBooks.sql) found in the Doc Sharing area of the website. You will need to download the file, then run the script in your SQL*Plus session. These tables will be used for the remaining labs in this class.
The SELECT statement is the primary mean…

Hi,

I have a site that was built on OsCommerce. There were many customization’s to the tables in OsCommerce, and I can’t update the OsCommerce because of these customized tables. I want to convert the site to WordPress, and a reliable plugin that will make it easy to convert the tables into WordPress and will be easy to update. It’s important that the site looks the same and has the same functionality.

Thanks!
J

I have a Drupal site with 6 pages of STATIC HTML TABLES. See attached image for a example. I have put all the numerical data into MYSQL Database and I just need some basic PHP done so that the HTML tables pull the data from the DATABASE.

There are Monthly and Quarterly charts for each of the 6 pages. If the DATES on the Monthly and Quarterly are the same, they should show in 1 chart.

Will provide more details. PHP, MYSQL, DRUPAL professionals only.

THIS IS A WORDPRESS PAGE.

I need a website page copied basically just the tables and the code part.

However they click sign up a pop up will open up that will say the name of the package and a description and a field that says

“Full Name” “Business Name”
“URL” “EMAIL”
“Phone” “CellPHONE:”
“DETAILS”

then they hit submit it says thanks with a few other text ill have then i get an email with that information.

Should be a copy and paste type of deal other than this portion.

See the attachment. I want this look on my website.

I know the website where this is so you can just go to their page and grab it, however I want it coded so they don’t know we took it from them.

I have a wordpress page.

** $20 for this
** $10 more to have the sign up go to a jquery pop up that will ask them for “First & Last Name” “Their Website URL” “Business Name” “Business Industry” “Cell Phone” “Additional Email” “message” and a spam capture, it will also tell me what package tehy are signing up for. then they can send it

See the attachment. I want this look on my website.

I know the website so that should make it easier.

I have a wordpress page.

** $20 for this
** $10 more to have the sign up go to a jquery pop up that will ask them for “First & Last Name” “Their Website URL” “Business Name” “Business Industry” “Cell Phone” “Additional Email” then they can send it.

I need 2 html parse scripts to extract text (including tables) from a file listing HTML pages (URLs and local FS) and write out in CSV. The output will include URL/filename, title tags and standard and custom metadata (in one output file) and URL/filename and various nodes in another output file. I prefer ruby/nokogiri/csv, etc. I’ll furnish an initial node tree (the html isn’t consistently formatted) and a list of the metadata (again, not consistently populated). thanks!

We ONLY need a MySQL programmer for this project. We have a Linux CentOS Virtual Dedicated Server and a Windows Virtual Dedicated Server with GoDaddy. We have two MySQL databases on the Windows Server, one with 1 table and the other with 9 tables. We need the following services:

(1) Create a NEW MySQL database on the Linux server for the following tasks;

(2) Copy the 10 tables and data AS-IS from the Windows server databases to the new Linux server;

(3) Create new tables and import data from fields in our Excel spreadsheets, the spreadsheets contain the following fields:
(a) 24 tables with no more than 7 fields, most have identical fields;
(b) 3 tables with no more than 15 fields;

We will provide you with access to both servers and the databases immediately along with additional details.

Thank you.

We want to spend between $75-$100. We are looking to get some tables made for our game. We want family, global, and prize tables made, but family needs to be customized with good detail that is unique from the other tables. Global,prizes and all of the tables in game should be a generic design based on the attachments for this project. Be sure to include the color scheme and add a beautiful and unique “flavor” to the family table that sets it apart from the global and prizes. You will need to refer to what I’m talking about at www.mob-wars.com. If you have an questions please address then. Project expected to be done within the week. Thanks

Hello

My client is a Rugby Football club that has teams in the following leagues (click “League Table”):

[1] http://clubs.rfu.com/Fixtures/MatchByDivision.aspx?DivID=130411134
[2] http://clubs.rfu.com/Fixtures/MatchByDivision.aspx?DivID=130411134

I would like to scrape these league tables so they can be displayed on their website in the formatting and style of my choice.

I am looking for someone to do this in PHP and to provide the data as a multidimensional PHP array.

Please take a look at the source code first because the league tables are displayed using JavaScript and will probably be a bit trickier than you first think.

Regards
Chris

go to this URL: http://screencast.com/t/SCXE6rrCp

In this URL, you will see a tournament board, and pool tables on the bottom. If you click the pool tables, they will return to 100% opacity, if you click again it goes down to 50%. Like an Off/On switch. And they are added to database when clicked, and if clicked in database they are deleted. I need, that if they are in the “tables” database, then they are “on”, 100% opacity. (when refreshed) very simple part.

Second part.

All Player 1, Player 2 on the tables should be removed from the tables, these are just place holders.

How these are filled is with drag and drop. So the tables that are “on” say 4 5 6 7 are on, they should be “droppable”. On the tournament chart you will see an orange half circle, going to be known as the movers. These movers need to be on every match that has an opponent. I need these added, top: and left:. Then made draggable. I made 1 example on Lee and Rob. So if table 4 was on, and I drug the mover from Lee and Rob to table 4, there names would appear where player 1 and player 2 are, the mover would no longer be there, and the color of Lee and Rob would go from Blue to Red, to show that it is “in a match”.

In the screenshot shows a context menu and is the winner/loser which works. Once the winner/loser is chosen, they will be removed from that table, and it will be now open and blank, and someone else should be able to be dropped on it. And the names should be a light gray since that match is finished now.

I should be able to move multiple, like chuck and kip to table 3, lee and rob table 4, leyroy and elvis table 5, and etc. the same context menu who won/lost should be copied on to the table also so I can click on that or that match on top to decide the winner.

I will have a lot more on this after this part, so please let me know asap.

And need to be able to start today.

Pricing Table screenshot:
see attached file: sept8-pricing-table-colours.jpg

pls see table – I would like to use this style on the two table graphics you can find at : current-CD-tables-to-change-sept8.jpg file and the data for those tables is in the tables.html

I need someone capable of redo the two tables to they look more like the pricing tables in the first example. Also I would like there to be a roll-over function, so which ever column selected it is in Green when nothing is hovering over the option is stays Blue.

Pricing Table screenshot:
see attached file: sept8-pricing-table-colours.jpg

pls see table – I would like to use this style on the two table graphics you can find at : current-CD-tables-to-change-sept8.jpg file and the data for those tables is in the tables.html

I need someone capable of redo the two tables to they look more like the pricing tables in the first example. Also I would like there to be a roll-over function, so which ever column selected it is in Green when nothing is hovering over the option is stays Blue.

Must be cakephp expert

I have a table that has 2 flags specifying if there are two followup deals. So these share same table field values as original Deal.

What’s required:

1. To have each type of Deal (original, 2, 3) to be stored as separate `deals` table row.
2. To have a mapper(pivot) table that interconnects 3 types of same deal in `deals` table by storing their respective ids.
3. Adjust the rest of the script code that was relying on old `deals` schema to support new one.

We have a need to have 6 different HTML forms connected via PHP submit scripts to MySQL tables. In some forms along with the string data, images must me collected and submitted to the DB. So, the scope in short is: design forms, design tables, design scripts.

I have a mysql database table that has data already and I would like more data to be added to it from an excel file, ie merge the two together.

Should be quick and easy for someone who knows what they are doing.

Thanks,

Richard

In the deals table we have five columns

name, description, private_note, coupon_conditions, coupon_highlights

and when you enter a deal from the admin panel, the above mentioned columns get filled, and they store information for english language. Now in the deals table we have five columns for the deal entered in the another language, which are:

name_por, description_por, private_note_por, coupon_conditions_por, coupon_highlights_por

now when you enter a deal in the other Language from the admin panel these columns remain empty. the only columns that get information from the admin panel are for english language.

that’s why when you enter a deal from the admin panel, you see everything when you are in english language but when you switch to Portuguese language you get empty result in these columns.

I’d like to have a script that will connect to one database and copy 2 tables to my second database and overwrites the date in those two tables.

The tables will be named the same. I just need the date to be overwritten in the second one.

If you have any questions please send me a message.

Thanks

Jan

In the deals table we have five columns

name, description, private_note, coupon_conditions, coupon_highlights

and when you enter a deal from the admin panel, the above mentioned columns get filled, and they store information for english language. Now in the deals table we have five columns for the deal entered in the another language, which are:

name_por, description_por, private_note_por, coupon_conditions_por, coupon_highlights_por

now when you enter a deal in the other Language from the admin panel these columns remain empty. the only columns that get information from the admin panel are for english language.

that’s why when you enter a deal from the admin panel, you see everything when you are in english language but when you switch to Portuguese language you get empty result in these columns.

I need a script written to

1. take two input parameters
2. select a range of records from a table
3. summarise the results to create an index/table of contents for the report
4. the summary/index should act as a link to the relevant section in the body of the report.
5. create the body of the report

I will require good robust coding an attention to detail in delivering a professional report format.

Also will need a piece of code to strip out any non 0-9, a-Z type characters that are potentially in the table.

I have recently had a database rebuilt in php. I need to move data from 13 tables in MS Access into the php database so requirements are:

Understand tables in old database (13 tables)
Understand tables in new database (21 tables)and modified structure
Facilitate upload of data into new tables.

I will provide MS Access database in zip file containing 13 tables.

Wanting a couple of templates that already exist having tables added to them, plus a couple of logos for an education site.

Thanks,

Richard

Php website with dynamic pages needs tables changed to divs, with listings centred on page (currently displayed on left). Also need facebook like buttons and twitter ‘tweet’ buttons added on template pages for dynamic urls (3 different template pages)

I have some MS word copy that needs to be converted into HTML tables. It will take 1-2 hours.. probably less. Really simple job, just need it done really quickly.

I will provide the copy and a template table. This is pretty much copy-and-paste work. Easy money!

Four Tables. Will require addition and subtracting. See attached 4 tables.

Main table = Item_List.
Table = Item Adjustment
Table = Item Received
Table = Item Sold

12 Columns

From TABLE Item_List : ItemId, ItemNum, Cost, SalesPrice, Notes.

From TABLE Item Adjustment: Adj_Loc, Adj_Q.

From TABLE Item Received: Rec_Loc, Rec_Q.

From TABLE Item Sold: Sold_Loc, Sold_Q.

The col Current will = Adj_Q + Rec_Q – Sold_Q = Current_Q

All math based on the total sum for each location in TABLES Adj+Rec-Sold and showing all Item_List.ItemID’s

Structure Example:

ItemId | ItemNum | Adj_Loc | Adj_Q | Rec_Loc | Rec_Q | Sold_Loc | Sold_Q | Current | Cost | SalesPrice | Notes

Please read COMPLETE description before bidding…and make sure to check back here for any updates.

First and foremost there is NOT MUCH OF A BUDGET to do this. We have a website that right now is laid out in tables…I would like to convert this to DIVs. Also it has embedded CSS on each page, I would like to create one main external CSS file for all the pages. There are 10 pages total…all the same layout/etc…the only thing different is the actual content on the pages (varying between 1-3 columns).

It shouldn’t be a ton of work…as once you get the actual layout done once…it can just be copied to each page…and then work on the content of the pages from there.

It would be nice if you could provide references where you have done similar work before. Looking to get this done ASAP.

I WILL PROVIDE WEBSITE LINK VIA PM ONLY…I will not post it in public. Thanks!

We need to sync information regarding user and orders submitted by users.

USER TABLES
we have 3 tables with user informations

One of this is a Joomla jos_users and two are with data collected from different websites registration process and one from a mobile app registration form.
We can use a new one table with edit and sync feature.
jos_users and the users from mobile app should be synced.
WE HAVE just done a smll script to put users into joomla.

ORDERS
Also we have two different tables with order information sent by our customer
One from a custom mobile app and one from joomla component fabrik
We have to sync data in both tables

Use the database and tables from last week’s assignment to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the Del Mar store. Check results by selecting all columns from both tables.

1) Use the database and tables from last week’s assignment to write SQL Select queries using Between, Like with Joins:
a. Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use salary to restrict data.
b. Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use hire dates to restrict data.
c. Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use telephone area codes to restrict data.
d. Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use age to restrict data.
e. Write a SQL query that joins the two tables to produce a third table. Use Select Into.
f. Deliverable: Save each SQL Statement for the above in a Word file and post using the Assignments tab with your week 3 individual assignments.
2) Use the updated database to write the following queries:
a. Select employees’ including last names and order them by EEO-1 classification.
b. Select employees’ including last names and order them by salary.
c. Select employees’ last names and order them by salary in their EEO-1 classification.
d. Count employees grouped by Exempt/Non-Exempt Status.
e. Count employees grouped by their EEO-1 classification.
f. Deliverable: Save each SQL Statement for the above in a Word file and post using the Assignments tab with your week 3 individual assignments.

Objective:-
1.To complete a mysql query on Virtuemart tables to produce desired csv file output.
2. The mysql query produced must run in Navicat 8 mysql for windows.

Requirements:-
Job has 6 Tasks – see attached file – task.csv, where the attachment contains:
- required alias field names and desired csv format for query output
- VM database equivalent fields & tables (discovered so far)
- the 6 task details, listed under the field the task applies to.

Also need query to be commented so I can add “custom data” in right places & add extra fields easily should they ever be needed. Comments must take account of any joins needed (i.e. how to add joins).

Skills needed:-
solid mysql query creation
ability to concatenate, x-ref, append, identify (a few) fields in DB, & produce joins where data resides in different tables.
Provide coherent comments on code

I can provide DB login details to a Virtuemart example if this needed.

Attachment 2 – nevermind.txt – my attempt at part of the query – if it’s of any use!

Priority: Fairly Urgent!

Four Tables. Will require addition and subtracting. See attached 4 tables.

Main table = Item_List.
Table = Item Adjustment
Table = Item Received
Table = Item Sold

12 Columns

From TABLE Item_List : ItemId, ItemNum, Cost, SalesPrice, Notes.

From TABLE Item Adjustment: Adj_Loc, Adj_Q.

From TABLE Item Received: Rec_Loc, Rec_Q.

From TABLE Item Sold: Sold_Loc, Sold_Q.

The col Current will = Adj_Q + Rec_Q – Sold_Q = Current_Q

All math based on the total sum for each location in TABLES Adj+Rec-Sold and showing all Item_List.ItemID’s

Structure Example:

ItemId | ItemNum | Adj_Loc | Adj_Q | Rec_Loc | Rec_Q | Sold_Loc | Sold_Q | Current | Cost | SalesPrice | Notes

We Require several Excel files whose data imported into corresponding new MySQL database from our site’s admin area via new sections created in the admin area for import from Excel.

There are about 6 Excel sheet tables.

Then following that we need to create new data fields when new members register on the site, like his place of birth, the time of his birth. Birthdate is already captured when new members register on the site, and this will be compared against columns in the new MySQL tables created/updated from the corresponding Ms EXcel tables, to derive the user’s corresponding zodiac sign.

The zodiac sign, and place of birth and time of birth of the user will be used in conjunction with these new MYSQL tables to retrieve data from the corresponding cells in the MySQL table and presented on the frontend pages of the website.

As a rule of thumb, these tables contain predictions of a user’s compatibility with other users, and also predictions about his inner character, personality and his attitude when he is in love. So, matching with frontend data helps to pull out relevant data and show on frontend pages to users. When users press buttons (named after these Excel sheet columns), they can retrieve the above-mentioned data that are displayed on frontend pages for their viewing.

I have 2 database tables and both reside on a Remote Server and Locally.

Table 1:

Company_UID, Company_Name

Table 2:

id, site_id, description, url, start, stop

Both Tables are to be merged with the local datatable AND saved.

Table 1: Master datatable is the remote table, so that one will have the most up to date information (meaning, update the local server with information from the remote server)

Table 2: Master datatable is the local table and will have the most up to date information (update the remote server with information from the local server)

Table 2: there could be NEW entries into the datatable on the remote server that are NOT in the local. In this case, those new entries need to be merged into the local datatable

*** This HAS to be in vb.net. It should also be tested with MySQL and a .NET connector.

*** You can use dataset.merge as long as it works exactly as mentioned above.