Exporting Results - for use with Protx

[Ravon]

Hello,

I am looking for a solution to export customer details, (e.g. Name, telephone and order no) into one csv file. THis is to be used with Protx reports to reconcile bank batchs.

I have checked the database but have to use two tables (Person and Order) to gather the info, is this the only way?

Maybe more export reports could be built into v8?!?!

[Nadeem]

Hi Raymond

I'm afraid so, have a look at the following thread: http://community.actinic.com/showthread.php?t=6645. Especially what Jan has written. Here is what she said:

The easiest way to import the Actinic export files is to create the files, create a link to the csv files in your access database and then write queries to append them to the end of your tables.

The links are

order - order lines
Order sequence number - nOrderSequenceNumber

order - person
InvoiceContactId - ContactID for the invoice row
DeliveryContactId - ContactID for the delivery row

order - payments
Order Sequence Number - OrderNumber

Maybe more export reports could be built into v8?!?!

It will be added to the wishlist.

Kind Regards