Edit MOD

[esm]

I have started an Edit MOD. Actually, it is not so much a MOD for INDEXU as it is a stand-alone program to edit database records. You can use it to edit the records of INDEXU. Well, the links first but later on the categories, users, etc.

I recently had a occasion to review some 1300 link records. Some I edited, some I deleted, some did not change. I had to either use the INDEXU admin control panel or phpmyadmin to do this. It took forever. Actually, I only got thru a couple of hunderd and decided there had to be a better way.

I've had to do something like this several times over the years since I first started with link directories back in 1999. IT IS ALWAYS A PAIN IN THE BUTT. Primarily because there is no efficient way to scroll thru the records.

So I have started working on this MOD. What does it do? well take a look at the NEXT-PREV MOD that I did that allows you to scroll thru the detail records in a particular category. see http://www.indexuhelp.com/indexu32e/detail.php?id=23. Now imagine that you can see ALL of the fields for the record AND that you can edit anything. then just click on the NEXT button to save the changes and automatically move to the next record.

as an aside at this point, the number of categories in INDEXU could be an issue. Just listing them in an HTML select tag could take lots of computer resouces. and in dody's attempt to add "additional" categories I would have to add it two more times. Go to your "add a listing" page at your site or take a look here: http://www.nicecoder.com/indexu/demo/add.php?cat=101289. and that is only with 287 categores. imagine 5,000+ categories and having to download that 3 times. but I will offer a number of options for that.

which brings me to another point. I will probably have a number of customizable options: for example, number of columns to display, whether or not to include the categories, additional cats, what to search for, how to search, which version of INDEXU (3.1, 3.2,5.0)

I will start with the links table but will probably add other tables (categories, users, etc)

So if you have any comments or interest in the MOD I would be interested in hearing from you. If folks here at INDEXU are interested, I will tailor it to INDEXU. if not, I will just develop it in a generic sense to use with any database.

The cost will be $57 thru PAYPAL.



.

[inspireme]

sounds good. can you put some features like "find and replace" you can do this with sql but its going to be great to haev an easy to use find and replace option on the panel. Maybe you could have a few options to limit which the find and replace is applied on (WHERE and OR clauses)

good idea though. I would buy it.

[esm]

The MOD is coming along nicely. The actual scrolling thru the records and editing/saving them is working just fine. As usual, the "guts" of a program is the easy part. Its the input/output (which deals with the user) that is the area that takes time.

In this case the input is the hard part. At least the part that creates the recordset to edit. I HAVE to create a way to filter the records. I'm sure no one wants to always start at the beginning of 20,000 records when they have already edited the first 5,000...!

But I'm working on that. You will be able to select a beginning/ending link ID (or whatever the ID is for that table when I add the other tables) or one or more categories or search by a word or phrase.

I'll post a link to it when I get it further along so you can see it in action.

can you put some features like "find and replace" you can do this with sql but its going to be great to haev an easy to use find and replace option on the panel. Maybe you could have a few options to limit which the find and replace is applied on (WHERE and OR clauses)

I've had a number of folks ask me about a "find and replace" feature over the years. You are the second one in the past week.

I usually tell them to create a backup and then use a text editor ( I use EditPlus ) to do a search and replace. This works fine if your database is not too large. I opened a 14MB file yesterday without any problem. I have a 38MB file that I will try later.

As you know using SQL can be dangerous. It always amazes me the number of folks who purchase INDEXU and don't know much about HTML. and many know nothing of PHP. (Those that are serious about their website do start to learn though ) I'm just not so sure about letting folks play around with SQL.

Having said that, I'm not so sure how someone would use it. I can set up a "template" for the SQL statement. but the WHERE clause gets tricky. Just too many combinations of fields and "connectors" ("and", "or"). I guess I could keep it simple but then what.

I have to be very careful when I use the "replace all" in my text editor. I've had to hit the undo button many a time. Lots of times i don't want to replace every occurence so I have to do one at a time. which is not too bad but then I'm only looking at a few hundred, not tens of thousand.

There is no undo to a SQL command (there is a rollback command but I am not sure it would be applicable).

Anyway, building a SQL statement could be challenging and using it could be dangerous. but i would be interested in discussing it further.



.

[aladdin1]

Hello,

It is nice to see you back on this forum.
Since you are speaking of database I will try to explain my problem. I have created a new article site. I usually edit the table with excel but the file is just too big (over 120mb) how can I conveniently divide my table into several smaller ones?
BTW did you know that excel can not handle anything above 65.000 rows

[esm]

It is nice to see you back on this forum.

hmmmm...
I didn't know that I left...

I'm just hanging around for kicks and giggles. Actually, I just decided that I was tired of doing dody's job for him. INDEXU is his program; he can support it or not.

So I just post ocassionally. When the mood strikes me...

It is nice to see the increased activity here at Nicecoder. The active members have actually doubled since the release of v4 ... ooops v5. There are now 6 active members...: eek:

BTW did you know that excel can not handle anything above 65.000 rows

Yep. I started with VisiCalc, SuperCalc, Lotus 1-2-3, etc way back in 1981 (when Bill Gates was worth less than $1 million ). Spreadsheets have always pretty much been limited to either 65,000 rows or the amount of available memory.

I usually edit the table with excel but the file is just too big (over 120mb) how can I conveniently divide my table into several smaller ones?
BTW did you know that excel can not handle anything above 65.000 rows

Hey, maybe you could use this MOD...Does it use the INDEXU database? Is it SQL?

I guess you could use ACCESS.

The MOD is coming along nicely. I'll send you a PM with the URL. I'll post it here later today or tomorrow depending when I get further along. Right now it can edit links by either categories, searching for keywords, dated added, date updated or by links. I'm adding searching by Hot, New, Updated, Pick, etc.

I also have two other MODs to go along with the Edit MOD. I will also create an ADD MOD. The Add mod will give you the ability to add links by grabbing the META info from a site. The idea is to fill in as much as the information as possible using the MOD and then just editing any remaining fields before adding the link.

I willl try to add features like "remembering" certain info from one record to the next so as to reduce the amount of typing and the ability to "grab" all the links from a webpage for possibly adding them to the INDEXU database.

I have another MOD in mind but I'll wait to announce it.

Not that any INDEXU users will actually use the MODs. There will need to be a lot more active INDEXU users than currently exist.

I'm really just doing them more for my sites than anything else.




.

[inspireme]

Find and replace is simple in sql :

update TABLE set COLUMN = replace(COLUMN, OLD_VALUE, NEW_VALUE);

I was just thinking a drop down box for the column, the old phrase and the new phrase. You can leave the old phrase blank and populate a new field with a word (yes/no) or it could be use to toggle or change phrases and words in your listings. its probably just the way i use indexU that makes this useful though, I guess for most this isnt useful... although you mentioned lots of people asking about find and replace.

[esm]

Find and replace is simple in sql :

update TABLE set COLUMN = replace(COLUMN, OLD_VALUE, NEW_VALUE);

yep, that will work.

you just need to be careful as the above code will update ALL records. You may want to use a WHERE clause as appropriate.



.

[esm]

sounds good. can you put some features like "find and replace" you can do this with sql but its going to be great to haev an easy to use find and replace option on the panel. Maybe you could have a few options to limit which the find and replace is applied on (WHERE and OR clauses)

good idea though. I would buy it.

You can see it at http://www.indexuhelp.com/addlinks/index.php. While I still have lots to do with it, I would appreciate any comments from folks. I'm sure there are some bugs in it at this point. I haven't added any password stuff please so don't screw around with too much. Try changing a field and clicking the save button. I'll add a delete feature later on.

Besides the Edit MOD and the Add MOD, the third mod I wanted to do was the search and replace MOD. Maybe I'll create a Delete MOD to round out the set.

I think every INDEXU user could benefit from the first two MODs. Not so much from the search and replace and delete MODs.


.

[esm]

I am thinking about adding a "grid" feature ( kind of like a spreadsheet ) showing just the found record set.

I already have most of the code from another project so maybe it won't take too long.



.

[esm]

I have added a new feature that allows you to view the meta information of a site. As you scroll a through the records, just click on a button and a window pops up with the site's information: Title, Description and Keywords. It will also show any email address. It will search the indicated page and any other designated pages. Just copy and paste into the approriate fields and click the save button and the site it updated!

You can also click a hyperlink to open a new window that shows the website itself.

Check it out. http://www.indexuhelp.com


.