Knowledgebase

Home > Item #80

How do I extract data from CactuShop as comma separated values (CSV)?

Item: #80
Date: 19 Nov 2001
Applies to
v4

Question

We have a need to extract the shopping basket contents and credit card details from the database but they are stored within a memo field. Is there an easy way of extracting this detail?

Answer

The easiest way is to write a query in Access that pulls the fields you require. Access has simple tools to let you build this visually. This query could also be copied into a simple ASP page to format a text file with the values you require.

If you have CactuShop set to store card details in the database you must take precautions to ensure that the file is not accessible from the web via HTTP and preferably FTP and that your server is secure (firewall, latest patches, etc.).

If you put the query in to an ASP page, you must all make sure this page only runs through SSL.

Can't find the answer you need? Click here to open a support ticket.

« Back