22 Replies Latest reply on Apr 20, 2009 2:00 PM by Albert S.

    when new record added create data from id and static information

      Hi, I have a datbase tabe like this:

       

      CREATE TABLE `paper` (
      `id_paper` INTEGER(11) NOT NULL AUTO_INCREMENT,
      `sample_url` VARCHAR(50) COLLATE utf8_general_ci NOT NULL DEFAULT '',
      PRIMARY KEY (`id_paper`)

       


      When I add new record I need the field "sample_url" to automatically add this information:

       

      images/15_sample.jpg.

       

      images - is subfolder where my images are stored
      15 - is id_paper (new primary autonumber ID)
      _sample.jpg - is static and should be added.

       

      I use adobedeveloper toolbox to generate the code with minor editing, I'm not php guru either.

      I retrieve my data like this:

       

      SELECT
      paper.id_paper,
      paper.sample_url,
      concat('<img src=images/', sample_url, ' ' 'width="66" height="174" />') AS sample
      FROM
      paper

       

      I use this code to add fields:

       

      // Add columns
      $ins_paper->setTable("paper");
      $ins_paper->addColumn("sample_url", "STRING_TYPE", "POST", "sample_url");
      $ins_paper->setPrimaryKey("id_paper", "NUMERIC_TYPE");

       

      This is php for the text box:

       

      <tr>
      <td class="KT_th"><label for="sample_url">sample_url:</label></td>
      <td><input type="text" name="sample_url" id="sample_url" value="<?php echo KT_escapeAttribute($row_rspaper['sample_url']); ?>" size="32" />
      <?php echo $tNGs->displayFieldHint("sample_url");?> <?php echo $tNGs->displayFieldError("paper", "sample_url"); ?> </td>
      </tr>

       


      What do I need to change?

       

      I think in this line here:
      <td><input type="text" name="sample_url" id="sample_url" value="<?php echo KT_escapeAttribute($row_rspaper['sample_url']); ?>" size="32" />
      I need to add some php code to get the ID of primary key and my static text too, but how?

        • 1. Re: when new record added create data from id and static information
          DwFAQ Level 4

          Change This:

           

          <tr>
          <td class="KT_th"><label for="sample_url">sample_url:</label></td>
          <td><input type="text" name="sample_url" id="sample_url" value="<?php echo KT_escapeAttribute($row_rspaper['sample_url']); ?>" size="32" />
          <?php echo $tNGs->displayFieldHint("sample_url");?> <?php echo $tNGs->displayFieldError("paper", "sample_url"); ?> </td>
          </tr>

           

           

           

          To this:

           

           

          <input type="hidden" name="sample_url" id="sample_url" value="images/<?php echo KT_escapeAttribute($row_rspaper['id_paper']); ?>_sample.jpg" />

          1 person found this helpful
          • 2. Re: when new record added create data from id and static information
            Level 1

            I changed the code like you say and I got this:

             

            images/_sample.jpg

             

            The id is not added. The code:

             

            <?php echo KT_escapeAttribute($row_rspaper['id_paper']); ?>

             

            does not pass the id.

            • 3. Re: when new record added create data from id and static information
              Albert S. Level 3

              Hi akieru,

               

              If I understand you correctly you are trying to get the id of id_paper before it has actually created that record. In short the next available number.

              If you create a recordset that gets the last number you can simply add 1 to it.

               

              Recordset example:

              mysql_select_db($database_db, $db);
              $query_Recordset1 = "SELECT id_paper FROM `paper` ORDER BY id_paper DESC";
              $Recordset1 = mysql_query($query_Recordset1, $db) or die(mysql_error());
              $row_Recordset1 = mysql_fetch_assoc($Recordset1);
              $totalRows_Recordset1 = mysql_num_rows($Recordset1);

               

              $idnewpapervalue = $row_Recordset1['id_paper'] +1;

               

               

              Input form:

              <input type="hidden" name="sample_url" id="sample_url" value="images/<?php echo $idnewpapervalue; ?>_sample.jpg" />

              • 4. Re: when new record added create data from id and static information
                Level 1

                I have made a php page with dreamweaver then added the insert into two tables form that inserts data into master table "paper" and slave table "paper_data"

                 

                my first table looks like I have posted on my 1st post:

                 

                CREATE TABLE `paper` (
                `id_paper` INTEGER(11) NOT NULL AUTO_INCREMENT,
                `sample_url` VARCHAR(50) COLLATE utf8_general_ci NOT NULL DEFAULT '',
                PRIMARY KEY (`id_paper`)

                 

                2nd table:

                 

                CREATE TABLE `paper_data` (
                  `id_paper_data` INTEGER(6) NOT NULL AUTO_INCREMENT,
                  `id_paper` INTEGER(6) NOT NULL,
                  `nanometer` INTEGER(5) NOT NULL,
                  `value` DOUBLE(8,4) NOT NULL,
                  `value_uv` DOUBLE(8,4) NOT NULL,
                  PRIMARY KEY (`id_paper_data`)

                 

                The page very complex as I have 36 fields for value and 36 fields for value_uv. Then another set of fields for master table. I have customized the page to make singe record entry to my master table and then enter all 36+36 fields as slave fields entering the correct foreign key. It works fine in browser, but very slow in dreamweaver.

                 

                I customised it like here: http://forums.adobe.com/message/1070477#1070477

                 

                Your method did not work because the field "id_paper" in this code <?php echo KT_escapeAttribute($row_rspaper['id_paper']); ?> is not a text box field on the page. It is primary key incremented by mySQL. So the code can't find a field named "id_paper" and value is not entered. I could be worng.

                 

                But somehow the page assigns the correct id to my slave records on second table? (pass the primary key as foreign key to second table) Can't I use this to add a prefix to my "_sample.jpg."? But I don't know how to get this information.

                 

                Thanks.

                • 5. Re: when new record added create data from id and static information
                  Level 1

                  Replaced my text box field code to:

                   

                   

                  Input form:

                  <input type="hidden" name="sample_url" id="sample_url" value="images/<?php echo $idnewpapervalue; ?>_sample.jpg" />

                   

                  Found some recordset code and added this line ($idnewpapervalue = $row_rspaper['id_paper'] +1;)    here:

                   

                  // Get the transaction recordset
                  $rspaper = $tNGs->getRecordset("paper");
                  $row_rspaper = mysql_fetch_assoc($rspaper);
                  $totalRows_rspaper = mysql_num_rows($rspaper);

                   

                  $idnewpapervalue = $row_rspaper['id_paper'] +1;

                   

                  // Get the transaction recordset

                  $rspaper_data = $tNGs->getRecordset("paper_data");
                  $row_rspaper_data = mysql_fetch_assoc($rspaper_data);
                  $totalRows_rspaper_data = mysql_num_rows($rspaper_data);

                   

                  Now I get this inseted: images/1_sample.jpg

                  • 6. Re: when new record added create data from id and static information
                    Albert S. Level 3

                    Hi Akieru,

                     

                    I understand that your form works fine entering data into both tables. Only that you want to enter information into the sample url that contains the primary id of the table id_paper into the sample_url field.

                     

                    If that is the case leave your page as is, go to Server Behaivors->Developer Toolbox->Forms->Custom Triggers then add this custom trigger:

                     

                    $samplevalue = "_sample.jpg";
                    $query = "UPDATE `paper` SET sample_url = '".KT_escapeForSql($tNG->getPrimaryKeyValue(), $tNG->getColumnType($tNG->getPrimaryKey())).$samplevalue."' WHERE id_paper = ".$tNG->getPrimaryKeyValue();
                    $update_result = $tNG->connection->execute($query);
                    if(!$update_result) {
                    $updateError = new tNG_error("Error setting the initial paper ID".$query,array(),array());
                    return $updateError;
                    } else {
                    return NULL;
                    }

                     

                    What this does is after the initial insert that your form does it will go back and update the sample_url field with "primaryid_sample.jpg".

                    This line here is the added value to the primary id:

                     

                    $samplevalue = "_sample.jpg";

                    ---

                     

                    This line here from the custom trigger is the line that contains the SQL update query.

                     

                    $query = "UPDATE `paper` SET sample_url = '".KT_escapeForSql($tNG->getPrimaryKeyValue(), $tNG->getColumnType($tNG->getPrimaryKey())).$samplevalue."' WHERE id_paper = ".$tNG->getPrimaryKeyValue();

                    ---

                     

                    This line executes the query:

                     

                    $update_result = $tNG->connection->execute($query);

                    ---

                     

                    This line here is for error checking.

                     

                    if(!$update_result) {
                    $updateError = new tNG_error("Error setting the initial paper ID".$query,array(),array());
                    return $updateError;
                    } else {
                    return NULL;
                    }

                    • 7. Re: when new record added create data from id and static information
                      Level 1

                      "I understand that your form works fine entering data into both tables. Only that you want to enter information into the sample url that contains the primary id of the table id_paper into the sample_url field."

                       

                      Yes you are correct. My form works fine and I want to insert or should I say update the field sample_url in my master table "paper" with id that new record got when inserted.

                       

                      I have added your custom trigger to my page.

                       

                      Then I have tried to use my original text box field code:

                       

                      <tr>
                                      <td class="KT_th"><label for="sample_url">sample_url:</label></td>
                                      <td><input type="text" name="sample_url" id="sample_url" value="<?php echo KT_escapeAttribute($row_rspaper['sample_url']); ?>" size="32" />
                                          <?php echo $tNGs->displayFieldHint("sample_url");?> <?php echo $tNGs->displayFieldError("paper", "sample_url"); ?> </td>
                                    </tr>

                       

                      I get nothing inserted or added except the value I enter into text box field.

                       

                      and modified code:

                       

                      <tr>
                                      <td class="KT_th"><label for="sample_url">sample_url:</label></td>
                                      <td><input type="hidden" name="sample_url" id="sample_url" value="images/<?php echo $idnewpapervalue; ?>_sample.jpg" />
                                          <?php echo $tNGs->displayFieldHint("sample_url");?> <?php echo KT_escapeAttribute($row_rspaper['id_paper']); ?> </td>
                                    </tr>

                       

                      This time I get the same as before, images/_sample.jpg inserted. But the field is hidden and that is the way I like it. I fthe field is not hidden then the user can override the text that gets inserted.

                      • 8. Re: when new record added create data from id and static information
                        Albert S. Level 3

                        Hi,

                         

                        Well the modified code is irrelevent at this point. The custom trigger should do the trick. Testing here on my test server it worked fine. So there must be something small missing. I was even going to the extent of adding nothing to the sample_url field and it was still populating the db properly.

                         

                        These were my registerTriggers


                        $ins_paper->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
                        $ins_paper->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $masterValidation);
                        $ins_paper->registerTrigger("END", "Trigger_Default_Redirect", 99, "paper.php?done");
                        $ins_paper->registerTrigger("AFTER", "Trigger_LinkTransactions", 98);
                        $ins_paper->registerTrigger("ERROR", "Trigger_LinkTransactions", 98);
                        $ins_paper->registerTrigger("AFTER", "Trigger_Custom", 50);

                         

                        Perhaps you can post a txt file with the ADDT code?

                        I really believe at this point it's something small.

                        • 9. Re: when new record added create data from id and static information
                          Albert S. Level 3

                          Hi,

                           

                          To help you futher, This is where I got the answer.

                           

                          http://help.adobe.com/en_US/Dreamweaver/10.0_ADDT/

                           

                          Go down to "Custom transactions and triggers" then to "Use transaction fields"

                           

                          This explains setting up a query within a custom trigger.

                           

                          Your goal is update the 2 tables then have the custom trigger run after and update the db field.

                           

                          This way if you come up with the solution yourself you have all the satisfaction.

                          • 11. Re: when new record added create data from id and static information
                            Level 1

                            It seems I or ADDT forgot to register the trigger:

                             

                            Adding this line to register triggers fixed it:

                             

                            $ins_paper->registerTrigger("AFTER", "Trigger_Custom", 98);

                             

                            Also I would like to ask what number 98 means should I change it to 50 like in your post?

                             

                            I also got it working another way and would like to know what is better, see code below:

                             

                            I was able to make it work by adding this code:

                             

                            Original code:

                             

                            // Get the transaction recordset
                            $rspaper = $tNGs->getRecordset("paper");
                            $row_rspaper = mysql_fetch_assoc($rspaper);
                            $totalRows_rspaper = mysql_num_rows($rspaper);

                             

                            // Get the transaction recordset
                            $rspaper_data = $tNGs->getRecordset("paper_data");
                            $row_rspaper_data = mysql_fetch_assoc($rspaper_data);
                            $totalRows_rspaper_data = mysql_num_rows($rspaper_data);

                             

                            Modified code with modified text box field code:

                             

                            $rspaper = $tNGs->getRecordset("paper");
                            $rspaper = "SELECT id_paper FROM `paper` ORDER BY id_paper DESC";
                            $rspaper = mysql_query($rspaper) or die (mysql_error());
                            $row_rspaper = mysql_fetch_assoc($rspaper);
                            $totalRows_rspaper = mysql_num_rows($rspaper);
                            $idnewpapervalue = $row_rspaper['id_paper'] +1;

                             

                            // Get the transaction recordset
                            $rspaper_data = $tNGs->getRecordset("paper_data");
                            $row_rspaper_data = mysql_fetch_assoc($rspaper_data);
                            $totalRows_rspaper_data = mysql_num_rows($rspaper_data);

                             

                            <tr>
                                            <td class="KT_th"><label for="sample_url">sample_url:</label></td>
                                            <td><input type="hidden" name="sample_url" id="sample_url" value="images/<?php echo $idnewpapervalue; ?>_sample.jpg" />
                                                <?php echo $tNGs->displayFieldHint("sample_url");?> <?php echo KT_escapeAttribute($row_rspaper['id_paper']); ?> </td>
                                          </tr>

                             

                            It works ok however I was puzzled about comatibility should I leave it like it is or use this instead:

                             

                            // Get the transaction recordset
                            $rspaper = $tNGs->getRecordset("paper");
                            $row_rspaper = mysql_fetch_assoc($rspaper);
                            $totalRows_rspaper = mysql_num_rows($rspaper);

                             

                            // Get the transaction recordset
                            $rspaper_data = $tNGs->getRecordset("paper_data");
                            $row_rspaper_data = mysql_fetch_assoc($rspaper_data);
                            $totalRows_rspaper_data = mysql_num_rows($rspaper_data);

                             

                            //Get the transaction recordset enter id to sample_url
                            mysql_select_db($my_MySQL, $db);
                            $rspaper = "SELECT id_paper FROM `paper` ORDER BY id_paper DESC";
                            $rspaper = mysql_query($rspaper) or die (mysql_error());
                            $row_rspaper = mysql_fetch_assoc($rspaper);
                            $totalRows_rspaper = mysql_num_rows($rspaper);
                            $idnewpapervalue = $row_rspaper['id_paper'] +1;

                             

                            Or use the trigger method?

                             

                            P.S I did have to modify the code to add images subfolder

                             

                            //start Trigger_Custom trigger
                            function Trigger_Custom(&$tNG) {
                            $samplevalue = "_sample.jpg";
                            $samplevalue2 = "images/";
                            $query = "UPDATE `paper` SET sample_url = '".$samplevalue2.KT_escapeForSql($tNG->getPrimaryKeyValue(), $tNG->getColumnType($tNG->getPrimaryKey())).$samplevalue."' WHERE id_paper = ".$tNG->getPrimaryKeyValue();
                            $update_result = $tNG->connection->execute($query);
                            if(!$update_result) {
                            $updateError = new tNG_error("Error setting the initial paper ID".$query,array(),array());
                            return $updateError;
                            } else {
                            return NULL;
                            }
                            }

                             

                            Waiting for comments and suggestions. Thanks for help.

                            • 12. Re: when new record added create data from id and static information
                              Albert S. Level 3

                              Hi Akieru,

                               

                              I would go with the trigger over the recordset +1.

                              The reason why is with the trigger it grabs the number from the whole transaction so there is no room for error. With the modified code/recordset there is little room for error but "no room" is better then "little room" The modified code/recordset looks at the database at the last record ID then add 1 to it. This works great if not many people are entering data thru your forms. But if a lot of people are entering into your forms a new entry could potentially be updated while another user is still entering in the form but taking longer to do so. Then the number that the modified code gave you is already used up.

                               

                              So lets go with the trigger.

                               

                              I will get a chance to look at your code in a couple hours.

                               

                               

                              Actually you got it working so I don't need to look at your code.

                               

                              The 98 is an order in which your triggers run. So if you have 5 AFTER triggers and wanted them in a specific order they could be 95, 96, 97, 98, 99 and they would run in that order. But note that BEFORE triggers will run before AFTER triggers and have their own order also.

                               

                              Message was edited by: Albert S.

                              • 13. Re: when new record added create data from id and static information
                                Level 1

                                Thanks for your quick reply.

                                 

                                I will have to use the trigger method then, if I want to have more fields filled this way I need to create more triggers. One for each field right.

                                Also I liked the thing that when I used the +1 method the text box field would display me next id, I could I place some text box on my form and make it do the same without it entering any information just for the user who fills the form to know what the next id will be and so the user could name the picture files correctly.

                                 

                                I was thinking to use the picture upload function in ADDT but it seems not to work right at the moment having issues with flash etc.

                                My whole idea of automated naming was that when data is exported from excel to web file. Excel creates subfolder and also exports all images. It's very easy to rename them to proper format by using bulk rename tools and upload them all at once using ftp. But if a user enters just one record it would be helpful to see what the next id will be or have possibility to browse for file and let the form handle the upload but I guess it's not easy (for me) to make either.

                                • 14. Re: when new record added create data from id and static information
                                  Albert S. Level 3

                                  Hi,

                                   

                                  If done correctly you only need one trigger for all your fields. Not one trigger for each field.

                                   

                                  In ADDT 1.0.1 update the flash uploader was fixed. I don't think I understand the whole goal you have but I've done a few things with image manipulation and folder creation, on the fly during the upload using ID's as folder names and more.

                                  • 15. Re: when new record added create data from id and static information
                                    Level 1

                                    I tried not to fill the sample_url field and gotthis error: SQL error: Column 'sample_url' cannot be null.

                                     

                                    This is because the trigger thatfill this field fires after initial insert, so mySQL complains that you can't insert null field. How do I fix this other than have it allow inserting null field? I would like to remove the field because trigger now does the filling.

                                     

                                    He is my code for multiple fields is is ok?

                                     

                                     

                                    //start Trigger_imagename trigger
                                    function Trigger_imagename(&$tNG) {
                                    $samplevalue = "images/";
                                    $samplevalue2 = "_sample.jpg";
                                    $query = "UPDATE `paper` SET sample_url = '".$samplevalue.KT_escapeForSql($tNG->getPrimaryKeyValue(), $tNG->getColumnType($tNG->getPrimaryKey())).$samplevalue2."' WHERE id_paper = ".$tNG->getPrimaryKeyValue();
                                    $update_result = $tNG->connection->execute($query);

                                     

                                    $samplevalue3 = "images/";
                                    $samplevalue4 = "_field2.jpg";
                                    $query = "UPDATE `paper` SET field2 = '".$samplevalue3.KT_escapeForSql($tNG->getPrimaryKeyValue(), $tNG->getColumnType($tNG->getPrimaryKey())).$samplevalue4."' WHERE id_paper = ".$tNG->getPrimaryKeyValue();
                                    $update_result = $tNG->connection->execute($query);

                                     

                                    $samplevalue5 = "images/";
                                    $samplevalue6 = "_field3.jpg";
                                    $query = "UPDATE `paper` SET field3 = '".$samplevalue5.KT_escapeForSql($tNG->getPrimaryKeyValue(), $tNG->getColumnType($tNG->getPrimaryKey())).$samplevalue6."' WHERE id_paper = ".$tNG->getPrimaryKeyValue();
                                    $update_result = $tNG->connection->execute($query);

                                     

                                    if(!$update_result) {
                                    $updateError = new tNG_error("Error setting the initial paper ID".$query,array(),array());
                                    return $updateError;
                                    } else {
                                    return NULL;
                                    }
                                    }
                                    //end Trigger_imagename trigger

                                    • 16. Re: when new record added create data from id and static information
                                      DwFAQ Level 4

                                      Go to phpmyadmin and set the field as NULL or add into form as a hidden field with a preset value and have trigger rewrite value. So input type="hidden" value="something" will set field with something then rewrite with trigger info.

                                      • 17. Re: when new record added create data from id and static information
                                        Level 1

                                        I have set field as allow null in my mySQL database and now everything works fine.

                                         

                                        I would like to ask for more help. I decided to make another version of the same page but to allow user to browse for image and upload it to server, then rename it to proper format store file path in database. I need to make 3 file upload fields. Each should name and store files in separate fields, but in same folder on the server.

                                         

                                        I have made a test.php page and used "multiple image upload wizard" how do I store the corrent file subfolder "images" path into my table field?

                                         

                                        This is my test code:

                                         

                                        //start Trigger_ImageUpload trigger
                                        //remove this line if you want to edit the code by hand
                                        function Trigger_ImageUpload(&$tNG) {
                                          $uploadObj = new tNG_ImageUpload($tNG);
                                          $uploadObj->setFormFieldName("Filedata");
                                          $uploadObj->setDbFieldName("firstname");
                                          $uploadObj->setFolder("images/");
                                          $uploadObj->setMaxSize(1500);
                                          $uploadObj->setAllowedExtensions("gif, jpg, jpe, jpeg, png");
                                          $uploadObj->setRename("custom");
                                          $uploadObj->setRenameRule("{id_location}_sample.{KT_ext}");
                                          return $uploadObj->Execute();
                                        }
                                        //end Trigger_ImageUpload trigger

                                         

                                        Tried to use but does not work:

                                         

                                          $uploadObj->setRenameRule("images/{id_location}_sample.{KT_ext}");

                                         

                                        I have however used custom trigger that Albert showed me to rename the path but would like to avoid using it if it is possible not to use it:

                                         

                                        //start Trigger_Custom trigger
                                        function Trigger_Custom(&$tNG) {
                                        $samplevalue = "_sample.jpg";
                                        $samplevalue2 = "images/";
                                        $query = "UPDATE `location` SET firstname = '".$samplevalue2.KT_escapeForSql($tNG->getPrimaryKeyValue(), $tNG->getColumnType($tNG->getPrimaryKey())).$samplevalue."' WHERE id_location = ".$tNG->getPrimaryKeyValue();
                                        $update_result = $tNG->connection->execute($query);
                                        if(!$update_result) {
                                        $updateError = new tNG_error("Error setting the initial location ID".$query,array(),array());
                                        return $updateError;
                                        } else {
                                        return NULL;
                                        }
                                        }
                                        //end Trigger_Custom trigger

                                         

                                         

                                         

                                        What the proper way to implement this? I think I should:

                                         

                                        1. delete the 3 text box fields I have on my form that I would like to replace with image upoad fields.

                                        2. run the "multiple image upload wizard" 3 times to make 3 separate file upload behaviors.

                                        3. remove the individual image upload buttons and make the main form submit button to work for image upload fields too.

                                         

                                        How do I make the main form "submit" button to work for iamge uploads and is it impotant how ADDT makes and orders Register triggers?

                                        • 18. Re: when new record added create data from id and static information
                                          Albert S. Level 3

                                          Hi Akieru,

                                           

                                          Why do you want to store the folder name in the db field?

                                          • 19. Re: when new record added create data from id and static information
                                            Level 1

                                            "Why do you want to store the folder name in the db field?"

                                             

                                            Because I my php file is stored in my website root folder, and I use it to enter data into my database tables, at first I decided that a user (actually myself) could use only FTP to upload images later after entering data to the database by filling the form. But then I so that it would be very helpful to be able to select the files with the browse button and allow the form to do the image uploading.

                                             

                                            I need full path stored in table because I will need to display a dynamic table with records from this table and also show an image for every record. The image will not show if the path does not include full path?

                                             

                                            Hmm...  I use third party software php report maker with this sql function concat('<img src=images/', sample_url, ' ' 'width="66" height="174" />') AS sample

                                            when I thought more about it maybe it is not required to store the folder name like you say

                                            • 20. Re: when new record added create data from id and static information
                                              Albert S. Level 3

                                              Hi,

                                               

                                              Looks like your upload script knows to upload to the image folder. The output script knows to pull from the images folder. Just wondered if you really need the folder name in the db. If later down the line you want to re-structure the folders does it sound easier to change your upload script and output script or go thru the many db entries with the folder name in it?

                                              • 21. Re: when new record added create data from id and static information
                                                Level 1

                                                I seems it is more easy to change the sql line to point to correct folder than store full path. Thanks for pointing that out

                                                 

                                                Could you help on making the upload behaviors etc.

                                                • 22. Re: when new record added create data from id and static information
                                                  Albert S. Level 3

                                                  Hi,

                                                   

                                                  Yes I can, but start a new post to better help people when searching a similar issue.