Support Forum

Ask questions and get help from MobileTogether experts.
MobileTogether Product Information
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
nigel  
#1 Posted : Saturday, January 28, 2017 2:05:43 PM(UTC)
nigel

Rank: Advanced Member

Groups: Registered
Joined: 1/20/2017(UTC)
Posts: 59
United Kingdom
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.
bbv  
#2 Posted : Saturday, January 28, 2017 7:35:46 PM(UTC)
bbv

Rank: Administration

Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 495

Was thanked: 87 time(s) in 87 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
nigel  
#3 Posted : Sunday, January 29, 2017 10:24:35 AM(UTC)
nigel

Rank: Advanced Member

Groups: Registered
Joined: 1/20/2017(UTC)
Posts: 59
United Kingdom
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.
bbv  
#4 Posted : Sunday, January 29, 2017 10:52:24 AM(UTC)
bbv

Rank: Administration

Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 495

Was thanked: 87 time(s) in 87 post(s)
Fine. Please make sure to read documentation about file location on server

http://manual.altova.com..._pgsrcs_loadsavefile.htm

and 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.htm

The 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
nigel  
#5 Posted : Sunday, January 29, 2017 12:04:36 PM(UTC)
nigel

Rank: Advanced Member

Groups: Registered
Joined: 1/20/2017(UTC)
Posts: 59
United Kingdom
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.
bbv  
#6 Posted : Sunday, January 29, 2017 12:26:47 PM(UTC)
bbv

Rank: Administration

Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 495

Was thanked: 87 time(s) in 87 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.
File Attachment(s):
RecordsSaveOnServer.mtd (12kb) downloaded 45 time(s).
Users browsing this topic
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.