Precious Metals Forum

Go Back   Precious Metals Forum > Bunker Talk > STS

Like Tree7Likes
  • 1 Post By benjamen
  • 2 Post By rblong2us
  • 3 Post By mmerlinn
  • 1 Post By DoChenRollingBearing

Reply
 
LinkBack Thread Tools
Old 07-03-2013, 01:10 AM   #1
PM Bug Supporter
 
DoChenRollingBearing's Avatar
 
Join Date: Oct 2011
Location: SE USA
Posts: 1,275
Liked: 691 times
Encryption for Mere Mortals

...

OK, DCFusor will not be impressed, but there are LOTS of fairly tricky ways of encrypting data (emails and sales data for example) that would stand up to almost anything except skilled cryptologists with good computers. Here is some SQL coding (for MS Access, oh, sorry again DCFusor (does not like Access)), your SQL will vary if you use other SQL databases (like Oracle, MySQL, etc.):

SELECT DISTINCTROW (((Right(([df_2].RUC),2) Mod 2) + 1) * 10) & (Right(Left((([df_2].RUC) * 599),11),10)) AS Cust_ID, (Right(Left(([df_2].Cliente),4),1)) & (Left(Right(([df_2].Cliente),3),1)) & (Left(Right(([df_2].Cliente),2),1)) & (Right(Left(([df_2].Cliente),4),1)) AS Customer, Sum([df_2].Cant) AS Sum_of_Qty, Sum(CCur([Cant]*[VUnit]*((100-[Dscto])/100))) AS Expr9
FROM df_2
WHERE RIGHT(([df_2].Fecha),2) = "13"
GROUP BY [df_2].Cliente, [df_2].RUC;

That nasty-looking coding cannot be explained very easily, but there are some cool functions (prime number 599 (although that is NOT the real number), a Modular function and manipulating text around to hide customer names (this last is rather weak though) in there that I use to protect the real data.

Here are two rows of output (ahh, well that did not format well in my Cut & Paste...), first are the field names, then the columns. Note that customer "DEMA S.A." is identified here (and so has six items of text here, that period/dot in "position two" is derived from the above SQL and is deliberate).

Cust_ID
Customer
Expr9
RUC
Cliente
Expr9

201149974507
T E
$3,408.61

100347361191
.
$3,306.45
20101177042
DEMA S.A.
$3,306.45


More details at my new blog piece (as I know the above is "Pure Greek"):

http://tinyurl.com/kkdath3
DoChenRollingBearing is offline   Reply With Quote
Old 07-03-2013, 07:07 AM   #2
Super Moderator
 
benjamen's Avatar
 
Join Date: Mar 2012
Location: Migratory
Posts: 1,617
Liked: 683 times
Assuming all you want is a list of amounts of sales and attached client IDs:

If you have 'n' clients, randomly assign a unique integer, perhaps called client #, between 1 and 'n' to each client.

Next, only display the client # and amount of sales.
__________________
I drive men mad
For love of me,
Easily beaten,
Never free.

PMBug 101 *** Forum Rules
benjamen is offline   Reply With Quote
Old 07-03-2013, 08:16 AM   #3
Yellow Jacket
 
rblong2us's Avatar
 
Join Date: Nov 2011
Location: off world
Posts: 1,948
Liked: 868 times
or simply written in a hurry using a quill pen and ink ......

no government decoding machine or spotty techie could unravel it
__________________
if it cant be done with a digger .... it cant be done
rblong2us is offline   Reply With Quote
Old 07-03-2013, 05:47 PM   #4
Ground Beetle
 
Join Date: Oct 2011
Location: Here, There, and Everywhere
Posts: 633
Liked: 388 times
Originally Posted by DoChenRollingBearing View Post:

More details at my new blog piece (as I know the above is "Pure Greek"):
Not Greek to me since I have been programming computers for over 30 years, years before IBM invented the PC and years before Bill Gates invented his DOS and Windows trash.

That said, I have done many "impossible" things that others said could not be done with a computer. One that comes to mind is that I wrote a complete database program (in Basic) where the whole program resided in 16k of memory (no paging code in and out of memory) while the data resided on dozens and dozens of 5-1/4" discs. I ran my business for years using it and published dozens of in-house books using the same program. Still works, but having the data scattered over dozens of 5-1/4" discs is a real pain to work with, so for the last ten years I have been slowly migrating everything to more modern machines.
__________________
If you keep doing what you are doing, You will keep getting what you are getting.
If you don't like what you are getting, You must change what you are doing.


http://mmerlinn.com

GOLD is the money of KINGS.
SILVER is the money of GENTLEMEN.
BARTER is the money of PEASANTS.
DEBT is the money of SLAVES.
- Norm Franz
mmerlinn is offline   Reply With Quote
Old 07-05-2013, 07:10 PM   #5
PM Bug Supporter
 
DoChenRollingBearing's Avatar
 
Join Date: Oct 2011
Location: SE USA
Posts: 1,275
Liked: 691 times
...

mmerlinn...

Don't start working up in The Cloud just because those 5 1/4s are a pain in the butt...

mmerlinn likes this.
DoChenRollingBearing is offline   Reply With Quote
Old 07-05-2013, 07:11 PM   #6
PM Bug Supporter
 
DoChenRollingBearing's Avatar
 
Join Date: Oct 2011
Location: SE USA
Posts: 1,275
Liked: 691 times
...

rblong2us!

Indeed, my handwriting is pretty bad, with ease I could make it nearly indecipherable too!

DoChenRollingBearing is offline   Reply With Quote
Old 07-05-2013, 08:10 PM   #7
Ground Beetle
 
Join Date: Oct 2011
Location: Here, There, and Everywhere
Posts: 633
Liked: 388 times
Originally Posted by DoChenRollingBearing View Post:
...

mmerlinn...

Don't start working up in The Cloud just because those 5 1/4s are a pain in the butt...

Not me. I don't trust my junk out where others can mess with it.
__________________
If you keep doing what you are doing, You will keep getting what you are getting.
If you don't like what you are getting, You must change what you are doing.


http://mmerlinn.com

GOLD is the money of KINGS.
SILVER is the money of GENTLEMEN.
BARTER is the money of PEASANTS.
DEBT is the money of SLAVES.
- Norm Franz
mmerlinn is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 07:57 PM.


Powered by vBulletin® from Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.6.0 PL2 ©2011, Crawlability, Inc.
Content of PMBug.com copyright © 2011 - 2019 Measuring Up. All Rights Reserved.