Real Estate Pipeline Leads not converting?

Discuss the spreadsheet application

Real Estate Pipeline Leads not converting?

Postby SourCreaming » Wed Apr 15, 2015 9:24 am

I recently switched over to OpenOffice suite from the other major guys (M$). I primarily am using Calc for my real estate pipeline leads that come in from Wooforms as a CSV.

When I used MS I didn't have problems opening the CSV's, however I feel like an idiot as when I open the file everything gets pushed into different columns. :crazy:

I know this is user error but this has led to complaints from my prospects as I'm not getting back to them quickly! Can someone help me understand how to open my real estate leads from CSV and have it formatted properly? Before I would just open the file and it would work fine.

Thanks in advance.
Last edited by floris v on Wed Apr 15, 2015 9:27 am, edited 1 time in total.
Reason: Removed icon used for threads with link to bug report
NeoOffice 2.2.3 with MacOS 10.4
SourCreaming
 
Posts: 2
Joined: Wed Apr 15, 2015 9:19 am

Re: Real Estate Pipeline Leads not converting?

Postby acknak » Wed Apr 15, 2015 1:33 pm

Generally, things work more smoothly using MS tools because everyone makes adjustments for that case. Using OO takes some extra time to understand what you're doing and make the adjustments yourself.

If you want specific suggestions for importing your data, we'll have to see a sample of the data. The best way to do that is to put some csv data into a zip archive and attach that here. If the csv file is large, cut it down to a few lines.

Alternatively, you can copy/paste a few lines into a message here. The forum may not preserve every character perfectly, but it's probably ok.

I usually recommend to stay away from opening csv files directly. Better to first start OO Calc, then use Insert > Sheet From File ... and choose your csv file. Then you can set the import parameters to match the csv file.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22613
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Real Estate Pipeline Leads not converting?

Postby MrProgrammer » Sun Apr 19, 2015 7:15 am

[Tutorial] Text to Columns

If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
OpenOffice 3.2.0 Build 9483 on Mac OS X 10.9.5.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 3073
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to Calc

Who is online

Users browsing this forum: acknak, Zizi64 and 48 guests