Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Excel manipulation of data

Quote Reply
Excel manipulation of data
I have about 4000 categories that I need to modify and move links around in. doing it in the browse window of the Admin panel will take me years! :)

Can I get a simple explaination of how and if I can somehow download the data and modifiy it in some sort of text or excel editor.

I have tried to open the BACKUP file in excel and i get a warning not to change any data as it will corrupt it.

If there already is an explaination on the forum somewhere can someone point me in the right direction, I can't seem to locate the info.

thanks for any help
Quote Reply
Re: [knewt] Excel manipulation of data In reply to
Aloha,

Ehm use the export function of mysqlman.

- Goto admin/menu-build/mysqlman/lanch mysqlman...

Browse the cats table, pick the export function.

Later use the import function, but be carefull first make sure u have a good backup just in case something goes wrong.

Hope it helps, i did it a zillions times only i exported it to ms access.

Regards startpoint.
Quote Reply
Re: [startpoint] Excel manipulation of data In reply to
is it possible to edit the cats within the MySQLman window itself?
Quote Reply
Re: [knewt] Excel manipulation of data In reply to
Aloha,

Sure u can (pick browse then right on a line click EDIT), but why not use database/cats from sql links itself ?



Maybe u can use sql statements to change things that are the same?



Depends on what u want to edit...



Good luck..
Quote Reply
Re: [startpoint] Excel manipulation of data In reply to
Well, what I want is to quickly add things to many cats.
For example i want to add the same description to 150 cats

if I do this in the database/cats it takes forever

i basically want to copy and paste

I am jus tnot sure the best way to approach that
Quote Reply
Re: [knewt] Excel manipulation of data In reply to
For updating a mass number of records with the same values in columns, you can use the SQL Monitor (as mentioned before) using SQL UPDATE statements.

If you want descriptions to be all the same, then you can use the following SQL statement in the SQL Monitor via the MySQLMan package that comes with LINKS SQL:

GENERIC EXAMPLE

Code:

UPDATE Category SET ColumnName = 'something' WHERE SomeColumnName = 'somevalue'


Good luck...
========================================
Buh Bye!

Cheers,
Me