Script/Program to print PDF documents based on an excel file list

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

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.

Currently when we wish to manufacture the frame, we have to manually work down the excel list, open each PDF drawing and print it.

Some of the drawings dont require the first page to be printed, based on the type of part. Others require all pages to be printed. The program MUST be able to handle this.

We require a program/script that can find, open and print all of the PDF files associated with the list. It should only print the required pages.

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)

*Print the file with the system default printer

*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.

Programming

Project ID: #11375759

About the project

6 proposals Remote project Active 7 years ago

6 freelancers are bidding on average $509 for this job

sid0

Hi sir, we have read your requirement and we can do programming for this project.. this would be great idea and it would be tricky and nice project for me...

$388 AUD in 10 days
(0 Reviews)
0.0
aanvikm

Hello Sir, I did a similar program in past for one of my client where I was working as ERP consultant. They not only needed a BOM (Bill of Material) list to be printed by by product list as well. (It was a process ind More

$555 AUD in 7 days
(0 Reviews)
0.0
ibapi

If you consider my bid please send a message to discuss in detail the work as well as other terms and conditions of the contract so that we can finish your job without as smoothly as possible.

$555 AUD in 10 days
(0 Reviews)
0.0
shikhamehta

Hello there, I have worked extensively in the MRP process during my work with an Indian Automobile manufacturer (Bajaj Auto Ltd.) and am well aware of the assembly diagrams. I am also an expert in automating the pro More

$888 AUD in 15 days
(0 Reviews)
0.0
octamer

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 in 7 days
(0 Reviews)
0.0
ksriniravi

Hello, Having worked in Electronics Manufacturing myself for close to 15 years, I can understand your pain dealing with large BOMs and printing associated drawings and design data. Overall, I have 17+ years experien More

$320 AUD in 3 days
(0 Reviews)
0.0