Import from Microsoft Fax Log

[Ian Wood]

I've attached the first few lines as OutboxLOG_Sample.txt  but don't
attachments get scrubbed from here?

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?
>
> --
> Kenneth Brody
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20130610/88b1dcdf/attachment.html 
-------------- next part --------------
?"JobID"	"ParentJobID"	"SubmissionTime"	"Scheduled"	"Status"	"ErrorDesc"	"ErrorCode"	"StartTime"	"EndTime"	"Device"	"DialedNumber"	"CSID"	"TSID"	"Pages"	"TotalPages"	"QueueFileName"	"Document"	"FileSize"	"Retries"	"ServerCoverPage"	"CoverPageSubject"	"CoverPageNote"	"UserName"	"SenderName"	"SenderFaxNumber"	"SenderCompany"	"SenderStreet"	"SenderCity"	"SenderZipCode"	"SenderCountry/Region"	"SenderTitle"	"SenderDepartment"	"SenderOffice"	"SenderHomePhone"	"SenderOfficePhone"	"SenderEMail"	"RecipientName"	"RecipientFaxNumber"	"RecipientCompany"	"RecipientStreet"	"RecipientCity"	"RecipientZipCode"	"RecipientCountry/Region"	"RecipientTitle"	"RecipientDepartment"	"RecipientOffice"	"RecipientHomePhone"	"RecipientOfficePhone"	"RecipientEMail"	"BillingCode"
"0x0201cd19909ee4c4"	"0x2001cd19909ececb"	4/13/2012 12:15:19	4/13/2012 12:15:19	"Completed"	"Call completed"	"0x00000012"	4/13/2012 12:15:20	4/13/2012 12:16:39	"Agere Win Modem"	"6890196"	"6316890196"	"Fax"	1	1	"C:\ProgramData\Microsoft\Windows NT\MSFax\Queue\1CD19909EE4C4.FQE"	" "	15146	0	" "	" "	" "	"EXTRANET\iwood"	"Ian Wood"	""	""	""	""	""	""	""	""	""	""	""	""	" "	"6890196"	" "	" "	" "	" "	" "	" "	" "	" "	" "	" "	" "	""
"0x0201cd19a8923fb0"	"0x2001cd19a8923ec6"	4/13/2012 15:06:46	4/13/2012 15:06:46	"Completed"	"Call completed"	"0x00000012"	4/13/2012 15:06:47	4/13/2012 15:08:05	"Agere Win Modem"	"6890196"	"6316890196"	"Fax"	1	1	"C:\ProgramData\Microsoft\Windows NT\MSFax\Queue\1CD19A8923FB0.FQE"	" "	15146	0	" "	" "	" "	"EXTRANET\iwood"	"Ian Wood"	""	""	""	""	""	""	""	""	""	""	""	""	" "	"6890196"	" "	" "	" "	" "	" "	" "	" "	" "	" "	" "	" "	""
"0x0201cd19ae211b8c"	"0x2001cd19ae211aa2"	4/13/2012 15:46:33	4/13/2012 15:46:33	"Completed"	"Call completed"	"0x00000012"	4/13/2012 15:46:34	4/13/2012 15:47:52	"Agere Win Modem"	"6890196"	"6316890196"	"Fax"	1	1	"C:\ProgramData\Microsoft\Windows NT\MSFax\Queue\1CD19AE211B8C.FQE"	" "	15146	0	" "	" "	" "	"EXTRANET\iwood"	"Ian Wood"	""	""	""	""	""	""	""	""	""	""	""	""	" "	"6890196"	" "	" "	" "	" "	" "	" "	" "	" "	" "	" "	" "	""
"0x0201cd1f089e9979"	"0x2001cd1f089e9051"	4/20/2012 11:16:54	4/20/2012 11:16:54	"Completed"	"Call completed"	"0x00000012"	4/20/2012 11:16:56	4/20/2012 11:18:13	"Agere Win Modem"	"6891589"	" "	"Fax"	1	1	"C:\ProgramData\Microsoft\Windows NT\MSFax\Queue\1CD1F089E9979.FQE"	" "	15147	0	" "	" "	" "	"EXTRANET\iwood"	"Ian Wood"	""	""	""	""	""	""	""	""	""	""	""	""	" "	"6891589"	" "	" "	" "	" "	" "	" "	" "	" "	" "	" "	" "	""
"0x0201cd1f08a002a6"	"0x2001cd1f08a001bb"	4/20/2012 11:16:56	4/20/2012 11:16:56	"Completed"	"Call completed"	"0x00000012"	4/20/2012 11:18:14	4/20/2012 11:19:32	"Agere Win Modem"	"6891589"	" "	"Fax"	1	1	"C:\ProgramData\Microsoft\Windows NT\MSFax\Queue\1CD1F08A002A6.FQE"	" "	15147	0	" "	" "	" "	"EXTRANET\iwood"	"Ian Wood"	""	""	""	""	""	""	""	""	""	""	""	""	" "	"6891589"	" "	" "	" "	" "	" "	" "	" "	" "	" "	" "	" "	""
"0x0201cd1f08a14315"	"0x2001cd1f08a141b5"	4/20/2012 11:16:58	4/20/2012 11:16:58	"Completed"	"Call completed"	"0x00000012"	4/20/2012 11:19:32	4/20/2012 11:20:50	"Agere Win Modem"	"6891589"	" "	"Fax"	1	1	"C:\ProgramData\Microsoft\Windows NT\MSFax\Queue\1CD1F08A14315.FQE"	" "	15147	0	" "	" "	" "	"EXTRANET\iwood"	"Ian Wood"	""	""	""	""	""	""	""	""	""	""	""	""	" "	"6891589"	" "	" "	" "	" "	" "	" "	" "	" "	" "	" "	" "	""