pepe Posted November 28, 2002 Posted November 28, 2002 Hi all. I decided to give a try to TEP and I'm really liking it. So i decide to use it on a test project of mine, starting to change the language. Since I only want 1 lang I deleted all the others and removed the block from the right menu. Next i thought it was a good idea to see how to import a already existent database, so I've downloaded EasyPopulate 2.1 and made a excel file from my 3 products on TEP. The idea was to see how EasyPopulate needed the field order to use that on a "real" inport. To my surprise there wheren't a "name" field or anything like that on the file. Can anyone help me trying to find what went wrong?? Thanks. Pepe P.S.: I apologize for my English, but I'm not used to write (or speak) it. Why is it called tourist season if we can't shoot at them?
wasson65 Posted November 30, 2002 Posted November 30, 2002 Hi all. I decided to give a try to TEP and I'm really liking it. So i decide to use it on a test project of mine, starting to change the language. Since I only want 1 lang I deleted all the others and removed the block from the right menu. Next i thought it was a good idea to see how to import a already existent database, so I've downloaded EasyPopulate 2.1 and made a excel file from my 3 products on TEP. The idea was to see how EasyPopulate needed the field order to use that on a "real" inport. To my surprise there wheren't a "name" field or anything like that on the file. Can anyone help me trying to find what went wrong?? Thanks. Pepe P.S.: I apologize for my English, but I'm not used to write (or speak) it. EasyPopulate is not very language smart right now. It pretty much assumes that english is the default, and can handle one other language for product names and descriptions. I should fix this so that EasyPopulate can have a default language code. Not sure just when I'm going to get around it. Tim
pepe Posted December 1, 2002 Author Posted December 1, 2002 I should fix this so that EasyPopulate can have a default language code. Not sure just when I'm going to get around it. Hi Tim. Thank you for your answer. At least i know that i wasn't doing anything wrong. ;) So i'll wait for the next version, and on the mean while i'll use phpmyadminto do the import (argh!) ;) Thanks for making this great contribution to the OSC users and keep up the good work. Pepe Why is it called tourist season if we can't shoot at them?
wasson65 Posted December 1, 2002 Posted December 1, 2002 I should fix this so that EasyPopulate can have a default language code. Not sure just when I'm going to get around it. Hi Tim. Thank you for your answer. At least i know that i wasn't doing anything wrong. ;) So i'll wait for the next version, and on the mean while i'll use phpmyadminto do the import (argh!) ;) Thanks for making this great contribution to the OSC users and keep up the good work. Pepe Pepe, I've got a beta version of 2.2 that should handle multi-language product descriptions, and will also let you create the categories in langs other than english. I haven't turned it loose as a contribution yet because I'd like some people to test it first. You can get it here: http://www.wassons.org/EasyPopulate_v2.2beta.zip You'll need to read the configuration section of easypopulate.php, but it should be fairly commented, so not too hard. Hope this works for you, if not let me know and we'll debug it. Tim
pepe Posted December 1, 2002 Author Posted December 1, 2002 Thanks! I'll try it. Pepe Why is it called tourist season if we can't shoot at them?
pepe Posted December 8, 2002 Author Posted December 8, 2002 Hello again. Wasson65, i've been trying to work with Easypopulate 2.2 and it's working... kinda. One of the problem that i'm having is that all latin characters (and i need those, sinse I'm portuguese) are giving me problems, for instance the "?" appears as "<" or the "?" as a "z" with some sort of acent. Do you think it's related with the code-page for the site or more related with EasyPopulate' Thank you for your time. Pepe Why is it called tourist season if we can't shoot at them?
wasson65 Posted December 9, 2002 Posted December 9, 2002 Hello again. Wasson65, i've been trying to work with Easypopulate 2.2 and it's working... kinda. One of the problem that i'm having is that all latin characters (and i need those, sinse I'm portuguese) are giving me problems, for instance the "?" appears as "<" or the "?" as a "z" with some sort of acent. Do you think it's related with the code-page for the site or more related with EasyPopulate' Thank you for your time. Pepe Hmm, This is a new one for me. I'm guessing it's some type of encoding problem, either the file isn't right coming out of excel, or php is mangling it when it reads it... But I'm not sure off the top of my head how to handle this... Maybe dynamok has some insight, since he wrote the original excel import that handled Ukranian...
pepe Posted December 9, 2002 Author Posted December 9, 2002 I'm guessing it's some type of encoding problem YUP! Try to have a text file with 3500+ produtcs made from a macintosh database (Filemaker Pro) a nice piece of software called EasyContents that expects a unix linebreak and a mysql database that expects pc characters and what you have? A mess! At least until i found out how to make my life easy on 2 steps. Got a software that converts characters in text files from mac to windows another to converts line breaks to the unix style and i'm all set and ready to go in less than 2 minutes. I'm happy! :) And i love EasyContents 2.2 Pepe Why is it called tourist season if we can't shoot at them?
denu Posted November 13, 2011 Posted November 13, 2011 Any new sugestion upon this subject? I'm using the latest version of EasyPopulate and still experiencing trouble with import data from Excel CSV. Excel saves my csv into colon-separated strings without any quotes sign but in Windows CP-something-latin encoding. EasyPopulate imports the rows correctly, but mentioned encoding causes strings to look like this: Szafa aktowa dwuskrzyd�owa I've tried to edit CSV file in Notepad++ and convert it to UTF8. After that operation I can't import data to EasyPopulate. I'm getting: No products_model field in record. This line was not imported: | PS02 | Szafa akto | Szafa akto | | | | | bi/primus/ | 590 | | | | | | | Meble biur | | | System Pri | | | Szafy biur | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | If converting to UTF8 blows understanding it in EasyPopulate, then what else can I do to import national encoded characters properly? greetz
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.