GetAFreelancer.com
 
Find projectsSearch
Sign Up | Log in | Top Rated Users | Browse projects | Post Project | RSS feeds | Articles
 

PDF to Excel data entry

   Click here to post similar project

PDF to Excel data entry is project number 180948 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider swexicorp)
Status: Closed
Budget: $100-300
Created: 10/05/2007 at 9:47 EDT
Bidding Ends: 10/06/2007 at 9:47 EDT
Project Creator: sawad View PM Post PM
Buyer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(4 reviews)
Description: Create a tire product spreadsheet.
==================================

- You will be given a Adobe PDF file and required to input the data into an MS Excel spreadsheet. The data must be entered accurately and in the right format. You will be given examples to show you how to perform this task.

- This task needs to be done within the next 3 days. We are going to start with 500 products (rows) and you are bidding for that contract.

- We have more products to input and other work so a good job may well result in more contracts awarded.

Additional information submitted:

09/27/2007 at 22:42 EDT:
CORRECTION
==========

- Really sorry but I made a mistake in the description. The source of the information will be a website and not a PDF file. We do have a PDF file but we found out its not complete so you would need to access a website as the source of the information.

- The URL of this website is confidential but its basically an online store selling a type of car part. Your job will be to go product by product and enter the product description fields (name, model, category, attributes, price, etc...) into rows in an Excel spreed sheet.

** IF YOU HAVE ALREADY BID PLEASE SEND ME A MSG IF YOU ARE STILL INTERESTED SO THAT I CAN CONSIDER YOU FOR FINAL SELECTION. SINCE THE DESCRIPTION HAS CHANGED I NEED TO KNOW IF YOU STILL WANT THE JOB.

10/05/2007 at 10:35 EDT:
We had picked a provider but he was not able to do it since it was too complex for him. To ensure that the service provider we select is capable of this job please make sure to read the added instructions below and post a comment on your bid if you understand then and can execute on them. You need to be familiar with the osCommerce "EasyPopulate" format described here:

http://www.oscommerce.com/community/contributions,500/category,all/search,easy+populate

I have included the example file attached. Instructions are below. Please withdraw your bid if you cannot understand or cannot execute based on the instructions below. If we chose you and find out later that you cannot execute we will rate accordingly.


Please find detailed instruction below. Please do not hesitate to contact me by email [this address] or MSN (*****) if you have any questions. I would ask that you start by entering 10 products and then allow me to check the file to make sure you are on the right track before continuing.

First you need to login to:

http://www.****.com/
User Name: ****
Password: ****

Once you have logged in click on Tires and then you have various options to browse their tire inventory. We want to start by entering passenger tires and precede in a systematic manner so we can know what we have entered and what is still missing.

I would recommend you start with the following link and then go first by tire diameter from 13" upwards.

http://www.****.com

For each tire you will need to enter a row in the attached spreedsheet was follows.

v_products_model: All caps; append manufactures, tire model and size as shown in example row. Max field length is 32 characters so you might need to abbreviate either manufacturer or model name to stay within this but please be consistent by using the same prefix for tires made by the same manufacturer/etc...

v_products_image Leave blank.

v_products_name_1: Product name; use the name of the tire as listed on the site; e.g. " Kumho Power Star 758"

v_products_description_1: Leave blank

v_products_price: Please enter the price as it appears on the website.

v_products_weight: Please enter 1 here for all of them.

v_date_added: Please use the date you add them.

v_products_quantity: Set this to 999

For the attribute fields you can copy the example row and change it as follows:

You just need to place a 0 in the v_attribute_values_price* fields that are one column before the applicable attribute v_attribute_values_name*. For example if this is an "All Season" tire then you would place a 0 in v_attribute_values_name_1_1_1 and leave v_attribute_values_price_1_2 and v_attribute_values_price_1_3 blank.

The attribute fields are:

Type: This will be either "All Season", "Summer" or "Winter". Please do not add "Light Truck" tires yet.

** On the website you will see the tire size listed as:

Size: 155/80TR13

This translates into the following attributes in the spreadsheet.

Width: 155
Aspect Ratio/Profile 80
Diameter: 13"

You can read more about tire sizes here.

http://www.sizes.com/home/automobile_tires.htm

As per the example in the first row I set the following columns to 0.

v_attribute_values_price_1_1 since v_attribute_values_name_1_1_1="All Season"
v_attribute_values_price_2_2 since v_attribute_values_name_2_2_1=155
v_attribute_values_price_3_23 since v_attribute_values_name_3_23_1=80
v_attribute_values_price_4_3 since v_attribute_values_name_4_3_1=13"

All the other fields v_attribute_values_name_* should be zero.

Additional fields should be set as follows:

v_manufacturers_name to the Manufacturer name
v_categories_name_1 to the tire diameter; in the first row example this is 13".
v_tax_class_title to " Taxable Goods"
v_status to "Active"

Please try to be consistent in spelling and case.

*** Very important to always save the file as "tab delimited text file". Do not save it in Excel format as this will add special characters that will make it unusable for us.

Thanks for your time and attention. Its complicated at the beginning but once you get the hang of it you can just copy and paste the previous row and make a few changes to add the next row.




Additional files submitted:
EP2007Oct01-1604.txt-1.xls
Report violation
Job Type:
  • Data Entry
Database: (None)
Operating system: MS Windows
Bid count: 200
Average bid: $ 123

 

Related project
 
Testing Project Featured
posted by eboneep
Budget: $250-750
 

FREE Trial project for new buyers!

 

View Project Message Board     Post Message on Project Message Board
Messages Posted: 21

If you are the project creator or one of the bidders Log in as project creator or bidder for more options

Bid on This Project

Service Providers PMB Bid Delivery Within Time of Bid Provider Rating
Djdesign
View PM Post PM
$ 100 0 days 09-27-2007 16:10 9.80/109.80/109.80/109.80/109.80/109.80/109.80/109.80/109.80/109.80/10
(335 reviews)
Let's start ! can be done more detail in pm
kriew
View PM Post PM
$ 100 1 day 10-05-2007 11:01 9.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/10
(249 reviews)
I'll do it!!!
arvindtechno
View PM Post PM
$ 100 3 days 09-27-2007 23:12 9.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/10
(165 reviews)
Hello, We can gather you the required information from the online store. Please check PM for further details. Thank you
ponnarasiBabu
View PM Post PM
$ 100 3 days 10-05-2007 13:11 9.91/109.91/109.91/109.91/109.91/109.91/109.91/109.91/109.91/109.91/10
(126 reviews)
Hi Kinldy check PM Thanks ponnarasi
ggopi
View PM Post PM
$ 100 3 days 10-05-2007 10:08 9.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/10
(92 reviews)
I'm Gopi from India. Please check my PMB.
SigmaVisual
View PM Post PM
$ 100 3 days 09-27-2007 20:21 9.71/109.71/109.71/109.71/109.71/109.71/109.71/109.71/109.71/109.71/10
(59 reviews)
Please check PMB.
Arenabpo
View PM Post PM
$ 110 3 days 09-28-2007 04:30 9.81/109.81/109.81/109.81/109.81/109.81/109.81/109.81/109.81/109.81/10
(58 reviews)
Hello, Our company are experiencefull on this kind of job, please kindly check PMB for details.Thanks!
Balky
View PM Post PM
$ 100 3 days 09-27-2007 14:25 9.84/109.84/109.84/109.84/109.84/109.84/109.84/109.84/109.84/109.84/10
(57 reviews)
Hi, check your pmb please
silgate
View PM Post PM
$ 150 3 days 09-27-2007 16:48 9.95/109.95/109.95/109.95/109.95/109.95/109.95/109.95/109.95/109.95/10
(56 reviews)
Hi, I can provide data in excel sheet within 3 days. Please let me know. Thanks
datasolutionss1
View PM Post PM
$ 100 3 days 09-27-2007 15:46 9.80/109.80/109.80/109.80/109.80/109.80/109.80/109.80/109.80/109.80/10
(41 reviews)
Please check PM, Thanks, Praveena.
elinksol
View PM Post PM
$ 100 3 days 09-27-2007 14:41 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(37 reviews)
Hi sir, Please check the PMB for details. Thanks, Regards, Naveed Akhtar
garbar
View PM Post PM
$ 300 0 days 10-05-2007 15:19 9.83/109.83/109.83/109.83/109.83/109.83/109.83/109.83/109.83/109.83/10
(30 reviews)
DEAR SIR, I AM READY TO START. REGARDS GARBAR
mithi
View PM Post PM
$ 100 2 days 10-05-2007 10:28 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(19 reviews)
Please check PM!! Regards, Mithi
YourAssistant
View PM Post PM
$ 150 2 days 09-27-2007 19:34 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(19 reviews)
Hi…Here is my bid to express my interest in your project. For further details please see PMB….Thanks (Tanweer)
Workstation168
View PM Post PM
$ 100 3 days 09-27-2007 21:34 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(19 reviews)
Hi. Kindly check pmb for details. Thank you.
swexicorp
View PM Post PM
$ 100 2 days 10-05-2007 17:09 9.94/109.94/109.94/109.94/109.94/109.94/109.94/109.94/109.94/109.94/10
(18 reviews)
Hello, I'm very interested in this project, please refer to PM.
goffy
View PM Post PM
$ 100 1 day 09-27-2007 17:55 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(17 reviews)
We are company from Poland.
Obialo
View PM Post PM
$ 100 0 days 09-27-2007 22:43 9.69/109.69/109.69/109.69/109.69/109.69/109.69/109.69/109.69/109.69/10
(16 reviews)
Hi, let me do this for your. thnaks
sureshmalankar
View PM Post PM
$ 100 3 days 09-27-2007 22:17 9.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/10
(16 reviews)
Kindly see pmb.
sureshiyengar
View PM Post PM
$ 100 3 days 09-28-2007 05:56 9.50/109.50/109.50/109.50/109.50/109.50/109.50/109.50/109.50/109.50/10
(16 reviews)
Hi, Kindly see PM. Thanks.
webpro123
View PM Post PM
$ 100 3 days 09-27-2007 15:14 9.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/10
(15 reviews)
Please check your PM Thank you
greatergap
View PM Post PM
$ 100 1 day 09-27-2007 15:24 9.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/10
(15 reviews)
Well worth your time. Check PM. Thanks.
arif25
View PM Post PM
$ 110 3 days 09-27-2007 16:36 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(14 reviews)
Ready to work. Best regards, Arif d
dev2u
View PM Post PM
$ 100 2 days 10-05-2007 09:57 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(12 reviews)
Please check PM
vnb400
View PM Post PM
$ 100 5 days 09-28-2007 08:10 9.82/109.82/109.82/109.82/109.82/109.82/109.82/109.82/109.82/109.82/10
(11 reviews)
kindly refer PMB, Thanks
hiratariq
View PM Post PM
$ 100 3 days 09-27-2007 14:23 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(11 reviews)
Hi! Please see PM.
dren
View PM Post PM
$ 200 3 days 09-27-2007 14:29 9.90/109.90/109.90/109.90/109.90/109.90/109.90/109.90/109.90/109.90/10
(10 reviews)
I have done similar projects. I have excellent typing skills.
JessieBek
View PM Post PM
$ 150 3 days 09-27-2007 17:08 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(10 reviews)
Hi, I'm Jessie. I am experienced in data entry, I am very responsible and accurate, so I know I can do the job perfectly. I do hope you choose me for it, if you have any questions do not hesitate to contact me. Thanks a lot!
maribel1218
View PM Post PM
$ 150 3 days 10-05-2007 23:29 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(10 reviews)
Dear Sir Kindly refer to PM
biko
View PM Post PM
$ 100 3 days 09-27-2007 18:03 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(9 reviews)
I can do it for you. Regards!
EXQUISITEICT
View PM Post PM
$ 100 0 days 09-28-2007 09:50 9.78/109.78/109.78/109.78/109.78/109.78/109.78/109.78/109.78/109.78/10
(9 reviews)
Hello Sawad, Plz check PMB. Thanks.
planright
View PM Post PM
$ 100 3 days 09-27-2007 16:26 9.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/10
(8 reviews)
Please check my Reviews, they are all for PDF to word conversion. I can give you the best output. Please check PMB
skilledsir
View PM Post PM
$ 100 1 day 09-27-2007 18:46 9.88/109.88/109.88/109.88/109.88/109.88/109.88/109.88/109.88/109.88/10
(8 reviews)
hi,sir,i can do it for u ,i will work until u get 200% satisfication .i am online now.looking forward to your rply
designcore
View PM Post PM
$ 100 0 days 09-28-2007 00:04 9.50/109.50/109.50/109.50/109.50/109.50/109.50/109.50/109.50/109.50/10
(8 reviews)
Hi, Your project is quite interesting, I can guarantee 200% job satisfaction in a very short time. Let's start.
sujiumesh
View PM Post PM
$ 100 3 days 09-28-2007 04:01 9.88/109.88/109.88/109.88/109.88/109.88/109.88/109.88/109.88/109.88/10
(8 reviews)
Hi, I will do this job, please refer the pm
uniiversesoft
View PM Post PM
$ 100 1 day 09-28-2007 04:17 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(8 reviews)
Greetings!!! We are ready for this job right now. Please refer PM for further details. Thanks, Regards, Shrinivas.P. Uniiverse Soft Tech, India.
RainbowSearches
View PM Post PM
$ 200 3 days 09-27-2007 16:53 9.71/109.71/109.71/109.71/109.71/109.71/109.71/109.71/109.71/109.71/10
(7 reviews)
Please see PM for details.
dearpravin
View PM Post PM
$ 125 3 days 09-27-2007 18:44 9.86/109.86/109.86/109.86/109.86/109.86/109.86/109.86/109.86/109.86/10
(7 reviews)
Please check PM