filePro 5.07.03<br>Windows 2008 Server<br><br>I currently do a bunch of PDF conversion (using Print Wizard) and automatic e-mail and/or faxing. <br><br>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.<br>
<br>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.<br><br>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<br>
<br>It has a schema.ini that shows:<br><br>[OutboxLOG.txt]<br>ColNameHeader=True<br>Format=TabDelimited<br>CharacterSet=1200<br>Col1=JobID Char Width 18<br>Col2=ParentJobID Char Width 18<br>.<br>.<br>.<br>Col50=BillingCode Char Width 255<br>
<br><br><br>My conundrum is this:<br><br>This looks like a regular text file with a header record and 50 fields. <br><br>I have tried:<br><br>import ascii imp=(file_name) r=\n f=\t<br><br>import ascii imp=(file_name) r=\n f=\t o=" c="<br>
<br>import word imp=(file_name) <br><br>import word imp=(file_name) r=\n f=\t<br><br>all give me the same issue, imp(1) shows only the first double quote of the file and imp(2) is blank<br><br>file_name is defined as (255,*,g) and is fine.<br>
<br>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). <br><br>I need to avoid that step as I want to automate this process nightly.<br>
<br>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 :)<br><br>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.<br>
<br><br><br><br><br>