Printable View
What was used to make the edits (Open Office is recommended)? Does the file that is to be imported to the database have proper formatting? (Quoted text, separated by commas with applicable characters escaped?)Quote:
Originally Posted by wheat
Perhaps could either attach the file, post the first couple of lines (please use the # option in the message menu toolbar to surround the information in code tags) or otherwise demonstrate the data that is not producng the desired result?
Hello,
I am trying to upload into a subcategory in my Westminster new zen cart version 1.5.3. I am getting the message it is uploading.
I had two previous item in this category which I used to start the download and then put the new information into the open office calculate sheet. I have tried this several time and the products just don't show up. Any help would be appreciated.
Thanks
Ron
Need a lot more information than what is provided. Enough to be able to duplicate what was done as if you were describing the actions and results to someone that was blind. Btw, glad to see that this was your first post, hope that we can all get the problem resolved.Quote:
Originally Posted by stuffwo
Hi,
This is not my first post to community, seems I some how had two name here, will have to straighten it out later.
Anyway Here is a link to the sheet which I have downloaded and uploaded. http://www.stuffwholesale.com/docume...p23-230347.csv
I have tested the link it seems to work.
Thanks
Ron
Thought that was you, but wasn't sure.:)
First thing that jumped out: no commas... Ts supposed to be a comma separated value file. :) in savng the fle need to include commas between fields...
I saved it as a csv file did it not do this? confused now.
See https://www.zen-cart.com/showthread....20#post1090420 (first post of this forum regarding how to save files to be imported.)Quote:
Originally Posted by stuffwo
Hello,
I read the post but I still am unable to have the products show. I done all the step in this post
1) Select File -> Save As
2) Ensure File type: is Text CSV (.csv)
3) check the Edit Filter settings box
4) click save
In the Export of text Files box,
Select your Character set. Probably UTF-8 is you are on zen 1.5 now.
Field delimiter: Comma ,
Text delimiter: Double quote "
you can leave the save cell contents as show box checked.
I have uploaded the file again into the server for you to look at. http://www.stuffwholesale.com/docume...p23-230347.csv
Could this be the Westminster new template that was installed I had no problems before installing the new template.
Nope, not template related. File to be imported still has incorrect format. Not entirely sure (off top of head) what setting is causing this. There are quotes around all of the text, commas within the text, but none between each column. May I suggest, just so you can see the differences in the files, to open a file using a plain text editor that has been generated for download alongside a fiile saved to be imported... You only need to look at the first line to see the significant difference... Don't even really need to read any of it, just look at the pattern.Quote:
Originally Posted by stuffwo
As for the notification, yes, the file was import (opened) successfully, but it wasn't processed successfully. (Should see a long list of "issues"/information at the bottom of the screen after importing.)
Quote:
Originally Posted by stuffwo
Took a look through the settings of Open Office (OO) versionQuote:
Originally Posted by mc12345678
File, Save As, mark the box that says Edit Filter Settings before clicking the save button.
Then choose the settings:
Character Set: Unicode (UTF-8)
Field Delimiter: , (Is a comma)
Text Delimiter: " (Is a double quote)
Suggest marking the Quote all text cells block
Looks like perhaps the field delimiter was set as a space instead of a comma...
Thought also not sure what caused all of the commas at the end of each row...