Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge Download Epesi BIM Free & Open Source CRM

jasiek

  •  
  •  
  • Joined Jan 4, 2006
  • 8 best answers
  • In Exporting history in phpmyadmin to a new table utils_attachment_data_1

    User Activity Report - selected myself and notes only - example below:

    Regarding your comment: "In the old version of Epesi, records were linked to records from different tables: utils_attachment_note and utils_attachment_link. The current version has, for example: utils_attachment_data_1 with the f_attached_to column to which I need to put values, e.g.: contact/1803"

    @wallstreet why are you trying to export from the old version of Epesi to the new one? Go through the upgrade process and there are patches that will take care of this. How old is your old Epesi, what version?

  • In Eksport historii w phpmyadmin do nowej tabeli utils_attachment_data_1
  • In Exporting history in phpmyadmin to a new table utils_attachment_data_1

    Hi @wallstreet,

    This post is a duplicate of:
    https://forum.epe.si/d/5351-eksport-historii-w-phpmyadmin-do-nowej-tabeli-utils_attachment_data_1

    Each recordset in Epesi stores data in several tables. Main data is stored in module name_data_1
    but exporting from phpMyAdmin will give you raw data only. You should use Epesi's export function, which will substitute values from related recordset and especially Common Data. This way you will get:

    Joe, Doe, USA, Pennsylvania

    where USA and Pennsylvania are values from Common Data, instead of:

    Joe, Doe, 45, 17

    Record history is stored in modulename_edit_history and modulename_edit_history_data

    edit_history_data table contains only old values of fields:

    edit_id, field, old_value

    However you are not trying to export Contacts' record history, but history of attachments. This is a completely different story. Utils_Attachment module links notes and/or attachments to a single record in any recordset.

    Do you want to export history of all notes/attachments created by a particular user?

    You can take a look at User Activity Report that comes with Epesi by default to see how you can obtain a very detailed activity of every user. You will need to write a custom module to do what you want - just to get data out. But then what? Do you have an application that can consume this data format/structure?

    FYI: There is no command in SQL that can be easily executed in phpMyAdmin to get what you want.

    More info about Epesi database structure:
    https://forum.epe.si/d/1256-a-methodical-question-is-there-an-er-diagram

    Regards,

    Janusz Tylek
    Epesi Team

  • In E-Mail Error

    digamcrown sorry for the late reply.

    Thank you for the update. I'm sure this info will be useful to other Epesi users.

    Thank you for using Epesi.

    Janusz Tyłek
    Epesi Team

    • In Wikipedia page about Epesi marked for deletion?
    • In Wikipedia page about Epesi marked for deletion?

      Wikipedia page about Epesi was deleted 13.10.2023

      Hi Janusz,

      I hope this email finds you well.

      The team just informed me that your page has been deleted. I am even attaching the snapshot. However, if you wish to have it restored, we can gladly assist you in the process of building and publishing a new page. Please get in touch if you want to learn more about this option.

      ![

      Looking forward to hearing back from you.

      Shawn Harrison
      Sr. Wikipedia Consultant
      https://thewikiinc.com/

    • In Wikipedia page about Epesi marked for deletion?

      I believe this is a case of racketeering:
      https://en.wikipedia.org/wiki/Racketeering

      Racketeering is a type of organized crime in which the persons set up a coercive, fraudulent, extortionary, or otherwise illegal coordinated scheme or operation (a "racket") to repeatedly or consistently collect a profit.[1]

      Originally and often still specifically, racketeering may refer to an organized criminal act in which the perpetrators offer a service that will not be put into effect, offer a service to solve a nonexistent problem, or offer a service that solves a problem that would not exist without the racket. However, racketeers may offer an ostensibly effectual service to solve an existing problem. The traditional and historically most common example of such a racket is the "protection racket", in which racketeers offer to protect a business from robbery or vandalism; however, the racketeers will themselves coerce or threaten the business into accepting this service, often with the threat (implicit or otherwise) that failure to acquire the offered services will lead to the racketeers themselves contributing to the existing problem. In many cases, the potential problem may be caused by the same party that offers to solve it, but that fact may be concealed, with the intent to engender continual patronage. The protection racket is thus often a method of extortion, at least in practice.

    • In Wikipedia page about Epesi marked for deletion?

      You can follow the discussion over here:
      https://en.wikipedia.org/wiki/Wikipedia:Articles_for_deletion/Epesi

      I was notified by a guy named Shawn Harrison in an e-mail:

      Hi Janusz,

      I hope this email finds you well!

      My name is Shawn Harrison; I work with this company "The Wiki Inc" as a Wikipedia Consultant and have been a Wikipedia Editor myself for more than a decade. I would like to update you that your company's Wikipedia page has been nominated for deletion due to multiple issues.

      Please see the Wikipedia link of your entry:

      https://en.wikipedia.org/wiki/Epesi

      I myself have been a Wikipedia Editor for more than 15 years. You can check my Wikipedia account below:

      https://en.wikipedia.org/wiki/User_talk:Guy_Harris

      If you are not interested in improving your company's live page then please acknowledge so that I can notify the Wikipedia community to proceed with deleting the live page and clearing our records.

      However, if you are interested in improving your company's page so do let us know so I can guide you on further details.

      Please be advised that once your details are sent over for the deletion and the page is deleted, the same content and title will not be usable for the next entry.

      Looking forward to your positive response.

      --
      Shawn Harrison
      Snr. Wikipedia Consultant
      https://thewikiinc.com/

      Here is the last e-mail I received:

      Hi Janusz,
      Thanks for your response.
      Well, as you are already aware of the situation and you have already noticed, your Wikipedia entry was already nominated for a speedy deletion process, and another editor has also voted against your entry, which is actually now making your case more critical and concerning if the immediate aren't taken at the right time. This new delete vote has also highlighted the concern of COI, which again is raising indications related to the violation of the neutrality guidelines of Wikipedia.
      Now, the actions that can be taken in order to preserve and secure your entry is that your page requires voting from different Wikipedia editors/ bureaucrats in your favor in order to balance out the situation. Also, what we can do to save your entry further is that your entry requires additional editing in a proper, neutral manner. Also, the tone of the page needs to be improvised, and that thing must be eliminated, which is making your page promotional. Moreover, it also needs to be cited properly through the references that are currently available for which detailed research needs to be conducted.
      These were some immediate actions that need to be taken as early as possible in order to save your entry. However, if you want us to assist you with your case, we can certainly guide you on the services that we provide. In addition, we can also assure you one more thing in case your entry gets deleted/ removed during the process, so we can also assist you with recreating your page from scratch in line with Wikipedia standards and protocols. Our main motive would be to protect and secure your initial entry first so the changes that we plan out can be implemented accordingly.

      Lastly, if you wish to move forward I can get you started with the plan I have mentioned above, and our complete services will cost you $1,499 only.

      Kindly confirm so I may get you started accordingly.

      --
      Shawn Harrison
      Sr. Wikipedia Consultant
      https://thewikiinc.com/

      I did some searching online and found this:

      https://www.reddit.com/r/ScamsEtc/comments/127ilte/wikipedia_consultancy_scam/

      So here's an interesting scam that seems to be making the rounds.

      This scam is very subtle, because some sites do seem to offer a legitimate variant.

      Basically, certain websites appear to be claiming they can win anyone notoriety by offering to write Wikipedia pages for exorbitant sums of money.

      Almost Definite Scam Sites
      https://www.wikicounsellor.com/lp-offer

      https://www.wikifederation.com/lp-offer

      https://www.wikiprofessionalsinc.com/lp-coupon

      https://www.wikiproficiency.com/lp-new

      https://www.thewikiinc.com/

      https://www.wikisolutionsllc.com/

      https://www.wikicreatorsllc.com/

    • In Wikipedia page about Epesi marked for deletion?

      @swim yes, I am aware of it. I received an e-mail from a guy, who apparently is making money on it.
      It is a much larger problem than I thought initially.
      I will let you know how the things progress and they look interesting.

    • In mysqli errors on many pages

      @digamcrown Thank you for the update and I am glad you made it work.

      I was not clear enough with my instructions. When you deleted all records in session tables Epesi should start fine and you should see new records, new sessions in these tables. You should check if this is what is happening. If it works maybe leave it with SQL session type - I don't know how your server is setup. What you can do is test the performance in each case using F12 - Developer Tools and observe Network load performance.

      Compare load times in both cases and choose more efficient version.
      While you are at that check if you have memache installed. Here is a simple script that not only checks for PHP extension, but actually does a test read/write to memcache database deamon:

      <?php

$memcache = new Memcache;
 $memcache->connect("localhost",11211); # You might need to set "localhost" to "127.0.0.1"
 echo "Server's version: " . $memcache->getVersion() . "<br />\n";
 $tmp_object = new stdClass;
 $tmp_object->str_attr = "test";
 $tmp_object->int_attr = 123;
 $memcache->set("key",$tmp_object,false,10);
 echo "Store data in the cache (data will expire in 10 seconds)<br />\n";
 echo "Data from the cache:<br />\n";
 var_dump($memcache->get("key"));

?>

      If you verify that memcache works - switch to it, this should give you the best performance and you will get fewer session lock errors. But don't take my word for it - test and verify it yourself.

      Make sure that you test session with new browser session - another browser works the best, incognito/private mode window is another option.

      You can also uncomment and set all DEBUG options in config.php and in that case Epesi will print at the bottom a lot of information: module load time, module's SQL query times, running totals etc. We used it extensively in the early development phase of Epesi to make sure, that it will work even on very slow 256kB Internet connection (upload speed) popular at that time in Poland. Epesi was designed to work on low end hardware and has very low disk space or bandwidth or CPU or RAM requirements. Both server side and desktop client side.

      In fact you can run Epesi on Raspberry Pi:
      https://github.com/jtylek/RasPiEsi

      Also all the best.
      If you do the above and have some spare time please post your results with some specs of your host/server for reference. Thank you in advance.

      Janusz Tylek (a.k.a. "jasiek")
      Epesi Developer

    • In mysqli errors on many pages

      Hello René,

      I apologize for the delay in answering your question here.

      You opened a support ticket at epesi.cloud as well but it looks like instead of using the ticketing system you started this forum post. I am closing the ticket, since you are not replying to it there, and we will keep the conversation here to the benefit of other users.

      As for the error - please read carefully what it says:

      Message: mysqli error: [1451: Cannot delete or update a parent row: a foreign key constraint fails (usr_web606_5.session_client, CONSTRAINT session_client_ibfk_1FOREIGN KEY (session_name) REFERENCESsession(name`))] in EXECUTE("DELETE FROM session WHERE name='c7ee89899cf536e7a195ba2bcc072be2'")

      Go to PhpMyAdmin and delete all session entries making sure that foreign key is unchecked.

      1. Check all
      2. Delete
      3. Uncheck: enable foreign key checks (if checked the DELETE query will fail)
      4. YES - to confirm

      Make sure that both tables are empty:

      • session
      • session_client

      Your /data/config.php file contains a directive where to store sessions. Options are:

      • file
      • database
      • memcache

      Find a section that reads:

      define('DIRECTION_RTL','0');
define('EPESI_URL','https://YourEpesiURL');

      and find a line that defines how the sessions are handled:

      Default: database driver

      define('SESSION_TYPE','sql');

      or

      define("MEMCACHE_SESSION_SERVER","127.0.0.1:11211");
define('SESSION_TYPE','memcache');

      or

      define('SESSION_TYPE','file');

      Memcached sessions are the fastest but you have to make sure Memcached deamon is running and you have PHP memcached extension enabled.

      File sessions are the slowest, but easiest to setup.

      If you experience errors in PHP with Epesi Directory, then add the following:

      define('EPESI_DIR', '/');

      To troubleshoot errors make sure that you can run phpinfo(); and note where PHP error logs are written. Then generate an error on purpose and see if the PHP error log reflects that.

      Your answers will be in:

      • apache or other HTTP deamon error or access log
      • PHP error log (if enabled and configured correctly)

      Good luck and please paste your results (think about other users in your situation).

      Jasiek

    • In A propos wersji mobilnej

      michlew

      Muszę dodać - o czym zapomniałem napisać ostatnio - że Epesi ma integrację z Telegramem.
      Powiadomienia Watchdoga są wysyłane na Telegram kiedy nie ma użytkownika przy komputerze.

      Więc polecam założyć Telegrama na smartfonie i komputerze. Prędkość synchronizacji jest w Telegramie rewelacyjna.
      Pozwala na chat, VoIP, video call, przesyłanie plików i nawet secret chat, do przesyłania zaszyfrowanych poufnych informacji czy danych, perfect np. do przesyłania haseł i loginów.

      https://telegram.org/

      Po założeniu Telegrama zrób dwie grupy:

      • Office - Biuro - ogólna dla wszystkich pracowników
      • Grupa robocza - do śledzenia np. zadań

      My korzystamy z Telegrama bardzo i często zakładamy nową grupę do projektu, gdzie dodajemy konsultantów z naszej grupy jak i klienta i tam odbywa się czat na temat zmian, szkolenie itp. Bardzo wygodne narzędzie i polecam gorąco.

      Czat można zarchiwizować i czytać jako HTML pliki w przeglądarce (funkcja export). Więc można przechować całą historię dyskusji / czatu o danym projekcie.

      Telegramem zastąpisz Shoutbox - od czasu do czasu ważniejsze rzeczy skopiuj/wklej do Shoutboxa.

      Co do używania na komórce Epesi w trybie desktop to działa na tyle, że jestem w stanie nawigować używając zoom dwoma palcami. Oczywiście, że wolałbym aby wersja mobilna była bardziej funkcjonalna, ale kiedy przeczytasz moją odpowiedź do @praski to zrozumiesz dlaczego jeszcze jej nie ma.

      Może też napiszesz jakiś protest w moim imieniu do kogoś w ministerstwie burdelu i niesprawiedliwości?

      Tak sobie myślę: skoro PiS to partia, która najwyraźniej walczy z prawem i sprawiedliwością - chuj jebany Kaczyński co się masturbuje i o aborcji decyduje głównie - to musimy założyć partię BiN: Bezprawie i Niesprawiedliwość, która będzie walczyć z bezprawiem i niesprawiedliwością. Chyba jest to logiczne i oczywiste!

      Jebać chuja Kaczyńskiego i jego PiS. Piece of Shit.

      • In A propos wersji mobilnej

        Witaj @praski,

        Zaczęliśmy prace nad wersją responsive już w 2018 roku, czyli ponad 4 lata temu.
        Jest to branch: https://github.com/jtylek/EpesiCRM/tree/new_gui
        Oparta była na Bootstrapie. Możesz spróbować odpalić. To już działało w 80%.

        Niestety prace zostały przerwane i to na długo po tym jak napadli na mnie bandyci w mundurach, wyważyli drzwi i potraktowali jak George Floyd'a w USA, tylko mnie nie 9 minut ale 2 minuty dusili...
        Byłem pewny, że nie przeżyję... bo straciłem przytomność. Ale kiedy odzyskałem ją i zdałem sobie sprawę, że to jeszcze nie koniec, to wybuchnąłem szaleńczym śmiechem. Nieśli mnie jak zwierzę pomimo, że byli ratownicy z noszami. Wyrwali mi ręce z przegubów, łokcie, kolana, barki...
        Po wielu godzinach spędzonych w samochodzie skuty z tyłu i związany staciłem czucie w obu rękach na ponad 6 miesięcy. Cierpię na PTSD, depresję i miałem wielokrotnie próby samobójcze. Po raz pierwszy od ponad 2 lat jestem w stanie o tym publicznie napisać.
        To co zobaczysz jest bardzo drastyczne ostrzegam: https://www.youtube.com/watch?v=vf9PuTOvy2Q
        Możesz więc podziękować bandytom z polskiej policji, totalnym idiotom, za brak nowej wersji Epesi z responsive UI.
        Mówiłem debilom żeby sobie wpisali na Google Janusz Tylek i zobaczyli kim jestem, że robię software.
        Myślę, że ponieważ pracuję z domu to podejrzewali mnie, że jestem może jakimś dealerem narkotyków, które sprzedaję na DarkNet? Chuj wie.

        Polska policja to debile dwupalczaści.
        Tak - nie spotkałem ani jednego, który wiedziałby co to touch typing.
        Chuje na siłę od pługa oderwani, bez kultury i wiedzy. Tak jest Polkatoland pod panowaniem buca Kaczyńskiego. Chuj się masturbuje i o aborcji decyduje!

        Pozdrawiam,
        Janusz Tylek

        P.S. Mój ojciec Stanisław Tylek, inżynier budownictwa wodnego, który zbudował między innymi stację uzdatniania wody w Łukanowicach dla Tarnowa czy sławetną wieżę ciśnień: https://pl.wikipedia.org/wiki/Wie%C5%BCa_ci%C5%9Bnie%C5%84_w_Tarnowie
        odznaczony medalami: Zasłużony dla Ziemi Krakowskiej i Tarnowskiej, Srebrny Krzyż Zasługi
        https://pl.wikipedia.org/wiki/Krzy%C5%BC_Zas%C5%82ugi
        człowiek bezpartyjny i niezależny, był wybrany w pierwszych wolnych wyborach w 1989 na przewodniczącego nowo powstałej dzielnicy X w Krakowie. Sprawował tą funkcję przez 2 kadencję.

        Moje oprogramowanie jest w tej chwili używane w 38 krajach i zostało przetłumaczone na blisko 40 wersji językowych i oferowane jest jak wiesz za darmo. W Polsce jest najwięcej bo około 30% instalacji.
        Możesz proszę napisać do ministerstwa niesprawiedliwości w Warszawie o tym incydencie i zapytać co oni kurwa robią.
        Z góry dziękuję.

      • In A propos wersji mobilnej

        Dziękujemy za miłe słowa. Stary UI był budowany do pierwszej generacji iPhonów i służy głównie do podglądania kontaktów i kalendarza w terenie.
        Dałoby się coś z tym zrobić ale brakuje nam czasu i funduszy na opłacenie deweloperów.
        Skoro nie kodujesz to możesz zaangażować się w projekt w inny sposób - na przykład przez wsparcie finansowe:
        https://epe.si/donate
        Nawet $20 USD to już lunch dla dewelopera 🙂

        Pozdrawiam
        Janusz Tylek

      • In How much will you save using Epesi vs. Salesforce?

        We run some numbers for you...

        ... and you will be surprised!

        Note that Epesi installation is 7.5 years old on average, with the oldest ones used since 2008 or for over 14 years. To compare we used median value of 10 years with only 10 users. Epesi has no per user cost per month and can scale to hundreds of users for free.

        See report -> https://epesi.cloud/announcements/5/How-much-will-you-save-using-Epesi-vs.-Salesforce.html

        What do you think?
        How much money did you save already using Epesi?
        Do you want to share your story?

      • In Free epesi.cloud PaaS plan for Epesi Academy Members

        ATTENTION !

        Free epesi.cloud PaaS plan for Epesi Academy Members

        Every Epesi Academy Member qualifies for a complimentary, Free epesi.cloud PaaS plan with 4.20 GB disk space for hands-on training or development needs like testing or product demo:
        https://epesi.cloud/announcements/3/FREE-Epesi-Compute-VM-for-GitHub-Developers.html

        Package: FreeCloud 4.20 GB

        - 4.20 GB Disk Space

        • 1 Custom Domain
        • 10 Subdomains
        • 10 Databases
        • 10 e-mail accounts
        • Free epesicrm.com subdomain
        • Free for Epesi Academy Members
        • Epesi CRM preinstalled
        • Unlimited Epesi users
        • DirectAdmin panel control
        • Daily backups to B2 bucket
        • AES-256 encrypted backups
        • Free Softaculous Premium Autoinstaller
        • Free SSL certificates
        • Free support via Forum
        • Limit of 42 e-mails sent per day
          - FREE • FOREVER!

        Epesi Academy Members only!

        You must provide a link to your Github's fork of EpesiCRM when ordering.

        Follow this link for instructions -> https://epesi.cloud/knowledgebase/28/How-to-get-free-Epesi-Compute-VM.html

        Enjoy,

        Janusz Tylek
        Epesi Developer

      • In Failure (403)
      • In Epesi BIM 1.9.1 Released
      • In Epesi BIM 1.9.1 Released

        R88 Backup to znaczy:

        • Dump bazy danych - jak masz phpmyadmina to ściągnij skompresowany SQL w zip'a.
        • FTP oczywiście też zadziała, ale to bardzo wolna metoda. Nie masz panelu kontrolnego typu cPanel albo DirectAdmin albo Webmin? Cokolwiek? SSH? Zrób archiwizację (skompresuj) folder "epesi" i ściągniesz zip'a jako jeden plik a nie będziesz się męczył z gadzylionem plików i katalogów do ściągnięcia.
        • In Epesi BIM 1.9.1 Released

          W wersji 1.7.1 powinno działać http(s)://epesiurl/update.php, ale najpewniej jest wgrać wyższą wersję i pozwolić się patchom odpalić. Dużo masz danych? Attachments? e-mails? Bo były zmiany i upgrade trochę trwa.

          Proponuję robić to na PHP 7.0 albo 7.1 i zmienić na 7.4 dopiero przy ostatniej wersji.

          Oczywiście backup, backup, backup.
          Epesi directory - sprawdź czy nie masz jakiś logów i wyczyść.
          Baza danych oczywiście.

          Wracając do upgrade:

          Masz do nadrobienia od stycznia 2016.
          Zrób 1.7.2, później 1.8.0, 1.8.2 i zmień wersję PHP na min 7.3 i upgrade do 1.9.1.

          Robiłem upgrade z wersji 1.0.8b z 2010 i przeszedł wszystkie kroki a było ich 16 in-between upgrades i robiłem wszystko ręcznie tak jak ciebie to czeka.
          https://sourceforge.net/projects/epesi/files/Old%20%20Epesi%20Releases/

          Softaculous autoinstaller robi te rzeczy automatycznie, polecam.
          Możesz sam przetestować albo sobie robić upgrade na naszej "chmurce".
          Oferujemy od tego miesiąca ekonomiczny "budget" hosting na Hetzner'ze w dodatku do obecnej chmury Epesi Cloud chodzącej na Linod'e. Są plany darmowe dla deweloperów i testerów Epesi. Polecam.

          https://epesi.cloud/knowledgebase/28/How-to-get-free-Epesi-Compute-VM.html

          Powodzenia i czekam na rezultaty.
          W razie czego robię data migration ze starych wersji, no problem.