extracting information for labels

[jxm28788]

I have a label printer and need a quick way of extracting the addresses of selected orders (or orders between certain times).

Is there a way to extract this info to a comma delimited file?

Do I need crystal to do this?

[rmladden]

Your can export orders to a separate file set (uncheck hide files dialog) or use Excel query or Access to get at them.

[Jan]

We can help you out there:

1) Use our free export addresses solution (or the white paper from Actinic) to export address details. See http://www.mole-end.biz/acatalog/Newsletter_Section.html for details of how to get to the free software library.

2) Use our mailing list export program to export them and import them into word for mail merge. See http://www.mole-end.biz/acatalog/One_Stop_Email_Marketing.html for more details and a free trial.

3) Use our integrated label solutions to include a removable sticky label on the invoice, packing list or data entry report. See http://www.mole-end.biz/acatalog/Integrated_Labels1.html for mroe details.

4) Use our mailing label solutions to print labels from Actinic or our own products. See http://www.mole-end.biz/acatalog/Mailing_Labels.html for more details.

If all of that is of no use then you can export data directly from the persons table into whatever it is you need to print labels from OR you can use the standard Actinic export orders function and take the data from the persons.txt file.

If you want to write your own label report using crystal (which is not an easy task) you need to buy crystal version 8.5 - standard edition.

Don't forget that if you do decide to use one of our products you can get a £15 discount this month (ie. until Sunday) if you are on our mailing list. So for example you could buy the email marketing tool for £35.

Cheers,

[jxm28788]

How many of those options let me export the order number with the name & address...? (it will save me a lot of time in other areas if the order number is displayed on the address label)

[Jan]

I got a bit over enthusiastic there and missed the bit about your label printer. The best way to do this is to have (or to write using crystal reports v8.5) a label report written that prints directly to your label printer. If you don't want to do that try option 1) or 2).

Cheers,

[Jan]

It seems to be my day for missing things - in answer to your actual question, which one of those will let you display the order number as well, neither will.

The best way to do this is to use a custom report to print the label - it streamlines the order processing nicely.

However if you don't want to do this you could write a query to move data from the person table and order table into another table.

First run this SQL to create a table

SELECT Order.[Order Number], Person.Name, Person.Salutation, Person.Title, Person.Company, Person.[Address Line 1], Person.[Address Line 2], Person.[Address Line 3], Person.[Address Line 4], Person.[Postal Code], Person.[Phone Number], Person.[FAX Number], Person.[Web Site], Person.sUserDefined, Person.bKeepContactPrivate, Order.nInvoiceStatus INTO OrderAddresses
FROM [Order] INNER JOIN Person ON Order.DeliverContactID = Person.ContactID
WHERE (((Order.nInvoiceStatus)=0));

Then run this SQL each time you want to update your table:

INSERT INTO OrderAddresses ( [Order Number], Name, Salutation, Title, Company, [Address Line 1], [Address Line 2], [Address Line 3], [Address Line 4], [Postal Code], [Phone Number], [FAX Number], [Web Site], sUserDefined, bKeepContactPrivate, nInvoiceStatus )
SELECT Order.[Order Number], Person.Name, Person.Salutation, Person.Title, Person.Company, Person.[Address Line 1], Person.[Address Line 2], Person.[Address Line 3], Person.[Address Line 4], Person.[Postal Code], Person.[Phone Number], Person.[FAX Number], Person.[Web Site], Person.sUserDefined, Person.bKeepContactPrivate, Order.nInvoiceStatus
FROM [Order] INNER JOIN Person ON Order.DeliverContactID = Person.ContactID
WHERE (((Order.nInvoiceStatus)=0));

This will put a copy of the data into a table called OrderAddresses for all orders that have not had their invoices printed yet. So you would run this, then print the invoices to stop them getting put into the table repeatedly.

Regards,

[smiffy]

Even I'm confused now Jan!

I have a Dymo Label printer and I actually use the copy of order confirmation email to get the customers postal address.

You can configure Actinic to send you a copy of each order under View : Business Settings : Ordering and put you own email address in the "Send receipt email copies to" box.

I then have a rule in outlook to move these email into their own folder.

The only downside to this is that if the customer USES ALL CAPITALS or mIXES CaSe then that’s how it appears on the label.

If you look at Jan's site she does have a utility/info on using Postcode Anywhere which allows users to pick the address from a list - which is formatted correctly. Each looked up address only cost 1p.

[jxm28788]

This will put a copy of the data into a table called OrderAddresses for all orders that have not had their invoices printed yet. So you would run this, then print the invoices to stop them getting put into the table repeatedly.ah, but I'm using your automation software that automatically prints the invoices (and I want it to do that, saves lots of time)...

The best way to do this is to use a custom report to print the label - it streamlines the order processing nicely. do I need crystal for this?

[smiffy]

You would need chrystal for this, but I believe that Jan would create a report for you - for a small fee.

[Jan]

Gary is right.

Sorry to have confused people - I'm trying to fix a horribly complicated bug (John, you reported it actually) and my confused state seems to be spilling out into my comments on here.

Regards,

[jxm28788]

I have a Dymo Label printer and I actually use the copy of order confirmation email to get the customers postal address. This is how I do it, but it has 2 problems -

1) As you pointed out, the text isn't formatted (which is more annoying now jans utils has formatted it correctly in actinic)

2) This is time consuming, to have to open each e-mail and cut and paste into the label program (unless you found a quicker way of doing it?)

[jxm28788]

I'm trying to fix a horribly complicated bug (John, you reported it actually) which one? ;)

[smiffy]

1... Yep I'd agree.

2... It's not as time consuming as finding the order in Actinic and copying one line of the address at a time.

2b... I also copy the customers email address, as we now email them a Royal Mail tracking number.


I've looked at automating, this but not all of my orders are postal, so I would be wasting labels.

[Jan]

The PSP pending problem - and it is working now as well - woo hoo (in the stock control mole - just the batch order processors to sort out now and it can go for alpha testing).

The other 'bugs' are on the wish list and will arrive shortly after Christmas if all goes well.

With regard to your mailing label, you could get 1 Stop Automation to print those out as well by installing them in place of the packing list or data entry report. That is the lovely thing about a label printer you can just print labels one at a time (same applies to integrated label reports) which makes life so easy.

Regards,

[smiffy]

Jan thant reminds me..... Is it possible for the One Stop Automation to actully print the PSPpenind orders too......

[Jan]

Not at the moment - it specifically excludes them - why do you want it to do that? (I'll add it to the wish list anyway - it would probably be an checkbox type option, would you want it to carry out all processing or just printing?)

Regards,

[jxm28788]

With regard to your mailing label, you could get 1 Stop Automation to print those out as well by installing them in place of the packing list or data entry report.

So if I understand correctly, I would have to - create a report in crystal with the info I want in the format I want, identify the data entry report and replace it with mine (with the same name?), then just tell batch processor to print the DE report?

[Jan]

That is exactly right John.

The data entry report is called dataentry.rpt. You could either write a new report and call it dataentry.rpt (it lives in the main Actinic directory not the site directory) or you could use the data entry report at a starting point, delete everything from it except for the delivery address and make it the right size for your label paper.

Regards,

[smiffy]

Originally posted by Jan
Not at the moment - it specifically excludes them - why do you want it to do that? (I'll add it to the wish list anyway - it would probably be an checkbox type option, would you want it to carry out all processing or just printing?)

Regards,

On a couple of occasions I have a problem with Protx not matching payments to orders, so they have remainded as PSP pending.

Also if they are printed then I can call the custoemr to see if they were having problem with the site, or just changed their mind.

[jxm28788]

The data entry report is called dataentry.rpt. You could either write a new report and call it dataentry.rpt (it lives in the main Actinic directory not the site directory) or you could use the data entry report at a starting point, delete everything from it except for the delivery address and make it the right size for your label paper. Having just seen the price of crystal (HOW MUCH?!?!?!) I was going to go for your 2nd option...but having opened the report in notepad it isn't in text format... maybe you meant open it in crystal and edit it...?

Is there a cheap version of crystal? a demo version? a shareware package that uses the same format...? failing that, how much do you charge for knocking up a short report?

[smiffy]

Depending on which (model) label printer you have then I may be interested too.

Though I would need to use one of my existing label templates as this includes the return address etc.

[jxm28788]

dymo labelwriter 330 turbo.

ditto for the return address.

[smiffy]

I've got the older 320 model.. with the Dymo Labelwriter Large Address Labels 36x89mm

What size labels do you use?

[jxm28788]

54mmx101mm 99014 standard shipping/name labels

[Jan]

Smiffy - you could use email marketing tool to get the names and addresses over to your label printer - I believe that they can print from csv files.

John - you can only edit the data entry report with crystal reports (you should pay between £100 and £150 for crystal and you have to buy v8.5)

Regards,