About claude_bellavan

claude_bellavan · ‎10-06-2016

Hi Eric and JP, I certainly do not want to start a discussion in the form of recrimination here. I am very pleased of the JMP team support. Regarding FileMaker, the important thing for me is to be able to work around the problem by removing the semicolon and to have shared the trick. You are correct in regard to the offer somewhat more limited for databases manager in Mac OS's world.. Personally, I mostly use FileMaker for my research for its design flexibility (and Rapid Development) which is more important for me than the raw power. I nevertheless manages with great efficiency (with FileMaker Server) some databases with hundred of tables, thousands of fields and millions of records. I also use SQLite (a user) and especially PosGres (PostGIS server) for geographic data. The ODBC drivers are particularly capricious for francophones like me because of the accents. You absolutely have to proscribe accents and spaces in field's titles! Thanks again, Claude

claude_bellavan · ‎10-05-2016

Hi Eric, I made a simple SQL Query with Query Builder. It contains only one semi-coma. It didn't work as it. But work perfectly after removing the semi-coma. So you are right. The semi-coma is incompatible with FileMaker (and/or the ODBC driver). Hope this can be fixed in a future upgrade. Thanks a lot for this quick response!! Claude B.

claude_bellavan · ‎10-05-2016

Hello, Since the introduction of the SQL Query builder, I tried many times to use this tool without success. So I use the old way (open database) which force me to build manually the SQL queries. Now that we can mix external databases and JMP tables, I'd like to give a second chance to Query builder. It still doesn't work. The error message : The connexions with the Database works fine (I made an update script and I used it without problems for few months). SQLSTATE=42000 means synthax error. But it is Query Builder who wrote the SQL Query... Any idea? Thanks, Claude B.

claude_bellavan · ‎06-30-2016

Thanks Ron. Finally, I chose to modify the original update script. It's a 3 steps procedure: The first step is the original update (ODBC data source) which is creating a new table (because of the hard code columns); Then a second script step is updating my main table with this new table's data; The last step is closing the new table. This way I can to create as many new hard code columns as I need (the script won't need any fix). Claude

claude_bellavan · ‎06-21-2016

Thanks a lot Ron. It is an ingenious way to solve the problem. Unfortunately, I cannot use script because I have to go through a computed column. In fact, if I add columns with hard data, the update to my table with my database (via DNS/ODBC) will create a new table instead of simply replace data. Claude

claude_bellavan · ‎06-15-2016

Hi Jerry, No problem. I'm happy to see that one day my wishes will come true! Thanks a lot again. Claude

claude_bellavan · ‎06-15-2016

Hi MS, Well, this is a very interesting workaround. It’s open to me a completely new area (Eval, Formula, etc.). I'm crossing my fingers for a future JMP version with this new function "ColRank by…". Thanks a lot for taking time to answer my question. Claude

claude_bellavan · ‎06-14-2016

Hi Jerry, Can you explain more please. The manual is very minimalist about this third argument. Col Rank Ranks each row’s value, from 1 for the lowest value to the number of non ‐ missing columns for the highest value. Ties are broken arbitrarily . I don’t understand what it might mean and how to use it. Thank you for your help! Claude

claude_bellavan · ‎06-14-2016

Thanks a lot Jim!! CB

claude_bellavan · ‎06-14-2016

I think I get the point. But… Since mosaic plot computes the number of observations, I suppose I have to put the population in the frequency's square (bottom right corner)? Am I right?

claude_bellavan · ‎06-14-2016

Hello, Is there a way to build a formula equivalent to «ColumnRank by…» (group). I normally use the distribution platform (with «by group» option) and save ranks for that purpose in a static column. But this time, I need a dynamic column (calculated). Thanks, Claude

claude_bellavan · ‎06-14-2016

Hello, I have a beginner question. I'm using Graphic Builder (stack bars or areas). Suppose I have 3 columns: Year, Country and Population. What is the simplest way (without creating new columns) to show distribution of population among countries over time in percent like this: I'm doing that kind of graphic routinely with other software . Thanks, Claude

claude_bellavan · ‎04-21-2016

Hello, I have another question. Can I have a list of my external Database IDs (which are store in a column of my JMP table) instead of JMP's table row numbers («fileRows»)? The relevant code in your post was : fileRows = "" ; For ( r = 1 , r <= NRow ( rs ) , r ++, fileRows = fileRows || Char ( rs [ r ]) || "\!n" ; ) ; Thanks a lot! Claude

claude_bellavan · ‎02-05-2016

Well. I was giving Excel as a similar situation where JMP doesn't need to interact with the application. Just tells the operating system to open the created file with the default application. Anyway, I've found a workable solution this morning. I wrote a MacOS script (in fact, it's an Automator action) which monitors a folder and open any file that appears inside. There is a delay (0,5 - 2 seconds), but it works. In closing, let me thank you warmly again for your assistance. That will help me greatly!! CB

claude_bellavan · ‎02-04-2016

Thank you Ian. I managed to adapt the script. The file is created and it works !! But I still do not understand how to tell the operating system to open the text file . I have carefully studied the scripts of the index and help. I've been running these 4 examples, but none seems to fit my needs. As I wrote earlier, my situation is like this: Create a script that would export in a file an excerpt from the JMP table and who would tell the operating system to open this file (by Excel, not by JMP). CB

claude_bellavan · ‎02-04-2016

2 more questions: 1- Is that «Run Program» command is only working with an executable file (.exe on Windows or .app on Mac OS)? After export JMP data to an Excel file, how the JSL script can tell the OS to automatically open that file (not only Excel)? Maybe a second parameter is needed? 2- The middle section of your script write the selected row numbers to the file. How can I write a list with the content of a normal data column (my database internal ID) for selected lines? As you may see, my understanding of JSL is very basic (and my English too). Thanks again! CB

claude_bellavan · ‎02-04-2016

Thanks a lot Ian. This is a very good starting point ! The action is simply: tell the OS to open that snapshot («.fmpsl») FileMaker file. Claude

claude_bellavan · ‎02-04-2016

Hello, I would like to program a script that would create a small text file. This file is actually a snapshot link used by FileMaker to open a set of saved records. This is a XML file, but with an file extension recognized by FileMaker ( ".fmpsl"): Snapshot link is very simple file. A first text string is fixed, it is followed by the database's ID list (stored in a column of the JMP table) and a third part consisting of a fix text string as the first.: <? Xml version = "1.0" encoding = "UTF-8"?> <SLMF> <UIState> <UniversalPathList> fmnet: /99.129.6.76/my_database.fmp12 </ UniversalPathList> <Rows type = "nativeIDList" rowCount = "2" baseTableId = "142"> <! [CDATA [! 5935 6597 ]]> </ Rows> <Layout id = "48"> </ Layout> <View type = "form"> </ View> <SelectedRow type = "nativeID" id = "5935"> </ SelectedRow> <StatusToolbar visible = "true"> </ StatusToolbar> <mode value = "browseMode"> </ mode> <SortList Maintain = "True" value = "false"> </ SortList> </ UIState> </ SLMF> The IDs (the only variable part) in this example are the 5935 and 6597. I would also like my action triggers the opening of the Snapshot Link file created. So I could access my database related records with a simple clic in JMP. Is this project is achievable with JSL? The solution could be cross-platform or run only on Mac. I'm new to JSL. Thank you for your help. CB

claude_bellavan · ‎01-18-2016

Thank you! Very interesting. I'll try this soon. CB

claude_bellavan · ‎01-13-2016

Hi, I'm afraid the solution doesn't work with the density (Contour). In this example, we can see that hiding rows state is working with dots, but the density is the same for both years (no evolution at all). Without hiding concatenated rows : I followed instructions very carefully. Maybe I missed something. Thanks again. C.B.

claude_bellavan · ‎01-11-2016

Thank you very much txnelson. I'll try this solution. C.B.

claude_bellavan · ‎01-10-2016

Hi I want to show the spread and growth of the population over time and space. I’m using Graph Builder to map population density (see below). I can produce quite nice heat maps but the density seems to be calculated separately for each year. Is there a way to share the same scale for all years so the colours will have the same meaning across maps? Thanks. C.B.

claude_bellavan · ‎12-07-2015

Thank you very much! Both responses will be very useful in the future. Claude

claude_bellavan · ‎12-06-2015

Hello, Is there a way to script this menu command: Columns/Reorder Columns/ Original Order . In the JSL manual, I found : dt<<Reorder By Name dt<<Reorder By Data Type dt<<Reorder By Modeling Type In need to restore the column order to orignal order before Data Table update and reorder it by name after the update. Thanks, Claude B.

claude_bellavan · ‎12-02-2015

thank you very much Jim! CB

claude_bellavan · ‎11-30-2015

Hello, I have three columns: Population, Year and Type. I need to write the Z score value of the population in a new column. This standardization applies for each subset (Year + Type). Until now, I've used the distribution platform with «BY Year» and «BY Type» and saved the normalized data (red triangle menu, Save standardized value). Since I have to update my table often, these values have to be refreshed dynamically (formula column). The problem here is that the Standardize function applies to all rows. Is there any function or special arguments that would standardize «on the fly» my population by subset? Thanks, Claude B.

Date Registered	‎11-05-2014 12:15 PM
Date Last Visited	‎03-03-2020 11:37 AM
Total Messages Posted	26
Total Kudos Received	2

Online Status	Offline
Date Last Visited	‎03-03-2020 11:37 AM

Re: Filemaker and SQL Query

Re: Filemaker and SQL Query

Filemaker and SQL Query

Re: ColumnRank by group?

Re: ColumnRank by group?

Re: ColumnRank by group?

Re: ColumnRank by group?

Re: ColumnRank by group?

Re: Graphic Builder Area: How to show results in percent without creating new co...

Re: Graphic Builder Area: How to show results in percent without creating new co...

Re: Any standardize function by subset

Re: ColumnRank by group?

Re: ColumnRank by group?

Re: Filemaker and SQL Query

Re: Filemaker and SQL Query

Filemaker and SQL Query

Re: ColumnRank by group?

Re: ColumnRank by group?

Re: ColumnRank by group?

Re: ColumnRank by group?

Re: ColumnRank by group?

Re: Graphic Builder Area: How to show results in percent without creating new co...

Re: Graphic Builder Area: How to show results in percent without creating new co...

ColumnRank by group?

Graphic Builder Area: How to show results in percent without creating new column...

Re: JSL: How can I get IDs of selected lines and export them in a text file

Re: JSL: How can I get IDs of selected lines and export them in a text file

Re: JSL: How can I get IDs of selected lines and export them in a text file

Re: JSL: How can I get IDs of selected lines and export them in a text file

Re: JSL: How can I get IDs of selected lines and export them in a text file

JSL: How can I get IDs of selected lines and export them in a text file

Re: Graph Builder heat map: how to share the same scale for all years?

Re: Graph Builder heat map: how to share the same scale for all years?

Re: Graph Builder heat map: how to share the same scale for all years?

Graph Builder heat map: how to share the same scale for all years?

Re: A JSL script for moving columns to original order?

A JSL script for moving columns to original order?

Re: Any standardize function by subset

Any standardize function by subset