[Download-List] Remote account problems & MV record problems

[Norman, David (SAAS)]

Dave,
Yes, that fixes my problem, provided that all dict items have the same
association.
Thanks,
========================
David Norman
Senior Systems Engineer
SA Ambulance Service
Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
fax +61 8 8271 4844
* norman.david at saambulance.com.au


-----Original Message-----
From: David L. Rotman [mailto:rotmand at cedarville.edu] 
Sent: Thursday, 28 October 2004 1:13 AM
To: download-list at cedarville.edu
Subject: Re: [Download-List] Remote account problems & MV record problems

Norman--

Thank you for pointing out the omissions in the setup routines.
I'll get that corrected on the next release.

I'm not sure I totally understand your unresolved issue, but it
sounds like an exploded list is what you need.

If file CUSTOMER has six associated attributes:
CONTACT.NAME
CONTACT.PHONE
CONTACT.EMAIL
CONTACT.FAX
CONTACT.CELL.PHONE
CONTACT.NOTE
you could use something like this:

GET.LIST MY.LIST
SELECT CUSTOMER BY.EXP CONTACT.NAME
DOWNLOAD CUSTOMER \
  BY.EXP CONTACT.NAME \
  CUSTOMER.ID \
  CUSTOMER.NAME \
  CONTACT.NAME \
  CONTACT.PHONE \
  CONTACT.EMAIL \
  CONTACT.FAX \
  CONTACT.CELL.PHONE \
  CONTACT.NOTE

to give you one line of output for each value of CUSTOMER.NAME.

Does that help?


>>> norman.david at saambulance.com.au 10/25/2004 8:53:04 PM >>>
I have just downloaded Download v7.11, after reading about it for some
time
on the U2 list.
I had problems setting up remote accounts to use Download, until I did
2
things - in VOCLIST changed the entry DL.EXPAND.ITEMS to remove the
dots,
and added DOWNLOAD.HELP to VOCLIST. Now a remote account works fine.
I have successfully created output files using 'normal' file structures
with
no problems.

The other problem I haven't been able to fix - I have a parameter
record
consisting of 6 attributes with any number of MVs. I want to create an
output CSV file where for each MV there is one record, containing each
of
the 6 attributes, but I can't seem to get this to work. Any tips on how
to
achieve this ? I ended up writing a program.

Thanks,
========================
David Norman
Senior Systems Engineer
SA Ambulance Service
Box 3, GPO
Adelaide, South Australia 5001
*+61 8 8274 0384
fax +61 8 8271 4844
* norman.david at saambulance.com.au
<mailto:norman.david at saambulance.com.au> 



Dave Rotman
Director of Computer Services
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819
_______________________________________________
download-list mailing list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list