[AccessD] Data Export Spec - Rev1

> I have been looking at the formatting information
> created by the export wizard.
John,

Have a look at this download - it has VBA code to manipulate Import/Export
specs - I think you can use it to not spend time on running Export/Import
wizard to analyze what kind of output formats it supports:
http://smsconsulting.spb.ru/shamil_s/download/imex.htm

> The other big thing remaining is what the header / footer records look
like
> and how to handle them.
These are usually checksum records and/or records having common to all
detail records information.

> I have questions about placing the delimiting characters in the field.
Has
> anyone run into cases where the delimiter changes from field to field?
Yes, it may happen. E.g. for the cases when export records have repeating
groups of attributes - e.g. employee with family members information in one
export record - COBOL-like stuff...

Export files can also have different types of body(detail) records - I did
program such applications. Well, maybe you'd better leave this case out of
scope now - it will make things too complicated to get first prototype
version quick...

Shamil

----- Original Message ----- 
From: "John Colby" <jwcolby at ColbyConsulting.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Saturday, October 22, 2005 8:35 PM
Subject: Re: [AccessD] Data Export Spec - Rev1


> OK, two things still need to be fleshed out:
>
> Custom field formatting - I have been looking at the formatting
information
> created by the export wizard.  They use:
>
> DateDelim
> DateFourDigitYear
> DateLeadingZeros (what is this?)
> DateOrder (yyyymmdd kind of thing)
> DecimalPoint
> FieldSeparator
> TextDelim
> TimeDelim
>
> I have questions about placing the delimiting characters in the field.
Has
> anyone run into cases where the delimiter changes from field to field?
>
> The other big thing remaining is what the header / footer records look
like
> and how to handle them.  If they are just delimited data similar to any
> other delimited data, then I would suggest that we simply use the existing
> functionality, treat them like any other export spec, but figure out a
means
> of specifying that a specific export is the header or footer of another
> export spec.
>
> Thoughts / comments on this?
>
> John W. Colby
> www.ColbyConsulting.com
>
> Contribute your unused CPU cycles to a good cause:
> http://folding.stanford.edu/
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com