Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - max

Pages: [1] 2
Older versions / BUG: Importing / Exporting Contacts / Companies
« on: August 29, 2009, 08:38:15 PM »
Dear Gooroos,
I'm afraid that not so many people have ever needed the import / Export function, right? Because it has a few serious issues.

1) export creates a csv file but doesn't enclose the text in Quotes. So the moment i have a comma in a record, all goes wrong.

2) Contacts are not related to companies, so after an export you are left with one list of companies and one list of contacts.

3) when uploading the same problem: there is no way of defining what company a contact belongs to.

4) upon importing a contact, opengoo apparently decides if a record exists and gets updated based on the email address. Not a bad idea. But it does so as well if the imported contact has no email address. Bad Idea! This means that if you import multiple contacts without an email address, only the last one is kept.

Here's a suggestion:
* when exporting, do add all company records to each contact. Even if this creates redundancies, it's the only usable format whereever you want to import it later on.
* Include the primary key number so I can re-import that dump later on without any hassles or ambiguities
* have an import function that will allow me to upload both company data and personal information in one go.

I'd like to import all of our old addresses. But that's about a few thousand if them.

Older versions / SOLVED: No way to modify a table in a document
« on: August 29, 2009, 12:18:19 PM »
Please tell me that I just overlooked something.
Is there really no function to add columns or rows to a table in a document?

i mean, come on.

Now, I always need to drop into HTML view to do that. But hey, i'd rather copy & paste it into openOffice and Back, i'm afraid...!

Somebody forgot a button somewhere? Where's the properties panel when I need one?

When creating an object from a template, the description of the template should be shown above the form. As it is now, the description is only visible to the admin who looks at the template's property page.

o, and furthermore, the template description escapes all special characters with their HTML-entities like " etc.

Older versions / Cannot open a task in new window
« on: August 10, 2009, 03:11:41 PM »
to right-click and "open in new window" doesnt work on a task in the task list. It only opens the overview screen because the links on the task items aren't deep.

However the plug-in "open in new window" does provide a link also for tasks that can open in a new window properly.

So this is possibly just a matter of formatting the links differently?

Older versions / Tags of subtasks are ignored in sort-by-tag view
« on: August 07, 2009, 08:30:38 AM »
I have a task "A" tagged "1" and it has a subtask "B" tagged "1" and "2".
Now in Tasks view sorted by tags, task B only appears as a subtask to A under the tag list "1".
I believe that Task B should also appear on its own under the tag list "2", no?

Older versions / 1.5. final - search function doesn't find companies
« on: August 03, 2009, 11:41:45 AM »
I am logged in as administrator and I have the "can manage contacts" and "can edit companies" permissions.

When I search for a company with the general search function, then I can only find those companies which are assigned to a workspace that I have access to.

Search does not find a company that is not assigned to a workspace; however, it does find contacts which are not assigned to a workspace, so i assume this is not a wanted behaviour.?

Older versions / SOLVED: 1.5 final: RSS feeds broken
« on: August 03, 2009, 10:54:17 AM »
I can't say if it ever worked for me, as I've simultaneously moved to a new server and upgraded opengoo. But when I try one of the rss links, i get:
We are sorry, but OpenGoo is not currently able to execute your request. An Error Report has been sent to the administrator."

perhaps this from the log may help:

Session "default" started at 2009-08-03T13:52:50+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column 'Array' in 'where clause'' - SELECT * FROM `og_application_logs` WHERE `is_private` <= '1' AND `is_silent` <= '1' AND  `id` IN (SELECT `object_id` FROM `og_workspace_objects` WHERE `object_manager` = 'ApplicationLogs' AND `workspace_id` IN (Array)) ORDER BY `created_on` DESC LIMIT 0, 50
#2 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Unknown column 'Array' in 'where clause''' in /var/www/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php:386
    Stack trace:
    #0 /var/www/opengoo/environment/library/database/adapters/AbstractDBAdapter.class.php(304): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
    #1 /var/www/opengoo/environment/library/database/DB.class.php(209): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
    #2 /var/www/opengoo/environment/classes/dataaccess/DataManager.class.php(242): DB::executeAll('SELECT * FROM `...')
    #3 /var/www/opengoo/application/models/application_logs/base/BaseApplicationLogs.class.php(114): DataManager->find(Array)
    #4 /var/www/opengoo/environment/classes/dataaccess/DataManager.class.php(270): BaseApplicationLogs->find(Array)
    #5 /var/www/opengoo/application/models/application_logs/base/BaseApplicationLogs.class.php(131): DataManager->findAll(Array)
    #6 /var/www/opengoo/application/models/application_logs/base/BaseApplicationLogs.class.php(133): BaseApplicationLogs->findAll(Array)
    #7 /var/www/opengoo/application/models/application_logs/ApplicationLogs.class.php(213): BaseApplicationLogs::findAll(Array)
    #8 /var/www/opengoo/application/controllers/FeedController.class.php(54): ApplicationLogs::getOverallLogs(true, true, Array, 50)
    #9 /var/www/opengoo/environment/classes/controller/Controller.class.php(76): FeedController->recent_activities()
    #10 /var/www/opengoo/environment/classes/controller/PageController.class.php(62): Controller->execute('recent_activiti...')
    #11 /var/www/opengoo/environment/classes/Env.class.php(173): PageController->execute('recent_activiti...')
    #12 /var/www/opengoo/init.php(149): Env::executeAction('feed', 'recent_activiti...')
    #13 /var/www/opengoo/index.php(9): require('/var/www/opengo...')
    #14 {main}
Time since start: 0.137410163879 seconds

Older versions / SOLVED: 1.5 final: imap email syncs only 10 mails
« on: August 02, 2009, 05:32:46 PM »
This behaviour has appeared for me in earlier versions, too:

when I try to sync my inbox using imap, only 10 emails are retrieved per click on "check mail" (and it says so: "success: 10 emails retrieved") .
But unfortunately I have about 10000 mails in my inbox.

And it seems to retrieve them beginning with the oldest,

* So do I have to press "check mail" 1000 times now?

And the mails are all marked as "unread" (could that be the problem?) and mails that I delete from the server with thunderbird never disappear from OpenGoo.

* would you say that opengoo can handle such big inboxes? of course with attachments those would be several gigabytes, but that in my opinion is what iMAP should be for - syncing only the headers, then retrieving the mail as required. no?

* how could we tell openGoo to sync only the last X days, or only unread e-mail messages? This is obviously a must If it's only my second mail client, and I use it only occasionally.

I was kind of suprised to see the spreadsheet button in the "new object" pulldown. Hadn't noticed that in 1.4.2.

However, the spreadsheet can't be saved, and the error message isn't translated even:
"Error guardando datos"
Is this the reason why there is no "Spreadsheet" button in the "new" menu under documents…?

How To's / Reverse sorting order for tasks
« on: July 23, 2009, 01:41:03 PM »
When sorting a task list by date, e.g. "created on", then the oldest task is on top, the newest on the bottom.
On long lists this is a constant nuisance.

Could some fellow gooroo kindly point me to the line of code where I could add an "DESC" to the query?

General Discussion / Introducing: Google Wave
« on: June 11, 2009, 07:56:59 PM »
Dear Gooroos,

in case you haven't yet, you are required to take an hour and a half and watch this demo.

I don't mean to be exaggerating, but it kind of changed my way of thinking about online office suites.

Would appreciate your coments.

Feature requests / Events cannot be longer than 24 hrs.-
« on: April 28, 2009, 11:40:28 AM »
This is one total annoyance which keeps me from switching to opengoo in favor of thunderbird calendar:


uh, boy.

do I need to make 24 entries for my summer holidays manually??

I hope you can fix this before June 14th... that's when I need that entry.

1.3 final / Error when changing calendar display time range
« on: April 23, 2009, 12:23:07 PM »
When I click the "next/prev" buttons i frequently, but not always get this:

Error (InvalidControllerActionError)
Invalid controller action event::undefined()
Error params:
File:    /var/www/opengoo/environment/classes/controller/Controller.class.php
Line:    79
Controller:    event
Action:    undefined
#0 /var/www/opengoo/environment/classes/controller/PageController.class.php(62): Controller->execute('undefined')
#1 /var/www/opengoo/environment/classes/Env.class.php(133): PageController->execute('undefined')
#2 /var/www/opengoo/init.php(146): Env::executeAction('event', 'undefined')
#3 /var/www/opengoo/index.php(9): require('/var/www/opengo...')
#4 {main}
Autoglobal varibles:
$_GET:    Array (
  ['active_project'] => (string) '0'
  ['ajax'] => (string) 'true'
  ['c'] => (string) 'event'
  ['a'] => (string) 'undefined'
  ['day'] => (string) '23'
  ['month'] => (string) '4'
  ['year'] => (string) '2009'
  ['user_filter'] => (string) 'undefined'
  ['status_filter'] => (string) ' 0 1 3'
  ['view_type'] => (string) 'undefined'
  ['current'] => (string) 'calendar-panel'
  ['_dc'] => (string) '1240499978207'
$_COOKIE:    Array (
  ['__utma'] => (string) '203147149.1030790917904386600.1220614419.1239127006.1240321892.64'
  ['__utmz'] => (string) '203147149.1239127006.63.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)'
  ['id'] => (string) '6'
  ['token'] => (string) '0a724f7bc6227f2283f1e79d62fa20988e3232a4'
  ['PHPSESSID'] => (string) '34d0aff3df4dce7c80463edc348d37f7'
  ['remember'] => (string) '1'
$_SESSION:    Array (
  ['cal_version'] => true
  ['month'] => (string) '4'
  ['year'] => (string) '2009'
  ['day'] => (string) '23'
  ['cal_loginfailed'] => (int)0
  ['cal_user'] => (string) 'wolf'
  ['cal_userid'] => (int)6

I first noticed this bug after importing a few ical calendars. but I can't precisely reproduce the behaviour.

any ideas?

Applications / file info - freemind viewer plugin
« on: April 10, 2009, 09:43:47 PM »
I'm continuing this thread here because it went off-topic.

I'm trying to integrate a viewer for freemind-files into file_details_content.php.

it's a flash app that loads a .mm file, then renders it interactively.

but it only works if
EITHER i run the code outside of file_details_content.php - i.e. in its own static HTML file -
OR i run the code inside file_details_content.php, but with a fixed, static MM file.

heres the code which works in a static HTML file, but not within file_details_content.php:

<?php if (substr($file->getFileName(),-3)==".mm") {?>

<script type="text/javascript" src=""></script>
   <div id="flashcontent" >
       Flash plugin or Javascript are turned off.
       Activate both  and reload to view the mindmap
   <script type="text/javascript">
      // <![CDATA[
      // for allowing using http://.....? mode
      function getMap(map){
        var result=map;
        var loc=document.location+'';
        if(loc.indexOf(".mm")>0 && loc.indexOf("?")>0){
        return result;
      var fo = new FlashObject("", "visorFreeMind", "100%", "100%", 6, "#9999ff");
      fo.addParam("quality", "high");
      fo.addParam("bgcolor", "#a0a0f0");
      fo.addVariable("openUrl", "_blank");
      // ]]>
<?php }?>

The way it fails is: the flash applet starts, but apparently can't load the mm file, rendering "undefined" only.

what am i missing?

The wiki documentation for developers is, at the moment .... well ... a little substandard. What can we do? anything we can contribute?

what I'dbe particularlyinterested in

* any written matter on the architecture of OpenGoo?
* Is there any documentation on the database relationships etc. ?

If I remember correctly I read somewhere OGOO started as a student project - so there's probably at least a diploma thesis somewhere?

I'd volunteer to put something online if you drop me some details.

Pages: [1] 2