HELP - Urgent SQL Dump - I'LL PAY

[Cris Santos]

Hello, I've been waiting for ages for someone to help me with dumping my categories list (13000 categories).


I layed them out to work with another directory code and now I don't know how to prep them for eSyndicate Pro. :unsure:

Please, this is urgent!
Any kind soul out there - name your price if you must.

[pgolovko]

Could you please post some more information. Where can I see the categories? What exatly do you have problems with? Give me something to work with.

[Cris Santos]

I have 13000 categories ready for upload in a text file but they are laid out to work with a different directory script.
That's my problem.

Here's how two of the cat strings look :


INSERT INTO `dir_categories` VALUES (1,0, 'The Shopping Directory', 'For online shopping', 'Y');
INSERT INTO `dir_categories` VALUES (2,1, 'Shows - Tickets', 'Online shopping', 'Y');


Please advise.[/quote]

[Sai_dallas]

6019;"0";"56";"Casper";"Casper WY Real Estate Agents, REALTOR, Brokers - Casper Wyoming Realty ";"active";"Find Casper WY Real Estate Agents, REALTORS, Brokers - Casper Wyoming Realty";"Casper Wyoming Real Estate Agents Realty Brokers in WY Home loan house buy sell Agent Lender MLS Move Relocate REALTOR listings appraisal home value interest rate quote";"WY/Casper";"1";"0";"0";"2";;
6020;"0";"56";"Cheyenne";"Cheyenne WY Real Estate Agents, REALTOR, Brokers - Cheyenne Wyoming Realty ";"active";"Find Cheyenne WY Real Estate Agents, REALTORS, Brokers - Cheyenne Wyoming Realty";"Cheyenne Wyoming Real Estate Agents Realty Brokers in WY Home loan house buy sell Agent Lender MLS Move Relocate REALTOR listings appraisal home value interest rate quote";"WY/Cheyenne";"2";"0";"0";"2";;

I separated my cvs with ";" and "" for marking the text
if you visit my site
www.RealtyLinkDirectory.com
I just used the same files to upload 6025 categories.

One thing I saw is the site being slow.
If you have 13000 cats you need to think again if you want to split the site in to two or theree databases.

1) Put the Cats first into an access database and then add few colums as required.
2) Best is to manually enter one or two Categories and then check them in the Categories tabel and follow from there.

if you have specific questions, please let me know and I will try to help you with the upload.

Thanks
Sai

[Cris Santos]

My specific question is what is the easiest way to quickly fix my sql categories and dump them to work with eSyndicate's category layout for phpmyadmin?

Sergei Ten said he'd do it yesterday, but apparently couldn't.
So I'm running out of time as I'd like to get this directory up and running today...

All help appreciated.
Thanks
Cristina

[Nick Collins]

It looks like you have already migrated your categories.