Jump to content

Glorifindal

Members
  • Content Count

    36
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Glorifindal

  • Rank
    member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi there, I have inherited a MirrorSync installation ( FMS17 / MirrorSync 5 ) Apart from the online MirrorSync documentation, there is nothing else to check this with (so ein schmarrn) Setup = Server1 > Server2. It is supposed to be setup for a failover (but this has not worked automatically for over a month) I need to reboot Server2 Is there anything I need to watch when rebooting? I would usually use the Filemaker Server console to simply close the databases before I reboot. BUT : will this effect in any way affect Server 1 (it has a External Data Source to the data file in Server 2 and the MirrorSync scripts point to Server2) ? SO: Is there a SAFE method of rebooting the server that is being used as a failover? (Server 2)? So that Server 1 will not suffer in any way? many thanks in advance, G
  2. Hi Ryan, many thanks for your answer. So, somewhere in the licensing we may already have a the possibility to do a server to server * 2 . And if not, I can buy such an option. Great stuff. Your comment "(this will work for any MirrorSync license)" - does this mean that "add to existing MirrorSync 6 license" will also work for a MirrorSync 5 license? MANY thanks in advance Ryan. kindest regards, Glorifindal
  3. Hi there, I have inherited a MirrorSync installation ( FMS17 / MirrorSync 5 ) It is my first time visibility to MirrorSync, and I have been working my way through it. Impressive solution indeed. Setup = Server1 > Server2 (1-way) I want to mirror to a second server, so: Server1 > Server2 (1-way) AND Server1 <> Server3 (2-way) Question: Is this possible? Question: What would I need in order to do this? Many thanks in advance. Glorifindal
  4. I am attempting to export XML and transform it - from Filemaker, to be usable in Word. For straight fields- no problem. For related data - I have it working, but once I start to attempt any sort transform, that's where I get unstuck. I have 3 columns that I want to format as follows ( as a table - it would actually be a table within a cell - BUT, perhaps someone has a better suggestion that a table within a cell ? ): Nr. Name Type Call-Sign 1 Jones Extra BRD2 2 Trucker New GF21 3 Brint Extra ASD2 I have got the Name column working fine... I just need the Nr. column ( position () ) and the other 2 columns to work...they always return empty....( but if I swap out their variable name with the name column it does work - so they are pulling data ) In the code that follows, Please excuse the Word mark-up...I have put the xls code in question in blue <code> <w:tbl> <w:tblPr> <w:tblW w:w="0" w:type="auto"/> <w:tblBorders> <w:top w:val="single" w:sz="4" wx:bdrwidth="10" w:space="0" w:color="auto"/> <w:left w:val="single" w:sz="4" wx:bdrwidth="10" w:space="0" w:color="auto"/> <w:bottom w:val="single" w:sz="4" wx:bdrwidth="10" w:space="0" w:color="auto"/> <w:right w:val="single" w:sz="4" wx:bdrwidth="10" w:space="0" w:color="auto"/> <w:insideH w:val="single" w:sz="4" wx:bdrwidth="10" w:space="0" w:color="auto"/> <w:insideV w:val="single" w:sz="4" wx:bdrwidth="10" w:space="0" w:color="auto"/> </w:tblBorders> <w:tblLook w:val="04A0"/> </w:tblPr> <w:tblGrid> <w:gridCol w:w="1427"/> <w:gridCol w:w="1427"/> <w:gridCol w:w="1428"/> </w:tblGrid> <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW[1]/fmp:COL[$Name]/fmp:DATA"> <w:tr wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidTr="00E337ED"> <w:tc> <w:tcPr> <w:tcW w:w="1427" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="000320AE" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> <w:r> <w:t><xsl:value-of select="."/></w:t> </w:r> </w:p> </w:tc> <w:tc> <w:tcPr> <w:tcW w:w="1427" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="000320AE" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> <w:r> <xsl:value-of select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW[1]/fmp:COL[$deviceEnv]/fmp:DATA" /> </w:r> </w:p> </w:tc> <w:tc> <w:tcPr> <w:tcW w:w="1428" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="000320AE" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> <w:r> <xsl:value-of select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW[1]/fmp:COL[$deviceEnv]/fmp:DATA" /> </w:r> </w:p> </w:tc> </w:tr> </xsl:for-each> <w:tr wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidTr="00E337ED"> <w:tc> <w:tcPr> <w:tcW w:w="1427" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> <w:tc> <w:tcPr> <w:tcW w:w="1427" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> <w:tc> <w:tcPr> <w:tcW w:w="1428" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> </w:tr> <w:tr wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidTr="00E337ED"> <w:tc> <w:tcPr> <w:tcW w:w="1427" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> <w:tc> <w:tcPr> <w:tcW w:w="1427" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> <w:tc> <w:tcPr> <w:tcW w:w="1428" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> </w:tr> <w:tr wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidTr="00E337ED"> <w:tc> <w:tcPr> <w:tcW w:w="1427" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> <w:tc> <w:tcPr> <w:tcW w:w="1427" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> <w:tc> <w:tcPr> <w:tcW w:w="1428" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> </w:tr> <w:tr wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidTr="00E337ED"> <w:tc> <w:tcPr> <w:tcW w:w="1427" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> <w:tc> <w:tcPr> <w:tcW w:w="1427" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> <w:tc> <w:tcPr> <w:tcW w:w="1428" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> </w:tr> <w:tr wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidTr="00E337ED"> <w:tc> <w:tcPr> <w:tcW w:w="1427" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> <w:tc> <w:tcPr> <w:tcW w:w="1427" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> <w:tc> <w:tcPr> <w:tcW w:w="1428" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> </w:tr> <w:tr wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidTr="00E337ED"> <w:tc> <w:tcPr> <w:tcW w:w="1427" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> <w:tc> <w:tcPr> <w:tcW w:w="1427" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> <w:tc> <w:tcPr> <w:tcW w:w="1428" w:type="dxa"/> <w:shd w:val="clear" w:color="auto" w:fill="auto"/> </w:tcPr> <w:p wsp:rsidR="00E337ED" wsp:rsidRPr="00E337ED" wsp:rsidRDefault="00E337ED" wsp:rsidP="00E337ED"> <w:pPr> <w:spacing w:after="0" w:line="240" w:line-rule="auto"/> </w:pPr> </w:p> </w:tc> </w:tr> </w:tbl> </code>
  5. Hi there, I'm back to Filemaker after a long break - and have been told to implement a Calendar. I am using a calculation field for each "Day" - as each field is not so much a date as a list of Date attributes - based on the date - i.e for the 10th of November the multi key list would be: 10/11/2012 monthday10 monthnum11 SecondSaturday I did OK (I think) as long as the Calendar was allowed to start on the first grid square (the first field knew that it was referring to the first of the month) BUT - the boss now wants the 42 day grid - with the first days as well as the last days that are not past of the selected month also being shown. My question is - how do I work out the shift needed - i.e how do I know that the first of November is actually the fifth grid square...? I suppose each field would start with this shift calculation... but am at a loss to know what the calculation is. I have tried variations on if( 1st of month selected is NOT a Sunday ; then ... ) but lost Could anyone please help me ? I've been struggling for a while now, my head is splitting, my eyes are red ... many thanks in advance Glorifindal
  6. Hi there, Filemaker 11.0.4... When I browse to a layout with a webviewer on it, it gives an ugly flash of white. Does anyone know how to supress this flashing? May be a silly question - as it's a dynamic layout object and it is simply refreshing itelf, but it's a question wrth asking... Pax et Lux Glorifindal
  7. So, I got so far - which I think works now anyway - "Q" and Int(( Mod ( dateEnd ) + ( 12 - 4 ) ; 12 ) +1 +2 ) / 3 ) & Right(Year( dEnd ) - (Month ( dEnd ) < 4 ;2) Not to elegant but it seems to work. The 4 in the above is April, our Fiscal year If someone can improve on this, or see a bug in it, please let me know, kindest Glorifindal
  8. Hi there, so, I worked out how to do a Year Quarter, based on a project date ending, when my boss turned and said - err, I meant Fiscal Year. Which leaves me with working out how to show which quarter a date is in - over 3 years , last year, current year, next year For example, the date 26/03/2011 is in the last quarter of last year, The data I am producing is in the format (Jan...Dec Year): Project 1 Q1 (date = 26/03/2011) Project 2 Q3 (date = 10/08/2011) What I need to produce is ( UK, Fiscal year start to Fiscal year end) : Project 1 Q410 (date = 26/03/2011) Project 2 Q311 (date = 10/08/2011) Project 3 Q212 (date = 29/04/2012) Anyone have an idea as to how this can be accomplished? I am at a loss really Many thanks in advance Glorifindal
  9. Thank you very much - works fine I would also prefer a custom function - but this will do for the moment kindest Regards Glorifindal
  10. Hi guys, sorry, I fell asleep (up in Scotland) @BruceR - actually, FMP 11 - need to update - sorry @Comment - nice one - I'll have a look and get back. Many thanks Glorifindal
  11. Sorry - The items table is a great great grandchild of the Owner table - not just a child Owner - shop - category - Item Two other tables between Owner and Item Hope that is clearer
  12. Hi there, I have been trying different methods to achieve the following - and none are correct as far as FMP 11 goes. Perhaps someone can help me ? I need to be able to tell which values in a relationship have the highest count. Parent record = Owner Child record = Shop Child record = Category Child record = Items If in the related items the carrots have sold the most, I need the Parent Owner to know this. Example data: Apples Apples Carrots Carrots Carrots Carrots Carrots Carrots Dried Fruit Dried Fruit The value I want to see is Carrots. The parent record has to be able to know this. The ER is as given above - i.e. there are 2 join tables between Owner and Items Any help greatly appreciated. Many thanks in advance Glorifindal
  13. Corporate IT send out a 4 page questionaire concerning the new corporate build which will include Filemaker - It's one of the questions - I am no Windows expert - so no idea why they need to know -0 BUT, If I do not answer it - no progress.
  14. Hi there, not sure where I should post this question - but here goes: When accessing a hosted version of the DB - does Filemaker write or store ANY data to the local disk ? I am thinking specifically about temp files etc. Any help greatly appreciated. Glorifindal
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.