submit category or links via csv file

[acidburn2002]

i was wondering is it possible if i can upload csv file
that contain the links or category. Assuming that i already have over 500 directory websites from my previous website

if anyone done this before please let me know what is the format for submitting links or category via CSV file and where can i upload such file into

thanks

[Michael Hill]

Hello, pinonsale!

You can upload csv file to your mysql database via phpMyAdmin - click on import in necessary table - there you can see `Format of imported file` box and radio buttons - one of them is CSV.

The problem is in that your data should contain mysql-correct content. For example, if your fields delimiter is ' symbol, data shouldn't contain this symbol in description and title content .

All of the rows in csv file present as text string with defined delimiter. You should have correct number of field in such rows. Otherwise, you will have error in during import this file.

What is the reason for such operation? You intend to migrate your data from other database to eSyndicat?

[acidburn2002]

yes , i need to migrate it from my other website directory since i already have all category and links from previous directory

by anychance you could attach the sample of category format and links format please

i would really appreciate it

thanks

[Sergey Ten]

Hello pinonsale,

You could send me your CSV file to [sten at esyndicat dot com] and I will try to adapt it for eSyndiCat database.

[Michael Hill]

Hi, pinonsale,

Please, contact with Sergey directly or send it to support[at]esyndicat[dot]com we are glad to help you with migrate your data to eSyndicat database.

[regiobuscador]

Yesand working fine, but the main issue is that all categories are show (0), but if i edit some, thn change to the real listing counts.

Some body can tell me what i need to do, to show the real amount of links on each category.

Tanks..

[regiobuscador]

Yesand working fine, but the main issue is that all categories are show (0), but if i edit some, thn change to the real listing counts.

Some body can tell me what i need to do, to show the real amount of links on each category.

Tanks..

Sorry friends, the script has a tool to recount all the listings on each category! :good:

[Simon Gooffin]

Just a quick update. Now there is no need to update each time. This problem has been fixed and we have prepared a script to migrate from CSV. It's a separate plugin for our latest version.

[Milan Matchev]

J..we have prepared a script to migrate from CSV. It's a separate plugin for our latest version.

I'm trying to use the csv plugin but I get "Error upload CSV file" when I click on the "parse" button. Any idea why? What can be wrong? I have set write permissions to the "uploads" directory on the hosting.

[Nikita B.]

I'm trying to use the csv plugin but I get "Error upload CSV file" when I click on the "parse" button. Any idea why? What can be wrong? I have set write permissions to the "uploads" directory on the hosting.

Hello Milan and welcome to our support forums!
Maybe you set wrong delimiter for this CSV file?

Also, can you please send me this sql file via ticket system? I'll try to convert it to esyndicat sql format

[Milan Matchev]

Thank you Nikita,
I could't import with the plugin, but I learned how to import it directly with the MySQL DB. So I have now everything in the directory what I need. Thank you for the help.

[Nikita B.]

You are welcome!