PDA

View Full Version : mysql editor or or data entry tool

DelMarSurf
06-02-2006, 03:21 PM
I need to build some large PLD_CATEGORY files and was thinking there might be an easier way. The files are in text format, so I am just copy and pasting them into an empty string, then repeat.

I googled and looked at hotscripts. There must be a simple free tool so I can give the list to my wife and let her enter the data ;)

Free tool ideas?

cant edit title. Two "ors" don't make an "if"
anon
06-02-2006, 03:29 PM
no tools available.

i just finished talking to David about what I have coming up. He loves it.

but for now, no tools.
DelMarSurf
06-02-2006, 03:42 PM
Dang! Back to copy and paste. It was so easy importing those state categories - I filled 4 subs with states in 10 minutes!

Maybe I will just list dogs by color instead of breed. LOL
anon
06-02-2006, 03:46 PM
Content visible to registered users only.

easy eh?

do me a favor, add a few new categories and see/tell me how the directory looks after you've done so.
DelMarSurf
06-02-2006, 03:49 PM
Content visible to registered users only.

Here? http://www.puppythrill.com/

Thank you for all of your help!
anon
06-02-2006, 03:51 PM
wherever it is that you added the states.

after you do so, tell me how the structure is holding up.
DelMarSurf
06-02-2006, 03:57 PM
Content visible to registered users only.

http://www.puppythrill.com/veterinary-clinic-supplies/state/

http://www.puppythrill.com/dog-kennel-clubs/state/

http://www.puppythrill.com/dog-kennels/state/

http://www.puppythrill.com/dog-training/state/

I'm spamming!
DelMarSurf
06-02-2006, 04:04 PM
The titles are over-flowing. Makes for bad SEO. I will need to break it up into more subs.

If you think the structure will melt down, please let me know now. I would hate to find out a few months down the road.
anon
06-02-2006, 04:06 PM
if you add a category it will break.
DelMarSurf
06-02-2006, 04:09 PM
Content visible to registered users only.

??? Do you mean in states, or the entire directory???
anon
06-02-2006, 04:10 PM
entire.

backup you db, and add a few categories. you'll see exactly what i mean.
DelMarSurf
06-02-2006, 04:13 PM
Is it bacause the ID count is off? Is there a fix or is it beer-thirty?
anon
06-02-2006, 04:16 PM
as stated yesterday, look for the quick fix i wrote for 3rd party people giving database advice for inserts to update your PLD_CATEGORY_SEQ table.
DelMarSurf
06-02-2006, 04:20 PM
Content visible to registered users only.

I added four with success - no screwing the pooch yet! What is the link to said fix. I can feel doom knocking on my door...
anon
06-02-2006, 04:46 PM
I dont knwo the exact url. check for pld_category_seq fix or something similar. by poster: anon.

you have a lot of categories and you may not see where it's screwed up.

i'll be back later on. i'm just kind of pissed off atm (no, not at you).
Steven Myers
06-02-2006, 04:48 PM
Content visible to registered users only.

whoa, anon what's your thought on that? :p
anon
06-02-2006, 04:50 PM
bestiality .... /me shudders.
anon
06-02-2006, 08:07 PM
http://www.phplinkdirectory.com/forum/showthread.php?t=3413&highlight=PLD_CATEGORY_SEQ