Search results

  1. P

    Preserving absolute date value when uploading via CSV

    Ok I think I have resolved this issue. The fix is set the website time zone to UTC and the element to UTC. This seems to work and the value CSV ends up being what gets recorded in the database.
  2. P

    Preserving absolute date value when uploading via CSV

    I cant reproduce the issue when converting the element to a field. I think this was an error on my part. When converting the element to Jdate the issue persists: With element set to Local time CSV value 2024-02-07 00:00:00 becomes 2024-02-06 13:00:00 in the database With element set to UTC...
  3. P

    Preserving absolute date value when uploading via CSV

    I also want to add that when I input via web interface it saves correctly. But when i CSV upload 2024-02-07 00:00:00 it converts to 2024-02-06 13:00:00. The difference seems to be the same if I convert 2024-02-07 00:00:00 to UTC. So it looks like UTC conversion is being applied no matter what I...
  4. P

    Preserving absolute date value when uploading via CSV

    Yep. I have set the element setting to local time. I have attached a screenshot.
  5. P

    Preserving absolute date value when uploading via CSV

    I have a CSV file with dated transactions that I want to upload via the CSV import. The problem is that the system applies some sort of timezone changing what gets stored in the database. if the csv has 2024-02-07 then that's what I would like recorded in the database. I am using the Jdate...
  6. P

    The user element is not rendering properly

    I have uploaded some screen shots. Let me know if you need anything additional such as access to the site.
  7. P

    The user element is not rendering properly

    The user element seems to be only visible in the list view and even there it only user the userid number ie “137” . It does not show on the form/detail view. The element does however populate and update correctly. Hidden is set to No PHP 8.1.2-1ubuntu2.14 Joomla 4.40 Cassiopeia...
  8. P

    Sending HTML formatted email via email plugin

    I have an application where I have a form which I want to use to send templated emails. I have a cascading dropdown which pulls the email template from another list depending on the dropdown value. The template is a formatted HTML template (created and stored using field element). However when I...
  9. P

    Pre populate a form field via url

    Thank you. I have tried that and it has worked for me.
  10. P

    Pre populate a form field via url

    My scenario is I am in detail view of a record and I want to link out from there to an add view of creating another record on a different list (to send an email for example) but I want to populate a field in the new record with a field from the record I linked out from. Something like having a...
  11. P

    Form email plugin

    I am looking to set up the form email plugin in such a way that the user can select which template to use when sending the mail. So I would like to click add from the list, populate the various fields and one last field which selects the template I would like to use. I have tried to store the...
  12. P

    Joined field not auto populating for new records

    I have two lists reximport and staffidentifiers. I have joined staffidentifers onto reximports (image attached) on the ApplicationID field and made it non repeatable. I have made ApplicationID a database join field in the staffidentifers field and it populates from reximports. When click on a...
  13. P

    Comments plugin with different versions of the same list.

    OK. I have figured it out. When creating a menu link there is a Fabrik list options tab which has a number of options including the option the specify a pre filter. Thanks this is what I was looking for.
  14. P

    Comments plugin with different versions of the same list.

    I am not sure how to apply a pre filter anywhere else except in the list config itself. How can I apply a pre filter at menu or module level?
  15. P

    Comments plugin with different versions of the same list.

    I would like to make different versions of the same list. I understand the best way to do this is make a copy of the list and then apply your prefilter to it. So different views of the list will exist but they will all sit on the same database table. I want to do this a few times so I can show...
  16. P

    List on a database view

    FIX: As usual right after posting I figure it. Out. The fix lies in "alter field types" option and setting it to no from use global. My problem was I couldn't change it because updating the list settings was not possible anymore. I was able to change the global setting to no which allowed...
  17. P

    List on a database view

    Apologies, I meant edit the list settings and not the record itself. For example I want to change the order by and it wont let me save the new setting.
  18. P

    List on a database view

    I am trying to create a list on a mysql view. When I try to edit the list I get the 1347 error "skill_base_V' is not BASE TABLE' The view includes a primary key which is set in the Primary Key field in the data tab in the list settings. I have joined this list to another list and it seems to...
  19. P

    S3 file upload issue

    I am running v3.9 of fabrik, 3.9.18 of joomla and v7.2 for php. Setting the value to 2 has not fixed the issue. I have tried applying the code fix but cant seem to find the code mentioned at line 3516. Instead I get the following: /** * Log the download * * @param object $row...
  20. P

    S3 file upload issue

    I am having an issue with the fileupload element. I have a working list where one of the elements is a fileupload element that stores to an S3 bucket. I want to join that to another table so I created a mysql view that filters only what I want and made it into a list and left joined it to the...

Useful links

  • Create a Fabrik Account (Downloads)
  • Create a Forum Account
  • Fabrik Wiki
  • Fabrik 4 Changelog /Install /Upgrade
    • We are in need of some funding.
    More details.

    Thank you.

    Members online

    Total: 118 (members: 2, guests: 116)
    Back
    Top