• [Plugin] Batch Import 5 0 5 1
Currently:  

Author Topic: [Plugin] Batch Import  (Read 285736 times)

0 Members and 1 Guest are viewing this topic.

Offline PaulC2K

  • Pre-Newbie
  • Posts: 8
    • View Profile
    • http://qazwert.com
[Plugin] Batch Import
« Reply #75 on: February 07, 2003, 07:53:18 PM »
if its any help, the folder i want to use is:
http://www.spazstix.com/gallery (it wont accept this address, why is that??)

and the addres for batch_import.php is:
http://www.spazstix.com/php/gallery/admin/plugins/batch_import.php

Any ideas?

Great plugin btw, i just wish it was working for me :(

Offline hellraiser128

  • Pre-Newbie
  • Posts: 8
    • View Profile
Batch Import ist super - aber download_url fehlt
« Reply #76 on: February 13, 2003, 05:15:59 PM »
Ich arbeite vorzugsweise mit dem batch_import script und bin sehr zufrieden.
Was mir fehlt ist der automatische Eintrag der download_url in die Datenbank. Z.B. ./data/media/cat-id/image_name.jpg , damit beim download das große Bild geladen wird und nicht das Thumbnail.
Das müßte doch mit batch_import zu bewerkstelligen sein - oder?

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
[Plugin] Batch Import
« Reply #77 on: February 13, 2003, 06:37:57 PM »
Standardmässig wird doch beim Download das normale Bild genommen  :?:

Jan
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline hellraiser128

  • Pre-Newbie
  • Posts: 8
    • View Profile
[Plugin] Batch Import
« Reply #78 on: February 13, 2003, 06:51:57 PM »
Oweia- jetzt hab ich mich aber blamiert :roll:
Habe das ganze mehrfach ausprobiert - und irgendwie wurden immer die thumbnails downgeloadet. Gerade habe ich es online getested und siehe da-es funktioniert.
Trotzdem danke
Reidar

Offline Philip L.

  • Pre-Newbie
  • Posts: 1
    • View Profile
[Plugin] Batch Import
« Reply #79 on: February 20, 2003, 07:06:16 PM »
Hi,

I have tried the version 1.7 and I find it very good.

I am using it for my college where my class can post their pictures from different college trips.

I wanted to use the Batch import script but it doesn't work and it just chucks a lot of error messages out.
Also it is not reading the images the correct folder.

The folder which I am using where the images are stored for the script is in the plugins folder and is called "batch_upload_files".

Here are the errors the script prints out when I try and use it:

5 images in . Importing image 1 to 5

Import category ...
DB Error: Bad SQL Query: SELECT cat_order FROM paristrip_4i_categories WHERE cat_parent_id = ORDER BY cat_order DESC LIMIT 1
You have an error in your SQL syntax near 'ORDER BY cat_order DESC LIMIT 1' at line 4

DB Error: Bad SQL Query: INSERT INTO paristrip_4i_categories (cat_id, cat_name, cat_description, cat_parent_id, cat_order, auth_viewcat, auth_viewimage, auth_download, auth_upload, auth_directupload, auth_vote, auth_sendpostcard, auth_readcomment, auth_postcomment) VALUES (5, '', '', , 10, 0, 0, 2, 2, 9, 0, 0, 0, 2)
You have an error in your SQL syntax near ' 10, 0, 0, 2, 2, 9, 0, 0, 0, 2)' at line 4
FAILED

1. Importing image im.tgz

Warning: Unable to create './../../data/media/5/im.tgz': No such file or directory in /path/to/batch_import.php on line 122
Copy Image: Error while copying image /im.tgz
Skipping.....

2. Importing image libupdate.tgz

Warning: Unable to create './../../data/media/5/libupdate.tgz': No such file or directory in /path/to/batch_import.php on line 122
Copy Image: Error while copying image /libupdate.tgz
Skipping.....

3. Importing image php.neu

Warning: Unable to create './../../data/media/5/php.neu': No such file or directory in /path/to/batch_import.php on line 122
Copy Image: Error while copying image /php.neu
Skipping.....

4. Importing image phpup.tgz

Warning: Unable to create './../../data/media/5/phpup.tgz': No such file or directory in /path/to/batch_import.php on line 122
Copy Image: Error while copying image /phpup.tgz
Skipping.....

5. Importing image ruby.tgz

Warning: Unable to create './../../data/media/5/ruby.tgz': No such file or directory in /path/to/batch_import.php on line 122
Copy Image: Error while copying image /ruby.tgz
Skipping.....


Import finished!



Also the script is reading "5" images but there are only "2" images in the folder.

Can you please help me.
I need this to be working because I am not very happy on uploading 300 and more pictures manually.


Philip L.

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
[Plugin] Batch Import
« Reply #80 on: February 21, 2003, 09:42:40 AM »
Use this script only if you want to import image AND categories. The structure inside 'batch_upload_files' should be for example:

categoryfolder1 (folder)
- image1 (file)
- image2 (file)
categoryfolder2
- image1 (file)
- image2 (file)

The script will first create two categories ("categoryfolder1" and "categoryfolder2") and will then import the images to this categories. If you have only image in 'batch_upload_files' the import will fail!

If you want to import images only, use "Check new images" inside the Control Panel.

Jan
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline Kamui

  • Newbie
  • *
  • Posts: 19
    • View Profile
[Plugin] Batch Import
« Reply #81 on: March 13, 2003, 08:52:52 PM »
hi this is nice but. i'm sick in getting this damn error

3 images in Covers. Importing image 1 to 3

Import category Covers ... OK

1. Importing image 1.jpg

Warning: file_exists() [function.file-exists]: SAFE MODE Restriction in effect. The script whose uid is 32024 is not allowed to access /home/saiyaz/public_html/animesessions/data/media/2 owned by uid 99 in /home/saiyaz/public_html/animesessions/admin/plugins/batch_import.php on line 118

Warning: copy() [function.copy]: SAFE MODE Restriction in effect. The script whose uid is 32024 is not allowed to access /home/saiyaz/public_html/animesessions/data/media/2 owned by uid 99 in /home/saiyaz/public_html/animesessions/admin/plugins/batch_import.php on line 122

Warning: copy(./../../data/media/2/1.jpg) [function.copy]: failed to create stream: No such file or directory in /home/saiyaz/public_html/animesessions/admin/plugins/batch_import.php on line 122
Copy Image: Error while copying image /home/saiyaz/public_html/animesessions/upload/Covers/1.jpg
Skipping.....

2. Importing image 2.jpg

Warning: file_exists() [function.file-exists]: SAFE MODE Restriction in effect. The script whose uid is 32024 is not allowed to access /home/saiyaz/public_html/animesessions/data/media/2 owned by uid 99 in /home/saiyaz/public_html/animesessions/admin/plugins/batch_import.php on line 118

Warning: copy() [function.copy]: SAFE MODE Restriction in effect. The script whose uid is 32024 is not allowed to access /home/saiyaz/public_html/animesessions/data/media/2 owned by uid 99 in /home/saiyaz/public_html/animesessions/admin/plugins/batch_import.php on line 122

Warning: copy(./../../data/media/2/2.jpg) [function.copy]: failed to create stream: No such file or directory in /home/saiyaz/public_html/animesessions/admin/plugins/batch_import.php on line 122
Copy Image: Error while copying image /home/saiyaz/public_html/animesessions/upload/Covers/2.jpg
Skipping.....

3. Importing image 3.jpg

Warning: file_exists() [function.file-exists]: SAFE MODE Restriction in effect. The script whose uid is 32024 is not allowed to access /home/saiyaz/public_html/animesessions/data/media/2 owned by uid 99 in /home/saiyaz/public_html/animesessions/admin/plugins/batch_import.php on line 118

Warning: copy() [function.copy]: SAFE MODE Restriction in effect. The script whose uid is 32024 is not allowed to access /home/saiyaz/public_html/animesessions/data/media/2 owned by uid 99 in /home/saiyaz/public_html/animesessions/admin/plugins/batch_import.php on line 122

Warning: copy(./../../data/media/2/3.jpg) [function.copy]: failed to create stream: No such file or directory in /home/saiyaz/public_html/animesessions/admin/plugins/batch_import.php on line 122
Copy Image: Error while copying image /home/saiyaz/public_html/animesessions/upload/Covers/3.jpg
Skipping.....


Import finished!

[Back]


The permissions are set right n i dunno why it`s not gonna work for me.

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Administrator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
[Plugin] Batch Import
« Reply #82 on: March 13, 2003, 09:09:34 PM »
the main key is SAFE MODE
search the forum for the solution.
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline batman

  • Pre-Newbie
  • Posts: 9
    • View Profile
batch importing plus zip linking
« Reply #83 on: April 01, 2003, 09:45:24 AM »
Ok.. I have mastered the Batch import . Great tool. I would like to know the following.

1. all my images are linked to a specific zip file of the same name, example. baby.gif is linked to baby.zip (in same folder)
is there anyway using batch import to make the programm batch import the gif with the link to the zip file? this would be great if i could get it working.

2. I have some images online, is there a way of batch-linking -importing them BUT leaving them in the original directory ( as I have that directory passworded, I dont want none members accessing them)

Cool programme thanks
`if all the things I`ve lost ` I miss my mind the most

Offline andersen

  • Newbie
  • *
  • Posts: 34
    • View Profile
[Plugin] Batch Import
« Reply #84 on: May 11, 2003, 01:36:56 PM »
I had follow the instruction as above. I got some error as below

====================

3 images in . Importing image 1 to 3

Import category ...
DB Error: Bad SQL Query: SELECT cat_order FROM 4images_categories WHERE cat_parent_id = ORDER BY cat_order DESC LIMIT 1
You have an error in your SQL syntax near 'ORDER BY cat_order DESC LIMIT 1' at line 4

DB Error: Bad SQL Query: INSERT INTO 4images_categories (cat_id, cat_name, cat_description, cat_parent_id, cat_order, auth_viewcat, auth_viewimage, auth_download, auth_upload, auth_directupload, auth_vote, auth_sendpostcard, auth_readcomment, auth_postcomment) VALUES (11, '', '', , 10, 0, 0, 2, 2, 9, 0, 0, 0, 2)
You have an error in your SQL syntax near ' 10, 0, 0, 2, 2, 9, 0, 0, 0, 2)' at line 4
FAILED

1. Importing image .autofsck

Warning: Unable to create './../../data/media/11/.autofsck': No such file or directory in /home/httpd/html/bullroad/gallery/admin/plugins/batch_import.php on line 122
Copy Image: Error while copying image /.autofsck
Skipping.....

2. Importing image 7.2scsi.V2.2byBRF-RW.tar

Warning: Unable to create './../../data/media/11/7.2scsi.V2.2byBRF-RW.tar': No such file or directory in /home/httpd/html/bullroad/gallery/admin/plugins/batch_import.php on line 122
Copy Image: Error while copying image /7.2scsi.V2.2byBRF-RW.tar
Skipping.....

3. Importing image aquota.user

Warning: Unable to open '/aquota.user' for reading: Permission denied in /home/httpd/html/bullroad/gallery/admin/plugins/batch_import.php on line 122
Copy Image: Error while copying image /aquota.user
Skipping.....


Import finished!
What's wrong, huh?

Offline andersen

  • Newbie
  • *
  • Posts: 34
    • View Profile
[Plugin] Batch Import
« Reply #85 on: May 11, 2003, 01:47:06 PM »
Mm... Problem had been solve

When I change to

/home/httpd/html/xxxxx/gallery/admin/plugins

it works!
What's wrong, huh?

Offline noyou

  • Jr. Member
  • **
  • Posts: 71
    • View Profile
    • http://www.nowife.com/photo/index.php
[Plugin] Batch Import
« Reply #86 on: May 14, 2003, 07:10:33 AM »
To Jan or V@no, I setup everything on my local machine,
go to admin->batch import, nothing came up. Just blank wite paper there, so what's the problem? :cry:

Offline Jan

  • Administrator
  • 4images Guru
  • *****
  • Posts: 5.024
    • View Profile
    • 4images - Image Gallery Management System
[Plugin] Batch Import
« Reply #87 on: May 14, 2003, 09:37:48 AM »
Try to change
Code: [Select]
$root_path = (eregi("\/plugins\/", $PHP_SELF)) ? "./../../" : "./../";
to
Code: [Select]
$root_path = (eregi("\/plugins\/", $_SERVER['PHP_SELF'])) ? "./../../" : "./../";
Jan
Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search

Offline noyou

  • Jr. Member
  • **
  • Posts: 71
    • View Profile
    • http://www.nowife.com/photo/index.php
[Plugin] Batch Import
« Reply #88 on: May 14, 2003, 05:51:01 PM »
So if I will run this mod in a remote server instead of my own machine, the following code doesn't need to be changed, is that right?


Quote from: Jan
Try to change
Code: [Select]
$root_path = (eregi("\/plugins\/", $PHP_SELF)) ? "./../../" : "./../";
to
Code: [Select]
$root_path = (eregi("\/plugins\/", $_SERVER['PHP_SELF'])) ? "./../../" : "./../";
Jan

Offline noyou

  • Jr. Member
  • **
  • Posts: 71
    • View Profile
    • http://www.nowife.com/photo/index.php
[Plugin] Batch Import
« Reply #89 on: May 14, 2003, 06:20:30 PM »
Just now I tried this mod again, the page came out and use the absolute path: "c:/import" and the following error appeared:
Quote
24 images in . Importing image 1 to 24

Import category ...
DB Error: Bad SQL Query: SELECT cat_order FROM 4images_categories WHERE cat_parent_id = ORDER BY cat_order DESC LIMIT 1
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY cat_order DESC LIMIT 1' at line 4

DB Error: Bad SQL Query: INSERT INTO 4images_categories (cat_id, cat_name, cat_description, cat_parent_id, cat_order, auth_viewcat, auth_viewimage, auth_download, auth_upload, auth_directupload, auth_vote, auth_sendpostcard, auth_readcomment, auth_postcomment) VALUES (4, '', '', , 10, 0, 0, 2, 2, 9, 0, 0, 0, 2)
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 10, 0, 0, 2, 2, 9, 0, 0, 0, 2)' at line 4
FAILED

1. Importing image 0501_Harcelement Au Feminin CD1.avi
Copy Image: Error while copying image /0501_Harcelement Au Feminin CD1.avi
Skipping.....

2. Importing image 0501_Harcelement Au Feminin CD2.avi
Copy Image: Error while copying image /0501_Harcelement Au Feminin CD2.avi
Skipping.....

3. Importing image 0504_La Princesse et la Pute 1.avi
Copy Image: Error while copying image /0504_La Princesse et la Pute 1.avi
Skipping.....

4. Importing image 0504_La_princesse_et_la_pute_2.avi
Copy Image: Error while copying image /0504_La_princesse_et_la_pute_2.avi
Skipping.....

5. Importing image 0504_le contrat des anges #1.avi
Copy Image: Error while copying image /0504_le contrat des anges #1.avi
Skipping.....

6. Importing image AUTOEXEC.BAT
Copy Image: Error while copying image /AUTOEXEC.BAT
Skipping.....



this error is same as buddy WoodShedd encounted (third page of this post), then I followed your suggestion change the absolute path to relative,
Quote
The data source path "../../import" seems to be incorrect!
error came out.
When I finished reading this post, follow the V@no's hint: SAFE MODE,  check my own php.ini, found that SAFE MODE is off.
So I think safe mode is not the reason, why your batch-import.php read the data from the root dir of C disk, instead of from import dir I created?

Later I change the souce dir to other location: C:/4image/import, and modified the source path in the batch-import.php. The same error came out, it still read the data from the root dir of C disk other than the path I specified. I am frustrated, what am I supposed to do now? :?

 

Post your comments here