Icy Phoenix

Hallo,
I've programmed a SQL generator for FAP 1.4.1 in Java. I hope you can understand it :)

Function:
First start the SQL-Gerator then go in options and modificate the fields for your album.
Then save and close the option Frame. After that you have to chose the path and then press create SQL.
In the dictory, where the pics are, is the generated SQL as an .txt file.

I hope you can understand my bad english :)


Bye Sorren

New version: v0.2


History:
01.03.08: Bug with " ' " in generated SQL fixed
27.02.08: SQL Preview added, Options in the main window, Bug .JPG solved, complete translation in english

Wow, this could be very useful for users like me which usually upload pics manually.

I will have a try next time I need to upload pics in my album.

Thank you for sharing!

Thanks for sharing Sorren,

I will have a look at it.

That would be great :) And if you find some bugs, please post it here :)

Good work, it seems to work fine, but I, at the moment, prefer the "old" Excel sheet provided by MG. :wink:
Some tips/ideas:
- Why don't you include options fields directly in main winodow?
- I think that could be be useful if you may also provide an SQL preview.

Bugs:
- Files that have capital letters extension will not be included in SQL_generated.txt (eg. "image.PNG")

Minor thing:
- Some messages (when you restart the program) are in German.

Ciao,

OK thanks for your ideas :)
If corrected the Problem with the diffrent endings of the pics.
Now the program see .jpg, .JPG, .png, .PNG, .gif, .GIF .

Now in the DOS-Box are all comments on english ;)

I think, i change the Option window in the main window. But not now :) later.
And a preview? Do you mean a textfield and in it is the hole SQL Code?


Bye Sorren

Sorren wrote: [View Post]

Now the program see .jpg, .JPG, .png, .PNG, .gif, .GIF .

:up:

Sorren wrote: [View Post]

Now in the DOS-Box are all comments on english ;)

:up:

Sorren wrote: [View Post]

And a preview? Do you mean a textfield and in it is the hole SQL Code?

Yes, bur not hole SQL, just the first query. :wink:

OK, thats an intresting idea ... i see what i can do :D

ok i've solved your ideas :) i hope you can give me more of them :D

Good work, but at the moment I prefer the "old" Excel sheet provided by MG because I want to insert more than one pic at once.

Anyway, thanks for sharing it.

^^ you haven't understand the program, the program can generate a sql syntax of a hole dictonary! ... Not only one picture, mark one picture in your dictonary klick on create SQL an then see into the marked dictonary. In it is the file SQL_generated.txt which contains for every picture a SQL statement.