查看单个帖子
nh_wzg
 
nh_wzg 的头像
核心会员
 
资 料:
注册日期: Jul 2000
帖子: 3,253 声望值: 3
精华: 5,解答: 9
#9 旧 2019-08-05, 13:23:06 默认
nh_wzg 当前离线  

引用:
作者: namejm 查看帖子
nh_wzg兄似乎想打造加工知识库的工具套件
这个愿望比较宏大,以我目前的业余水平,还难以帮上什么忙
可能需要找相关的专家一起搭建
也希望论坛里能有专家前来讨论
@namejm

提出软件工具实现的目标,都是大处着眼,小处着手。

根据目标,把流程作了切分细化的分析,要实现,总是由最小的部分开始的。

上面的例子,用户遇到的最实际的问题就是:EXCEL里面文件A已有两行数据的导出,再在文件B中进行导入 / 插入两行数据的操作。

如果两个文件都在本地打开了,剪贴板操作,最快。
但这文件A两行要导出》成为一个可供再导入的数据文件》再导入到文件B的指定行,有什么快捷工具完成这个导出 / 导入的操作?

===>--20190806-0814
没有新的方向,临时转向PhraseExpress / Ditto 类的剪贴板管理软件。
Phrase Express Manual for 10
_http://www.phraseexpress.com/docs10/09/manual.htm
_https://www.phraseexpress.com/doc/
Ditto 分组及网络传送的测试。Srv1出现防火墙的设置问题。

--20190817-2023
整天变成一个clip manager 软件的筛选操作:
Phrase Express 始终不能方便地支持Excel2003的单元格内容,先行出局吧
Ditto的网络共享模式,实现起来太不方便
ClipCache基本仅仅是针对个人使用
ClipMate引入了多用户的模式,探索的方向


引用:
作者: netsonic 查看帖子
用专业的数据库软件不更好吗?
未完成规范化的信息,放到专业的数据库软件中,用户处理起来的限制更大。

--20191013-0725 Clipmate 多用户的使用
To set up a multi-user database,

First you must establish a network directory, accessible by a drive letter, to which all users have read/write/create access.
(Note that this has been tested on Windows2000/XP networks, but not Novell)

Next, have one user create a new database in that directory, using the Database Tab <cfg_up_database.htm> in the User Preferences dialog.

Set the directory as appropriate, and select the option for "multi-user, networked database".

Select a user name for this user - it can be their login name, first name, or whatever you prefer.

Use the Read-Only checkbox to limit access to users who you wish to restrict.

Important - every user must have read/write access to the directory.

In a multi-user environment,

each user should have their own local database as well. You do not want Sara's Excel copies to slow down because Tom just copied a bunch of PowerPoint slides.

Instead, users should copy everything locally, and then move important clips onto the network.

On the other hand, if you are the sole user of a computer empire in your basement, and want the same clip available at each computer, then you may very well want to just have a single, networked database.

Also, in a multi-user database,

you probably want to avoid having collections like "inbox".

You should instead set up meaningful collections, by topic, project, or purpose.
Such as "Tech Support", "Policies", "Stocks", or "How To". Set them all to be "safe" collections.

And you may want to turn on the Garbage Avoidance, so that if anyone is "sitting" on a collection, and they forget, then the collection won't fill up with their garbage. Instead, it'll "bounce" back to their own InBox.

Important - the network and server must always be available!

ClipMate needs reliable, continuous access to the database.
If a shared database resides on a server that is allowed to hibernate, suspend, sleep, etc., or is on a network that is unreliable, then you will have trouble. It is NOT acceptable to share a database on the network, when the database server is going to be frequently inaccessible.
Shared databases are for servers or "always-on" workstations.

Refreshing Networked Data:

As users add data to networked databases, each user will see the new data when they switch collections. So if Joe puts a new tech support bulletin in the "Tech Support" collection, then Mary will see it when she switches to that collection.

If she is already viewing that collection however, she can use the File | Reload Collection,

or click on the "network update" icon that appears in the status bar when the new data is detected (this is available if the "polling" option is used).

Exclusive Access:

New versions of ClipMate may need to gain exclusive access to the database to perform upgrades to the table structures. This will require exclusive access to the database.

Check the readme.txt file of any update to version 6.x, to see if there are database changes that will require exclusive access. If so, you will need all users to shut ClipMate down while you perform the maintenance. The same applies if you perform other database maintenance <cfg_dbmaint.htm>.

Exclusivity

Database maintenance requires exclusive access to the database files
If you are in a multi-user environment, sharing a common database, then you need to have all other users close ClipMate
(or de-activate the shared database).
ClipMate will let you know if it attempts to perform database maintenance and cannot continue.

Shutting Down:

If you are going to shut down the server or PC that is hosting the database, you should close ClipMate on the other workstations first, because they may hang if the networked directory is not available when they log off.

Tech Tip: There is a table in the database called "users", which keeps track of the individual users in the database, for purposes such as identifying the creator of a clip, or for notifying users of updates. You can view the current state of the table by going to the SQL window <cfg_sqlwindow.htm>, and entering this SQL:

代码:
select * from users;
Or for a fancier report showing which clips were created by which users:
代码:
select users.username, clip.timestamp, clip.id, clip.title

from clip, users

where clip.user_id = users.id

order by users.usernam
上传的附件
文件类型: rar ClipMate7.5.26_help.rar (946.2 KB, 0 次查看)

此帖于 2019-10-13 07:28:56 被 nh_wzg 编辑. .


平和精确简约应成为精品成员的三大基本要求!!!
nh_wzg
回复时引用此帖