Guest Posted February 23, 2008 Posted February 23, 2008 What does (tab delimited) mean... I am trying to upload an excel file to my server
germ Posted February 23, 2008 Posted February 23, 2008 That means there are tabs (an "invisible" ASCII character, chr(9)) between fields, as in a file you import into Excel. ;) If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
germ Posted February 23, 2008 Posted February 23, 2008 No prob... ;) You may be more familiar with the term CSV file. That means Comma Separated Values Another type of file used to import data into Excel, but there are commas between the fields instead of tabs. If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Guest Posted February 23, 2008 Posted February 23, 2008 Ok... One more question for you... SRY I am new at this but... LOL... Every thing is as it is... I HOPE... But when I go to upload my CSV file... NOTHING TAKES... I get no error... Looks like every thing uploads but when I go to verify the upload www.cupidshouseoftoys.com none of the items are there... Do you might have any suggestions...
germ Posted February 23, 2008 Posted February 23, 2008 There are some categories that are there that weren't a while ago. It's hard to say what the problem is. Since it's a purchased template, it might be the template code. Have you been into your Admin to see if the categories and products show up in there? :unsure: If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Guest Posted February 23, 2008 Posted February 23, 2008 yep... I added the categories... in hopes that the items would fall in place...
germ Posted February 23, 2008 Posted February 23, 2008 I found another shop with the same template: yassadultshop DOT com I Googled the text that shows up when you click on your Privacy Policy link. :blush: Login to your Admin. Click on Configuration --> Maximun values Be sure these fields are NOT ZERO Search Results Special Products New Products Module Selection of Random New Products Selection of Products on Special New Products Listing Then click on Product Listing. On that page is where you determine what shows in what order. Try these settings: Display Product Image 1 Display Product Manufaturer Name 0 Display Product Model 0 Display Product Name 2 Display Product Price 3 Display Product Quantity 0 Display Product Weight 0 Display Buy Now column 4 Display Category/Manufacturer Filter (0=disable; 1=enable) 1 If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
germ Posted February 23, 2008 Posted February 23, 2008 Another thing to check is to go into your Categoies / Products page in the admin and be sure the Status is GREEN on your products. If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Guest Posted February 23, 2008 Posted February 23, 2008 OK cool... I just went in and did that... and what it did when I uploaded was wipe out the headings that I put there... SO some how in the configuring that I think that it just might take it... cuz on upload it got rid of em... So not sure how but with some changing it prob will take the headings and items... Am I close... THX SO MUCH FOR YOUR HELP... :sweating:
germ Posted February 23, 2008 Posted February 23, 2008 Have you tried to manually create a Category, then add some test products to it via your Admin? :unsure: If that works, then the template code is working, and the problem would be in your import of data. If it doesn't, I'm leaning towards bad template code... :huh: If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Guest Posted February 23, 2008 Posted February 23, 2008 yes sir... I was up to about 300 items... till tonight... I have about 1500 items to upload... So ya... I was uploading the items one by one with photo and it was working... Entering the heading by hand... SO COOL... it is working just have the csv file wrong some how... R u aware of things that make it so the csv file dont work...
germ Posted February 23, 2008 Posted February 23, 2008 I've never tried to import data into osC that way. Sorry. :blush: I hope you backed up your database... If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Guest Posted February 23, 2008 Posted February 23, 2008 All good... Yep got her backed up... SAY thx ever so much for you helping me 2night... I think much progress has been made... I have been fighting with this for about 2 weeks... U ROCK...
Guest Posted February 23, 2008 Posted February 23, 2008 an "invisible" ASCII character, chr(9)) between fields, as in a file you import into Excel. maybe this is where I am messing up... How do I do this... or how do I know it is this way now...
germ Posted February 23, 2008 Posted February 23, 2008 If you have a choice, I'd work with CSV files. That'd be my preference. ;) If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Guest Posted February 23, 2008 Posted February 23, 2008 ok then... cvs it is... MAYBE HERE is my problem... On line (1) that is where you put your (Item Stats... Price... Categories... Product Name... ect) Every thing under line one are the items... Got that part... Where in osCom can I match it up so with what is on LINE 1 of my excel sheet... Not sure if this is my problem why when I upload that nothing shows up... O YA>>> GOOD MORNING>.. ;-)
germ Posted February 23, 2008 Posted February 23, 2008 Well, as I said before, I've never imported/exported from osC. You said in an earlier post, that you had manually entered about 300 items. Maybe if you restored the database to what it was at that point, then exported it into a CSV file, you could determine what is what. I always work better from an example when dealing with something I'm not sure about. :lol: And a hearty 'Wake up, Sleepyhead!", to you, too. :) If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Guest Posted February 24, 2008 Posted February 24, 2008 I have got ONE MORE QUESTION for you... I think that I change price of vender list by going to format cells... I need to increase prices by a %... LOL... WHAT option is it... or do I have to change every 15,000 items one by one... THX BOSS...
germ Posted February 24, 2008 Posted February 24, 2008 I've been tracking your progress. It looked to me like you did a re-install, and things are looking much better. ;) I looked for a contribution to do a "blanket price increase by a percentage", but didn't see one. If you did use a spreadsheet to populate things, I could write a simple VB script to up the prices for you, then you'd have to import it again. I'll look more for a "blanket price updater". If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Guest Posted February 24, 2008 Posted February 24, 2008 Yep... Thx for the help boss... My friend did just that... Reinstalled it... There were several things that were JUST NOT WORKING... and Now they are... Now I am re-uploading all of the photos... AND have the spreadsheet just about done except for the prices... I have my wholesale prices but now I need to take that and increase it by like say 175%... I have been looking in excel to increase one column for to do just that... and not having luck... I AM SURE it has to have it... I bet it is some formula... Not use to Excel so ya having problem... THX SO MUCH FOR THE IMPUT... And if it is not much of a problem to make a simple code... MAN I tell you this whole thing has been a learning step for me... THX Germ / Yoda :D
germ Posted February 24, 2008 Posted February 24, 2008 Obi-Wan has taught you well, Young Skywalker... ;) If you want me to up the prices with a script, just send me the spreadsheet in an email, and I'll up them (just tell me what column and how much), and send it back. If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
germ Posted February 24, 2008 Posted February 24, 2008 do I have to change every 15,000 items one by one... I'm woking on my laptop (the Wife is playing WOW on the desktop), and it's not the "fastest horse in the corral", with that many to change it may take a while... :blink: If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there >
Guest Posted February 24, 2008 Posted February 24, 2008 LOL... WOW... RIGHT ON... I am on Jewlgin and Whisperwind server... Look for Blacksangre if you are on ether realm... BRB... going to run fast to the store to pick up an EPIC gallon of Milk... LOL... brb...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.