Importing a dump does nothing.

[Chuck Neal]

Studio won't import correctly either since the CSV dump has comas and spaces
embedded in the text areas.  It does not have an escape character so there
is no reliable way to get the data in via studio. :(  

Does anyone have any other ideas on how to convert this?  I can dump to
access, csv, export a sql dump, etc but my data seems completely unable to
import into Valentina. 

-Chuck
--------------------------
Chuck Neal
CEO, MediaMacros, Inc.
chuck at mediamacros.com
http://www.mediamacros.com
--------------------------
Check out the Developers Mall 
Your one stop shop for all your Director Xtra Needs
http://www.mediamacros.net/customer


-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Chuck Neal
Sent: Friday, September 03, 2004 4:41 PM
To: 'Valentina Developers'
Subject: RE: Importing a dump does nothing.


Well this helped some.  I used Martin's utility to create the DB (although
now I have a totally empty DB that is for some reason about 20 MB, but I can
always compact that later.)

ODBC_Valentina is a total wash for me.  I tried it with access and MySQL and
both either don't show any tables or it tries to import but does not copy a
single record.

VisSQL works a little.  Some records will import from copying and pasting
the SQL dump from mySQL, but unfortunately many of my text ones just crash
the program. 

Studio seems to not want to run any of my SQL statements, ignores all the
ODBC sources and does little more than let me look at the data in a table.  

I am about to try exporting each table out as CSV individually and see if
that imports.  This is painfully slow for a 27 table DB, but I hope it
works.  Any other suggestions welcomed! :)

-Chuck
--------------------------
Chuck Neal
CEO, MediaMacros, Inc.
chuck at mediamacros.com
http://www.mediamacros.com
--------------------------
Check out the Developers Mall 
Your one stop shop for all your Director Xtra Needs
http://www.mediamacros.net/customer


-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Frank Schima
Sent: Friday, September 03, 2004 4:17 PM
To: Valentina Developers
Subject: Re: Importing a dump does nothing.



On Sep 3, 2004, at 3:41 PM, Ruslan Zasukhin wrote:

> On 9/3/04 10:28 PM, "Chuck Neal" <chuck at mediamacros.com> wrote:
>
>> How can I pull a simple DB with structure and data into Valentina so
>> its usable in Director?
>
> Nothing as far as I know will not import structure.
> You need self make tables.
> Jochen promise add this into Vstudio/

ViSQL might work. Assuming the MySQL CREATE TABLE syntax matches 
Valentina syntax - it depends on which field types you are using I 
suspect. Just paste the entire MySQL SQL dump file into ViSQL and see 
if it works. You will have to first create a new blank database with 
Vapp or VStudio and open that in ViSQL.


Best regards,
Frank

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina