Activity for Frank Bergmann

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Antanas, I understand you just did a "vanilla installation" following the instructions and then you tried to manually install the intranet-reporting-indicators on top of that, is that correct? It seems that the data-model already included the data from this package, even though it is not "installed" ("installing" is just one entry in the database, the main part is loading the related tables and meta data). And because the entries for the indicators already exist, the DB reject duplicate new indicators...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Antanas, Delete all ~projop/log/error.log*, do a "killall -9 nsd" and check the error.log for "Error:" or "Warning:". Please post the result! :-) V5.1 V5.2 is just packaging a number of changes from the last months. You're a long-time user. Could you have a quick look at the installers (Windows and Linux VM based on Ubuntu server this time) and tell us if you see any issues? It should only take a few minutes each... Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Diego, Sorry, there is no way to "debug" your code without seeing your code. There is a feature in PO to convert hours logged into days logged. But the system will probably never be able to allow users to enter "days", because all the internal data structures work on hours. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, You didn't mention the version you are running... This message means that for some reason the following Library has not been loaded: ~/packages/intranet-reporting-indicators/tcl/intranet-reporting-indicators-procs.tcl Please check if there are permission issues or similar. You can work around the error simply disabling the portlet in Admin -> Portlets -> check for the page in which the error appears. We're working on PO V5.2 currently. Maybe you want to try that as soon as it comes out. I'll...

  • Frank Bergmann Frank Bergmann posted a comment on ticket #182

    Hi, we're working on a new version with the latest PG. I can't provide a date yet, but it shouldn't take too long. Please check again in 3 months.

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Diego, Did I get this correctly that you have manually edited the page? That's basically impossible for us to support, because we can't diagnose your errors... However, there is a parameter "TimesheetLastMonthClosingDay" that allows you to "close" the last month at the given day of the current month (not allow to log more hours to the past month). Have a look at this parameter and how it works, this might guide you. Bests Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Tarek, We are currently working on a OAuth2 based SSO solution. We've got SSO running with Google Cloud as provider. You won't need the REST API for this one. Bests Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi JD, We will probably go with Debian for the next version, so no, Rocky won't officially be "supported". Also, we found incompatibilities in RHEL 8. This not definitive yet, but that's the direction we are thinking about. At the moment the safest move is to buy support for RHEL 7. Best regards Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Tarek, You need to create a new package and "install" the new package using the OpenACS way. There is documentation about this, please search around in Google. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi! With "timesheet" you refer to ]po[, right? can decode I've recently implemented an OpenID server functionality, and there was no need for any JavaScript at all, this implementation was purely back-end. Just FYI... You obviously need to implement the decoding part yourself. I don't see any major issues. Both TCL and JavaScript should have all crypto libraries available, maybe double-check. decode ... before Don't do anything that breaks security... validate Please see the OpenID specs. There are...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Tarek, ]project-open[ does not yet support OpenID. The reason for this is that 99% of all customers are using ]po[ behind their corporate firewall, so that it's integrated with ActiveDirectory/LDAP. However, OpenID does not make sense in this usage scenario. The LDAP integration is available as part of the Enterprise Edition. I believe there is an OpenID integration available as part of OpenACS.org. Please have a look there. Creating an OpenID integration for ]po[ would not be difficult. However,...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Antanas, ]project-open[ continues just as before. It's our GitLab server that has some issues with DNS resolution from the "inside" (also VPN) vs. from the outside (you, the Internet) since an update. Meanwhile it's the best to take the source code from the official releases (V5.1.beta on SourceForge). I hope we'll get the GitLab stuff running soon... Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Antanas, We have hidden the Web GUI of the repo. However, the SSH access to GIT should be working. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, Ramiro, I can't see your message here. Please search the source code for the strings above in ~/packages/ Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, Ramiro, I can't see your message here. Please search the source code for the strings above in ~/packages/ Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Chris, Please use the code from the V5.1 virtual appliance available here on SF. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Please search for the PL/SQL procedure im_exchange_rate_fill_holes in the intranet-exchange-rates package. Best option is: ./intranet-exchange-rate/sql/postgresql/upgrade/upgrade-5.0.2.3.0-5.0.2.3.1.sql You will see there is an end_date set as 2018 + 7 * 365. Just extend that to 10 * 365 and load the code into PostgreSQL. That should do the job. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Ciao ADR, Congrats for getting the functionality to work. what if we need to have more than one query inside list_sql? These are the limits of the current engine. It's based on a per-page rendering. So the limit of one list per slide is hard-coded into the structure of the engine. You will have to tell Valentina that it won't be possible the way she has designed the slide :-) 2. The alternative would be to extend the engine. However, that's not that easy because we initially took the decision to...

  • Frank Bergmann Frank Bergmann posted a comment on ticket #72

    Hi Antanas, The truth is that public holidays are not yet included in the calculation of SLA "solution time". Public holidays are available (you can define holidays for groups of people, for example for all customers or per office). You would have to modify the algorithm calculating the solution time to take these into account. This is not on our prio-list, so we will not likely implement this until a paying customer asks us for it... Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Dear Helga, In ]po[ V4.1 or higher please use the Projects -> Export Projects to CSV link. You will see this link leads to the intranet-dw-light package. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on ticket #1004

    Please specify the version of ]po[ you are running. Bests Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, There is currently no automatic or semiautomatic way to add expenses to an invoice. Edit the existing invoice, and three new empty lines will appear that allow you to add the sum of the expenses manually. Did you see the functionality to create expense bundles"? These are supposed to represent a journey or similar, and they are by default controlled by a workflow for approval by HR department. Please search Google for "expense bundle site:project-open.com" Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    I understand the error message basically just says it can't connect. Please undo the acs-mail-lite settings and use the local Postfix for forwarding. Please use the CentOS VMware appliance for production use and not the Windows version. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    http://www.project-open.com/en/configure-external-smtp-server Best regards Frank

  • Frank Bergmann Frank Bergmann posted a comment on ticket #71

    Hi! It seems you have upgraded to ]po[ V5.1, at least to some part. Please get the V5.1 VMware (here in the "Files" section) and copy the contents of /web/projop/www/SYSTEM to your system. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on ticket #70

    Hi! Sorry, I didn't 100% understand the issue then. Yes, you can update, and you can use the "force" checkbox to do so. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on ticket #70

    Hi Antanas, In the Home page, the system has an "System Updates" portlet. Whenver there is a message to run an upgrade script, please do so. Please perform a backup before, then you are ultra-safe. rule of thumb for upgrading This is not "upgrading". Upgrading is when you update the ]po[ source code. For decisions on upgrading, please check the "News" section on SourceForge or check the ]project-open[ group on LinkedIn. We will soon announce the upgrade to ]po[ V5.1. Bests Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Roopesh, trying to make Did you actually start to code, or do you just want to say that you need such a column? You can take the "Resources" column as an example: - We've written a custom field with the code to edit the list of resources in ~/packages/sencha-core/www/view/field/POTaskAssignment.js. - A column configuration in ~/packages/sencha-core/www/view/gantt/GanttTreePanel.adp in line 282 contains the code to display this field - The field gets the data from the field "assignees" of the model...

  • Frank Bergmann Frank Bergmann posted a comment on ticket #69

    Hi Atanas, allow I'm not sure why some ticket type would not be "allowed". You need to be a bit more specific. But: This will very likely require customization. You you'll either have to do this yourself or it will be relatively expensive... Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Roopesh, Please check ~/packages/sencha-core/www/view/gantt/GanttTreePanel.adp. You will see a column configuration starting in line 148. There is already a column called "Sort Order". Please set both: hidden: false and debug: false (watch out, this is in the last line of the column!) That way, "Sort Order" should appear and represent what you need. Please go to the Sencha ExtJS Web Page and read the documentation for V4.2.1 in case of doubt on the Sencha stuff. We won't be able to provide you...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi JAC, Sorry, this is an uncommon use-case. There is currently no UI for assigning a user to several projects. Your options: You could write such a portlet yourself. It is not very difficult. Just list the available projects, add check-boxes and write a second page uses im_biz_object_add_role $uid $object_id $role_id. Please see the /intranet-core/www/member-add-2.tcl for an example. I believe somebody from our time would need 2-4 hours for it. Checkout the source of im_biz_object_add_role and create...

  • Frank Bergmann Frank Bergmann posted a comment on ticket #68

    Hi Antanas, The sad truth is: Check the source code of the page sending out the email There you will find the package-key and the localization-key * Then go to /acs-lang/admin/ to modify the L10n. Cheers Frank

  • Frank Bergmann Frank Bergmann created a blog post

    ]project-open[ Featured in OpenSource.com "Serious" Project Management Tools

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Lakshminarasimhan, shell No. Instead, the entire system has been designed to run in the open Internet from scratch (>20 years ago). I have seen at least 100 companies with their ]po[ system open. One of them is us - www.project-open.net is just a standard ]po[ system with a large Wiki... One very large German company (wordwide in the top 10 of their sector) runs a large server openly in the Internet. However, you effectively need to close a support contract with us in order to get security updates...

  • Frank Bergmann Frank Bergmann posted a comment on ticket #67

    Hi, This is an old version of ]project-open[. The problem is the Indian IST time zone which is GMT+5.5, which is not accepted by PostgreSQL that way. The latest ]po[ V5.1 includes a fix for this issue. Please upgrade. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Diego, methods I should use The REST API is tied to the object-oriented design of the database schema. So there are two options for you: Modify your custom table in order to "make" it a sub-type of acs_object or Just write a custom REST API end-point using TCL. You can look at the design of a simple object for example in the intranet-risks package. You would have to add similar metadata to your table. (And you would have to add a primary key linked to acs_objects). For an example of a custom data-source...

  • Frank Bergmann Frank Bergmann posted a comment on ticket #998

    Hi LC, Confirmed and fixed. https://gitlab.project-open.net/project-open/intranet-core/commit/50ed4394888aa88cd521d8e18d8eecb99e8697c7 You should be able to see the diff without login, can you please confirm? This is the first time we use our relatively new GitLab system publicly... Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on ticket #999

    Please specify the version of ]project-open[ where this happens. Best regards Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi SIJO, Please use a local SMTP server. We had issues with the direct configuration which we couldn't easily resolve. Normally, ]po[ is used on Linux, and there a Postfix is part of a standard installation. There are a lot of issues these days with email, and protocols constantly changing due to the abuse by spammers. => Please install a local SMTP server, it's very easy. You can also use Postfix on CygWin. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi SiJo, It seems PO tried to send out an email, but your configuration isn't work (trying to use SMTP on a mail server with TLS...). Please see http://www.project-open.com/en/configure-external-smtp-server There are several free SMTP servers for windows. Install one of those to have a local SMPT server. Then continue with the ]po[ standard configuration. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, As part of the release process for the next version we have created installation instructions for version 5.1 on CentOS 8: http://www.project-open.net/en/install-rhel-8 This document will be the base for the final release some time in spring 2021. For comments and issues please post below. Bests Frank

  • Frank Bergmann Frank Bergmann posted a comment on ticket #998

    Hi, You mean /intranet/users/index, right? Please observe the double arrow ">>" in the top of the page, indicating pagination and the availability of a second page. I'll contact Mr. Lenoir, thank a lot! Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on ticket #997

    Hi! There are apparently objects of type "im_baseline" in the dump that shouldn't be there. So let's try to delete them, they are not essential. Actually, you can delete them completely, together with the im_audits entries. update im_audits set audit_baseline_id = null; update acs_objects set last_audit_id = null; update im_audits set audit_last_id = null; delete from im_baselines; delete from im_audits; Optional: delete from acs_objects where object_type = 'im_baseline'; In the case that you get...

  • Frank Bergmann Frank Bergmann posted a comment on ticket #997

    Hi Antanas, Thanks for posting. You used the wrong PostgreSQL database dump, apparently. Which version do you use and how did you get the dump? Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on ticket #66

    Hi Antanas, There are two parameters controlling redirection. Check: select * from apm_parameter_values where attr_value like '%yourdomain%'; Then check for the apm_parameter with the respective parameter_id. Maybe also check ~/etc/config.tcl for the "hostname" parameter and set to the right URL. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Lux, Do you have a copy of the "bad" database dump? Could you try to compare the "apm_parameter_values" table in order to check which parameter (I understand it was a parameter...) caused the issue? Do you know that you an actually run a "diff" on database dumps? You have to unzip the file, but then it should work pretty well on the SQL level. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi! Maybe we do an exchange? We fix your Gantt editor and you provide us with a number of hours/days of work on other areas? How much do you offer? We'd do the debugging together, so you'd learn :-) Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, The error.log is perfectly OK. You have to check the URLs served, and what the PO server returns. Use Chrome developer tools and post both request and result headers and contents here. reinstall Better do a new install on a different machine, copy the PostgreSQL dump from your current machine and restore there (search Google for "project-open backup restore"). However, please consider what exactly you changed. I believe there is a good chance that the change was "outside" of ]po[ on the Linux...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi! replace You need to replace all folders, right? And then you need to go to APM and make sure that all packages have been updated.. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Iuri, Your system seems to have multiple issues: - One report seems to be missing (one of your error messages) - Why is there a conflict between Bootstrap and jQuery?? Maybe you performed a partial upgrade? Or installed your specific versions of JavaScript libraries? I believe the day.getTime() error message is the reason why your Gantt display is not shown. You have to follow back from this error messages where the "now" is coming from, and why this is wrong. At the moment we're preparing V5.1...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi! First of all: Which version do you use? For JavaScript errors you need to check the Developer Tools in Chrome/Chromium. There seem to be issues displaying even the date bar on the top of the right-hand display area. Then try the middle "zoom" button (between the + and - zoom buttons with the lense) to center. How did you "add" Gantt charts? They are enabled by default... Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, 4.99.8 should also support TLS. However, putting a reverse proxy in front has somehow become tradition. In production environments it's very helpful, because you can also put DEV and TEST on the same server... Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, It's running with 4.99.8. I didn't really try 4.99.19. In the past, there were only small changes in NaviServer, so I think there is a good chance it will just work fine. Why would you want to upgrade? If you should find an issue, please post on OpenACS.org, specifying your NaviServer, OpenACS and PO versions. I promise to have a look at it. Also, the community there is quite active, so together we should be able to get any issue fixed. However, it would be great if you would be able to track...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, The error.log is perfectly OK. You have to check the URLs served, and what the PO server returns. Use Chrome developer tools and post both request and result headers and contents here. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Lakshminarasimhan, Can you please look at the /web/projop/log/error.log and check for "error:" or "warning:" strings? You should be able to identify the "loop" there in the error.log. Please post such a loop here, so that we can have a look. Also: Please enable in Chrome: Menu -> More Tools -> Developer Tools and look at the requests. Can you identify any error conditions? Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on ticket #996

    Hi, Sorry, it's basically impossible to do anything with this error description. You are running PO on Windows, right? Which version? I don't understand if it's NaviServer that doesn't respond or other parts of your system. Did you check the error.log file? Try deleting the file after stopping the ]po[ service. Then restart the service and search for warning, error or fatal messages. Please post these messages here, together with their context. Please contact info@project-open.com if you need personalized...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Dominique, client's experience Maybe you can tell your customer that we'd be happy to provide some hours of help in exchange for a success story. That could be particularly interesting towards the end of an implementation project, when during or after the go-live there are issues. Gantt chart Right, that's not localized at all at the moment. Our plan is to include this in V5.2, but you are right, maybe we should pioritize this. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Dominique, In V5.1 (we are working on it...) we have fixed the issue by introducing a subject field together with the message. The value of the subject is a localizable key now. V5.1 will be using GIT instead of CVS. You can get the future code the following way: In a separate directory get the intranet-core package from V5.1: git clone https://gitlab.project-open.net/project-open/intranet-core From this folder please copy the following files into your production system: modified: user-add-2.adp...

  • Frank Bergmann Frank Bergmann posted a comment on ticket #66

    Hi, Please search for "www1" in apm_parameter_values via SQL and replace with "sub.domain.com"... Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi! I did a search for the string: find . -type f -exec grep -il lt_first_names_last_name_1 {} \; That gave me ./intranet-core/www/users/user-add-2.adp From this page, a click will get you to user-add-3.tcl. Checkout the source code, the subject of the ns_sendmail is hard-coded. Just change the string to French for the moment. I'll issue a request to modify this hard-coded behavior in the OpenACS product, but this will take some time... Would you be OK to write up a short "success story" about how...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, There are tens of parts in the system sending out email notifications. Can you please provide us with the URL where the email is sent out? Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on ticket #66

    Hi Antanas, after clicking The server probably does a redirect to the original port. Just make sure port 80 is also forwarded to the NaviServer... Put Chrome in debugging mode (developer tools), and you'll see more. Search in the database in the table apm_parameter_values for a value corresponding to your old server name. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on ticket #995

    weekends are used to calculate the % or duration when using Fixed Units or Fixed Work PO assumes that doing work on a weekend is an exception. (This is unlike TaskJuggler, where you can explicitly say that there are weekend shifts or similar...) You don't "damage" anything if you allow users to log hours for the weekend. The probably won't ever do this... But I believe I now see what you want to say: On the 2nd screenshot in the weekly view you just want to start the columns with Monday, is that...

  • Frank Bergmann Frank Bergmann posted a comment on ticket #995

    Hi! scheduling needs are more on the order of the week That sounds great. since the issue I didn't really understand in which page your issue appears. Could you please provide a URL and/or a screen shot? What is the wrong actual result, and what should be the correct one? I would need this information in order to point you to the right source code. sponsor No problem. We provide free 90min "Guided Tour" online meetings to all potential customers. Just contact me in a few days or weeks once you've...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Bernhard, my personal favourite source to learn about specific modules is the database "creation" script. For example: ~/packages/intranet-riskmanagement/sql/postgresql/intranet-riskmanagement-create.sql The "create scripts" provide the data-structure and a good amount of coments explaining design decisions etc. The TCL GUI is just "a thin layer" to format the database contents in HTML... The REST interface is basically a 1-to-1 translation of the create scripts for the Web. It's exactly the same...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Bernard, Maybe it's good to have some discussion on-line? I belive we could clarify a lot of stuff in an hour, if you're interested. Just send me an email to info@project-open.com. Tuesday and Wednesday should be good for me. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Bernard, permissions are stored The ]po[ permission system has several layers: OpenACS "privileges" control "global" permissions (for all objects of a certain type). For example the privilege "view_projects_all" may be granted to the group "Senior Managers", so these guys will be able to see all projects. This is stored in acs_permissions. Watch out, there are some denormalized tables for faster access that are maintained by triggers. ]po[ "Business Objects" all support a concept of "members",...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi! It should not break anything. However, I can not understand how you want to have to companies in the system with identical names. There is a case when a customer acts as provider and customer at the same time. But then you can introduce a new category "cust + provider" that inherits from both. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi! Just go to our demo server, login as Ben Bigboss and then enter this URL: http://demo.project-open.net/intranet-rest/im_invoice/50453?format=json You will see that VAT ist just one field of an invoice. You can update it just like any other field. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, Your actions are absolutely reasonable and correct. Please let us know if you were finally successful. If not, please include the JSON and the full command lines in your next post so that we an reproduce the issue here and delete any remaining issues. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, Please replace current_user_id to rest_user_id. It seems this "path" through the code has not been tested before, sorry. Can you provide us the POST command, so we can make sure the code works? (In case of yet another issue?) Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Nicolaij, im_uom_units Please replace "im_uom_units" with "im_uom_unit". Then restart the server. The bug should disappear. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Yogesh, I don't fully understand your question. However, you have full control of the workflows now. Please see the example workflows included in ]po[ for best practices. In these workflows we change the status of the underlying business object once the WF has been started. Please see the examples in detail. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, Please see the workflow tutorial: http://www.project-open.com/en/tutorial-workflow The fire/enable actions are explained here: http://www.project-open.com/en/workflow-developer-guide Please also read the following document in order to get the connection how Petri-Nets are used to represent workflow structures: http://www.project-open.net/en/download/file/application-of-petri-nets-to-workflow-management-van-der-aalst Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, No, the intranet-timesheet2-interval package requires the intranet-timesheet2 package. It 's an add-on. It's basically a different way to enter hours. But at the end (and in order to maintain compatibility with all the other parts of ]po[ that use timesheet information), the entered hours are stored in aggregated form into the same im_hours table. The portlet for logging hours should appear on the project's page or the home page, I don't remember... Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, Not sure, it's probably a naming thing. The functionality is important and actively used, obvously. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Ok, got these two changes. TSearch2 stuff is harmless. However, we'd have to rewrite cost center permissions. => I'd recommend to stick to OpenACS 5.9.1 instead of 5.10. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Malte, create an oacs-5-10 branch Hopefully we'll have GIT in place soon... Providing you access to just one branch on our CVS would be difficult and time consuming. We would also have to go through changes manually, so I believe manually managing diffs would not a big overhead... But I don't understand how OpenACS breaks "]po[ habits". ]po[ uses both acs_privilege_decendant map and acs_object_context index. What are the changes you'd have to make in intranet-core and intranet-cost? Do you mean...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi JAC, I wanted to know if it possible [...] Yes, this is exactly what the packages does. Sorry, this is open-source free support not a personalized contract. You will need to be able to read the documentation and to perform a "cvs checkout". Otherwise please ask for help within your organization from somebody familiar with system administration and Linux. Bests Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    cvs checkout intranet-timesheet2-interval As written above, please search for "cvs checkout" on www.project-open.com for more information. Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, time zone I understand you refer to "timesheet interval logging". "Time zone" would be New York vs. Berlin vs. Delhi :-) Yes, there is a package intranet-timesheet2-interval that implements that. Just search on www.project-open.com for "cvs checkout" for "downloading" the pacakge and install via /acs-admin/apm/ The package used to work at one customer, but it's not officially part of the product, so there is no guarantees related to it. Test first on a development server. If this should work...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Perfect, sub-types make perfect sense if you try to limit the number of data returned by the REST interface. However, it also means that you need specific "models" on the JavaScript side for every sub-type. I would start off avoiding this: Start optimizing only when things get slow. So far there is no complaint about that side of the REST interface as far as I know. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi! subtypes You can simulate this with the "sql=..." parameter. For example you could say: <server>/intranet-rest/projects/?sql=project_type_id = 100</server> Only return columns which are explicitely specified in the request I understand. However, do you really think this causes a big difference? I guess you want to save bandwidth and processing time? Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, Watch out! ]po[ REST interface actually returns the database_columns available, not the meta-data from DynFields. DynFields are used for de-normalization (get the company_name for a company_id) and similar and for getting all tables for a specific object type, but the list of columns is just what's in the database. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi! I would be very interested to see certain areas of your code: DynView Datatables Notifications Messaging ]po[ 4.x only Well, I don't think there there should be a big problem. The other question is if the code is available publicly, and whether you would be able to form a "product" from it that would relplace the existing ]po[ translation solution (which hasn't changed much in the last 5 years...). If you have a "product" that is downloadable/installable for everybody (possible including "enterprise"...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Cool, congrats! I would be very interested in a write-up of your experience. Or maybe just listen to your experience during a beer or two later this year :-) Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, There are currently no plan to implement OpenAPI, you are right... You know that the bulk of intranet-rest is based on DynFields and the columns of the database? Can't you automatically generate the document? The only on-automatic part are constructors, because we have to manually write the PlPg/SQL constructors... Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi! 1 - major version - incompatible (requires new Linux/database) 2 - minor version - normal releases with PR announcement etc. 3 - intermediate release 4 - we could skip this one 5 - increased by 1 for every upgrade script I'd prefer that you mark forked packages by something like intranet-core-cognovis or similar... Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Hamma, There were issues in a previous version of ]po[ with the resource management, that's why it's so important to understand which version you are using. This is a very difficult bug, because it is probably related to some data in your system which isn't entered 100% correctly. Probably some field is "null" while the system expects a value there. => One path according to the error message: "can't read object_availability_hash(526)". I've checked 526 is the "Administration" cost center. Please...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Hamna, Sorry, the error message is not enough. Which version do you run? How did you create this situation? (steps to reproduce) * Can you reproduce this on the demo.project-open.com server? Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, Some time ago we committed on Sencha ExtJS as the main JS library for ]po[. Today, particularly the Gantt Editor is writting in ExtJS, so we won't be able to get rid of this in years. So my take on this is that we should continue with ExtJS in order to avoid JS hell, even if ExtJS should not have the most funky GUI anymore. Salo has started to write a stand-alone ]po[ client using Electron and ExtJS. This client appears as a tray icon in Windows, Linux and Mac and allows to sync files (under...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Malte, How is your docker different from Salo's Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi D L, require something special We haven't had any customer so far who would need DynFields with expenses. Logging expenses with "new-multiple" is definitely not supported. But it should be easy to customize that screen. Logging an individual expense should work, but it doesn't in V5.0.3. We just fixed the issue, there was a typo. In line 250 of file /packages/intranet-expenses/www/new.tcl please replace the line: object_subtype_id $cost_type_id \ with the following: object_subtype_id $expense_type_id...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Luca, As answered in another thread: This questionair is so long that I stopped in the middle. I very much like the idea behind your research, but I strongly suggest to create a new questionaire with half the questions of less. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Issam, We can read sufficient French in order to understand the budget structure, please send the document to frank.bergmann@project-open.com. Please contact us in 3 to 6 months from now to check if there was progress on our side, OK? We can have a GoToMeeting then and discuss if the functionality meets all of your requirements. Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Issam, First of all: Great answers from Iuri, thanks! Here are some pieces of information Iuri couldn't have: We are currently working on the next version of budgeting/planning for ]po[. Here is how things should work out in the future (]po[ V5.1 or 5.2): There is a new package called "intranet-budget". This package maintains a hierarchical budget plan (top-down), per project. Later versions may also be able to manage budgets per department or for other budiness objects (customer, ...) We are...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi Sceptic, NOT able But that's just a minor issue you've got with Perl! Just invest 1 hour in Perl hashes and arrays, and you'll be over it. There is this funny thing with references vs. data, but eventually you'll manage! Cheers Frank

  • Frank Bergmann Frank Bergmann posted a comment on a blog post

    Hi, We have developed a patch for the most serious SQL injection vulnerability found in the report. Please contact info@project-open.com for details. We would consider the other (non-persistent XSS) vulnerability as not that critical, because: 1. Quite some knowledge is required to create a suitable URLs, 2. most ]po[ systems run locally and 3. an attacker would have to make the victim click on a forged link. In order to consistently fix the XSS issues, we would have to update the OpenACS core version...

  • Frank Bergmann Frank Bergmann posted a comment on discussion ]po[ Open Discussion

    Hi, Sorry, I won't be able to debug your Perl code. Just show the actual JSON documents being sent back-and-forth. You will need them for debugging anyway... Frank

  • Frank Bergmann Frank Bergmann created a blog post

    Critical: ]project-open[ Security Advisory: SQL Injection Vulnerability for V3.3 - V5.0.3

1 >
MongoDB Logo MongoDB