Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

bat command to delete data from a model

hi,

for our version control we need to create a bat command that:

deleting the data from the model and just the script should stay.

how can we do it?

adi

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Maybe. If you want to remove all the data then you can use the /nodata option for the command line:

qv.exe /nodata MyDoc.qvw. It will open the file with no data. You can then save the document.

You could also try using something like the attached excel file.


talk is cheap, supply exceeds demand

View solution in original post

8 Replies
Gysbert_Wassenaar

Maybe. If you want to remove all the data then you can use the /nodata option for the command line:

qv.exe /nodata MyDoc.qvw. It will open the file with no data. You can then save the document.

You could also try using something like the attached excel file.


talk is cheap, supply exceeds demand
Peter_Cammaert
Partner - Champion III
Partner - Champion III

As an aside, storing binary files (even empty QVW's) in a version control system will effectively block any sensible version control. Consider switching to storing your documents into prj- folders: the resulting xml files will be in text format (full version control for each individual item/object/setting in your document) and data will be thrown away by default.

Best,

Peter

adiarnon
Creator III
Creator III
Author

i will try

tnx

adiarnon
Creator III
Creator III
Author

TNX! ITS WORKING

what command should i write i want to copy the document to another folder but i want that the document will be without the data.

what command copyit to another folder?

i need to copy with the data and then delete the data? or i can copy without the data?

Gysbert_Wassenaar

Use the copy or xcopy command. https://support.microsoft.com/en-us/kb/240268


talk is cheap, supply exceeds demand
adiarnon
Creator III
Creator III
Author

HI AGAIN,

i did the /nodata command

but i want to save end close the document

how can i do it from the batch?

and after im doing the copy command

and i need to delete the file

how can i do that?

tnx again,

adi

jonathandienst
Partner - Champion III
Partner - Champion III

Have you considered Peter Cammaert's comment? Empty QVWs can still be quite large if there are many objects and they are binary, so they will clog up your VC database pretty quickly. The -prj folder option is designed precisely for this purpose.

If you need help, you can search the community site for 'version control'.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
adiarnon
Creator III
Creator III
Author

YES i considered Peter Cammaert's comment but i cant manage the changes with the XML files

i have alot of objects in one doc

so  i cant manage it like this