Find Jobs
Hire Freelancers

Create PDF file thumbnails with file title based on Excel file list

$250-750 AUD

Cerrado
Publicado hace más de 7 años

$250-750 AUD

Pagado a la entrega
We design and manufacture large steel frames that consist of many parts. Typically one frame may have over 100 parts. All of the parts are created and drawn in CAD and a PDF of the drawing saved in a master folder. The CAD system produces a list (called a BOM) of the components that go into each frame assembly. When we purchase parts, they arrive from the supplier in a large box. Someone has to work out what each part is, this is time consuming and none of the physical parts carry identification numbers. He only has a list of parts and must open and close each drawing manually. We need a program/script that will run through an excel file list, find the PDF files and create a new document with a thumbnail of the PDF alongside the part number. An example of the desired output is shown attached. Some of the parts are "Laser cut" and for those files, the thumbnail must be of the second page in the PDF. Only one thumbnail should be created for each file. For example, if the file has 4 pages, the thumbnail should be of page one only (unless it is laser cut in which case only page 2) An example of the desired output is shown attached. We believe the process will be similar to the following: *Import an excel file in the same format as shown in the example image. *Ask the user where the files are located (prompt for the first file only, all others will be in the same location) *Open the first PDF drawing from the selected folder *The name shown in the excel file is not the exact file name but the part number will be identical - See the same files attached that show the format of the PDF file names. *If the "laser cutting" column for that part =1 then print every page EXCEPT the first page *If the "laser cutting" column for that part =0 the print all pages *If there is more than one revision of the PDF file (denoted by Rev-XX on the end of the file name), only the HIGHEST revision number should be printed. (See File Revisions image attached) *If the part number in Excel ends with -00 the PDF file name will not include -00 *If the part number in Excel ends with a number other than -00 that suffix will be on the PDF file name. (See attached Part Revisions image) *Capture a thumbnail of the page *Insert the thumbnail into a word or excel document with the part number alongside. *Move to the next file in the list The system should prompt the user to browse to the PDF file location for the first file only. Once the user has chosen the folder, the program should use that folder for all other lines. An example of the desired output is shown attached.
ID del proyecto: 11375869

Información sobre el proyecto

17 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
17 freelancers están ofertando un promedio de $489 AUD por este trabajo
Avatar del usuario
I can write the necessary VBA code for this. Lets talk in detail. Thanks..............................................
$1.000 AUD en 7 días
5,0 (141 comentarios)
7,1
7,1
Avatar del usuario
Hello. 47 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
$366 AUD en 10 días
5,0 (118 comentarios)
6,5
6,5
Avatar del usuario
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start
$555 AUD en 5 días
4,6 (43 comentarios)
5,5
5,5
Avatar del usuario
Hello Sir, I am an excellent VBA and C# programmer. I can certainly help you create this program to reduce the manual effort and have the program select appropriate files and print them. Thanks Aanvik
$666 AUD en 7 días
4,9 (12 comentarios)
4,9
4,9
Avatar del usuario
Hi Im an expert in .Net technologies I have been working in software development for the last 20 years Regards Carlos
$277 AUD en 5 días
4,9 (26 comentarios)
4,9
4,9
Avatar del usuario
First I would like to know what version of Excel you are using. As I am using Excel 2013 on VM on a Mac., macros created may not work on older versions of Excel. I have created many macros and creating one produce thumbnails and place it Excel in a desired position should not be difficult. Is the "laser cutting" information only on the pdf or available elsewhere,- example in the filename itself. There may be more clarifications required as I get to know more about the project.
$555 AUD en 10 días
4,5 (50 comentarios)
5,0
5,0
Avatar del usuario
- Let me make 1 demo 3 day maximum, (70% complete) and then you review it? - We have more 10 years experience Java programming. - Trusts me make projects done early
$300 AUD en 5 días
5,0 (1 comentario)
1,3
1,3
Avatar del usuario
My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & experience that are required to complete this project. I can show you some examples of my work. Please contact me to discuss your project.
$672 AUD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Okay, I read your proposal, it is an interesting project. I have experience in using scripts to do conversion jobs like pdftoexcel pdftocsv vice versa and many more. I have a few questions for you if you are interested in awarding the job to. I have done 2 small projects here on freelancer and now I am looking for big ones, you won't see my rating directly as I don't have matching skill tags. You can interview me if interested Thank you Naresh D Bhadresha
$333 AUD en 15 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear sir, I've recently completed similar project related to processing files of both those types, so I am sure I will be able to create such application Sincerely yours Eugene
$350 AUD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Let's discuss in detail I have some query. After understanding project detail I will reduce the price. Speak to you soon. Thank
$550 AUD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Wangara, Australia
5,0
34
Forma de pago verificada
Miembro desde feb 27, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.