SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

Can I fill a data block (DB) from file?

6/7/2014 7:56 PM	Rate (0)
make_it_move Posts: 25 Rating: (1)	Hi, I'm using a datablock with a large array (more than 1000 values). It will be used as a lookup table with fixed values. The values will be calculated by some external program, that could create a file with all the values in it. Is it possible to read the values for the array from a file in stead of typing them in manually? I do not mean writing a program to read a file, but just using a file to set the initial values of the array at program time. For instance with a coma separated list file.
make_it_move Posts: 25 Rating: (1)	Last edited by: make_it_move at: 6/7/2014 7:56 PM
Suggestion To thank Quote Answer

6/7/2014 10:47 PM	Rate (1)
William_B Posts: 5225 Rating: (1204)	Could I sign on as your virtual personal trainer. I promise my rates are very reasonable. [smile] Do you have a problem with copy-and-paste? Please see the JPG. [Alternative method] Or would you rather want to have the values written into the array in a semi-automatic way? Does this help? Other methods exists. You can copy-paste values into a watch table. Alternatively you can create SCL export (generate blocks). Then the SCL code can be modified. Note you can do this type of export with a pure DB also! You can create a spreadsheet to generate code in the format.. A B C 1 0 xxx ="value[" & A1 & "] := " & A3 Column A has values from 0 to 999. Column B has the values you need to get into the array Column C constructs the coding you need to paste into a code block. Then the code text can be re-imported (external source files). Need more info? Please go ahead and ask specific questions. w Attachment Visual clue_Populate DB or FB with start values.jpg (973 Downloads)
William_B Posts: 5225 Rating: (1204)	Last edited by: William B. at: 6/7/2014 10:48 PM Re-attach JPG
Suggestion To thank Quote Answer

6/8/2014 3:38 PM	Rate (0)
make_it_move Posts: 25 Rating: (1)	William B. Could I sign on as your virtual personal trainer. I promise my rates are very reasonable. [smile] Well, I must say you are a very good teacher. Your explanations are very clear and helpfull to me! Thank you very much. William B. Do you have a problem with copy-and-paste? Please see the JPG. Didn't know I could past a complete colom at once. Again the solution is simpler then expected.
make_it_move Posts: 25 Rating: (1)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users William_B

6/8/2014 5:05 PM	Rate (0)
Ayman Elotaify Platinum Member Joined: 5/28/2008 Last visit: 7/8/2025 Posts: 4520 Rating: (843)	Hello, I think this FAQ will guide you: How do you import an Excel list with STEP 7 variables into a data block? Hope this helps.
	Ayman Elotaify
Suggestion To thank Quote Answer

6/8/2014 5:34 PM	Rate (1)
William_B Posts: 5225 Rating: (1204)	Ayman Elotaify Hello, I think this FAQ will guide you: How do you import an Excel list with STEP 7 variables into a data block? Hope this helps. Dear Ayman Elotaify, Thank you for taking part in this discussion. I however doubt that those STEP7 5.x instructions help as-is for TIA V1x. In TIA the mechanism works differently. It all depends on which columns are shown. One can copy rows from TIA and paste this in spreadsheet. Then the structure shown at that moment is available to a spreadsheet. Next, fill in the spreadsheet and copy back into TIA. Greetings. w
William_B Posts: 5225 Rating: (1204)
Suggestion To thank Quote Answer

Share this page:

Share this page on...