1. Jochen Peters
  2. Valentina Server
  3. Monday, May 09 2016, 03:25 PM
  4.  Subscribe via email
I need to read data from xojo ios to a valentina server sqlite

Can this is posible
Yes or No
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hi Alexis,

Yes, it is possible, but only using Valentina Server REST interface through the series of HTTP requests.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 1
Jochen Peters Accepted Answer
if any XOJO examples ?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 2
Sergey Pashkov Accepted Answer
No, there are only python examples at the moment.
Looks like Xojo HTTPSocket can be used for this task.
References
  1. http://docs.xojo.com/index.php/HTTPSocket
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 3
Sergey Pashkov Accepted Answer
Hi Alexis,
I've created a basic example on how to work with Valentina SQLite Server via REST in Xojo iOS.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 4
Jochen Peters Accepted Answer
cool thanks

the only i do no see is make a report on it

;)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 5
Sergey Pashkov Accepted Answer
Reports are accessible via REST interface - SQL command REPORT is used.

We'll make an example for reports.

Do you need reports only for SQLite in this task? (I'm asking because there will be an important fix for this datasource in the future version 6.5.4, and it will be necessary to update)

And how generated report will be used - shown in the WebView or sent elsewhere?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 6
Jochen Peters Accepted Answer
Yes sqlite
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 7
Sergey Pashkov Accepted Answer
And how are you going to use generated report? Show to the user or send somewhere? In which format?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 8
Jochen Peters Accepted Answer
show and some times send by email
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 9
Sergey Pashkov Accepted Answer
Hi Alexis,

I've created an example on how to generate a report in PDF format (HTML is possible, too) via Valentina Server REST and present it to the user.

To run it - it is necessary to drop M_Text extension methods into the project to get DecodeBase64 functionality, missing in iOS.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 10
Jochen Peters Accepted Answer
thanks for the hard works
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 11
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.