Importing Excel output with phpmyadmin ?

[Frank71]

Hello,

again my old problem, I build my categories in Excel, but I use own fields so i can't use the import function from index.

Now I try to import my excel sheet with phpmyadmin, but my version allows only an import of textfiles and it seems, that I'm not able to save my table in excel in the right format to import it.

Any body here who can help ?
Very urgent

Frank

[esm]

use a formula to create the category string and then use the Paste Special to convert the formula to a value.Copy and paste the values to your editor and save.

Concatenate the various cells together. Also, concatenate a comma or pipe ( | ) to separate them. You could even use G-T Links 2 Category import feature if you use the pipe.

[Frank71]

I, ähm, I can't work with copy and paste, we are talking about very very very much categories, think nearly 20-30 k categories - we will see what indexu do this them

And I can't use indexu import function, because my knowledge is, that it only works with standart table and not with table with more categorie fields...

Thats my problem

Frank

[esm]

   A       B       C
1  |
2  2       0       Board Games
3  5       2       Jolly Games
4  7       0       Card Games
5
6  2|0|Board Games         =A2&$A$1&B2&$A$1&C2
7  5|2|Jolly Games         =A3&$A$1&B3&$A$1&C3
8  7|0|Card Games          =A4&$A$1&B4&$A$1&C4

Come'on Frank. I used to do this for a living. This is easy. Unless there is more stuff you haven't told us...

If you have a large file, just do part of it until you get it all done.

The above would create GT Links 2 Category file for easy importing.

[Frank71]

Hm, GT-Links import will also import into category tables with own fields ?
The normal import won't do this some months ago...

2|0|Board Games
7 5|2|Jolly Games
8 7|0|Card Games

I will check this
What is, if a field is empty ?

And how do i create the | for the export of excel ?

Frank

[esm]

now you thinking!

I imported the categories from an old GT Links 2 file with no problem.

What is, if a field is empty ?

you will still need to reference a blank cell in Excel.

And how do i create the | for the export of excel ?

just go to a blank cell and press the vertical bar on your keyboard and press enter. Then when you reference it in your formula, press the F4 key to lock the cell or type the $ signs as shown.

Do a few thousand at a time.

[Frank71]

Ok, new problem

Now my file is to big to change it in Notepad and I have a new problem:

ai,

ok, Texteditor fällt mittlerweile aus, die Datei ist zugross und Windoof hängt sich auf.
Aufteilen ist auch schlecht, da es zu viele Dateien sind

Thats in my colums:
<php>include ("http://www.domain.de/cgi-bin/?mode=a&input_template=2");</php>

Und the CSV willmake this out of it:
....;"<php>include (""http://www.domains.de/cgi-bin/?mode=a&input_template=2"");</php>";....

" at start and end AND around urls...

Some more ideas what I can use for include and href instead of " - perhaps simple ' ?

Frank

[esm]

as for a texteditor editplus.com is very good ( but it does cost ). While not as good, http://www.fixedsys.com/context/ is free. That should fix your problem there.

you really should try to split the data into several files. it can be done. reduces problems with importing

once again, I would not use CSV as you could have commas in the data. Use the pipe ( | ) and the GT category import. I have done it that way and works fine.

Not much more I can tell you.

Keep working at it. it will work for you also.

[aladdin1]

Hello,

Why don't you buy "Excel to MySQL" a life/time save $29.00 and it work like a charm.
If you are just to cheap then do it the hard way, In excel add an column between each of your field then ad "|" in the empty field (make sure that "|" and tab are not otherwise use") now save your excel workbook as tab delimited
open your file with wordpad find and delete all tab save and upload as a text file with "|" as separator. A little complicate but it will work.

[CEC]

here's a real elementary question for someone -- but one I haven't been able to reslove. when i set things up as tab delimited in excel, it throws quotes around all of the fields containing text (e.g., the content field). is there a way of handling things so it doesn't? it happens when there are code-related characters -- such as is the case with the <title>, and so on.