Import from Microsoft Fax Log

[Ian Wood]

filePro 5.07.03
Windows 2008 Server

I currently do a bunch of PDF conversion (using Print Wizard) and automatic
e-mail and/or faxing.

I need a way for the users to verify that their faxes were successful, my
filePro and PrintWizard functions can only tell then that it was sent to
the fax modem.

I can't just give them access to the server to view the outbox and sent
items in Windows Fax and Scan as that is based on user profile and will
only show their individual faxes, I need to show all.

After some digging, I found that the sent faxes reside in a directory
called C:\ProgramData\Microsoft\Windows NT\MSFax\ActivityLog\ in a file
called OutboxLOG.txt

It has a schema.ini that shows:

[OutboxLOG.txt]
ColNameHeader=True
Format=TabDelimited
CharacterSet=1200
Col1=JobID Char Width 18
Col2=ParentJobID Char Width 18
.
.
.
Col50=BillingCode Char Width 255



My conundrum is this:

This looks like a regular text file with a header record and 50 fields.

I have tried:

import ascii imp=(file_name) r=\n f=\t

import ascii imp=(file_name) r=\n f=\t o=" c="

import word imp=(file_name)

import word imp=(file_name) r=\n f=\t

all give me the same issue, imp(1) shows only the first double quote of the
file and imp(2) is blank

file_name is defined as (255,*,g) and is fine.

If I open the .txt file in Excel or Access it imports fine.  I can then
save as a .csv and run my import into filePro without issue (o post to a
filePro faxlog file).

I need to avoid that step as I want to automate this process nightly.

I have done literally 10's of thousands, if not hundreds of imports/exports
in my filePro career, so I definitely don't think it's that :)

As these are standard Microsoft files, I was wondering if someone else had
perhaps come across this, and if so, what they did to resolve it.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20130610/6f8271d3/attachment.html