Import from Microsoft Fax Log

[Ian Wood]

On Mon, Jun 10, 2013 at 3:27 PM, Kenneth Brody <kenbrody at spamcop.net> wrote:

> On 6/10/2013 3:18 PM, Ian Wood wrote:
>
>> filePro 5.07.03
>> Windows 2008 Server
>>
> [...]
>
>  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:
>>
> [...]
>
>  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.
>>
>
> Any chance you can attach the first few lines of that file, so we can see
> what's actually in it?
>
> Also, when you import it into Excel or Access, what options do you use?
>

To answer the second part of your question, I just take the defaults,
delimited file, tab delimited, I don't even convert all columns to text, I
leave them as General.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20130610/d271a8a1/attachment.html