got the example, thanks! I'll keep you informed how it went.
chris
Alex Mandel wrote:
> Got a little excited about being able to help so I fished up the example
> and posted it (The site may be down for a couple of hours today due to
> planned power outage). It should be available right away or if you wait
> 6 hours.
>
> http://www.cdfg-rap.net/applications/development/documents/dia2accessExample..zip/download
>
> the .dia file is the diagram
> .SQL is the sql from dia2code output
> tool.bas is a text file showing what the VBA code inside the database
> looks like (by hand for this example)
> .mdb the final table
>
> Sorry no relationships in this example but I can dig up the web pages on
> that later if you need.
>
> Alex
>
> Christian Thanner wrote:
>> Hi Alex,
>>
>> thanks a lot for the information, I'll try that. Honestly, I've to say I
>> did not expect it to be possible.
>>
>> It would be great if you could also post your example, for sure it would
>> be of great help!
>>
>> Thanks again,
>> Chris
>>
>> Alex Mandel wrote:
>>
>>> Christian Thanner wrote:
>>>
>>>> Hi there,
>>>>
>>>> I would like to know if it at all possible to design a data model in dia
>>>> and import it to MS Access or to Open Office Base, and if it is, maybe
>>>> some hints how to do so.
>>>>
>>>> greetings,
>>>> Chris
>>>> _______________________________________________
>>>>
>>>>
>>> Yes, I've done it.
>>>
>>> I can post an example tomorrow,but here's the general idea.
>>> Make a UML diagram, each table is a class.
>>> Each field in a table is an attribute of the class.
>>>
>>> You have to code it for the end database you want, so if you want a text
>>> field for access you have to give the field as
>>> Name: SomeName
>>> Type: TEXT and add any constraints following it using what Access SQL wants.
>>> Comments are ignored
>>>
>>> Then run dia2code on the dia file to get and SQL file.
>>>
>>> Copy and paste the SQL removing end of line and --attributes-- or write
>>> yourself a script to call DAO and run the SQL. (I've been hoping to get
>>> to this part soon, last part that isn't automated.)
>>>
>>> Now you have an Access database.
>>>
>>> Alex
>>>
>>>
>>>
>>
>
> _______________________________________________
> Dia-list mailing list
> [email protected]
> http://mail.gnome.org/mailman/listinfo/dia-list
> FAQ at http://live.gnome.org/Dia/Faq
> Main page at http://live.gnome.org/Dia
>
>
_______________________________________________
Dia-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/dia-list
FAQ at http://live.gnome.org/Dia/Faq
Main page at http://live.gnome.org/Dia
