Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reading Ms Fax Server Logs
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01233417
Message ID:
01233431
Vues:
9
Hi Michele,

Just want to answer on the question of reading the logs. Do you want to add these records into your table?

I don't see the Scheduled field in your sample.

Here is a simple test I've tried:
CREATE CURSOR test (JoibID C(18), ParentJoibID C(18), SubmissionTime T, Scheduled C(1))
APPEND FROM test1.txt DELIMITED WITH tab
go top
delete &&(remove the first record with captions).
>I need to read the log files of Ms Fax Server to register in my application tables info about sent faxes (sender, tif file,etc).
>these files are ascii files delimited with tab but i can't append the data from these files.
>This is an example of the file
>
>"JobID"	"ParentJobID"	"SubmissionTime"	"Scheduled"
>"0x0201c7190f7450ba"	"0x2001c7190f744bd8"	12/6/2006 09:20:56	
>"0x0201c719e1d5ef8a"	"0x2001c719e1d5ed40"	12/7/2006 10:26:55	
>"0x0201c71d170695ea"	"0x2001c71d17069379"	12/11/2006 12:25:13
>"0x0201c71d1777c9b6"	"0x2001c71d1777c9b6"	12/11/2006 12:28:23
>"0x0201c71d2d67a74d"	"0x2001c71d2d67a74d"	12/11/2006 15:05:25
>"0x0201c71dcfcf0c64"	"0x2001c71dcfcf09f3"	12/12/2006 10:27:57
>"0x0201c71e01820f74"	"0x2001c71e01820d03"	12/12/2006 16:23:42
>"0x0201c71e01abcd56"	"0x2001c71e01abcae5"	12/12/2006 16:24:52
>"0x0201c71e0e0b97ed"	"0x2001c71e0e0b957c"	12/12/2006 17:53:27
>"0x0201c71e939d022d"	"0x2001c71e939d022d"	12/13/2006 09:49:34
>"0x0201c71e94cf0f54"	"0x2001c71e94cf0ce3"	12/13/2006 09:58:08
>"0x0201c71eaba56d8e"	"0x2001c71eaba56b1d"	12/13/2006 12:41:36
>"0x0201c71f571145ee"	"0x2001c71f571145ee"	12/14/2006 09:08:41
>
>How can i import this file in my tables ?
>
>On the contrary i have to use some fax object to comunicate directly with the fax server if there is one ?
>
>Someone can help me ?
>
>Thanks
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform