Make a BackUp in .csv from a DB

Hi

TIA V15
CPU1214C

I have a DB dedicated to store 'parameters' of my machine (array of UDT in RETAIN mode)
When I change CPU, or when I change the udt or whatever I lost all the parameters.... and that's not cool
I want a back-up of this values (and I can import from another project when the things are similar...)
I search and find RecipeImport and RecipeExport
I have use this (last year) on a 1500 and works well (I copy when I decide, I recover the file from webserver and I can reverse the process). I try the same thing here on my 1200

I have the error : 80B6
With (S7-1200 CPUs only) attribute "Save only in load memory", the recipe data block is not activated.

So I goes to DB's properties and change the attribute to "only store in load memory"
Optimized or not don't change anything
But now my CPU goes crazy "Temporary CPU error: DB 9993 not loaded, access in FB 2100"

and now I'm in "unknown land"

In my previous project (1500) the DB is optimised and NOT only load memory, and it's working
What's the difference here ?

Question 1 :
Can I create a back-up (all values from a DB) with something else than RecipeExport instruction ?

Question 2 :
How to deal with a DB (I need read/write in my program) when it is in load memory only ?
Create a mirror DB ? which copy which and when ?

Thanks !

Hello sixthomas;

There are ressources you can find in the forum and on the web, discussing this issue and providing solutions to export and inport DBs to csv file.

For example, look at the posts from O_Einstein and Piotr.m in the following discussion:

https://support.industry.siemens.com/cs/ww/en/view/63900229 

And this program from Sourceforge looks very interesting.

Step7 Db To Excel

https://sourceforge.net/projects/step7dbtoexcel/

There are more posts on the forun discussing options to export DB data to csv files, search the forum to locate them.

OK

- Your link is wrong
- Search by user, Piotr.m give lot's of topic
- Search by user, O_Einstein give an internal error
- Search by words, "DBs to csv" give me 
https://support.industry.siemens.com/tf/ww/en/posts/exporting-recipes-in-cpu-to-a-file/160718/?page=0&pageSize=10
https://support.industry.siemens.com/tf/ww/en/posts/write-to-load-memory-read-data-from-load-memory-using-pointers/158081/?page=0&pageSize=10
- Search by words, "DB to csv" I find a post from O_Einstein :
"
If you open a DB and select all by clicking on the empty block above the 1 (which is just left of "Static"), you can copy and paste as tab-delimited text that includes all the same data you see in the DB.  You get the name and datatype, and can filter out fields inaccessible to the HMI with other values.
"

and from Piotr :

"o copy ALL data to Excel (not only one visible during monitoring)

1. do SNAPSHOT - this will take a snapahot of ALL data in the DB

2. Expand all (or needed) structures

3. copy/paste to Excel

Note: there is a limitation of no of rows (I think ca 40k rows) which can be copied at any time.

to copy big db you can copy structure by structure.
"

That is not really helping, because I want to export and import

I know how to work with ExportRecipe, because I already use it (just read my post)


If you want to help, you are welcome, if you are just saying "go search yourself" well...ok


I move forward,
- I create a DB_mirror (load memory only),
- I copy the DB to DB_mirror with WRIT_DBL
- I finally use ExportRecipe with the DB_mirror
- And I finally have the error 8091:
The data structure referenced by RECIPE_DB cannot be processed or the number of data columns in a S7-1200 CPU is greater than 255.

columns are...columns (perhaps it is different in my language), and I don't have the choice (except put a struct in a struc in a struct...), so I guess they wanted to say "line"
And yes, my DB have more than 255lines
or
"cannot be processed", so I guess I have to phone hotline

So question 2 is almost answered by me


Second link is for step7


My question 1 still the same, is there a way to export/import DB in other way on a 1200 ? (because I just test this on a 1500, and I can export/import easily whatever the DB I want)