Sales Questions for EPim

General talks about EssentialPIM

Moderators: TerryRogers, Max

Post Reply
EPCurious
Novice
Posts: 13
Joined: Tue Nov 05, 2019 9:44 pm
Has thanked: 6 times
Been thanked: 1 time

Sales Questions for EPim

Post by EPCurious »

Hi,

Regarding the Pro Edition,

Since Treepad Enterprise is no longer in development, I'm exploring EP as the replacement tool.

1. Is there a .pdf or .chm document I can look at, without installing? This might answer the questions below, as well as other questions that come up.

2. EP has a tree-style HTML website generation feature available, like Treepad?
2a. Can you write embedded html in the pim, which will then be integrated into the exported html (like Treepad)?

3. Is there documention on the sql you can use on the Firebird database, for custom purposes?

4. Is it 64-bit (Windows)? Is there a 32-bit version?

5. Is a Linux version being considered (just a question, not a request)?

6. I'd like to see screenshots of the optional views, other than the default Tree view (i.e. the Flat View and Table view)

7. How difficult is it to move groups of emails, into the Notes part of the Pim?

If there's a document available to answer all these questions, a link would be sufficient.


Thanks and regards,

EPC
EPCurious
Novice
Posts: 13
Joined: Tue Nov 05, 2019 9:44 pm
Has thanked: 6 times
Been thanked: 1 time

Re: Sales Questions for EPim

Post by EPCurious »

Disregard. The documentation is at

https://www.essentialpim.com/help/epim_pro.pdf

I'll take a look, thanks.
Max
Site Admin
Posts: 21714
Joined: Wed Dec 08, 2004 11:39 pm
Has thanked: 819 times
Been thanked: 364 times
Contact:

Re: Sales Questions for EPim

Post by Max »

Hello,

1. Online help file is at https://www.essentialpim.com/help/
2. EPIM can export individual Notes into HTML
2a. I am not sure what the expected result should be
3. https://firebirdsql.org/refdocs/langrefupd20.html
4. EPIM works well on both 32 and 64 bits
5. Currently not considered. EPIM works in Wine
6. You can see screenshots here: https://www.essentialpim.com/pc-version/screenshots For the other screenshots- you can easily install EPIM
7. You can convert Emails to Notes
Maxim,
EPIM Team
EPCurious
Novice
Posts: 13
Joined: Tue Nov 05, 2019 9:44 pm
Has thanked: 6 times
Been thanked: 1 time

Re: Sales Questions for EPim

Post by EPCurious »

Thanks Max,

"2. EPIM can export individual Notes into HTML"

It doesn't have all the features that the Treepad export had, unfortunately. That's ok ; for some purposes, I'll continue using Treepad Enterprise.


"2a. I am not sure what the expected result should be"

As an example,

if you wanted to embed a Youtube video inside a Treepad Node page for the video at,

https://www.youtube.com/watch?v=uzyGNof-tYU

, you would surround the Share/Embed code at the Youtube channel with $( )$.


$(
<iframe width="560" height="315" src="https://www.youtube.com/embed/uzyGNof-tYU" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
)$


Then, when the website is generated, the page will display an image and link of the Youtube video.



"3. https://firebirdsql.org/refdocs/langrefupd20.html"

Sorry. I didn't mean instructions on accessing Firebird databases in general. I mean, specific examples of quering the tables in EssentialPim, for specific purposes. For example, you can do this with the Sqlite database that Ultra Recall uses:

https://kinook.com/Forum/showthread.php?t=2825

...
...

SELECT * FROM SQLITE_MASTER;

to view the database structure.

SELECT * FROM Item;

to view items in database

SELECT * FROM ItemLink;

to view logical links to items

SELECT * FROM ItemAttribute;

to view attributes for items

SELECT * FROM Attribute;

to view attribute properties (name, etc.)


Common Commands

Replace a common string in all URL item attributes:

UPDATE ItemAttribute SET Value = Replace(Value, 'Folder1/', 'Folder2/') WHERE AttributeID = 996 AND Value LIKE '%Folder1/%';


Change an absolute path in all URL item attributes to a relative path:

UPDATE ItemAttribute SET Value = Replace(Value, 'D:\MyFolder\', '') WHERE AttributeID = 996 AND Value LIKE 'D:\MyFolder\%';


Update the Quick Search item search text:

DELETE FROM FilterRow WHERE ItemId=990;
INSERT INTO FilterRow VALUES ((SELECT MAX(FilterRowID)+1 FROM FilterRow),990,0,12,'search text',0,-1,0);


Change all URLs starting with c:\ to e:\:

UPDATE ItemAttribute SET Value = 'e' || substr(Value, 2, 2000) WHERE AttributeID = 996 AND Value LIKE 'c:\%';


Remove a common title prefix from all matching items (replace ebay.co.uk below with desired prefix):

BEGIN;
UPDATE Item SET ItemTitle = substr(ItemTitle, 11, 1000) WHERE ItemTitle LIKE 'ebay.co.uk%';
UPDATE ItemAttribute SET Value = substr(Value, 11, 1000) WHERE AttributeID = 5 AND Value LIKE 'ebay.co.uk%';
COMMIT;


Replace a common string in the title of all items (replace $$dot$$ with text to match on):

BEGIN;
UPDATE Item SET ItemTitle = Replace(ItemTitle, '$$dot$$', '.') WHERE ItemTitle LIKE '%$$dot$$%';
UPDATE ItemAttribute SET Value = Replace(Value, '$$dot$$', '.') WHERE AttributeID = 5 AND Value LIKE '%$$dot$$%';
COMMIT;


List items with duplicate URLs:

SELECT ItemID, Value FROM ItemAttribute WHERE AttributeID=996 AND UPPER(Value) IN (SELECT UPPER(Value) AS Val FROM ItemAttribute WHERE AttributeID=996 GROUP BY Val HAVING(COUNT(*) > 1)) ORDER BY UPPER(Value);


List items with duplicate titles:

SELECT ItemID, Value FROM ItemAttribute WHERE AttributeID=5 AND UPPER(Value) IN (SELECT UPPER(Value) AS Val FROM ItemAttribute WHERE AttributeID=5 GROUP BY Val HAVING(COUNT(*) > 1)) ORDER BY UPPER(Value);
...
...
AJ
Expert
Posts: 95
Joined: Mon Jun 12, 2006 5:00 pm
Has thanked: 25 times
Been thanked: 4 times

Re: Sales Questions for EPim

Post by AJ »

Hi,
you can choose portable version by the intallation so it wont touch your system.
You can also install it as a portable version on your usb stick.
Just try it out.
Is this helpfull for you?
EPCurious
Novice
Posts: 13
Joined: Tue Nov 05, 2019 9:44 pm
Has thanked: 6 times
Been thanked: 1 time

Re: Sales Questions for EPim

Post by EPCurious »

Thanks AJ, I already purchased it last night, and have been testing the Portable version since.

I always feel guilty asking support questions for something I didn't pay for, so I took chance. Looks ok, so far.


Regards,


AJ wrote: Thu Nov 07, 2019 12:01 am Hi,
you can choose portable version by the intallation so it wont touch your system.
You can also install it as a portable version on your usb stick.
Just try it out.
Is this helpfull for you?
Max
Site Admin
Posts: 21714
Joined: Wed Dec 08, 2004 11:39 pm
Has thanked: 819 times
Been thanked: 364 times
Contact:

Re: Sales Questions for EPim

Post by Max »

Thanks for clarifications.
2a: EPIM does not have such functionality currently
3: There has not been many requests for such specific queries, so there is no examples
Maxim,
EPIM Team
EPCurious
Novice
Posts: 13
Joined: Tue Nov 05, 2019 9:44 pm
Has thanked: 6 times
Been thanked: 1 time

Re: Sales Questions for EPim

Post by EPCurious »

Ok, thanks Max.
Post Reply