Hi Folks, i need to do a few bulk submissions into my PHPLD directory 50-100, is there an easy way via php myadmin or even SQL that someone has tried and works please. Alternatively if there is a script out there that does this ...? Probs will be copying my data from excel any suggestions appreciated. i posted here because the PHPLD forum seems a little slow right now....
You could just use some SQL code to dump a load of rows in. You could go to phpmyadmin and use the insert button. You could go to the directory admin panel and just create links...
Thanks Mikey, was looking for something a bit more specific, ie a script or the actual sql syntax to run to achieve this.
I have managed to download a demo version of Navicat, anyone know how to use it for importing excell data into PHPLD in the correct format please ?
Try to contact LeopardAt1. He has a "new payment mod" where you can submit your sites using a text file.. Lots of submissions at one time only.
I can't offer any useful input on what you were asking about regarding navicat but i did want to throw in, i've used navicat for quite some time and it's really an awesome program
Can leopards mod be integrated into the current one? As i have got 300 submissions to be added in queue.
Yes, its working for current phpld script.. But i think it will add 5 links at a max from a text file
Well around two months back, we got an order for 250 listings to be added. I wishd we knew of the leopard's tool. Would have been great help at that time. Coz it was really painful to add all listings one by one. And that too in 72 hours....Argghh Do you have a link to his tutorial or any demo on how things are done. I really do not know much about this mod...really
I myself tried that demo. He gave me a text file with few link details.. I just uploaded text file on that submit page ( there was a upload file button) and submission was complete. OK look here http://www.ripenapples.com/directory-list.pl Can you see "auto Loader" at the top ? That's it
Hi Everyone, I didn't even notice this thread till Jg notified me. Sorry for any misunderstandings. My payment system is nothing more but a way for directory owners to receive reviewed submissions (up to three at a time). The Auto Load feature allows filling in the submission form easier, but its not meant for "bulk" purposes. I think its probably best if you were to type the submission information inside a excel file and import it via phpMyAdmin. You could also use a CSV file as well. I'll see if I can write a tutorial soon to apply one of these two methods.
"This feature allows you to fill out most of the directory submission fields automatically by browsing for the appropriate text file you have previously downloaded. When submitting website(s) to a web directory with the Auto Loader feature, for each successful submission, you will be able to download a proper auto loading text file to use in the future." Probably Leopard needs to elaborate as i am still not understanding how it is done And is this mod unique to ripenapples or is available for downloads (paid or free) by leopard? Now that makes sense. Coz after going thru the mod description, it in no way looked to be bulk submission kinda mod. Thanks for clarifying that Leopard
Hey no problem. I definitely don't want people thinking my mod is equipped for this type of job. The AutoLoader feature can be a bit confusing. You can visit http://ripenapples.com/autoload.html to try it out if you want. Also, sorry but its a paid mod (http://forums.digitalpoint.com/showthread.php?t=398824). The other ones I release will be free though. Thanks