Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Encrypt CSV file?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    #16
    Re: Encrypt CSV file?

    No Keith, I did not make that assumption.
    If the csv file is encrypted by Windows 7, the user will not need PGP.
    If the user will use PGP, then encrypt it on your machine using PGP.

    Comment


      #17
      Re: Encrypt CSV file?

      Keith, as I have a bit more info following our telecon, the issue seems to be the transmission of Credit Card data to a processing company?

      A few issues here if you need to handle it all yourself at your end.
      If you do, then you will need a way of validating the CC number (checksum etc) without that info being available to the user, and the encryption key being a common test key between you and the processing company.
      At some point the data will need to be entered but using WAS it should be easily hideable.
      If you choose the DIY route, then you will need some embedded software to manage the transaction processing, and there must be some out there to work with DBF's. (Presumption).

      The easiest way is to use something like PayPal and instead of worrying about the processing at your client's end, just take the money.
      See our Hybrid Option here;
      https://hybridapps.example-software.com/


      Apologies to anyone I haven't managed to upset yet.
      You are held in a queue and I will get to you soon.

      Comment


        #18
        Re: Encrypt CSV file?

        Hi Jenny,

        Thanks for your input regarding the CSV file. This is not the same file that is downloaded from the web site, but a new one that is to be processed by the credit card handling company. Storing are stepping up their data security and need to encrypt the exported credit card file before it is uploaded. The idea is that it must not be able to be read either on or off the local machine. I do appreciate you mentioning the other software company, nobody could remember anything about it.
        Regards
        Keith Hubert
        Alpha Guild Member
        London.
        KHDB Management Systems
        Skype = keith.hubert


        For your day-to-day Needs, you Need an Alpha Database!

        Comment


          #19
          Re: Encrypt CSV file?

          Keith -

          There are numerous ways to encrypt a file. You will need to converse with the receiver regarding which method of encryption will be used and how the key will be created and shared. Once you know that then you can start working on how to encrypt the file. However without that information all we can do is take the shotgun approach to help you solve this issue.

          Remember encryption only protects the data in transit.
          Andrew

          Comment


            #20
            Re: Encrypt CSV file?

            Hi Andrew,

            Thanks for joining in this thread, I did mention in message #15 that PGP was going to be used.

            I need to understand how to make that work, can you help?
            Regards
            Keith Hubert
            Alpha Guild Member
            London.
            KHDB Management Systems
            Skype = keith.hubert


            For your day-to-day Needs, you Need an Alpha Database!

            Comment


              #21
              Re: Encrypt CSV file?

              Reading the PGP blurb Keith, it offers whole disk encryption or specific file encryption.
              If you and the receiving company use the same encryption key, then the data should be secure when the CSV is created on your system, and also during transit.
              As Andrew mentioned, the data in Alpha will need to be considered and how you will be able to lock it down.
              Opening and then locking the table between Data Write might work, and then you would have to run the process to create the CSV file in the same way.
              You probably need an evaluation copy of Symantec's PGP and try a few scenarios.
              It's �111.00 so it won't break the bank.
              See our Hybrid Option here;
              https://hybridapps.example-software.com/


              Apologies to anyone I haven't managed to upset yet.
              You are held in a queue and I will get to you soon.

              Comment


                #22
                Re: Encrypt CSV file?

                you may use axcrypt? it can decrypt on the fly (with STORED key information on both sides) - can't be decrypted without the FILE(key)
                just have to encrypt on one end have have it SAVE the information on the machine, file opens as normal just by opening it, if the information is stored on both machines.

                I've used it from time to time, but no expert

                Comment


                  #23
                  Re: Encrypt CSV file?

                  Hi Jeff,

                  Thanks for the suggestion. axcrypt cannot be run from within Alpha, which means the csv file is available to the user before encryption.
                  Regards
                  Keith Hubert
                  Alpha Guild Member
                  London.
                  KHDB Management Systems
                  Skype = keith.hubert


                  For your day-to-day Needs, you Need an Alpha Database!

                  Comment


                    #24
                    Re: Encrypt CSV file?

                    you can make the KEY a registry entry? and delete the key from within alpha?
                    then you just open the file as usual (if alpha can read/write registry and SHELL to hidden cmd prompt)?

                    Comment


                      #25
                      Re: Encrypt CSV file?

                      http://en.wikipedia.org/wiki/Pretty_Good_Privacy

                      Compatibility
                      As PGP evolves, PGP systems that support newer features and algorithms are able to create encrypted messages that older PGP systems cannot decrypt, even with a valid private key. Thus, it is essential that partners in PGP communication understand each other's capabilities or at least agree on PGP settings.
                      Also available are PGP Command Line, which enables command line-based encryption and signing of information for storage, transfer, and backup
                      You would be using the Command Line portion of the PGP package. Again I stress that this will only protect the data during transit. You will need to develop a method of securing the data on your end prior to encryption. The receiver will be responsible for securing the data after decryption.
                      Andrew

                      Comment


                        #26
                        Re: Encrypt CSV file?

                        Keith
                        Could this Scenario work for you ?
                        1, You encrypt the text to write to the CSV from within Alpha with Xbasic code
                        2. The recipient has a standalone EXE (that can be linked to a diff filetype called when the file is clicked). The EXE takes care of decription

                        I dont know the products named in the thread but if you devise the schema and how a new decodeword (my own word for the day) can be sent to the recipent it would be easy-ish for me and probably many others here, or you maybe, to write the decryptronite (another new word) program for you -according to the rules you applied in the xbasic part.
                        postscript:
                        I'm talking about string manipulation, character transposition, concatenation etc based on a code-word of some length
                        Last edited by Ray in Capetown; 07-19-2012, 01:10 PM. Reason: postscript

                        Comment


                          #27
                          Re: Encrypt CSV file?

                          Keith,

                          Why can't you run Axcrypt from within Alpha??
                          Gary S. Traub, Ph.D.

                          Comment

                          Working...
                          X