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

OK..NEWBIE HERE...trying to A5 from A4V7

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

  • OK..NEWBIE HERE...trying to A5 from A4V7

    Well hello all. I am certain you will all laugh and grimace as you read this but....here it goes.
    Husband's company (consists of only 3 employees - 1 office, 2 forklift operators) had the A4 setup by a person who no longer here. I am computer literate but NOT database literate. We do not recognize a profit to us in this company but do keep 3 employeed in the small community. I know THAT info does not means nothing to noone but us. We have NO money to hire someone to help us get A4 to A5 (SO we are relying on my NON database skills to make this happen). We have to buy new computer which is why we are needing A5. I am literate with Excel - but only dabble once/twice in databases.
    THAT being said...I attempting to "create a test A5 of our business" here at home to "get it just right" before the old computer totally crashes and we are without any backup. Testing on my home computer because it has Vista (new one we ordered is Vista). I copied the dbf files from the A4V7 into the same folder that A5 is found. I have already opened A5 created a blankdatabase and added all the dbf files as tables. NOW I AM STUCK.

    What on earth do I do next? I know how all the menus appear on the old, how all the menus acted on the old....but I AM LOST as to what to do, in which step, in order to make the menu (and its actions) happen here in the new!!!

    I have read alot thru the threads, other's woahs - and worked with this 8 hours on Weds, 15 hours yesterday, and now 5 hours today...feel as if I am going around in circles. HELP?????? Just what can I do to get ONE of the old menu options to work like did on the old......If only???

  • #2
    Re: OK..NEWBIE HERE...trying to A5 from A4V7

    What version of A5 are you trying to move to? I believe A5V8 is the first Vista compatible.
    There can be only one.

    Comment


    • #3
      Re: OK..NEWBIE HERE...trying to A5 from A4V7

      a5 V9

      Comment


      • #4
        Re: OK..NEWBIE HERE...trying to A5 from A4V7

        I have the dbf files in the same folder as A5V9, I opened the program, looked at the tutorial briefly, looked at the existing database - the promptly created a blank database named it TCS, then added the tables to the new TCS database. That is as far as I have gotten. From getting the dbf files into the TCS database - I began to "study" how the old A4V7 menu worked, didn't work - looked into how he configured things, he has A LOT of macros written to do many of the stuff we just clicked on the menu to accomplish.

        I have taken the 5 hour tutorial online at Alpha - but still stumbling on my processes or my first step to actually work on. I just am not sure "in what order" to do things (knowing that the tables will need to have some fields set with parameters and properties, knowing the "old menu" driven creature we had in dos will need reconstructed (and see all his macros I am not certain I will be able to KNOW the precise item to choose for the tables in order for all to go smoothly).

        Comment


        • #5
          Re: OK..NEWBIE HERE...trying to A5 from A4V7

          There are no macros in A5. Specifically, what would you like to do?
          Peter
          AlphaBase Solutions, LLC

          Peter@AlphaBaseSolutions.com
          https://www.alphabasesolutions.com


          Comment


          • #6
            Re: OK..NEWBIE HERE...trying to A5 from A4V7

            well I have gotten familiar with creating the BASIC form. Now I am attempting to make the NewInput form work as it did in the A4v7 (disregarding the fact I know I will have to go back an create the Menus that were before - just for sanity's sake I will work on 1 thing at a time).

            Ok, this is how A4V7 Input acted:

            We would choose Enter New Load from the menu, which took us to the Storage entry form.
            1. The first box defaulted in "A" for active (that later would automatically be moved/place into the LotHead.dbf )
            2. next Box Defaulted Age (000) for days in the cooler (later this same form return info based on the Calendar date received to number of days in the cooler - fee charge the client ea month in storage). Rec date entry later in form.
            3. Customer #- selected from drop down box which populated into the box for select. Drop down list taken from the customer.dbf file (would not let you leave this box blank, manditory entry)
            4. customer name (once choose in 3,then box 4 showed the name of the customer)
            5. Lot#- manditory number to be entered and will not allow to go to next box without data entry (BUT NOT auto increment, we assigned the number due to type of product - where place etc, this part can not be automated must be chosen by the office personnel entering info).
            6. product - drop down list populated from the product.dbf , manditory entry will not go on with entry.
            7. product type - automatically entered/returned info when chosen in box 6
            8. storage - defaulted "Cold" automatically, no entry required but did have to enter to move onto the next box
            9. Cooler - this was one header for 3 cells(sorry using wrong terminology but similar to that) of entry, manual entry for each cell, each (1) character entry populated drop down selections - but none of the 3 cell drop downs were populated by a database but must have been written into code somewhere. the first cell drop down was numbered between 1-12 (representing the cooler number) and a Header would also show to tell the person what they were choosing - this one said Cooler, next cell drop down was "N,S,E,W", with a Header that said Location, next cell was header Position with drop down choices of "F,C,B".
            10. Temp - manual entry, no drop down. This was designated on the BL from the driver as to the temperature the product to be stored (a prompt showed the person "Enter Cooler Temperature. (10-80)".
            11. Received- Today's system date would automatically drop into this screen, but someone could override this info if they were entering something delivered day before but after she left for the day and fork operators took the load anyway). Once the date populates in and person hits enter, then the "Calendar" would popup (the calendar is it's own database, used to track when received due to the predesignated Calendar week of the year , begin week of month - used as a tool later for monthly billing - this popup is used to verify the date received is accurate to the calendar week of the predefined calendar). If accurate person hits enter and populates into the appropriate boxes Acct, Week, Month, Year - if inaccurate person needs to select correct week from popup then hit enter.
            12. Pallets- manual entry, number of pallets taken from paperwork
            13. Pallet weight- manual entry, taken from paperwork
            14. containers-manual entry, taken from paperwork
            15. net weight-manual entry, taken from paperwork
            16. tare weight-manual entry, taken from paperwork
            17. gross weight- automatically adds up all the weights and returns the value (person entering is to double check the figure on screen to the paperwork)
            18. Loc#- manual entry, taken from paperwork (I am going to add drop down for this). This number is tied to plant.dbf (why no dropdown not sure) but once choose plant hit enter then the plant location Name, City, State defaults in (to allow person to verify correct loc number chosen).
            19. BL#- manual entry (bill of lading number)
            20. SM#- manual entry (sales manifest)
            21. Carriers - drop down, tied to carriers.dbf (choose the company who delivered the product) will allow manual entry without the drop down
            22. Mfg Date1: manual entry, date product produced (may have 2 dates in which case you used both lines Mfg 1 & 2)
            23. Mfg Date2: manual entry, date product produced (if 2 date listed on paperwork). if no second date can leave blank by hitting enter.
            24. Note: area to leave a special notation , 2 lines for memo.
            25. Once you hit enter for box 24, then a WARNING popup will present itself....the warning is Save the RECORD or Continue to adjustments (with two separate buttons listed below it, 1 for SAVE, 1 for Continue) If everything is correct one would hit enter here (since Save was the defaulted preselected button) . 3 beeps sound, then it "posts" or puts the information into the lothead.dbf database. If incorrect one could hit escape and arrow around to make the changes. If need to make adjustments then one would click on Continue.

            At ANY time someone was in this form, the person could hit escape, and it would popup a prompt to say "Are you sure you want to lose all changes to this record : YES NO. This is a great feature for them to have.

            NOW this is just the Inbound input, there is a whole process that goes into the Shipped input. If I get an idea how to do the above, I may be able to figure out the Shipped Form. (one step at a time......). ALL this is long winded, I know - but this is where I am, where I am at in the process. Thank you for asking and any help you give me (I am saying in advance).

            Penny

            Comment


            • #7
              Re: OK..NEWBIE HERE...trying to A5 from A4V7

              Penny:

              I have converted dozens of applications in Alpha Four to Alpha Five.

              I am assuming your Alpha Four Application works fairly well, and is constructed fairly well, or you wouldn't still be using it.

              Here's what you first need to keep in mind.

              1) Marking records in Alpha Four was a common way of filtering records for tasks. Alpha Five will hide all marked records from you, making them deleted.

              2) You MUST use the a4 document tool to print every dbf (include field rules), every set (include field rules), every script involved in your application, and also print the application menu structure, too.

              Using the menu structure printout, highlight the tables and scripts that are actually used in the application.

              3) Now, you can add the tables in use to the New Alpha Five database. Recreate the sets from your set printouts.

              4) Remember that sets and tables in Alpha Four could have different field rules.

              5) Begin reproducing your field rules, then create your forms, browses, reports, labels.

              6) Create your scripts.

              7) Create your application menu.

              The advantage of Alpha Five is having control yourself. If you need online tutoring to get you up and running, please let me know. A few online lessons will get you up to speed quickly.

              Comment


              • #8
                Re: OK..NEWBIE HERE...trying to A5 from A4V7

                Penny:

                I have converted dozens of applications in Alpha Four to Alpha Five.

                I am assuming your Alpha Four Application works fairly well, and is constructed fairly well, or you wouldn't still be using it.

                Here's what you first need to keep in mind.

                1) Marking records in Alpha Four was a common way of filtering records for tasks. Alpha Five will hide all marked records from you, making them deleted.

                2) You MUST use the a4 document tool to print every dbf (include field rules), every set (include field rules), every script involved in your application, and also print the application menu structure, too.

                Using the menu structure printout, highlight the tables and scripts that are actually used in the application.

                3) Now, you can add the tables in use to the New Alpha Five database. Recreate the sets from your set printouts.

                4) Remember that sets and tables in Alpha Four could have different field rules.

                5) Begin reproducing your field rules, then create your forms, browses, reports, labels.

                6) Create your scripts.

                7) Create your application menu.

                The advantage of Alpha Five is having control yourself. If you need online tutoring to get you up and running, please let me know. A few online lessons will get you up to speed quickly.

                Comment


                • #9
                  Re: OK..NEWBIE HERE...trying to A5 from A4V7

                  Ahem. Penny, thank you for being so specific, BUT. Perhaps I should have said, tell us one specific thing you would like to do. Your detailed description is a little overwhelming, and w/o the context of the actual db, not particularly helpful. I suggest that you ask a specific question on one specific task, not give us a whole process to resolve.

                  Also, check out this thread:
                  http://msgboard.alphasoftware.com/al...ad.php?t=77309
                  Peter
                  AlphaBase Solutions, LLC

                  Peter@AlphaBaseSolutions.com
                  https://www.alphabasesolutions.com


                  Comment


                  • #10
                    Re: OK..NEWBIE HERE...trying to A5 from A4V7

                    Craig:
                    A4 worked fine(for what we did). We need new computer or would not do this. I did not setup A4 nor familiar with it (trying to understand it and A5 but decided concentrate learning A5 soley to ease confusion). That being said........your suggestions below that I am unsure what/how to do:

                    2) You MUST use the a4 document tool to print every dbf (include field rules), every set (include field rules), every script involved in your application, and also print the application menu structure, too. Using the menu structure printout, highlight the tables and scripts that are actually used in the application.

                    All that I did was find all the dbf files in A4 and copied them into the A5 directory. Everything I read on the Alpha forum stated all the other files were not "usable" in A5. How will I find the scripts?

                    Guess I am jumping the gun since I started to create the input form before I created any sets (if this has sets). I just do not know.

                    Sorry, I had such confidence in myself yesterday but today I just feel that I am over my head.

                    Comment


                    • #11
                      Re: OK..NEWBIE HERE...trying to A5 from A4V7

                      Peter
                      sorry for so much detail. Over zealous I guess. After reading what you have stated as well as what Craig has stated ....I feel perhaps that I may have gotten off on the wrong foot with regard to what to do first.

                      You mentioned: "Your detailed description is a little overwhelming, and w/o the context of the actual db, not particularly helpful." I am confused as to what you mean by the content of the database?

                      As I replied to Craig - I was confident with this yesterday, but now today I just feel I am in too deep. I worked within my husband's company as the 1 office personnel so I understand the all the steps for all the "things" we used A4 to work the inventory (be it new input, be it to take out of inventory, be it to create reports, be it to clean up history/maintenance). HOW A4 did all this I do not know since I did not develope it. We have since moved to another state so now work my day job only to come home to attempt to "recreate" the A4 into A5 to save the company. If we could I would hire someone we would, but as I mentioned earlier we can not afford to do so (current economy can be thanked for that).

                      I just need to gain my confidence back...but fear I am going to just waste my time only to find that I did a step in the wrong order and then just have to start over.

                      Comment


                      • #12
                        Re: OK..NEWBIE HERE...trying to A5 from A4V7

                        Penny:

                        We were all over our heads in the beginning. You are in good company.

                        So, are you saying you don't know Alpha 4 development? That makes for a very steep learning curve...

                        My earlier response to you is basically saying that, if you have A4 working, you have a framework to follow in designing your A5 counterpart. There will be many, many opportunities to enhance the new application in Alpha Five, but that's icing on the cake.

                        Given your timeline, the steps stated above are your best choice.

                        The A4 documentor is in the Alpha 4 directory. It is called A4Doc.exe. It is a tool to print your application out. By printing it, you have everything you need on paper to reproduce the app in A5.

                        Print everything, one at a time. Staple the pages for each table, set, etc. together, and group them together alphabetically.

                        If you want help from the users here, I think you'll need to post one question at a time, each in a new thread. There is no way anyone can help you with the info above. It is too much information.

                        One last thing, A4 used macros. A5 is scripting, or more commonly, code. A macro is recorded as clicks on the keyboard. For example CO triggers Change, the Open on the A4 main menu.

                        This said, you will need to be able to open and work on A4 while you are transitioning this to A5. You will need to open an offline version of your application to step through the old macros to see what they are actually doing.

                        I will not kid you. This will be a challenge for you. I do not frequent this board much, anymore, but I saw your thread and figured I'd give you the basic steps I used to rewrite apps.

                        I think you can do this; the huge post above indicates the stamina required, and the understanding of both the business itself, and the procedures set in the A4 application. But I doubt you can do this in this short a window of time.

                        Comment


                        • #13
                          Re: OK..NEWBIE HERE...trying to A5 from A4V7

                          thank you all for your kindness: it will be daunting, but I have to do this - no other solution...

                          OK...I have remote access to the current working files on the company computer (I do not have it working here on my local computer). Tried to get it working but his bat file must be running soemthing that I do not have on my local). IN any event I have remote access to the file (and tend NOT to make any changes to the live files, more like extract info). I zipped the entire directory from their computer and unzipped it on my computer but it still does not work properly. I can, however, look at their A4Doc.exe, printscreen, then have the image of the info on this end to "staple" together. It will be more labor intensive but shall work non the less. That is what I am going to do first.

                          As for the MANY steps asked in the HUGE post above (again sorry) but I will heed the advise that both of you gave me - - 1 question at a time. I have found, though, to NOT give the big picture and only a small portion sometimes defeats the whole. I merely gave TOO much. I shall prevail - I have to.

                          Comment


                          • #14
                            Re: OK..NEWBIE HERE...trying to A5 from A4V7

                            Originally posted by Penny View Post
                            I am confused as to what you mean by the content of the database?
                            IOW, your steps are indeed very specific, so specific that w/o seeing the original A4 db, it's difficult, if not impossible, to understand.

                            Look at the sample A5 Sports db that comes w. Alpha. Maybe that will give you some ideas.
                            Peter
                            AlphaBase Solutions, LLC

                            Peter@AlphaBaseSolutions.com
                            https://www.alphabasesolutions.com


                            Comment


                            • #15
                              Re: OK..NEWBIE HERE...trying to A5 from A4V7

                              Peter - thanks, I see that I need to back up about 100 steps to do more BEFORE I get to the form step. Thank you for your help and I have indeed looked at the A5 Sports "sample" company - it does indeed give direction and step by steps. I need to first get back to even more of the basics before I tackle the form (I can see now). Your guidance has been MOST helpful. If I get past the "stuctural" steps, the relational steps, the set steps - then I will get back to the forms and perhaps "ask" one step at a time the questions (if I can not get it from the tutorial or sample database). I see that I really should just "get" a handle on it - knowing NOW it will be even more involved than I ever imagined.

                              Comment

                              Working...
                              X