On 15/06/2011 22:12, Tazio Baker wrote:
I have no IT skills and I need to extract data from a PDF into an SQL
database to create statistical reports.
What makes you think this is possible?
You are using PDF as a format to store data!
What makes you think that's the purpose of PDF?
Please read: http://lowagie.com/node/136
What you are asking can be compared with this:
you're giving us tomato soup, and you ask us to extract the tomatoes.
Do you think that's possible?
Please advice if I may attach a sample of the PDF report I'm
confronted with.
You forgot to attach the PDF, but it was forwarded to me
from another address you've sent it too.
The PDF wasn't tagged, therefore there is NO STRUCTURE WHATSOEVER in the
file.
I've extracted the content of the first page.
I've copied the result and pasted it below.
If you can do anything with that plain text, then we can talk.
If you can't, then you're trying to do something that is impossible.
The PDF was created using "Oracle PDF driver".
This means the data you need is probably stored in a database somewhere.
Use that data!
stat_items
Page 1
AGENCES MARITIMES REUNIES S.A : STATISTIQUES COMMERCIALES
Rapport Du 01/04/11 Au 30/04/11
Bateau : CAMION DOMINICAIN Date Voyage : 01-APR-11 No Voyage : 010411
Carrier : CROWLEY LINER SERVICES,INC
CntrQty Shipper Consignee Port Weight Kg Comodity Quantity
2 GILDAN ACTIVEWEAR TEXTILE GLOBAL MANUFAC & CONTRACTORSANTO DOMINGO
2.00 CONTENEURS VIDES 2.00UNIT
COMPANY
3 GILDAN ACTIVEWEAR TEXTILE MULTIWEAR S,A SANTO DOMINGO 3.00 CONTENEURS
VIDES 3.00UNIT
COMPANY
1 GILDAN ACTIVEWEAR TEXTILE SEWING INTERNATIONAL S.A SANTO DOMINGO 1.00
CONTENEURS VIDES 1.00UNIT
COMPANY
Bateau : VIKING PRINCESS Date Voyage : 01-APR-11 No Voyage : 020 Carrier
: EUKOR CARS CARRIER
CntrQty Shipper Consignee Port Weight Kg Comodity Quantity
0 HYUNDAI CORPORATION LES MOTEURS REUNIS GUNSAN 83,045.00 VOITURES SUV
50.00UNIT
0 HYUNDAI MOTORS COMPANY SUN AUTO S.A ULSAN 25,432.00 BUS 2.00UNIT
VOITURES SUV 14.00UNIT
0 IBC JAPAN LTD PARTICULIER KOBE 9,410.00 VOITURE D'OCCASION 5.00UNIT
0 PARTICULIER PARTICULIER MANZANILLO 10,000.00 BUS, CAMIONS D'OCCASION
1.00UNIT
0 RAMA D.B.K.LTD PARTICULIER YOKOHAMA 4,290.00 VOITURE D'OCCASION 2.00UNIT
0 YOKOHAMA TRADING PARTICULIER YOKOHAMA 1,960.00 VOITURE D'OCCASION 1.00UNIT
INTERNATIONAL CO
Bateau : BITU MOUNTAIN Date Voyage : 02-APR-11 No Voyage : XXX Carrier :
NOT AVAILABLE
CntrQty Shipper Consignee Port Weight Kg Comodity Quantity
0 SARGEANT TRADING LTD GROUPMENT INGIENERIA MOBILE 1,770,983.00
ASPHALTES 451,881.00GAL
BAHAMAS ESTRELLA
Bateau : CAMION DOMINICAIN Date Voyage : 02-APR-11 No Voyage : 020411
Carrier : CROWLEY LINER SERVICES,INC
CntrQty Shipper Consignee Port Weight Kg Comodity Quantity
1 GILDAN ACTIVEWEAR TEXTILE GLOBAL MANUFAC & CONTRACTORSANTO DOMINGO
1.00 CONTENEURS VIDES 1.00UNIT
COMPANY
Bateau : IVER PROSPERITY Date Voyage : 02-APR-11 No Voyage : XXX Carrier
: NOT AVAILABLE
CntrQty Shipper Consignee Port Weight Kg Comodity Quantity
0 REFINERIA ISLA CURACAO B.V DINASA S.A CURACAO N.V. 12,956,396.00
ESSENCE POUR MOTEUR 1,223,922.00GAL
KEROSENE 839,916.00GAL
GAS-OIL 2,124,570.00GAL
0 REFINERIA ISLA CURACAO B.V SOGENER S.A CURACAO N.V. 1,363,531.00
GAS-OIL 419,202.00GAL
0 REFINERIA ISLA CURACAO B.V SOL HAITI SA CURACAO N.V. 13,685,513.00
ESSENCE POUR MOTEUR 801,024.00GAL
KEROSENE 126,000.00GAL
GAS-OIL 3,216,150.00GAL
Bateau : CRISTINA EXPRESS Date Voyage : 03-APR-11 No Voyage : 166S
Carrier : ANTILLEAN MARINE SHIPPING CORP
CntrQty Shipper Consignee Port Weight Kg Comodity Quantity
1 ABC TOOLS INC BRICO LOCAL MIAMI 16,783.00 OUTIL DE TOUT TYPE, OUTIL
INTERCHANGEABLE,COFFRE A 357.00PC
OUTIL
0 ACKER DRILL COMPANY BANQUE NATIONALE DE CREDIT MIAMI 33,825.00
REMORQUE 2.00PC
(BNC)
CAMION 1.00UNIT
1 ALTERNATE ENERGY SOLUTIONS UNIGESTION HOLDING S.A MIAMI 6,407.00
BATTERIES 5.00SK
1 AMALGAME TRADINC INC. MAX METAYER MIAMI 18,841.00 TOILE
METALLIQUE,GRILLAGE ET TRELLIS 62.00PC
1 AMERICAN GAS AND CYLINDER GAZ INDUSTRIELS ASSOCIES MIAMI 710.00
HYDROCARBURE ACYCLIQUE 20.00CYL
S.A
1 ANGLADE LE CROIX ROSE LAURE TERRIER MIAMI 15,195.00 EFFETS PERSONNELS
1.00LOT
2 ATLANTIC CARIBBEAN BRASSERIE NATIONALE D'HAITIMIAMI 24,041.00
EMBALLAGE PLASTIQUE 55.00PA
1 BETTER FAMILY PRODUCTS COMPAGNIE HAITIENNE DE MIAMI 2,725.00
PARTIES,ACCESSOIRES 29.00SK
MOTEURS
VOITURE,TRACTEUR.BUS,DEPANEUSE,CAMION
1 BETTER FAMILY PRODUCTS MATPAR MIAMI 328.00 PLAQUE,FEUILLE,BANDE,AUTRE
FORME PLATE AUTO-ADHESIF 1.00PA
PLASTIQU
1 CPG GROUP CORP PEINTURES CARAIBES MIAMI 12,483.00 SOLVANT ET DILUANT
ORGANIQUE COMPOPSITE,ENLEVER 80.00DR
PEINTURE...
1 DROOMPAC DROOMPAC MIAMI 3,661.00 EFFETS PERSONNELS 11.00PC
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
iText-questions mailing list
iText-questions@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/itext-questions
iText(R) is a registered trademark of 1T3XT BVBA.
Many questions posted to this list can (and will) be answered with a reference
to the iText book: http://www.itextpdf.com/book/
Please check the keywords list before you ask for examples:
http://itextpdf.com/themes/keywords.php
