RubyPDF Blog

A requirement of my customer is as follow,

In access there’s the possibilities to import an xml file into a table but the problem is that the procedure is manual and is possible to import a file once a time. I ask you if you can develop a VB utility trough out I can select a list of XML files and append them to a specific table.

After researched, i knew, he means ImportXML Method,

Imports data and/or presentation information for a Microsoft Access object from an XML file or files.

expression.ImportXML(DataSource, DataTransform, OtherFlags)

expression   Required. An expression that returns an Application object.

DataSource  Required String. The name and path of the XML file to import.

DataTransform  Optional String. The name of the XSL file to apply to the incoming XML data.

OtherFlags  Optional Long. A bit mask which specifies other behaviors associated with importing from XML. The following table describes the behavior that results from specific values; values can be added to specify a combination of behaviors.

Value	Description
1	Overwrite  The import file silently overwrites the target should it already exist.
2	Don’t create structure  By default, new structures are created. If Overwrite is not set, an alert asks the user for permission to overwrite.
4	Don’t import data  By default, data is imported when a data document is used to create a schema.

Example

The following example imports an XML file representing a table called Invoices into the current database. Access overwrites the Invoices table if it already exists.

Application.ImportXML _
    DataSource:=”C:\XMLData\Invoices.xml”, _
    OtherFlags:=1

It is very easy to implement, but any way, it is a very useful utility.

Here is a requirement that want to batch dump xmp from PDF to xml file or Database,

I’d like to know if you have developed or if you can develop an application for extracting customize XMP from PDF documents.

I’ll try to be more relevant: I customized a specific card for additional metadata in Acrobat Professional. If I save the xmp properties in xml format, I obtain the value that I inserted, after that I import xml file in Database. I’d like to know if is possible to develop an application that can extract xmp customized value from a group of PDF files.

And what is XMP?

Adobe’s Extensible Metadata Platform (XMP) is a labeling technology that allows you to embed data about a file, known as metadata, into the file itself. With XMP, desktop applications and back-end publishing systems gain a common method for capturing, sharing, and leveraging this valuable metadata — opening the door for more efficient job processing, workflow automation, and rights management, among many other possibilities. With XMP, Adobe has taken the “heavy lifting” out of metadata integration, offering content creators an easy way to embed meaningful information about their projects and providing industry partners with standards-based building blocks to develop optimized workflow solutions.

Finally, I used iTextSharp(of course iText also ok) to batch extract XMP from PDF, and save it to XML.

It is just a article talks about my two softwares posted by JimmyZou on http://www.mobileread.com/forums/archive/index.php/t-10515.html

After google a lot, I find super fast tool to cut A4 pdf into double pages A5 file.

I did one, and attach it behide, you guys can check it out.

Using DOS command to do it, and it done very fast, I split the 210K size pdf in 2 seconds, and the outcome file is 240K only, very effective!

You can find the software here:
http://www.rubypdf.com/

There are two softwares needed: PDFRotate and PDFDivide

First copy all software and the PDFs into one directory, the 2 simple steps:
1.First use PDFRoate
\PDFRoate 1-A4.pdf 1-A4-90.pdf 90
Rotate pdf 90 degree first, prepare to divide it.
2.USE PDFDivide
\Divide 1-A4-90.PDF 1-2A5.PDF

The only none-beatiful thing is that it cut directly, so in some pages there are 1 line letters been cut into 2 parts.

But anyway, it’s nice and fast.