Normal Topic Exporting in a particular manner. (Read 457 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Exporting in a particular manner.
Jan 21st, 2010 at 10:17am
Print Post Print Post  
Hello!

For the cost units (health insurance settlement) we would like to export the data in special Format.
The records must have following criteria:
1 - Every record (inklusiv Subform records) are summarized
2 - Main form fields (without repetition) followed by all Suform records.
3 -  Fields are separated by a carrige return
4 - Fields without delimiter

Every exported record must look as this example:

- Record start

Main Form (Mainrecord)
PatientNr
firstname
lastname
DOB
address

Subform (Subrecords)
Date      1
Code     1
Service 1
Price     1
Date      2
Code     2
Service 2
Price     2
Date      3
Code     3
Service 3
Price    3
.

.
.
- Record End


Thank you vor the Help.

Dr. Belhareth
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Exporting in a particular manner.
Reply #1 - Jan 21st, 2010 at 3:40pm
Print Post Print Post  
Hello Amor,

To do this you are going to have to write the export file using Sbasic programming and then write it to disk using FileOverWrite().

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged