Entry of Lighting from PDF Catalogue and File Renaming


We have a PDF of lighting products which need to be entered into an excel spreadsheet. The spreadsheet already has the prices and the product code. The rest of the information needs to be entered in from the catalogue.

The fields are :

- Product name (Just a description of the light, ie Hanging light, or wall light, or large lamp post(

- Collection Name (common to 4-6 products at at time)

- Description (this comes from the PDF and is listed on the side for a group of products)

- Category (You need to pick whether a light is outdoor wall lighting, outdoor lamp post or if appropriate, consult us on the creation of new category type)

- Finish Shown ( if the light comes in multiple finishes, you need to list them in a list in one field, but on separate lines)

- Other versions (If the light comes in other models, they also need to be listed here)

- Page number of the Catalogue

- Size

- Units (ie mm or cm)

- Width (if applicable)

- Diameter (if applicable)

- and creating a new column for new types of measurements as they arise (i.e. Max Drop, Min Height etc)

- Number of Lights

- Type of Light ( e.g. E27)

- Outdoor Rating (ie IP44)

The source of this data is in a PDF. We currently have the first 100 pages of the 187 page catalogue. We will supply the excel spreadsheet with test data for you to help you understand.

The last part, and most important part : We will supply you with images of the lights. You must search through the photos and find the matching light from the catalogue. You must then rename the photo file to the EXACT code specified in the excel spreadsheet. Some of the photos are missing (you would note that in the excel spread sheet) and some are poorly labeled, so sometimes needs to be done by inspection.

It is better if :

- You use a Mac and have Numbers available


I realised it would be more helpful if I gave you more specific details. The excel file is attached. It explains what is required in the text above the columns. The catalogue is also attached (18mb).

N.B. If you have a mac and can use Pages, please let us know, because we will have to go through and add the images to the spreadsheet in Pages, so would save us time if you could do it as you go.

Taidot: puhtaaksikirjoittaminen, tiedonsyöttö, tietojenkäsittely, Excel, PDF

Näytä lisää: pdf lighting catalogue, width first search, types of data processing, types of data entry fields, test data creation, number data entry test, a description of the product, entry lighting pdf catalogue file renaming, source inspection, search pdf, renaming, renaming i, product list find images, product catalogue, photo post processing, pdf to spread sheet, file renaming, field inspection, diameter, data entry with spread sheet, catalogue, rest pdf, excel pdf fields, images wall hanging, post multiple pages group

Tietoa työnantajasta:
( 7 arvostelua ) Sydney, Australia

Projektin tunnus: #4284175

Myönnetty käyttäjälle:


Hello dear Sir/Ma'am. I am a highly qualified, certified, talented and highly professional MS Office, Adobe Acrobat, Adobe LiveCycle Form Designer, Adobe Photoshop and Adobe Illustrator expert. I have exceptional s Lisää

$7 AUD / tunti
(128 Arvostelua)

14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön


Hi, I carefully read your project. Willing to work with you. KR,

$4 AUD / tunti
(273 arvostelua)

consider it done .. check pm .. thx

$8 AUD / tunti
(347 arvostelua)

Ready to start immediately. IT professional with high expertise and experience in Excel work here. I have read your project description and i can do it perfectly for you. Please give me chance to start work with u. Th Lisää

$4 AUD / tunti
(176 arvostelua)

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$7 AUD / tunti
(97 arvostelua)

Ready to start.

$5 AUD / tunti
(3 arvostelua)

Will provide you with quality [url removed, login to view]

$3 AUD / tunti
(6 arvostelua)

Sir I am willing to do this for you ...

$8 AUD / tunti
(4 arvostelua)

Hi there I have good attention to detail and sure can help for this project. Ready to start..

$7 AUD / tunti
(2 arvostelua)

I am fast, efficient and accurate (somewhat pedantic and detail oriented!), and deliver quality work. I would enjoy working on a project such as yours. I am available to start immediately.

$8 AUD / tunti
(0 arvostelua)

I'm interested in the proposed project. I leave a private message with more information. Yours faithfully

$7 AUD / tunti
(0 arvostelua)

I am interested

$8 AUD / tunti
(0 arvostelua)

I can do it for you as I am having a good typing speed, and have been working on net for quite a long time now. Thanks.

$6 AUD / tunti
(0 arvostelua)


$5 AUD / tunti
(0 arvostelua)