Hi Mark
You're right it works, the problem is in my enhanced version of the import script. Could you please give me some assistance with this? I've tried to add a check if the profile which should be imported already exists, and a host replacement.
The execution of timport twice seems to raise the problem. When I don't use the check it imports 2 rows more and I can also see the Meta Field entries.
I don't understand completely how this timport works. I have assumed I can import the file as many times as I need it, but it seems to remove lines when I execute it again.
Here is my changed version of the script:
<script language=vortex>
<a name=main public>
<if '' ne $REMOTE_ADDR>Not for web!<exit></if>
<vxcp htmlmode off>
<VERB>
</VERB>
***************************************************************************************************************************
* Basic export and import of Webinator profile settings. *
***************************************************************************************************************************
Usage Export: texis profile="Your-Profile-Name" $url/exportprofile.txt >Your-List-Name.lst
---------------------------------------------------------------------------------------------------------------------------
Usage Import: texis fromHost="current.domain.ch" toHost="new.domain.ch" $url/importprofile.txt <send "<">Your-List-Name.lst
---------------------------------------------------------------------------------------------------------------------------
NOTES: The Import creates a new profile with Rewalk-Type "New". No database is created, must start a walk to get data.
---------------------------------------------------------------------------------------------------------------------------
</a>
<a name=outstring s>
<sandr '"' '""' $s>
"$ret"<!--nop-->
</a>
<a name=exportprofile public>
<if '' ne $REMOTE_ADDR>Not for web!<exit></if>
<vxcp htmlmode off>
id|Profile|Name|Type|Int|Float|String|Strlist
<sql row "select * from options where Profile=$profile and Name not in ('SSc_nbytes','SSc_npages','SSc_walked','SSc_walknow','SSc_walking','SSc_ndbs','SSc_schedule','SSc_schedulehr','SSc_LastWalkType','SSc_LastWalkStart','SSc_LastWalkFinish','SSc_FailedWalkType','SSc_FailedWalkStart','SSc_FailedWalkFinish','SSc_CurrentWalkType','SSc_CurrentWalkStart') and Name not matches 'SSc_pause%'">
$id|<outstring s=$Profile>|<outstring s=$Name>|$Type|$Int|$Float|<outstring s=$String>|$Strlist
</sql>
</a>
<a name=importprofile public fromHost toHost>
<if '' ne $REMOTE_ADDR>Not for web!<exit></if>
<$mustBeImported=0>
<$profileName="">
<vxcp htmlmode off>
<timport "csv |
field Profile varchar 2
" fromfile "-">
<$profileName=$Profile>
<sql row "select distinct Profile as ProfileValue from options where Profile=$Profile"></sql>
<if $ProfileValue neq $Profile>
<$mustBeImported=1>
</if>
<break>
</timport>
<if $mustBeImported eq 1>
<timport "csv |
field id counter 1
field Profile varchar 2
field Name varchar 3
field Type varchar 4
field Int long 5
field Float double 6
field String varchar 7
field Strlist strlst 8
" fromfile "-">
<if $Name eq "SSc_rewalktype">
<$String="new">
</if>
<strstr $fromHost $String>
<if $ret gt -1>
<sandr $fromHost $toHost $String><$String = $ret>
</if>
<sql novars "insert into options values(counter,$Profile,$Name,$Type,$Int,$Float,$String,$Strlist)"></sql>
<if $Name eq "SS_dataspace">
<sysutil mkdir parents $String>
</if>
</timport>
$loop records imported
Profile "$profileName" has been created!
<else>
Profile "$profileName" already exists!
</if>
</a>
</script>
