Hello,

I have to export/Import MasterDetail tables to XML files.

Any tips ?

thanks

John

John wrote:
> Hello,
>
> I have to export/Import MasterDetail tables to XML files.
>
> Any tips ?

Scalabium SMExport. Never leave your house without it.

Ralf

> > I have to export/Import MasterDetail tables to XML files.
> Scalabium SMExport. Never leave your house without it.

Thanks for kind words, Ralf
--
With best regards, Mike Shkolnik
E-mail: mshkolnik@scalabium.com
WEB: http://www.scalabium.com

John wrote:

> I have to export/Import MasterDetail tables to XML files.
> Any tips ?

I did a lot of XML Import/Export...
So I even  did a lot changings in structure of the formats. After I did
this quite often in sources I changed all this stuff to runtime
"compilers"..

At the time I use NativeXML from simdesign. It's a very handy XML class
which I registered to PascalScript of RemObjects. Even the table and
query Components of DBISAM are registered...

So I do all the export and import parsing stuff at runtime..
I just call a class with some parameters.. and if one customer would
like to change the export or import format.. or would like to change
everything to another format.. ASCII, EDI,... just change a script at
runtime...

The benefit is that you have absolute control of nearly everything..

HIH
ralf

Ralf,

I have also TntiveXML for mNils and RemObject.
Can your code be downloadable somewhere ?

thanks for your help.

John

Ralf,

I have tyed the last version with Master/Details, unfortunately, the XML
create is not valid.
It work fine with single dataset.

Regards

John

The trial with master-detail export is not published for SMExport.

--
With best regards, Mike Shkolnik
E-mail: mshkolnik@scalabium.com
WEB: http://www.scalabium.com

"John" <prout@nospam.com> wrote in message
news:55802EA3-779E-4BFC-885C-EFD71199E9FD@news.elevatesoft.com...
> Ralf,
>
> I have tyed the last version with Master/Details, unfortunately, the XML
> create is not valid.
> It work fine with single dataset.
>
> Regards
>
> John
>
>

John,

> I have also TntiveXML for mNils and RemObject.
> Can your code be downloadable somewhere ?

I'm sorry, I don't have a sample App. that displays all the
functionality ... it's embedded in applications. There are Demo's of
the application available ... but no source of the app's..

But it's quite simple:

1.st
- Create a new Class
- Embed the RuntimeScript
- Create some propertys for the parameters
- Create some Propertys for result's..

2.nd
- You have to make the classes, that you wish to use, visible to the
runtime "compiler"...  PascalScript has a tool to build the basic's
(take care of the pointers..). There is a another very good runtime
"compiler" from ContextSoft.com .. I think it should work nearly the
same way like PascalScript from RemObjects... and the Author know's
DBIsam very well...

For NativeXML it's a little bit tricky to register the class in
RemObjects PascalScript.. they make heavy use of pointers which are not
supported by Remobjects.. a lot of work. Maybe it's easier to implement
it to Context Scripting Suite.. I used this for another project and it
was very nice because they have debug features and a lot more examples
than remobj...

To register DBIsam... nice job, not much work..

3.
To edit the script's I use Synedit.. with Pascal Highligther..

I'm sorry that I can't give you all the sources for that..
To make the classes visible you wish to use you have to include parts
of the original sources of the classes source.. prop's, func's, ...
they have a copyright...
... and they are even embedded with a lot stuff....

if you have question's of part's how to implement feel free to ask..

Because DBISAM is just a small part of this I think it would be the
right place to ask questions which are not related to SQL/DBISAM in
public.dbisam or by PM....

regards,

ralf

> Because DBISAM is just a small part of this I think it would be the
> right place to ask questions which are not related to SQL/DBISAM in
> public.dbisam or by PM....

... soorry, it was nearly the right group.. that's what happens on a 21"
screen.. some times ya don't see what you are doing...

I'm a registered user

we are speaking together those days....