4 Replies Latest reply on Jan 22, 2009 10:03 AM by Joel_Pointon

    Database Questions

    tomthompson1945

       

      Hello

       

       

      i have begun tinkering with Veysys and i find that some of the import options are "ACES" format and a few others that I never heard of.

       

       

       

       

       

      What isthe ACES format? I have searched and searched and cant find anything related to that format.

       

       

      Also what is the Veysys database ? Oracle? some kind of SQL?

       

       

       

       

       

      We have about 700 parts to import , but doing this one at a time seems insane.

       

       

       

       

       

      Any info or suggestions would be helpful

       

       

       

       

       

      Thanks  Tomm  

       

       

        • 1. Re: Database Questions
          Joel_Pointon

           

          Hi,

           

           

          ACES was a format of database used by CADDS5 by Land Rover, MG Rover, Leyland Trucks and some of their Wire Harness suppliers.  It is a delimited text file format but the data it stores in limited compared to VeSys.  Do you have a sample of the data you want to import?  Sometimes importing data is actually slower that adding it in, although this seems a strange statement to make it is because importing data has a couple of downsides.   We did some work with one customer to import data, it turned out that there data was much more than a list of part numbers with descriptions what this meant is that every component needed to be manually checked and terminals/seals assigned after import.  It would have been quicker to manually enter the data as the 'Add similar' functionality could have been used to create whole families/ranges of connectors.

           

          1. There is no check on the quality of data being added, for example 2 connectors of the same family/type may have different terminals assigned.

          2. You will not be able to use the 'Add Similar' functionality, this is a fast way of duplicating components that are similar.

           

          • 2. Re: Database Questions
            Joel_Pointon

             

            Hi,

             

             

             

             

             

            I should have pointed out that we've done a lot of work with the ACES format and understand it so we can theoretically convert data to ACES format in order to import into VeSys.

             

             

            • 3. Re: Database Questions
              tomthompson1945

               

              Thank you for the information. We have started to manually input the connectors into the database. its not tooo painful

               

               

               

               

               

               

               

               

               

               

               

              Regaurds

               

               

              Tomm Thompson 

               

               

              • 4. Re: Database Questions
                Joel_Pointon

                 

                I'd recommend you start with the commonly used families/ranges of connectors because you can use the 'Add Similar' functionality to speedily create a whole group of connectors.  Also you kind of start in reverse order setting up Terminals, Seals and Additional Parts before you add a Connector...I'm sure you've already know this if you've done a few  :).

                 

                 

                One other approach is to put a few commonly used parts in the database then start creating harnesses, as you create your first harness you may need to add 90% of the parts to the database, on the second drawing this may drop to 60%, you'll find the quantity of new additions to the database rapidly decreases.

                 

                 

                Hope this helps.