Csv File

[Guest peggy]

hi,

 

when the demo script, credit card payment, is run, a file in .csv format is created and all details are stored in it.

 

may i know is it possible to change this file format to something else for eg, microsoft access or normal microsoft excel?

 

thanks

[SupportTeam]

Both MS Access and MS Excel can read the comma delimited (.csv) files...

 

You can just open them directly in Access/Excel...

 

If you wish to create your own log files please read the VG Help file's section on Run VB Script module - you can write out log entries of your own format using the Run VB Script modules and some examples are provided in the Help file.

[Guest Guest]

But how do you input the entered data into the microsoft excel csv file?

 

Can I have the algorithm (a general guideline)?

 

Thanks

[SupportTeam]

Just open the file in Excel...

Go to "File" menu, then select "Open" then in the Open File window set the "Files Of Type" to be "Text Files"...

[Guest Guest]

What I mean is can I set up my own database and then overide the csv file such that all details are saved automatically to my database instead of the csv file?

 

If can, how do I go about doing that?

[SupportTeam]

You can just write data to your database directly using a "DB Query" module...

 

To create your own text files (comma delimited or XML etc.) then you can just use a "Run VB Script" to write information to file - see VG Help file's section on Run VB Script for more information - there are examples provided there on how to do this.