Customer Accounts from emails

[inkjet]

Hi we are starting accounts for customers and because Actinic does not let anyone register online i have created a form and script that emails me the data from the customer, is there anyway to set a link so that i can export the data from the email into the correct fields in Actinic Acount setup, i only uploaded this page on friday and i have 15 people already waiting for accounts, as you could imagine this would take a while to create each account manually.

thanks

[inkjet]

Ok i know most people are just reading this and passing by, which database holds the account info, i could probably sort it out that way.

[Nadeem]

Hi there

If you open the actiniccatalog.mdb, the customer accounts are kept in the [BUYER] table. This is where it holds the username and password

The customer address details are kept in [Person] table

Kind Regards

[Jan]

There are three tables,

Customer : the main account details, main address, price schedule etc

Buyer : the buyers for the customer, you can have as many as you like, the username and password used to logon are held in this table.

Address : address information, used to hold customer and buyer information.

The minumum you need to create is one record in the customer table, one record in the buyer table and one record in the addresses table.

We have a product in beta that allows you to setup a form on your website and then the information is collected into a database table. This might be an easier way of doing what you are trying to do because then all of the name and address info etc will be available easily rather than you trying to extract information from the email. Contact Pat is you want a copy to try -it's currently known as the catalog requestor.

The easiest way to create customer accounts is to click on the 'create account' button when an order arrives. You could add an option to checkout asking whether they wanted to setup an account - this would probably get more people to setup and account and would be very easy for you to process, you would just have to click on the create account button to setup the account when you go into Actinic to send the email.

Regards,

[inkjet]

Cheers Jan got the software

The click here to get an account is not really that much of an option for me as the orders are downloaded else where and my laptop has the shop on for updating reasons.

hope this works