I'm looking for a coder that experienced in indexu
my problem is about importing categories
I prepared my categories as a .csv file with indexu database style but couldn't import it exactly.
In fact, this is very easy for experienced coders, everthing is ready.
I submitted a ticket into nicecoder support team but they got me back with saying "we've lots of work now, we'll answer you soon" although 1 week pasted. So I couldn't wait anymore.
I'm pasting the exact subject below, there's an attached file as I mention below but couldn't paste now, I'll paste tonight at home, I'm pasting this so that you can understand my problem:
"I attached the sample excel file.
As you see here, there're 2 columns.
First one is singer, second one is title
I want to put "singer" names like my main categories
and
I want to put "title" names like my sub categories
But each sub categories must belong to its singer's main category of course.
If I give an example from my excel file, there's a title called "Six Shooter" and it belongs to "Queens Of The Stone Age", so the "Six Shooter" title must be under the "Queens Of The Stone Age" main category, not "Quarashi".
I think you understood this.
And of course all of these subcategories has links. I want it to be my main page. Yes all of my links are the same, www.mydomain.com
So I need to know how I should setup my excel file to import from indexu admin panel "import" section or maybe if it's easier, phpmyadmin can be second alternative.
But I've no php or sql knowledge, only I know modifying templates.
As I see from indexu admin panel "add category" section, there're some field to enter.
I want to set like this:
Name: this must be category name
Description: again category name
Content: again category name
Visible: yes
Link Submission Permission: Not allowed
Registered users only: No
Meta Keyword: again category name
Meta Description: again category name
Page Title: again category name
Also adding subcategories process is same way I think, the only difference is choosing "Parent Category" and I think it will be set in my excel file that you'll teach me how to setup.
Also there's a "add link" section:
Title: title of singer
Url: http://www.mydomain.com (all of my links are same)
Description: title of singer
Keywords: title of singer
Contact Name: title of singer
Email: info@mydomain.com
All of my aim is to import my excel file which has over 20.000 lines, but of course I must modify it related to indexu structure for importation.
Please give me all details about modifying my excel file according to my main category, sub category and link wished that I explained at the above. I can change all of datas according to your suggestions for indexu structure in excel, I know excel very well, so no problem here. Please inform me also the important points for modifying this file.(for example I need to tab not space as I know). I can convert the excel file into txt also but I think I must modify/set/prepare my excel files related to indexu structure in excel and then after it, I can convert it to txt to import via indexu admin panel. Also we can use phpmyadmin sql commands but I don't know any sql."
However, my main categories are about 1000-1200 and subcategories are about 20.000 in total.
Please inform me about your help.




