Seperate Database In To Two Files Using Identified Criteria

This will be a quick and simple job for anyone that works with large data sets. I have a csv file with around 45 to 46 million records. Most of the fields in the file are not needed and will be deleted. I have attached a small sample of the file.

The key item we will be looking at is the date of birth (Birth date) (DOB) column. There are records in the date of birth field that are clearly not correct and must be output to a separate file. We know these are not correct DOB’s just by looking at the data. The last two characters (day of birth)are 00 or the month of birth is listed as 00. Any record with a DOB that has two zeros for month, or day of birth needs to be output to a new file. It is possible to have two zeros in a row and have and a record be accurate as long as the zeros cross over between month and day or month and year. If you review the sample you will see rows in purple. These are the rows that would be output to another file.

Project summary:

1. Save only fields that are highlighted in yellow and delete all other fields from the file.

2. Split the file into two separate files. One will have only records that have two zeros in the month, day or year field and the other will have records that appear to have valid dates of birth.

Actually very very simple if you work with large files. Completed file should be saved as a txt file.

Please ask any questions.

Thank you for your consideration.

Cannot Log In To Magento Admin

I am starting a new Magento site and am using Siteground as my host. I installed Magento (through Siteground, not manually) onto my root. When I go to mydomain.org/admin I am told Invalid Username or Password. I’ve plugged in every configuration of UN and PW to no avail.

What I’ve seen on threads is that possibly it does not like the local host.

What I want is to be able to access the admin, and an explanation of both what was the issue and how it was corrected.

Thank you,
Elio

Turnkey Adult Website

I need a website, for two of my models. Preferably on the same website. We need to have a chat room we can sale access to, we need to be able to sale dvd and cd sets of images, need a request form so the people can request special things from the models, etc. I need a turnkey site, all I want to do is replace pictures with actual pictures of the girls and replace the text, add some products and start making money.

Preferably would like a girly looking website, with black and pink colors, or white and light blue and pink. Etc.

I don’t have a big budget for this, and need this within the next few days.

Osc: Easypopulate – Empty Fields

I just need Easypopulate to stop adding the value “0” into fields which should be left empty.

———–

I´m also looking for a programmer with extensive knowledge with OSCommerce, that in other words can track down problems within seconds and modify code like he had done nothing else 🙂
If you are “the one” then leave a message for me about this.

New Bar/club/lounge Name

Hi,

I need suggestions for a club name. It will be one floor club and the other floor lounge.

The best suggestion will win money, $5, $10, $20, $30 depends on the quality of the suggestion, i’m honest you can view my feedback.

Public:
Week – University Students
Weekends – Adults
So 70% of the public is student.

Country: Portugal

It’s going to be a innovative club, in terms of design and ideas, that wants to beat the competition so the name should be great and unique.

I already tried many names for my boss but none of those names feel right. So it’s your turn!

Article Writer For 6 Articles

I need an article writer. Articles MUST be original, period. The articles have to pass copyscape.

The topics will be:
• Web Design (2 Articles)
• Business Cards(2 Articles)
• Online Advertising (2 Articles)

Articles will be 400-500 words each. I am looking for great writing, and your writing must be clear, logical and grammatically correct.

You will need to complete the 6 articles within 3-4 working days. Please bid on writing 6 articles in total.

Future work pending based on this project results.

Custom Script Online Order Processing E Commerce

Hello,

I am setting up an seo link building service and need a script made that has all of the features listed below.

the main site will be wordpress based but the script can be made on html pages as long as we can customise the html pages look to match the wordpress theme.

There are 4 areas of the site,

client front end (order process)
client back end (client area to track order process)
staff login area (for staff to login, see all orders)
admin area (for myself to login, add staff etc)

I will explain the features of each area and how they work in more detail here.

Client front end –

The client will be able to order a range of services all priced individually, they will have the option to select thier desired qty of each service.

Once ordered they will go to paypal and pay, then return to a thank you page where they will enter thier order details. This page can also contain thier login details or the details can be automatically emailed. whichever is cheapest to program.

The main points here are, the script must know what each line of the order is and recored the data provided for each service in the thank you page, must create the order in the system, auto create some login credentials for the client and email them to the client.

Client back end –

In the client back end once logged in they will have a list of thier order numbers with a summary. The list will need to show each seperate item from each order. Next to each item will be the status of this particular order line, this will be updated by the staff in the staff area. when completed it will show an icon for them to download a report from with their completed order data. This list must keep the latest orders at the top of the list. The area should also have a search function, to allow the client to search for previous orders by order number, url, or service.

Staff area –

The staff area will allow the staff to login and work thier way through processing each order line. They will need to have a drop down selection list next to each order line which updates the orders status in the client backend area. each order line will need to have the ability to upload the client report as a excel file or word file for the client to download from the client backend area once each order line is complete. each order line will need to have a notes section. Each order line will need to either display the information collected when the client filled in the order form (url, keyowrds, qty etc) or have an option for the staff member to view this data in another page.

Admin area –

will need to have all the staff area features in addition to the following:

the ability to create or delete a staff member
see the current order queue – number of orders outstanding
see all previous orders and which staff member completed.
see sales value for day, week, month and year

I do not have a huge budget for this script, but will have multiple projects in the future for whichever programmer lands this job.

I am open to suggestions on any better ways that you can think of to create and manage this operation.

I look forward to receiving your bids.

Php – Yui – Mysql – Image Slider

Hi, I’m looking for a specialist in the above. What needs to be done is the following:

A need a website which will show 3 images. The URL’s to these images will be stored in a mySQL database. However, there will be 1000s of combinations of these 3 images (and therefore 1000s of URLs stored in the mysql database).

I want the user to be able to control the appearance of these images using a YUI slider. What I mean is if the user scrolls I want new images to load on to the website (via JS, php from the mysql table). The YUI slider needs to be done in such a way that its range is altered depending on how many images there are in the database (ie if there are only 5 the slider should have a range of 1-5 and if there are a 1000 the slider should have a range of 1 – 1000. This should be automatic).

Organic Manual Seo Links 3

Hello,

I need 100 links please. Anchoring 1 keyword. Job pays $0.25 per link.

100% organic manual blog and forum posts.
PageRank 3 or higher only.
All must be DO FOLLOW
Alexa Rank under 100,000.
Complete report with the exact page url where the link is visible within 48 hours please.

100% escrow.

I will release escrow ONLY after I have verified all 100 links.

I am paying for verifiable non spam organic posts only. I will be verifying all 100 for spammy content, pagerank, and source code do follow. Experienced Posters only please.

Press Release…….

I need somone to write a press release for my hip hop beat selling web site. you must have good writing skills and have writen a press release befor. at the begining of your post write Red Dragon, and at the end of your post write Green frog. this will let me know that you follow directions. if you do not do this you WILL be deleted! Thank you for your best offer..

Legal Social Networking / Collaboration Website

The project is a web-based Software as a Service (SaaS) legal practice management solution designed for the needs of small and medium sized law firms. In addition to seamlessly offering the standard law practice management components, such as Calendaring, Contacts, Document Management, Time Tracking, Billing and Invoice Generation, Task Lists, Statistical Analysis, Expense Tracking, and Messaging – the project utilizes social networking to allow legal practitioners and firms to collaborate and share resources with similarly situated attorneys and firms. Through the site Lawyers will be able to collaborate online with clients in completing documents. Law firms and attorneys can create profiles that highlight practice areas and foster the development of efficient work output and strategic pooling of resources.

I have attached two documents to provide a raw idea of the site-map for this project (this should just be used as a conceptual outline)

1. Please specify what programming languages / development platforms you intend to use.
2. Please show links ONLY to examples relevant of your work.
3. I can only respond to bids with these two requirements.

Thank you for your time and understanding.

Chris