Rank: Advanced Member
Groups: Registered
Joined: 1/20/2017(UTC) Posts: 59  Location: sussex Thanks: 1 times
|
Please can you send me an example of how to output the persistent client xml file to an external file so I can import this into sql server.
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 484
Was thanked: 81 time(s) in 81 post(s)
|
Hi Nigel,
can you clarify a bit what you intend to do with XML data? Because MobileTogether supports databases natively and usually there is no need to generat external files.
If you still believe that you HAVE TO generate XML file, you can simply use Load/Save File action with File Path on server
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 1/20/2017(UTC) Posts: 59 Location: sussex Thanks: 1 times
|
I have built the xml as persistent on the client and the file is quite large. So if I can export the xml then I can import that into sql server on the mobile server and then link the two. It is the structure that I need to export so I do not have to retype the fields.
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 484
Was thanked: 81 time(s) in 81 post(s)
|
Fine. Please make sure to read documentation about file location on server http://manual.altova.com..._pgsrcs_loadsavefile.htmand about configuring the Working Directory. As a server admin, you have to define a folder where files are allowed to be saved on server http://manual.altova.com...l?mts_webui_settings.htmThe easiest way is to save files using relative file path - you simply enter the file name, and it lands in the pre-configured working directory
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 1/20/2017(UTC) Posts: 59 Location: sussex Thanks: 1 times
|
I really want to use an sql server as the backend database. I just need a way to export the client xml file I have typed so I can import this into the sql server. I have been through the examples and it would seem that I can go through the xml file line by line and output this to a file. Unfortunately the syntax I used does not quite work. Have you an example of how this would work.
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 484
Was thanked: 81 time(s) in 81 post(s)
|
I see now why you failed - I didn't realize that $PERSISTENT tree is not offered within Save File action - this must be some very old restriction which doesn't make sense anymore - we will fix that with the next release. Sorry! For the time being I've used my sample for record editing to show how you can simply copy the records from $PERSISTENT tree to a temporary tree and then execute the actual save command. There is no need to save records one by one - you simply save the whole XML at once.
|
|
|
|
|
|
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
