Valentina question

[Jochen Peters]

Hello!

> I have some Valentina questions.  I'm not sure exactly where to ask 
> these, so please let me know if this is the correct way for me to do 
> this.
Yes - you can ask here - and - of course - also on the Valentina 
mailing list - please visit:
http://listserv.macserve.net/mailman/listinfo/valentina
to register for the list. It is very very usefull because many 
Valentina developers are listening to the list, offering help to each 
others.
I have forwarded this mail to the list.

>
> Here is what we are trying to accomplish:
>
> We have data in a MySQL database on a Solaris box that we are trying 
> to load into a Valentina db.  Unfortunately, it's not a straight data 
> transfer - we need to process the data slightly before it goes into 
> Valentina.  Right now, we're retrieving the data from MySQL using a 
> Java program (on the Solaris box) that processes the data and then 
> creates a file of "INSERT INTO ......." sql statements.  We're then 
> processing this sql file on Windows using a Director program that 
> creates a Valentina db and inserts the data.  This works, but we need 
> to automate this process.  Ideally, what we would like to do is to 
> retrieve the data and insert it into Valentina right on the Solaris 
> box.
Hhmm - but Valentina does not run on Solaris. So - you must do this on 
Windows or Mac.

>  I have not found a way to do this using Java/JDBC. Do you have any 
> ideas for how we can automatically transfer data from MySQL to 
> Valentina on Solaris?   If it's not possible on Solaris, what would be 
> your recommendation on the best way to do it on Windows?
Well - your approach seems to work. What exactly is your problem? You 
have to do this on a regular base and wants to automate
this?
I think Valentina Studio would be the ideal candidate for this - 
problem now is that it does not allow processing of data during import.
But i plan to integrate this into Valentina Studio. Studio already 
contains a JavaScript engine - so - in future it will be possible
to do this task with Studio.
Mike - what is your time frame for this task?
Maybe i can implement this feature into vStudio right now....

>
>
> Also, I have had some trouble with the Load feature in Valentina 
> Studio (I'm using Ver. 1.0a66 Build 0116092004).  I cannot get data 
> loaded from a SQL file into a Valentina db.  Any suggestions will be 
> appreciated.
Answer is easy: Valentina 1.x CAN'T load from SQL! (only from XML). 
This feature will be available for Valentina 2.x.

>
-- 
Best regards,
Jochen Peters
PIIT GmbH

------------------------------------
http://www.valentina-db.de