Jump to content

maba

Members
  • Posts

    167
  • Joined

  • Last visited

Posts posted by maba

  1. 4 hours ago, bernhard said:

    This sound like you don't know them well enough ? If using RockFinder I'd definitely go with RF2 and not RF1.

    "RockFinder2 is the successor to RockFinder v1", so.. I'll use RockFinder ?
    I follow your works after saw this awesome Custom Office Management CRM/Controlling Software.

    4 hours ago, bernhard said:

    8 lines of code when using RockTabulator. Maybe 10 more for applying the diff (if you have a library for that). I bet you'll save hours of work using RockTabulator, but as I don't fully understand your scenario that's just a guess...

    Diff has to be done on previous/last imports for a User or Asset. I won't compare the xlsx/csv files.
    E.g.: take all the pages about asset ABC1234 from the import of 02 Sep., compare them with ABC1234 pages of today's import and highlight which items changes (pages and their fields).
    I don't think this is possible with RockTabulator. Is it possible?

    I'll try to be more clear with an example (that I still have to set up ?).

    Thanks for your time and help guys!

  2. Nope. No other needs beyond this costs analyses.
    Some fields are already present in my PW installation as page - user (user pages), asset (clients and maybe servers page) - other as single like ASNA and CC (the same for all the rows).

    Basically, I thought to analyse this dataset with ListerPro for quick checks (mainly on the latest import), create some charts and share them with my team and other with my boss. The need of a custom dashboard is possible but before I have to set the notification system for every import (and the "diff" features. I have no control of what HQ charges to the daughter companies.
    So, at the first, no user interaction in the backend.

    21 hours ago, dragan said:

    I don't know what this means.

    Not so related. It is just to say that I can't use LDAP/SAML for Active Directories authentication.

    Yes, I know all the @bernhard's great modules but I don't know if I can create the "diff" features using RockGrid. I'll take a closer look, also for the import requests.

  3. Hello,
    I need to import regularly - every 15 or 30 days - a big .xslx file into my PW installation.
    This file now has 14 columns, 5.000 rows and grows every month.

    I'll need to group, order and work with these data to:

    • analyse User monthly costs
    • analyse User costs per Asset
    • ...

    User (real AD account) has to match with a PW user - I can't join to the domain - but as you can see I have some services users (start with sca_*) or no user at all. Those rows have to be assigned to a specific user, e.g. account100.

    And:

    • I would like to be able to have a kind of diff function to compare User assets between this and last month (and so on)
    • other request is to have a notification when something change for a User between actual and latest import

    First request: which is the best solution to store those data in your opinion? Page, Table, Repeater Matrix, ...?
    Those are very repetitive data and I think a page reference is better than to import all the data every time but I have to understand how to manage those "dynamic" groups of software (AccType Det), hardware (Asset), ... For example Price will be imported and not stored with the description because it could be change in the future and I'll not have any control on it.

    Thanks!

    User,OE,productNmr,AccType1,AccType Det,Count,Price (€),Sum,ASNA,CC,AccType Info,Asset,AccGroup,,,,,,,,,,,,,
    Spoiler
    
    ,IT,000410,SAP Service,Licenses,0,0,0,012345678,ABC1234,-,,-,,,,,,,,,,,,,
    account1,IT,000016,Client - Computer - Hardware,O Notebook ´Standard´,1,0,0,012345678,ABC1234,-,AAA3913,-,,,,,,,,,,,,,
    account1,IT,000016,Client - Computer - Hardware,Notebook ´Standard  (1100-1300)´,1,101,101,012345678,ABC1234,-,AAA3913,-,,,,,,,,,,,,,
    account1,IT,000015,OS Windows Client,OS4 - Standard Group (Installation w Office),1,10.6,10.6,012345678,ABC1234,-,AAA3913,OS,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),Adobe Flash Player ActiveX 27.0.0.183 (installation),1,0,0,012345678,ABC1234,-,AAA3913,Software: viewer and player,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),Adobe Shockwave Player (freeware license),1,0,0,012345678,ABC1234,-,AAA3913,Software: viewer and player,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),CDBurner XP 4.5.6.5844 (installation),1,0,0,012345678,ABC1234,-,AAA3913,Software: tools,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),Copy Path to Clipboard (installation),1,0,0,012345678,ABC1234,-,AAA3913,Software: tools,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),OS/M Standard 4.2 - 64bit (installation),1,0,0,012345678,ABC1234,-,AAA3913,OS,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),Firefox Windows x.x (installation),1,0,0,012345678,ABC1234,-,AAA3913,Software: other,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),Google Chrome (freeware license),1,0,0,012345678,ABC1234,-,AAA3913,Software: other,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),Google Chrome x.x (installation),1,0,0,012345678,ABC1234,-,AAA3913,Software: other,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),Java (freeware license),1,0,0,012345678,ABC1234,-,AAA3913,Software: CASE,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),Java 8u121 - 32/64 (installation),1,0,0,012345678,ABC1234,-,AAA3913,Software: other,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),Microsoft Office Professional Plus (machine license),1,25.66,25.66,012345678,ABC1234,-,AAA3913,Microsoft-products,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),Microsoft Office Professional Plus 2013 SP1 (installation),1,0,0,012345678,ABC1234,-,AAA3913,Microsoft-products,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),Notepad++ (freeware license),1,0,0,012345678,ABC1234,-,AAA3913,Software: tools,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),Notepad++ x.x (installation),1,0,0,012345678,ABC1234,-,AAA3913,Software: tools,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),PDF-XChange Editor (freeware license),1,0,0,012345678,ABC1234,-,AAA3913,Software: converter,,,,,,,,,,,,,
    account1,IT,000023,Services & Software - CIU (Software),PDF-XChange Editor 5.5 (installation),1,0,0,012345678,ABC1234,-,AAA3913,Software: converter,,,,,,,,,,,,,
    account1,IT,000014,Software - Dummy - ABCC-EU\CI,OS/M for any (machine license),1,0,0,012345678,ABC1234,-,AAA3913,OS,,,,,,,,,,,,,
    account1,IT,000023,Software - OS Windows - Client - ABCC-EU\CI,OS/M for ABCC ITA (machine license),1,0,0,012345678,ABC1234,-,AAA3913,OS,,,,,,,,,,,,,
    account2,IT,000016,Client - Computer - Hardware,O Notebook ´Standard´,1,0,0,012345678,ABC1234,-,AAA2999,-,,,,,,,,,,,,,
    account2,IT,000016,Client - Computer - Hardware,Notebook ´Standard  (1100-1300)´,1,101,101,012345678,ABC1234,-,AAA2999,-,,,,,,,,,,,,,
    account2,IT,000015,OS Windows Client,OS4 - Standard Group (Installation w Office),1,10.6,10.6,012345678,ABC1234,,AAA2999,OS,,,,,,,,,,,,,
    account2,IT,000010,Services & Software - CIC (Software I...),MATLAB Compiler Runtime (machine license),1,0,0,012345678,ABC1234,-,AAA2999,MathWorks-products,,,,,,,,,,,,,
    account2,IT,000010,Services & Software - CIC (Software I...),MATLAB Compiler Runtime 2015b - 9.0 - 32bit (installation),1,0,0,012345678,ABC1234,-,AAA2999,MathWorks-products,,,,,,,,,,,,,
    account100,IT,000023,Services & Software - CIU (Software),Notepad++ (freeware license),1,0,0,012345678,ABC1234,-,AAA1825,Software: tools,,,,,,,,,,,,,
    account100,IT,000023,Services & Software - CIU (Software),Notepad++ 7.3.3 (installation),1,0,0,012345678,ABC1234,-,AAA1825,Software: tools,,,,,,,,,,,,,
    account100,IT,000023,Services & Software - CIU (Software),PDF-XChange Editor (freeware license),1,0,0,012345678,ABC1234,-,AAA1825,Software: converter,,,,,,,,,,,,,
    account100,IT,000023,Services & Software - CIU (Software),PDF-XChange Editor 5.5 (installation),1,0,0,012345678,ABC1234,-,AAA1825,Software: converter,,,,,,,,,,,,,
    account100,IT,000014,Software - Dummy - ABCC-EU\CI,OS/M for any (machine license),1,0,0,012345678,ABC1234,-,AAA1825,OS,,,,,,,,,,,,,
    account100,IT,000023,Software - OS Windows - Client - ABCC-EU\CI,OS/M for ABCC ITA (machine license),1,0,0,012345678,ABC1234,-,AAA1825,OS,,,,,,,,,,,,,
    account100,IT,000016,Client - Computer - Hardware,Notebook ´Application E02200M48 (2000-2400)´,1,49.5,49.5,012345678,ABC1234,-,AAA2963,-,,,,,,,,,,,,,
    account100,IT,000015,OS Windows Client,OS4 - Standard Group (Installation w Office),1,10.6,10.6,012345678,ABC1234,-,AAA2963,OS,,,,,,,,,,,,,
    account100,IT,000014,Software - Dummy - ABCC-EU\CI,OS/M for any (machine license),1,0,0,012345678,ABC1234,-,AAA2963,OS,,,,,,,,,,,,,
    account100,IT,000023,Software - OS Windows - Client - ABCC-EU\CI,OS/M for ABCC Europe (machine license),1,0,0,012345678,ABC1234,-,AAA2963,OS,,,,,,,,,,,,,
    account100,IT,000016,Client - Computer - Hardware,O Notebook ´Standard´,1,0,0,012345678,ABC1234,-,AAA3508,-,,,,,,,,,,,,,
    account100,IT,000016,Client - Computer - Hardware,Notebook ´Standard  (1100-1300)´,1,101,101,012345678,ABC1234,-,AAA3508,-,,,,,,,,,,,,,
    sca_check-mk,IT,000010,Server - Hardware,Server - virtual ESX,1,42.96,42.96,012345678,ABC1234,-,BBB137,-,,,,,,,,,,,,,
    sca_check-mk,IT,000014,Software - Dummy - ABCC-EU\CI,OS/M for any (machine license),1,0,0,012345678,ABC1234,-,BBB137,OS,,,,,,,,,,,,,
    sca_other-ab,IT,000010,Software - OS Linux - ABCC-EU\CI,OS/X - RHEL Linux Server virtual (machine license),1,10.50,10.50,012345678,ABC1234,-,BBB137,OS,,,,,,,,,,,,,

     

  4. I've this problem with that site: cookie isn't created.

    All other cookie are created but not this.

    Production site (linked) now use ProCache so it is right.

    But dev site with ProCache disabled has the same problem. 

    It works for a while.

  5. Hi,

    with the latest dev I notice some problems to login in the admin area.

    domain.com/cp/ (example) thrown in 404 error page.

    If a user is logged in and he is in the admin area he can works without problems.

    When he logged out.. 404.

    Last time I have a superuser logged in and with a ProCache clean(ing) I can log in with other user.

    I haven't superuser logged in in this moment and a manually rm on ProCache*/* does not work.

    I have ProCache for entire site but home template use core cache system.

    How I can debug this?

    Thanks

  6. That's what you'd want the hook for. Alternatively you could add page-publish permission for that role just to the "language" template from the Access tab of the template editor (see "Additional edit permissions and overrides"). But since you aren't otherwise managing access for the language template, I would suggest just using the hook function as the best solution. 

    Ok, I have some problems to understand that because in my test it doesn't work but I have understand the logic.

  7. I agree, I have committed a slight modification that enable this (now on dev). 

    Perfect, it works.

    No hook required (read below).

    These changes are minor enough and restricted to one permission (lang-edit) that it doesn't affect anything else, so it's fine. 

    :) 

    I suppose we could override that for Language pages if the user has lang-edit permission, but not sure we should, will have to think about that one more. However, if you want to provide that behavior for your site, you could do so with a hook in your /site/ready.php file:

    The "problem" is not for Language pages but for all other pages (template):

    - with page-publish not installed translator can edit pages (e.g. Contact page) and unpub them

    - with page-publish installed translator cannot edit pages (no action in tree menu, ecc - even with "contact" template edit page permission)

    - with page-publish installed and enabled for the role, translator can edit pages and unpub them

    - wanted behavior: with page-publish installed and not enabled for the translator role, translator can edit pages but not unpub them.. is it possible? Make sense in your opinion? Some wrong setting in my installation?

    In any case I tried your hook and there is an issue for me: translator can edit also Language pages that are not assigned to him.

  8. Hi, the edit problem is tied to page-publish permission.

    I added this standard permission and not give it to the translator role (so, with page-hide, translator cannot hide on unpub pages), after that they cannot edit pages anymore. Probably is intentional but is it necessary with the new permissions?

    Other request: make site/core translation files fields as multi-language-field so they are editable also without page-edit-lang-none permission. 

    Thanks

  9. Thanks for your support.

    Ok, with page-edit-lang-none permission translator can see site/core translator files fields. But in this way they will see also non-multi-language fields in other pages right? Mmm..

    Yes, every translator role has page-edit and page-edit-XY permissions but the edit problem is still here. Probably I have made some error in my previous tests if you cannot duplicate the behavior.

  10. Thanks Ryan, this is grandioso!

    I saw the commit this morning and I tried immediately.

    Only one problem.. I think that permissions are ok but.. translator now see Setup->Languages menu but when they choose one language they not see Site translation file and Core Translation File fieldtype. And "edit" permission is not listed in permissions list (see image): in this case translator has "view, edit, create" and translator-es has "view, edit" (only for test).

    post-846-0-71208900-1446738477_thumb.png

  11. Thanks Ryan.


    Yes, built-in process provides everything and more (blank and replaced strings for example) and works well but how I can allow translator to use these pages? They haven’t an “Access” tab or similar to manage permission.


    I tried editing Admin template (view for translator) and language template (view and edit for translator) but I not see the Admin page in the tree view.


    I can wait for the “limitation” aspect for now but translator have to be allowed to use built-in process.


  12. Hi,

    is there an easy way to allow translators to edit strings in our template files?

    I know Admin->Setup->Languages->$LANG page where we can create blank template translation files and edit them, but:

    - translator must have the right permission and it is not so easy (EN translator must be allowed to edit EN page only and we are under Admin page)

    - (or) when admin creates blank files, download them and send it to translators, they haven't source string and/or ID

    I could solve my problem (in this case) if I could create a page that call "Site Translation Files" input field (like Admin->Setup->Languages->$LANG) and allow translator to edit this page, like a shortcut.

    Another way to solve this can be don't use __() methods but use a sort of placeholders (like $myTranslationsPage->myPlaceHolder) in template files and enable translators to edit /myTranslationsPage/.

    Any suggestions? At the moment I have about 100 not translated strings and 4 translators for 6 languages.

    Thanks,

    Marco

  13. Hi,

    I have 3 translators that can edit pages following the new page-edit-lang-[name] system. And this is great.

    In the Settings tab of the page they cannot change status of the page but "unpub" and "hide", for a published page, are present and fully working in the page list tree options.

    Translator shouldn't create/delete, publish/unpublish and hide/unhide. page-publish permission does not solve the problem in this case.

    I read some posts from CMSCritic Development to Dynamic Roles but I think that this can be "fixed" in the core. Am I wrong?

    Thanks

  14. :(

    Aside from ProCache.. another little question.

    My default system language is it (customer request) but for all request outside it browser I want to fallback to en.

    With defaultSiteLanguageCode set to en all the call from it browser are redirected to en (because not match it -> "default").

    Does it make sense for you?

    - defaultSiteLanguageCode -> it

    - fallbackSiteLanguageCode -> en

    Or something similar..

    Thanks

×
×
  • Create New...