Software converting program - Great Lakes 4x4. The largest offroad forum in the Midwest

Go Back   Great Lakes 4x4. The largest offroad forum in the Midwest > General 4x4 Stuff > The Pub
GL4x4 Live! GL4x4 Casino

The Pub A friendly forum where everybody is nice, and will answer any questions you have about life.

greatlakes4x4.com is the premier Great Lakes 4x4 Forum on the internet. Registered Users do not see the above ads.
Search
Reply
 
Thread Tools Search this Thread
Old January 11th, 2010, 10:37 AM   #1
Silver Bullet
Livin the American Dream
 
Silver Bullet's Avatar
 
Join Date: 04-18-07
Location: Westland, MI
Posts: 3,774
iTrader: (4)
Mentioned: 0 Post(s)
Default Software converting program

I am looking for a program to convert a pdf into an excel spreadsheet that is functional. Any ideas? I was thinking maybe adobe suite.
Silver Bullet is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old January 11th, 2010, 10:38 AM   #2
Freak
Wheelin the HD
 
Freak's Avatar
 
Join Date: 01-27-07
Location: Portland, TX
Posts: 7,227
iTrader: (14)
Mentioned: 0 Post(s)
Send a message via MSN to Freak Send a message via Yahoo to Freak
Default

you might as well do it all by hand, if you make the adobe into a spreadsheet you still have to enter all the equations to make the spreadsheet work properly... Im not quite sure I understand the question.
Freak is offline   Reply With Quote
Old January 11th, 2010, 12:23 PM   #3
Silver Bullet
Livin the American Dream
 
Silver Bullet's Avatar
 
Join Date: 04-18-07
Location: Westland, MI
Posts: 3,774
iTrader: (4)
Mentioned: 0 Post(s)
Default

I am trying to take our invoices we download off our clients websites that are pdf and convert them into an excel spreadsheet so I can sort by date.
Silver Bullet is offline   Reply With Quote
Old January 11th, 2010, 12:48 PM   #4
SammySmalls
Senior Member
 
SammySmalls's Avatar
 
Join Date: 02-04-09
Location: Farwell, MI
Posts: 437
iTrader: (2)
Mentioned: 0 Post(s)
Default

Sometimes the select feature will let you copy....
I dont think PDF naturally converts to xL since the value have to be separated by a comma, tab or space, which are usually annihilated as part of PDFs aim to make things uncopyable.
SammySmalls is offline   Reply With Quote
Old January 11th, 2010, 04:59 PM   #5
BigBlkYJ 355
U-Joints Fear Me
 
BigBlkYJ 355's Avatar
 
Join Date: 11-05-05
Location: Clawson
Posts: 3,361
iTrader: (4)
Mentioned: 0 Post(s)
Default

You want to merge all of the pdf's into 1 xl file or u want to make separate xl's for each pdf?
BigBlkYJ 355 is offline   Reply With Quote
Old January 11th, 2010, 05:40 PM   #6
Silver Bullet
Livin the American Dream
 
Silver Bullet's Avatar
 
Join Date: 04-18-07
Location: Westland, MI
Posts: 3,774
iTrader: (4)
Mentioned: 0 Post(s)
Default

1-20/40 page pdf into 1 excel file.
Silver Bullet is offline   Reply With Quote
Old January 11th, 2010, 05:45 PM   #7
Freak
Wheelin the HD
 
Freak's Avatar
 
Join Date: 01-27-07
Location: Portland, TX
Posts: 7,227
iTrader: (14)
Mentioned: 0 Post(s)
Send a message via MSN to Freak Send a message via Yahoo to Freak
Default

considering a pdf is almost just an image I don't think there is anything out that does this.
Freak is offline   Reply With Quote
Old January 11th, 2010, 05:47 PM   #8
awalters
Hired Badass
 
awalters's Avatar
 
Join Date: 06-09-09
Location: Petoskey, Michigan
Posts: 1,328
iTrader: (9)
Mentioned: 0 Post(s)
Default

I have two suggestions for you. 1) Try the SAVE AS TEXT option in Adobe Reader, and try importing, that into excel. I wonder what that would look like for you. I have no PDF's here to try it with, sorry.

2) Highlight everything in the PDF, and copy and paste, but do "paste special" and see if it formats it into the right columns for you.
awalters is offline   Reply With Quote
Old January 11th, 2010, 05:47 PM   #9
RyeBread
Catch the wave
 
RyeBread's Avatar
 
Join Date: 11-08-05
Location: Fenton
Posts: 7,950
iTrader: (2)
Mentioned: 0 Post(s)
Default

acrobat 8x and higher will allow you to select+copy as table and then past into excel. It will not be super clean, and it will only work if the original .pdf was generated by something 'intelligent'

if they scanned said invoices and made them into .pdf's as images then you'll have the added BS of doing OCR on those images within the .pdf

describe the order of magnitude and I'll tell you how badly you are screwed...


Quote:
Originally Posted by Silver Bullet View Post
1-20/40 page pdf into 1 excel file.
each page has separate headers/footers? OR is it all one 'data-dump' to .pdf?

if it's the latter, you may get lucky. I also should have said that acrobat 8x and higher will "copy-as" or "save-as" if the .pdf was created from something other than an image. e.g. - if it was created from acrobat/distiller's print-to.pdf or export-to.pdf functions.
RyeBread is offline   Reply With Quote
Old January 11th, 2010, 05:57 PM   #10
Silver Bullet
Livin the American Dream
 
Silver Bullet's Avatar
 
Join Date: 04-18-07
Location: Westland, MI
Posts: 3,774
iTrader: (4)
Mentioned: 0 Post(s)
Default

To add info I am almost positive the pdf was created from some sort of invoicing program.....export as pdf.
Silver Bullet is offline   Reply With Quote
Old January 11th, 2010, 06:02 PM   #11
RyeBread
Catch the wave
 
RyeBread's Avatar
 
Join Date: 11-08-05
Location: Fenton
Posts: 7,950
iTrader: (2)
Mentioned: 0 Post(s)
Default

Quote:
Originally Posted by Silver Bullet View Post
To add info I am almost positive the pdf was created from some sort of invoicing program.....export as pdf.
the problem will be, in that many data-base based applications have horrific reporting front ends in order to make them look like their old school paper invoicing and it may not truly be a delimited file on the export.

this is seemingly especially true of older legacy type of cash receipting and invoicing systems
RyeBread is offline   Reply With Quote
Old January 11th, 2010, 06:04 PM   #12
mtnbikinbryno
Senior Member
 
mtnbikinbryno's Avatar
 
Join Date: 11-08-05
Location: TC
Posts: 5,314
iTrader: (3)
Mentioned: 1 Post(s)
Send a message via AIM to mtnbikinbryno
Default

Quote:
Originally Posted by Silver Bullet View Post
I am looking for a program to convert a pdf into an excel spreadsheet that is functional. Any ideas? I was thinking maybe adobe suite.
Have you asked whoever is doing the PDF creating if they can just export it as an Excel file for you?
mtnbikinbryno is offline   Reply With Quote
Old January 11th, 2010, 06:09 PM   #13
RyeBread
Catch the wave
 
RyeBread's Avatar
 
Join Date: 11-08-05
Location: Fenton
Posts: 7,950
iTrader: (2)
Mentioned: 0 Post(s)
Default

another thought.

if the file's creation date (from it's properties) is = to its invoice date and if these are all from the same vendor, and if all you are trying to do is sort by date, simply download them all to a new folder, and sort them via the "view-details" option in windows-file-explorer.
RyeBread is offline   Reply With Quote
Old January 11th, 2010, 06:52 PM   #14
schweeb
spelling nazi
 
schweeb's Avatar
 
Join Date: 07-02-07
Location: Grosse Pointe Woods, MI
Posts: 2,563
iTrader: (3)
Mentioned: 0 Post(s)
Default

Quote:
Originally Posted by RyeBread View Post
another thought.

if the file's creation date (from it's properties) is = to its invoice date and if these are all from the same vendor, and if all you are trying to do is sort by date, simply download them all to a new folder, and sort them via the "view-details" option in windows-file-explorer.
This is a good point. Easier than relying on sort-by, you could come up with a file naming convention that includes a datestamp (i.e. 20090111 for today), allowing you to just sort by filename.

If you happen to be any good at programming or scripting, I'm pretty sure there are some perl or python modules that might allow you to crack it open (if the text is in a text format) and pull out some important data. Regular expressions are pretty helpful in this regard. (example: you could create a script that scans a folder, scans for a date on the invoice in the PDF, and renames the file).

Or... the best way... ask them to give you invoices in a sane format that is easy to interpret.
__________________
[FlatFender]: ill put it like this, if she wasnt MY aunt, id hit on her
schweeb is offline   Reply With Quote
Old January 11th, 2010, 07:19 PM   #15
yellowjeeperman
The N3rd
 
yellowjeeperman's Avatar
 
Join Date: 01-15-06
Location: Birch Run/Clarkston, Mi
Posts: 5,871
iTrader: (12)
Mentioned: 1 Post(s)
Default

Plan on spending money...
http://www.pdftransformer.com/
yellowjeeperman is online now   Reply With Quote
Old January 12th, 2010, 05:51 AM   #16
SammySmalls
Senior Member
 
SammySmalls's Avatar
 
Join Date: 02-04-09
Location: Farwell, MI
Posts: 437
iTrader: (2)
Mentioned: 0 Post(s)
Default

They are probably printing the invoice to a PDF printer, just ask them to send you the text or xL file.....
SammySmalls is offline   Reply With Quote
Old January 12th, 2010, 06:10 AM   #17
Silver Bullet
Livin the American Dream
 
Silver Bullet's Avatar
 
Join Date: 04-18-07
Location: Westland, MI
Posts: 3,774
iTrader: (4)
Mentioned: 0 Post(s)
Default

Quote:
Originally Posted by mtnbikinbryno View Post
Have you asked whoever is doing the PDF creating if they can just export it as an Excel file for you?
Quote:
Originally Posted by schweeb View Post

Or... the best way... ask them to give you invoices in a sane format that is easy to interpret.
Quote:
Originally Posted by InspectorCloussou View Post
They are probably printing the invoice to a PDF printer, just ask them to send you the text or xL file.....
Come on guys thats the first thing I did. But national companies are not easy to work with. With them its survival of the fitest. This is how we do it, this is how it is to be done.....adapt...sink or swim.
Silver Bullet is offline   Reply With Quote
Reply
Great Lakes 4x4. The largest offroad forum in the Midwest > General 4x4 Stuff > The Pub

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 06:06 AM.


Powered by: vBulletin, Copyright 2000 - 2012, Jelsoft Enterprises Ltd.
User Alert System provided by Advanced User Tagging (Lite) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd. Runs best on HiVelocity Hosting.
Page generated in 0.23693 seconds with 72 queries