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
Sales Questions for EPim
Moderators: TerryRogers, Max
-
- Novice
- Posts: 13
- Joined: Tue Nov 05, 2019 9:44 pm
- Has thanked: 6 times
- Been thanked: 1 time
Re: Sales Questions for EPim
Disregard. The documentation is at
https://www.essentialpim.com/help/epim_pro.pdf
I'll take a look, thanks.
https://www.essentialpim.com/help/epim_pro.pdf
I'll take a look, thanks.
-
- 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
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
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
EPIM Team
-
- Novice
- Posts: 13
- Joined: Tue Nov 05, 2019 9:44 pm
- Has thanked: 6 times
- Been thanked: 1 time
Re: Sales Questions for EPim
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);
...
...
"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);
...
...
Re: Sales Questions for EPim
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?
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?
-
- Novice
- Posts: 13
- Joined: Tue Nov 05, 2019 9:44 pm
- Has thanked: 6 times
- Been thanked: 1 time
Re: Sales Questions for EPim
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,
I always feel guilty asking support questions for something I didn't pay for, so I took chance. Looks ok, so far.
Regards,
-
- 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
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
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
EPIM Team