Import from Microsoft Fax Log

[Kenneth Brody]

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?

-- 
Kenneth Brody