The Official Website of AgoraCart and Agora.cgi
AgoraCart.com Demos Download AgoraCart User Manuals & Wiki Gold Members Forum Go Gold Now! Gold Version Memberships
Shop Live Sites | iMegaMall.com | AgoraPros.com | AgoraPay | WebHosting Search | SnooperClick.com Search

AgoraCart.com

• About
• Features
• Download
• Payment Gateways
• Send a Donation
• Founders Club
• BLOG: News & Updates

Showcases & Demos

• AgoraCart Demos
• Shop Live Stores

Downloads & Add-ons

• Gold Version Downloads
• DBwizz Database Mgr.
• AgoraCart.com Store

Help & Support

• User Manuals
• Gold Version Users Forum
• Gold Version Chat
• Tech Support
• Certified Agora Pros
• Certified Designers
• Hire a Freelancer

Gold Version Members

• Member Benefits
• Join Today!
• Gold Members Home
• Gold Version Users Forum
• Gold Version Chat Rooms
• Gold Version Downloads

For Store Owners

• Merchant Accounts
• Cool Resources
• Advertise Here
• "Powered by" Logos
• Web Hosting Search

Misc.

• Contact Us
• MEET's Talking Guide
• The Ancient Greek Agora

AgoraCart Free User Forums

This is the official FAQ and Cool Tips guide For the AgoraCart shopping Cart software


Official Sponsors of the AgoraCart Project:

       


Register • Search • FAQ • Log in

AgoraCart Free User Forums Forum Index » Misc - Store Management » New question about data file

The time now is Sat Dec 21, 24 5:45 am
View previous topic | View next topic
This topic is locked: you cannot edit posts or make replies. Page 1 of 1
New question about data file
Author Message
Gary
Newbie - Two Blades
Joined: 25 Aug 2010
Posts: 26
Reply with quote
Post New question about data file 
Scott,

You have been responding to rbalthrope about removing a catagory on our new site. Robert and I are working together on the site of which I do the server stuff. The issue at hand is a catagory that says it has one product that is really not there when we try to remove the catagory.

In short you've directed Robert to pull up the datafile and manually remove the entry there. I've downloaded the file to my local pc using FTP. Problem is, it's a datafile that has a bunch of entries that could take forever to find the listing (transmissions).

Is there an application I can use to open this file that would make it easier to find the above entry?


Thanks

Gary
Thu Sep 09, 10 7:40 am View user's profile Send private message
scottcrew
Moderator
Joined: 13 Feb 2004
Posts: 7516
Location: The West Side of MI USA

Reply with quote
Post  
Gary,
You could use a program called CSVed.
Then you might be able to find the line that is basically empty...
But you should be able to spot the empty line with any text editor,
like EditPad Lite, that you can see the line numbers.
Each product is on its own line.
If you see a line with a bunch of pipes and not much data, that would probably be the line.
It was probably created because a hard return was used in the product's
description when adding the product to the database.


_________________
God Bless!
Bonnie - AgoraCart Moderator

Get a Gold Membership
Thu Sep 09, 10 12:37 pm View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger ICQ Number
Gary
Newbie - Two Blades
Joined: 25 Aug 2010
Posts: 26
Reply with quote
Post Actually Scott, 
I was able to open the file with notepad but it doesn't offer the option to list the file in what I would call line mode. I used the search feature and found the lines with the word Transmission as aposed to transmission without the capital T.
I deleted the word Tansmission (with the capital T) then saved it back to the server. I renamed the original datafile first so I wouldn't over write it but it didn't make a difference when I reloaded the site. I think I'll just dump all entries that refer to transmissions and see where that gets me.

I only have a few items listed so it won't hurt so bad if I loss the data, but then again I do have the original file.

I'll let you know what happens....again, thanks for your help.


Gary
Thu Sep 09, 10 4:24 pm View user's profile Send private message
scottcrew
Moderator
Joined: 13 Feb 2004
Posts: 7516
Location: The West Side of MI USA

Reply with quote
Post  
EditPad Lite does have the capability to display the file with line numbers and it is free.
http://www.editpadlite.com/

You would need to eliminate more than just a single word, you'd have to delete the entire line.
Each line in the database represents a single product.



Last edited by scottcrew on Thu Sep 09, 10 4:44 pm; edited 1 time in total
_________________
God Bless!
Bonnie - AgoraCart Moderator

Get a Gold Membership
Thu Sep 09, 10 4:35 pm View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger ICQ Number
Gary
Newbie - Two Blades
Joined: 25 Aug 2010
Posts: 26
Reply with quote
Post I'll try it, 
but in the meantime I screwed the whole thing up. After clearing all the transmission entries the store would not work. I re-loaded the original file and now I get this:

%%head_info%% %%StoreHeader%%

--------------------------------------------------------------------------------

We're sorry, an error has occured.
Please hit the browser back button, change what was done in error, and try again.


--------------------------------------------------------------------------------

%%StoreFooter%%

How bad have I screwed this one up??????



Gary
Thu Sep 09, 10 4:39 pm View user's profile Send private message
scottcrew
Moderator
Joined: 13 Feb 2004
Posts: 7516
Location: The West Side of MI USA

Reply with quote
Post  
What's the store URL?
Try clearing the cookies in your browser... close the browser, re-open the browser,
and try again.

Oh, did you make sure that you uploaded and downloaded the file in ASCII mode?


_________________
God Bless!
Bonnie - AgoraCart Moderator

Get a Gold Membership
Thu Sep 09, 10 4:45 pm View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger ICQ Number
Gary
Newbie - Two Blades
Joined: 25 Aug 2010
Posts: 26
Reply with quote
Post Never mind, 
I fixed it, restored the wrond file.....It must be time for a beer???? Ha ha

I also download the edit program which I will try tomorrow.

Thanks

Gary
Thu Sep 09, 10 4:48 pm View user's profile Send private message
Gary
Newbie - Two Blades
Joined: 25 Aug 2010
Posts: 26
Reply with quote
Post Scott, 
Here's the url:
http://www.allperformanceproducts.com/store52/store52/agora.cgi

I took a few minutes last night to look at the data file and see that I'll need to spend more time on it, the file is HUGE!!.

To make my search easier I'm going to remove all the transmission products because the wording comes up about a gazillian times in the file. Ha

I've also noticed that we now have extra spaces in the menu between catagories.


Gary
Fri Sep 10, 10 7:24 am View user's profile Send private message
scottcrew
Moderator
Joined: 13 Feb 2004
Posts: 7516
Location: The West Side of MI USA

Reply with quote
Post  
You have to look for empty lines and remove all empty lines....
Take a look at the 2nd line in your database... That is the problem line...
See how it starts with a pipe? That should never be...
Delete that entire line.
Also, line #126 has a space at the beginning of the line. The space must be removed.

Take care of those 2 things and see how it goes.


_________________
God Bless!
Bonnie - AgoraCart Moderator

Get a Gold Membership
Sat Sep 11, 10 8:13 am View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger ICQ Number
Gary
Newbie - Two Blades
Joined: 25 Aug 2010
Posts: 26
Reply with quote
Post Will do, 
Thanks Scott



Gary
Sat Sep 11, 10 8:37 am View user's profile Send private message
Display posts from previous:

AgoraCart Free User Forums Forum Index » Misc - Store Management » New question about data file

The time now is Sat Dec 21, 24 5:45 am | All times are GMT - 7 Hours
 
This topic is locked: you cannot edit posts or make replies. Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
  


Another K-Factor Technologies, Inc. Web Site     © Copyright 1999 - 2005