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!

____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON

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.
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,

____________
~~~ Andrea ~~~
User #379756 on Linux Counter
"If you can't apt-get something, it isn't useful or doesn't exist!!"

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 .

Sorren wrote: [View Post]

Now in the DOS-Box are all comments on english

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.

____________
~~~ Andrea ~~~
User #379756 on Linux Counter
"If you can't apt-get something, it isn't useful or doesn't exist!!"

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

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

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.