Summary

This article explains the procedure to edit existing translations, then move the edited copy to the import folder where it will be used live by the product.

More Information

1. To start, navigate to the folder that was shared with you via email.  The folder is in SharePoint, which is a part of OneDrive.  It is required that you have a OneDrive account to open the file.  When you click on the link sent to you via email, you will be directed to either sign in to OneDrive or Create an account.  The folder shared with you will be named after your company.
2. Click on the folder to open.  You should see a Development folder and a Production folder.
   
1. The Development folder is used in your development product that is used on the testing site.
   
2. The Production folder is used in your production product that is live on our Focus site or your DOS site.
   
3. 
   
3. Click the Development folder to open it.  You will see two folders:  Originals and To Import.
   
1. The Originals folder holds the translations spreadsheet that can be edited.  This is where you will edit the existing translations sheet.  
   
2. The To Import folder holds the translations spreadsheet that is currently being used by the corresponding product (development/production).
   
3. 
   
4. Click on the Originals folder to edit your translations spreadsheet. You will see your Translations file here.  Multiple products can be supported on one spreadsheet.
   
5. Click on the excel file to open.  
   
1. If you click on the file, it will open online.  This is the easiest and most efficient way to edit.
2. You can right click on the file to download, then upload back into the Originals folder when done.  If you use this method, take great care to make sure you place the file in the correct folder.
   
6. The file has 6 columns.  Please do not change the column names or the ProductName on the sheet.
   
1. ProductName column - this column is your product's name.  It has to match the product name in our system exactly, so this column should not be edited unless you are adding a new line.
   
2. StyleName column - This column will have the style name that contains the option needed to be translated. Style names in our products are usually lift systems, such as Motorized, Cordless, etc.  Again, these style names have to match exactly to what is in the product for the translation to work.  If the option to be translated is in every style, then the StyleName column can be blank.
   
3. OptionName - This column contains the option as it appears in the Solatech product.  Again, the option name must match what is in the Solatech product exactly.
   
4. TranslatedOptionName - This column contains the options as YOUR system needs to receive it.  
   
5. OptionValue - This column will contain the value for the option as it appears in the Solatech product.  If there is more than one option value that needs to be translated, each option will be on it's own line.  The option value will only be filled in if the value needs to be translated.  If it does not need translation, then this will be blank.
   
6. TranslatedOptionValue - This column will contain the value for the option that your system needs to receive.  As above, if there is more than one option value, they will go on separate lines.  The TranslatedOptionValue column could contain word IGNORE.  This is telling your system to ignore this option.
   
7. Lines can be added to the sheet if there are new options or option value that need to be translated.  If you add lines, add them to the next consecutive row on the sheet.  If rows are skipped the system will not pick up the new rows to be translated.
   
8. See sample translation spreadsheet below:
   
1. 
   
9. Once you are done editing the translation spreadsheet, close the spreadsheet.  You should be at the level below:
   
1. 
   
10. Click the three little dots to the right of the file name and choose "Copy To".
    
11. A smaller window will open where you will choose the destination folder for the edited file.
    
1. You will need to navigate back one level to the Development folder (just click the word Development).
   
2. 
   
3. Click the To Import folder, then click Copy Here.
4. This will automatically begin the upload process for the file to be used for translations.  When the file has been successfully processed you will receive an email.  If there is a problem with the file, Solatech will also receive an email letting us know.