Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

adiarnon
Contributor 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

Re: bat command to delete data from a model

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
8 Replies

Re: bat command to delete data from a model

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

Re: bat command to delete data from a model

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
Contributor III

Re: bat command to delete data from a model

i will try

tnx

adiarnon
Contributor III

Re: bat command to delete data from a model

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?

Re: bat command to delete data from a model

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


talk is cheap, supply exceeds demand
adiarnon
Contributor III

Re: bat command to delete data from a model

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

MVP
MVP

Re: bat command to delete data from a model

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'.

adiarnon
Contributor III

Re: bat command to delete data from a model

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

Community Browser