Posts Tagged table

Transform SQL Query To An Updating Stored Procedure

I have a SQL query that returns 2 columns whice are IDs from 2 tables on a one to one relationship.
I need this to update two table in a MS SQL database using a stored procedure, looping through each row of the query. The query currently matches 1:1 even if there is a dupe and it is important that it only updates 1 matching entry in each table even if there are dupes.

Please see attached sample query and notes.

Tags: , , , , , , , , , , , , , , , ,

Data Scraping And Possible Data Entry To Build A Database

I would like to hire someone to compile specific statistics from websites and build a database that I can then analyze in Excel. The data is all available in table format on websites. I am trying to compile quarter by quarter statistics of NBA teams in order to do further detailed analysis and create advanced metrics. The quarterly stats for every game going back to 2005 are available online in table formats and I would like to capture that data and bring it into a spreadsheet for my further analysis.

There is also older data going back to 2002, but that is not in table format and it is play by play data that would need to be converted in to quarter by quarter stats. I would like the 2005-present data first and hopefully there can be a way to process the play-by-play text to convert it into quarterly stats as well.

I have attached a sample file showing 2 lines of data. Each line represents a game played. The data going back to 2005 would require ~7000 lines to be entered. The data going back to 2002 would be another ~4000 lines

Tags: , , , , , , , , , , , , , , , ,

Pay To Book A Restaurant Table

I need a module for joomla that allows users to sign up and be able to book a table at a restaurant for a specified date with the number of people etc. Ideally i would like a credit system where they buy up and book a table and the credits is deducted but if that cant work then a simple pay as you go is sufficient. I came across a Joomla credit system called Joom Credit and a table reservations module called TableBooking. Is there any way we can mash these two together?

Tags: , , , , , , , , , , , , , , , ,

XMLCompression – Byte Table – IPhone

I require a class or set of classes that can be used to compress XML The concept is that a sending process will call the class to process amy XML string to send. Compresses the XML using a byte table as the conversion rules. The receiving process uses the opposite conversion function to convert back. The sender and receiver processes must have access to the same byte table i.e. the rules for the compression (Can be a constant or http get for the rules). This will allow mobile apps to be able to send and receive xml quickly. I have proven the concept in Java, but need a set of classes for XCode for iPhone. This is mostly about compressing known tags in an XML file the data is a separate issue. I am open to ideas.

Tags: , , , , , , , , , , , , , , , ,

VS FormView Insert

USING:
SQL 2005-2008
VS 2005 – 2008 – 2010 VB

Im having problem, and cant seem to find any solutions using Google, to be able to pre-fill textboxes in FormViewInsert mode, using data from Table A, and saving form contents into Table B.

I need a small demo created showing the process, along with detailed instructions. Need an example using both EXEC Stored Procedure and a query, and using Northwind database. Form will be called with a link using QueryString value or Session value. Link(s) on non related page may call the form, and thus would need ModeChange to insert.

Tags: , , , , , , , , , , , , , , , ,

BIO Data Printer

It is simple project to fresher can write own BIO DATA in quickly , this application is create Auto database and table if the database and table is not existing every time this application help to print the bio data and save in to in data table , the candidate can search from name from table and print the Bio data , I knew this a small project ,

Tags: , , , , , , , , , , , , , , , ,

EBay Template Fix

As you can see my reviews are GOOD. I respect your work! Another provider was not able to come up with a code to fulfill my needs. In the following link you will see the eBay template life. What I need is the ability to insert a table (in the attachment ) with information about my products on the white area (container)of the product description on ebay . The table looks like this on my website: http://www.trendsfb.com/servlet/the-133/prueba-de-nueva-ctagoria2/Detail is the one under "detail description" it has a flash and other information.

the same table needs to be inserted on the eBay template.

by the way this is just a test product on my website….

The problem is that when I insert the table(HTML code) on the product description (container) eBay template (white area) everything gets mess up, however the container accepts regular text as you can see on the eBay link.

Previous freelancer had all the src files (pictures) stored on his server, I downloaded them and are included in the Attached file along with the code for the product description table and the eBay template code.

This is a no brainer for someone with the HTML knowledge.

Send me questions if you have any before you bid

first milestone payment is $10, do not ask for more!

I need this done in 48 hrs

Just to let you know. the whole template looks good on any HTML editor (including the table with the product description) but when is uploaded on eBay is when it gets mess up! so I will provide an eBay account for the developer to test the code multiple times before I make the final payment.

Clear instructions about how to change links on the template must be given!

New freelancers with not feedback are welcome, payment will be released at the end of the project.

Bid if you are sure you can do this job "fast"

Max I am willing to pay is $40

Tags: , , , , , , , , , , , , , , , ,

Slice & Code PSD To HTML/CSS

I have a PSD that I need sliced into HTML/CSS Today.

The links on the top (home, phon, email, etc) must be clickable (directed to #)

The "Free Shipping!" must be clickable.

The shopping cart part needs to be an empty table (365×45) so that it can be filled with the shopping cart status code.
(I have the checkout button in a seporate jpg so please leave that entire area as one (365×45) table)

Please make all of the grey menu buttons clickable and linked to #
(There is a mouseover layer for the menu buttons also, please code that)

Please make the search a small form the same size and look, and the search button linked to #

Please make the "guaranteed lowest prices online" clickable and linked to #

Please make the white area one large table so I can create the body.
(keep the footer in mind)

Budget: $30

Deadline: Today

Payment via: escrow

Tags: , , , , , , , , , , , , , , , ,

Simple Apps Template For Demo

A company requested to do a demo on iPhone Apps, the project have two phases, phase I will be demo and we need to show some concept on our proposal; phase II is actual production. At this Job, we mainly focused on Phase I first.

The apps is designed for an internal company to prompt their products and events;

Scope:
1. Splash Screen, when the apps launched will show the splash screen and until user tap anywhere then jump to main menu.

2. Menu Screen; with 5 tab and navigation bar on top.
2.1 Event List; First Tab
2.2 Product; Second Tab
2.3 Photo Gallery; Third Tab
2.4 Contact; Fourth Tab
2.5 Location; Fifth Tab

Tab Layout:
1. Event List Tab
– Simple Table view with 5 Levels
– Show the event name
– Tap on each table row can alter row text

2. Product Tab
– Advanced Table View with 5 Levels
– Advanced Table will show Image at 1st Line Left, Price at 1st Line Right, Description at 2nd Line
– Tap on each table row can alter row text.

3. Photo Gallery Tab
– We will load certain images, e.g. 10 images
– User can swipe left and right to go back and forth view
– Click on each View can prompt a individual message; e.g. Assign a unique ID for each image

4. Contact & Location Tab
– Just only 1 Simple View Only, just put a different label is ok

Attached with simple structure; above Demo do not required any actual data so developer can put their own testing data and ensure the workflow is works then ok.

PLEASE NOTE:
=============
– Source Code Required
– Able to complete on before 6 Apr 2011.
– Please PM for any question

Tags: , , , , , , , , , , , , , , , ,

Expert Magento Development Team Only Start ASAP VietCodePro

I need a Magento Ecommerce Jewelery store created. I need the project started ASAP, and needs to have a demo completed by no later then 10 April 2011. If you can not have the project completed by then, please do not bid. If you are not a magento expert, and can not show me Magento portfolio products, then please dont bid.

I have the site created and its been functional, but its been having major problems, so I want it redone in Magento. Project winner will get site details to help with new site build. I have all the .csv feeds, and the table rates feeds already created.

Please read all details, and send me a PMB with the coded message at the bottom so I know you read my entire message. Please also view the attached files, as they are from the current site, and will provide you with information on the functionality.

Here are the project details:

I need a Ecommerce Jewelery website created. I have one that is done, but its having some major errors so I would like it to be recreated. You will be able to use the one done as a template.
The site will need to have following functionality.
You can get a .csv file with all product feeds from the current site. The feed contains about 1500 products
You can also export the current table rate shipping rates from the current site.

Payments
Blog
Shipping
Coupons
Promotions

Payments:
Paypal Express
Bank Payment (this payment method just shows the bank information) Review payment image attached
Western Union Payment ( this payment method just shows the western union information) Review payment image attached
Shipping: Shipping will be done by table rates. I have the file that you can just import for the site.
UPS
DHL
FedEx
EMS (named from table rates.

I have this extension already purchased that needs installed:
http://www.magentocommerce.com/magento-connect/QuartSoft/extension/3709/automatic_configurables

PMB Message: Cow Jumped Over Moon!!

Tags: , , , , , , , , , , , , , , , ,

Private Job VietCodePro

I need a Magento Ecommerce Jewelery store created. I need the project started ASAP, and needs to have a demo completed by no later then 10 April 2011. If you can not have the project completed by then, please do not bid. If you are not a magento expert, and can not show me Magento portfolio products, then please dont bid.

I have the site created and its been functional, but its been having major problems, so I want it redone in Magento. Project winner will get site details to help with new site build. I have all the .csv feeds, and the table rates feeds already created.

Please read all details, and send me a PMB with the coded message at the bottom so I know you read my entire message. Please also view the attached files, as they are from the current site, and will provide you with information on the functionality.

Here are the project details:

I need a Ecommerce Jewelery website created. I have one that is done, but its having some major errors so I would like it to be recreated. You will be able to use the one done as a template.
The site will need to have following functionality.
You can get a .csv file with all product feeds from the current site. The feed contains about 1500 products
You can also export the current table rate shipping rates from the current site.

Payments
Blog
Shipping
Coupons
Promotions

Payments:
Paypal Express
Bank Payment (this payment method just shows the bank information) Review payment image attached
Western Union Payment ( this payment method just shows the western union information) Review payment image attached
Shipping: Shipping will be done by table rates. I have the file that you can just import for the site.
UPS
DHL
FedEx
EMS (named from table rates.

I have this extension already purchased that needs installed:
http://www.magentocommerce.com/magento-connect/QuartSoft/extension/3709/automatic_configurables

PMB Message: Cow Jumped Over Moon!!

Tags: , , , , , , , , , , , , , , , ,

Objective-c Threading

I have a project working already but im stuck on a small bit of it and to get it done asap. Im reading several xml files using threading, im facing two problems;
1.my threads are not queuing up
2.while obtaining the data from the xml and adding it to my sqlite db im showing a table view with the msg Loading…. The problem here is even after the xml data has been added to sqlite my tableview is still showing Loading as the table is not being reloaded.

I will provide a simplified working copy of what i have and will need someone to fix the issue as per my layout as i cant afford redo my logic unless its already totally flawed.

I will pay on completion of task, i will need an invoice.

Tags: , , , , , , , , , , , , , , , ,

Source For Print On Canvas Suppliers In The US

Hi,

We are a big retailer of photo prints on canvas.

We would like you to conduct a complete supplier sourcing in the US, contacting printing companies that print on canvas (not retailers with a website that sells to end customers like ourselves).

These companies will have an online interface to our print orders and will need to print and ship them to the customers. Each print will be a separate custom made print (we will not order big quantities of the same print)

Assuming that we will order at least 100 prints a month, please prepare a table with the following:

1.) Name of the company
2.) Address
3.) Email address
4.) Phone number
5.) Price for 12"x16" Gallery-Wrapped canvas print (the width of the Gallery-Wrap can be 1". if otherwise please mention the width)
6.) Same for 16"x20" – you can tell them that our target price for this size is less than $30
7.) Same for 20"x24"
8.) Same for 24"x36"
9.) Monthly capacity

The table should include 30 suppliers from all across the US. Please note that if the price for number 5 is over $50, it is surely a retailer with prices for end customers, so you shouldnt even list it in the table.

If the results will be good, we will need your help with doing similar research in the UK and AU as well.

Thanks,

Assaf

Tags: , , , , , , , , , , , , , , , ,

Convert HTML Table Web Page Into Tableless CSS/HTML

Convert existing HTML Table Web Page into Tableless CSS/HTML

All sections (EXCEPT for "Perfect for all occassions") must expand vertically to be filled with text. If done properly and in a timely matter, other projects will be offered as well. This design will be converted into a WordPress template to be handled by our PHP programmers.

Tags: , , , , , ,

Private Job For Shmai2

custreg.asp?action=login

once logged in custreg.asp code points them to here if login is successful.

custreg.asp?action=goodpass

This page is stored in CustomerRegPages table. pageid is 23 – Good Login. this is the same place you added new cells for pro club form. So just do a quick hack as before. If the user logins and their ALTCUSTID (customers table) has something rather than null then display the new page which will be stored in new cell.

Tags: , , , , , ,

3 Part PHP, Form-build, Email-send And Db-builder

Hi!

I need 3 PHP files each handling their own task + test PHP file to test functionality of other 3.

Each of the 3 files will:

* Have a db-table for internal settings with "instance" ID + name to seperate saved data
* Provide an API to get/set/delete instance with all vars available.
* Be able to output XHTML forms to get/set/delete settings. With comment first <!– xx,xx –> width/height req.

On the example/test page you should be able to choose to get all settings forms inline on page or as jQuery dialog() with width and height as specified in <!– xx,xx –> at outputs first line (or by optional API-call)

So, on the example page, you should be able to make forms, set up new email post "instances" with reciver email for example, and create new db-tables… All with the help of the other 3 files and their APIs.

———————————–
When setting up a new form you should be able to choose:
* Form name
* Form action, db-builder table OR email OR post request with hidden cmd value for service name and hidden redirect
field for showing thank you. if db table, build table for you with form fields, or select any field to exclude and
instead save to custom table/row
* Form should support everything from input, textarea, CKEditor, file upload field (save as blog if we want, attach if email.)
* Form should post to itself before sending API to save – to verify data, and use random generated id/names for values
and encrypting when receiving. Extra option to add hidden field with JS that is requeried to post (as spam protection)
* www.captcha.net – support if wanted
* Have support to "add more" on group of fields, like adding unlimited photos to an article (when autobuilding tables,
use secondary table to store automaticly)
* Have support to hide group of fields if "Another delevery address"-type checkboxes/radios are set
* Be able to dump all data in API friendly format (JSON) when submitted correctly to POST
* Be able to group fields together with labels, columns, rows and extra text/br between.
* Be able to specify field type to error-check the form. text, html, numbers, date formats, file-types and so on…..
also use this info when calling db-builder API, and make available though own API

You can use many functions from:
http://code.google.com/p/php-form-builder-class/

but no need for google images. And no OOP, just plain files with reable PHP functions.

——————————————————
The email-sender only needs options for:
* ID/instance
* Name
* receiver email
* Custom email template, with support for %%varname%% and some way to loop out when unknown no. of fields, like article_id1, article_id2, article_id3.. and so on.

And it will need to output XHTML for new/editing instances, and API for GET/SET/DELETE any option on instance.

————————————————-

DB Builder

* Will save instance ID and "db"-name in settings table
* Will create 1 or more tables with one API call or by filling out form that it outputs in XHTML for inclusion as mentioned
before.
* Will allow edits in tables/rows connected to certain instance id. Both instance ID and table name has to be correct for
get/set/delete APi to work. Allow same edits to be preformed with form that can be outputed to jQuery dialog or
inline for other PHP doc.
* Will take column names and datatypes a arguments for API to add new table. IF detected need of extra table for
linking in unkown number of articles/fields/image references or so, it will automaticly make 2 tables and store same
instance ID for both

——-

The test document can be totally unstyled, no design at all, only links to test out the functions/APIs! Outputed API-forms for inline inclusion and/or jquery dialogs() should be styled, and have good web2 looks.

Extraordinary good work can result in bonus and more projects!

Dont place bid if you dont understand the project!

Tags: , , , , , ,

PHP/MYSQL Expert

Hi, … I am confronting a problem on my hosting server.
All my websites on this server are going down and coming back, and going down and coming back.
This has been going on since last wednesday.
It seems that the httpd service is stopping.

Also it seems that the problem is related to a so called TABLE CACHE. and that my mysql configuration file is much smaller than it should be.

This all seems to be caused by one of my websites on this server which is running joomla.

Check this error message out:

TABLE CACHE
Current table_cache value = 64 tables
You have a total of 3463 tables
You have 64 open tables.
Current table_cache hit rate is 1%
, while 100% of your table cache is in use
You should probably increase your table_cache

This also seems to explain why "tmp table" is showing up so frequently with the user webcur_lps.

I need someone with experience to solve this problem for me ASAP.

Tags: , , , , , ,

3 Part PHP Project – Formbuilder, Emailer & Db-builde

Hi!

I need 3 PHP files each handling their own task + test PHP file to test functionality of other 3.

Each of the 3 files will:

* Have a db-table for internal settings with "instance" ID + name to seperate saved data
* Provide an API to get/set/delete instance with all vars available.
* Be able to output XHTML forms to get/set/delete settings. With comment first <!– xx,xx –> width/height req.

On the example/test page you should be able to choose to get all settings forms inline on page or as jQuery dialog() with width and height as specified in <!– xx,xx –> at outputs first line (or by optional API-call)

So, on the example page, you should be able to make forms, set up new email post "instances" with reciver email for example, and create new db-tables… All with the help of the other 3 files and their APIs.

———————————–
When setting up a new form you should be able to choose:
* Form name
* Form action, db-builder table OR email OR post request with hidden cmd value for service name and hidden redirect
field for showing thank you. if db table, build table for you with form fields, or select any field to exclude and
instead save to custom table/row
* Form should support everything from input, textarea, CKEditor, file upload field (save as blog if we want, attach if email.)
* Form should post to itself before sending API to save – to verify data, and use random generated id/names for values
and encrypting when receiving. Extra option to add hidden field with JS that is requeried to post (as spam protection)
* www.captcha.net – support if wanted
* Have support to "add more" on group of fields, like adding unlimited photos to an article (when autobuilding tables,
use secondary table to store automaticly)
* Have support to hide group of fields if "Another delevery address"-type checkboxes/radios are set
* Be able to dump all data in API friendly format (JSON) when submitted correctly to POST
* Be able to group fields together with labels, columns, rows and extra text/br between.
* Be able to specify field type to error-check the form. text, html, numbers, date formats, file-types and so on…..
also use this info when calling db-builder API, and make available though own API

You can use many functions from:
http://code.google.com/p/php-form-builder-class/

but no need for google images. And no OOP, just plain files with reable PHP functions.

——————————————————
The email-sender only needs options for:
* ID/instance
* Name
* receiver email
* Custom email template, with support for %%varname%% and some way to loop out when unknown no. of fields, like article_id1, article_id2, article_id3.. and so on.

And it will need to output XHTML for new/editing instances, and API for GET/SET/DELETE any option on instance.

————————————————-

DB Builder

* Will save instance ID and "db"-name in settings table
* Will create 1 or more tables with one API call or by filling out form that it outputs in XHTML for inclusion as mentioned
before.
* Will allow edits in tables/rows connected to certain instance id. Both instance ID and table name has to be correct for
get/set/delete APi to work. Allow same edits to be preformed with form that can be outputed to jQuery dialog or
inline for other PHP doc.
* Will take column names and datatypes a arguments for API to add new table. IF detected need of extra table for
linking in unkown number of articles/fields/image references or so, it will automaticly make 2 tables and store same
instance ID for both

——-

The test document can be totally unstyled, no design at all, only links to test out the functions/APIs! Outputed API-forms for inline inclusion and/or jquery dialogs() should be styled, and have good web2 looks.

Extraordinary good work can result in bonus and more projects!

Dont place bid if you dont understand the project!

Tags: , , , , , ,

Build Html Table With Data From An XML Feed

I have two xml feeds that I need some data extracting and displayed on a php webpage.

The first feed has two elements that need to be displayed.

The second feed has seven elements that need to be displayed in a html table, with the table row repeating for the next 10 instances.

A third table is needed for a reworking of some of the data in the second xml feed. Only one instance is pulled from the XML feed this time.

Tags: , , , , , ,

Customisation Needed For Groupon Clone

-DO NOT BID IF YOU HAVE NO PRIOR EXPERIENCE WITH GROUP BUYING SITE
-DO NOT BID IF YOU ARE OFFERING TO BUILD A WEBSITE FROM SCRATCH

I have bought a script from groupscript.net
check out the demo there before you bid.
I need some customisation to be done.

Requirements:

-Add "branches" when creating a deal,
deal creator can input
1. restaurant branch name
2. branch adress
3. button to add another branch

-add branches to order page
after hitting BUY, on the order page, a table should be displayed.
The table automatically displays the list of "branches" of the restaurant featured in the deal (as inputted when creating the deal)

In that table, the user can input quantity of coupons he wanted to buy for each branch.

Basically I want user to choose which restaurant branch he want his coupon to be valid for.

The grand total will adjust accordingly.

Before the grand total, a random number should be generated, between 001-300. This random number will be added to the grand total and serves as identification for payments (for manual review)

-branch into coupon codes
add branch unique code to coupon code

-Add a way so that I can print the list of coupon bought for each branch. (I will give it to the restaurants)

-Below the table, user can choose payment method.

-Add another payment method (does not involve any gateway) on checkout: bank transfer. User can choose "Bank Transfer" as payment method.

This is 100% manual bank transfer which does not involve sending funds electronically.
Bank account info will be displayed to users.. user have to pay manually.

-Add a order confirmation method
After submitting purchase info, this is like a thank you page.
We are asking the buyer to tell us if they have sent the bank payment.
It will display our contact number, and a form.
The form will have to be filled in with buyers name, amount transferred, and when submitted, the data will be forwarded to our email account.

-add order confirmation on admin backend
for every order that uses "Bank Transfer" payment method, the orders are automatically on "Pending" status.
Admin must Confirm the orders MANUALLY.
Confirmed orders will be processed like usual by the system.

Automatically send email containing instructions as in the thank you page.

Tags: , , , , , ,

PHP MySQL Tag Creation Tool

A PHP tool to search text from select columns in all tables in a MySQL database and store this information for a tag cloud presentation.

function 1:

A. Read the database
B. Display the tables and columns in a grid and provide the user a checkbox selection option for inclusion/exclusion of certain data types.

function 2:

Add all textual words from specified columns to another table (tag table).

function 3:

A. Search the database and selected tables again for the words in the newly created tag table.
B. Count the words usage – ignoring case and matching the whole word
C. Add the counts to the new tag table

function 4:

A. Display tag table to eliminate common words (in, the, of,….)
B. Provide and option to add these words to a new "exclusion" table to be used in future runs of the tool

Thanks for your interest.

Tags: , , , , , ,

Openbravo POS Custom Work

1) In "Close cash" panel add sale by user(s)
2) Put restriction in table orders in this way – only user who opens a table, can access table until payment is done and table is closed
3) Admin report "Cash by user" has in last column price without Tax (subvalue) – needs to be changed to price with Tax (Total)

Tags: , , , , , ,

PHP Update And Add Some Features

Existing PHP forms that reference some tables and do some queries and do calculations on the data based on date and time, and when to rotate out items.

Need someone to finish up – adding some features, reference some tables and allow users to change fields.

User permissions on an existing user table to limit access – 3 access levels, view only, modify (change days), and admin (add, deleete, modify) existing location table.

Form rfor users to modify locations in existing table, specify a range to easily change a large range of records with the same data, or to individually select and change a record.

Need someone that is an experienced PHP programmer, and please provide examples of work and projects you have done.

We are looking for best price for the best quality of work, and may lead to longer term working relationship, and projects.

Tags: , , , , , ,

Asterisk AGI Billing, PHP Asterisk VoIP Customer Portal

In the development of a PHP based VoIP user portal, we are seeking an Asterisk AGI script which will check a balance value in a MySQL database, compare to a rate table, determine how many seconds the call can last based on the preceding and allow the call to terminate appropriately. This script will then need to rate the call and deduct the appropriate amount from the balance and update the value in the mySQL table. The cdr table will also need to reflect the total amount billed for the call.

In addition, we are seeking a PHP script for adding new peers to the server (asterisk-realtime). We will require the ability to have different billing methods, ie postpaid, certain amount of minutes included, then billed per minute.

Tags: , , , , , ,

Comparison Table Modifications

I have a comparison website with a database driven comparison table on it. I would like to add a five columns to the table and two extra links. The extra columns will also need to be database driven.

There is a CMS that enables me to add and edit the comparison tables, so these extra columns will need to be factored into the CMS so that I can also edit the data in these new columns via the CMS.

Tags: , , , , , ,

.Net MS Office

There are 2 utilities needed:

1) This utility will facilitate the import of a file into a SQL table. The interface will require the user to select a file (MS Excel csv most likely), request a password (use this to unprotect the file and re-protect afterwards), then import the data into a SQL table. There will need to be a control record created (in a SQL table) to record the who, what, when and how many records/rows etc. Once the data is imported, the file will need to be protected again, with the same password.

2) This utility is very similar to the first except it is exporting data from SQL. In this case, the password will be used to protect the file. The folder/filename will be prompted for. A control record will be created to record the who, what, when, where and how many.

Code can be done in C# or VB.Net. MS SQL Server 2008 database.

Milestones:
50% upon delivery of code and installation
50% when testing completed and signed off

Tags: , , , , , ,

PHP-JOOMLA-MySQL Database Connection

Project:
We are looking for a Joomla 1.5 PHP developer to create a table with drill down capabilities for our website. This table would be connected to our MySQL database and pull the required information from our database based on the user

Tags: , , , , , ,

Facebook Login/Reg Repair And Facebook App

I recently had a freelancer create a Facebook Registration and Login for my site. It will collect the Facebook users ID and email address, put their first and last name into separate fields in two database tables. However, he broke it and has not fixed it. Partial code is there.
The process (Repair Facebook Registration/Login):

Users come to my site. Register using their Facebook account; their ID, email, First Name and Last Name are collected and posted to a DB table (Their first and last names must be split and posted to the First Name and Last Name fields in my users table). Another table is involved that references a foreign key in the users table and creates a listing for the new user in the listings DB table.
Once the Facebook user info is collected, the user will be redirected to a page to finish filling out their online profile. This page exists. When they fill out this page (exists) then they will be directed to their Account Manager page (Exists and works) so that they can alter their page.

The Facebook App:
This App will show data from the users by referencing the users Facebook ID and display records from a table in two different pages within the app. The Php pages will live on the server and need to be displayed in the app ( I will create with AJAX Tabbed Panels). The information that is being displayed already exists in the Database. Facebook users will be able to get this app and if they have signed up for our site, then their data (which is a list of contacts to other members in our site) will be displayed in the app on their page.
The information being displayed is business referrals that send business to the member, and show who the member refers business to. And, testimonials by members as well as a "star rating" graphic.

IMPORTANT: You must speak and write perfect English. I do not have time to translate for you. Prior to selecting the bidder, we will have a Skype or AIM chat and I will ask you to define various, simple American Colloquialisms to prove your ability to understand English. If that is a challenge for you. DO NOT BID.

I will have detailed instructions with images on the process for you before you start, and you may request to see these prior to securing the bid.

Thank You.

Tags: , , , , , ,

XML PROGRAMMER / 3D CART TO MAKE STOCK TABLE WITH PRICE FILE

XML PROGRAMMER / 3D CART TO MAKE STOCK TABLE WITH PRICE FILE

We have the Price file for various items, we need to generate stock table that are in the price file, the price file is in the FTP folder of the site, we need someone to generate the Stock values quantity and display them on the Site into an html table, using whatever coding for a 3D Cart Store, We dont have access to any Database or Source code, so if you are familair with 3d cart, you can make javacscript html table with a simple txt or csv flat file from the FTP Folder, then itll be great and we also haev XML that can be integrated but not sure how. Someone pelase help.

Waiting For Offer, small budget, aorund 50$ to 75$ Max.

Tags: , , , , , ,

Google Map – Heat Map With Animation

1) You should have experience with Google maps or heat maps that you can show me.
2) I have files on my server and I want to be able to generate graphs from them. (My scripts generate new files and then I want to make heat maps based on these new files.) The program should allow the user to choose a file and then create the heat map. The graphs should allow for the user to visualize different variables. The model for the map tool should be http://bis.clients.talis.com/.
3) So the map should be annimated and show allow for the user to show "heat" for different variables. There should be a pulldown menu that will display all the variables. This will be the first step (after selection of the file to be used). The user can then select 4 different variables. This will be the four colored buttons that you can see at the top right of http://bis.clients.talis.com/. So they choose 4 variables to visualize simultaneously and then they can play the automation as shown on that site (http://bis.clients.talis.com/.). The size of the actually google map should be somewhat adjustable. The color of the background of the application does not need to be the (ugly) blue at http://bis.clients.talis.com/.
4) There should also be a "ALL Time" button that shows the heat for any of the selected variables summarized over the entire time frame. The user would select a single variable for this and then the could see a heat map for just that variable over the entire time frame. In this case the size of the map could be larger since the graphs wont be present. Ajax should be used on this map so that when the user clicks on an area the closest record to that location should display the "Text" field of that record. Actually it should display the Text field of the 3 closest records.
5) There should also be the option to have two instances of the google map shown next to each other. This would not be in the case of the animated map (not like #3 above) but two instances of the case #4 above. This is so that the user can visualize two different variables (in the ALL TIME mode) next to each other.
6) The files are csv files. However I want to have a script that will make a temporary table in a mysql database (made specifically for this application). The script would simply (?) read the file and based on the number of columns and the column names create a table with these fields and then upload the csv as the records for this table.

Maybe there could be a "loading indicator" until the graph is ready.
The steps would be something like this
1. User navigates to a file on the server.
2. there is button that says something like, graph this file.
3. user presses that button
4. a script is run that creates a table (this table will later be
deleted but you dont have to worry about that) with the fields coming
from the file column names and the records being the rows of the file.
5. Then you do the normal graph sets to create the graphs based on
calls to this table.
The code should be modular enough so that if I decide to just access database data (instead of starting with the csv files) that it should not be hard to chop the code and do this.
Here is a nice beginning but not exactly what I am after.
http://www.eggheadcafe.com/tutorials/aspnet/d21d8b31-bcb7-4777-9637-49b71fed6d38/generating-a-heat-map-wit.aspx

Tags: , , , , , ,

CRELOADED – Minor Enhancements 3

Create a new PHP file as following:
————————————————————————————————————————————————
Top Portion – Top section has two drop downs – category (list of product categories), format (Auction, FixPrice) and a text search field for product model entry. These are used as filters for the detail list portion below.
————————————————————————————————————————————————
Detail/Product List Section – This section displays the list of products from product catalog tables that are not in a database table ebay_active. This table (ebay_active) has list of items already active on ebay having same products_model field as in the products table. You dont have to write code to populate this table. You need to look into the table and the product catalog, and, show those products that are not in ebay_active table. Query should also include the category and format filter criteria selected from the Top portion.

For each row display following columns:

Thumbnail (populate this from products table)
Product Model (populate this from products table)
Title (populate this from products table, make it editable)
Description (when click on this field, it should open a popup, see more below *)
Price (populate this from products table, make it editable)
Category ID (leave it blank, editable)
Domestic Shipping (default 2.95, editable)
International Shipping (default, 3.95, editable)
Free Shipping (This is a checkbox, if the column header is clicked it selects all rows)
Select All (This is a checkbox, if the column header is clicked it selects all rows)
——————————————————————————————————————————————–
Bottom Portion – Has a buttons as submit, cancel. Submit button will take the selected rows (select checkbox) and insert into another table – ebay_listing_queue.
———————————————————————————————————————————————
* Description Field Popup:
Since, description is big, and, it has HTML. This field will have a small edit image. Click on it will open a popup displaying the
description in a design view (not the source HTML). It will have 3 buttons – Save, Save and Update Product, Cancel.

Save – This will only save locally in the session.
Save and Update Product – This will save locally as well as update the product description table
Cancel – Do nothing, close popup.

Create a New Menu Section in admin Ebay, add a menu item Add Items. Link the above PHP to this.

Note: This project will not require you to understand ebay. If you have questions, ask me before bidding.

Tags: , , , , , ,

Database Management Web

I need some one that can do the follow task:

I need a page with capabilities to:
1-taking a connectionstring show database in dropdownlist.
2- then show tables on that database.
3- Selecting a table, show column and column datatype.
4- Clone that table with new one name.
5- Capability to do Alias for columns.

Database is SQL Server 2008 and Visual Studio 2010.

most important i need this functionality at least for saturday. So, if you got the experiences doing something like this you may get the job.

IF you have previous project that can do this…let me now

Skills Required:
jQuery, Microsoft SQL Server, Entity Framework, LINQ to SQL

Tags: , , , , , ,