cybercon Posted March 25, 2007 Share Posted March 25, 2007 OK I am a PC guy - I know little about Mac. I can use EP with no issue from my windows system, my client is a Mac guy and cannot. He can't open my .csv in Excel, and we cannot import into EP no matter if it is .csv or tab delimited .txt I am pulling my hair out after hours of forums searching. I was doing the same bonehead move as others and typing Unix into the sheet, that is nt clear in the instructions, I am not about to buy BBedit for $200 and there has to be a simple explanation for this. Can someone please explain the forat, and EP settings necessary to produce a working file from a Mac with Excel? I would really appreciate it. Quote Jeff Contributions I use: DynaMenus - Light Box - Best Sellers Content Box - Related Products 3.2 - UPS XML - Secure Admin Login - Vendor Locator - Graphical Borders. Link to comment Share on other sites More sharing options...
Jan Zonjee Posted March 25, 2007 Share Posted March 25, 2007 OK I am a PC guy - I know little about Mac. I can use EP with no issue from my windows system, my client is a Mac guy and cannot. He can't open my .csv in Excel, and we cannot import into EP no matter if it is .csv or tab delimited .txt I am pulling my hair out after hours of forums searching. I was doing the same bonehead move as others and typing Unix into the sheet, that is nt clear in the instructions, I am not about to buy BBedit for $200 and there has to be a simple explanation for this. Can someone please explain the forat, and EP settings necessary to produce a working file from a Mac with Excel? I know nothing about EP, but if your client is using Mac OSX there is no reason why he shouldn't be able to import a tab delimited file in Excel. I do that lots of times (in NeoOffice though, a OpenOffice variant for the Mac). If it is a line ending thing (a text file on Mac OSX normally has Unix line endings "\n" whereas Windows has "\r\n") use the free TextWrangler editor (from the same company that makes BBEdit) and open and save the file with the correct encoding and Windows line endings (look at the bottom of the TextWrangler window when you have opened the file for where to change it). Using a Mac makes things not suddenly not working. Quote Link to comment Share on other sites More sharing options...
cybercon Posted March 26, 2007 Author Share Posted March 26, 2007 I know nothing about EP, but if your client is using Mac OSX there is no reason why he shouldn't be able to import a tab delimited file in Excel. I do that lots of times (in NeoOffice though, a OpenOffice variant for the Mac). If it is a line ending thing (a text file on Mac OSX normally has Unix line endings "\n" whereas Windows has "\r\n") use the free TextWrangler editor (from the same company that makes BBEdit) and open and save the file with the correct encoding and Windows line endings (look at the bottom of the TextWrangler window when you have opened the file for where to change it). Using a Mac makes things not suddenly not working. LOL I was not accusing the MAC of making it not work, although the thought did cross my mind..... TO be honest I just cannot figure out why it won't work. I cannot find detailed instructions on it. I could not import a windows .csv into the mac, so I opened the .xls file and tried to bring into EP the tab delimited text file. - No go. So I am hping to get the answers for myself, and put them somewhere easy for others to find. I love Easy Populate, I just cannot figure out something that I am sure it is a very simple solution. Quote Jeff Contributions I use: DynaMenus - Light Box - Best Sellers Content Box - Related Products 3.2 - UPS XML - Secure Admin Login - Vendor Locator - Graphical Borders. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.