Jump to content
Sign in to follow this  
kungx

Exporting Mutiple Columns to One Column

Recommended Posts

kungx    0

Spec: Filemaker 9 on window 7 computer.

So I have some columns that need to be combine into one but I don't want to use Concatenation as a field because it creates quotes whenever I copy and paste.

 

The example:

Name = Nick

Field Name A - Nick A (this is produced from entering the name Nick)

Field Name B - Nick B (this is produced from entering the name Nick)

FYI - Field Name A and B must in the same record.

 

When I export I want Nick A to be first row and then Nick B to be second row is that possible?  Right now as it sits it looks like the attached.

Any suggestions?

 

Screen Shot 2017-03-09 at 12.11.30 PM.png

Share this post


Link to post
Share on other sites
comment    1,392

What is the required format for the exported file? You show the result in Excel(?) - do you export as Excel? Or can you export as a CSV or tab-separated fie?

Share this post


Link to post
Share on other sites
kungx    0

I just want it as a excel file.

 

1 hour ago, comment said:

What is the required format for the exported file? You show the result in Excel(?) - do you export as Excel? Or can you export as a CSV or tab-separated fie?

 

Share this post


Link to post
Share on other sites
comment    1,392

When Filemaker exports as Excel, there will be exactly one row for each exported record. If you want the same record to occupy two or more rows, you need to split it into multiple records. Judging from your field names, that's what you should do anyway: instead of having two Name fields, place the names in a related table and export from there.

The alternative is to cook your own export, using either XML with a custom XSLT stylesheet (with the resulting file being in Excel 2003 XML format) or a plugin.

 

Share this post


Link to post
Share on other sites
kungx    0

Is there an example of this on FM forum I can take a look at?  I have a ball park idea of what you're taking about but I would be interested to see a set up of these. My curiosity will be importing items into the table. Not sure if the items will import properly but I might just be over thinking it.

On 3/9/2017 at 3:36 PM, comment said:

When Filemaker exports as Excel, there will be exactly one row for each exported record. If you want the same record to occupy two or more rows, you need to split it into multiple records. Judging from your field names, that's what you should do anyway: instead of having two Name fields, place the names in a related table and export from there.

The alternative is to cook your own export, using either XML with a custom XSLT stylesheet (with the resulting file being in Excel 2003 XML format) or a plugin.

 

 

Share this post


Link to post
Share on other sites
comment    1,392
3 hours ago, kungx said:

Is there an example of this on FM forum I can take a look at?

What exactly do you mean by "this"? I mentioned three different alternatives - which one do you have in mind?

 

3 hours ago, kungx said:

My curiosity will be importing items into the table.

This is very confusing. I thought your question was about exporting from a Filemaker table, not importing into one.

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

  • Similar Content

    • By Neil_Million
      I've got multiple Filemake databases with 4m+ records each. I've created a layout which calculates a summary using a sort, Groups and Counts. This takes 10-15 seconds, which is OK.
      However, when I try to export this summary report to Excel it appears that Filemaker has to recalculate all the Groups & Counts, but for some reason this takes several hours. The last report took over 4 hours.
      I can't figure out how I can simply export or copy the summary report that Filemaker creates for the Layout?
      Please can someone provide assistance because I have another 20 similar reports to do and this will take me days instead of hours
    • By Andrew Bailey
      I develop in an environment with a 50/50 mix of Macs and PCs and have many scripts that either export or save records out to a directory on a server.
      On PCs, this is very straightforward: just enter the output file path and the file saves, no other interaction required. On Macs, the only way this works is if the specific drive the directory is in gets mapped to each user's computer. This is problematic for a bunch of reasons, namely that it means extra steps and we have users who regularly delete the mounted drives and then wonder why the scripts stop working.
      Is there a trick for Macs that I'm just missing?
    • By Kvothe
      I'm designing and working with my first Filemaker database using Filemaker 12 Advanced and Ipads using the Filemaker Go app (self hosted). I am having issues with random records going missing from the whole database (in each table and TO). There is no evidence that the record was ever in the database at all and this only happens every once it a while and is not restricted to a single Table; it happens in multiple tables, randomly, with no correlation between the instants. I would say 1 record in 50 goes missing daily.
      I have 9 main tables that are connected with a key. Each table has TO of every other table attached to share information through portals on each table. Table1 can create/delete records in Table2, but not vice versa, Table2 can create/delete records in Table3, but not vice versa... and so on and so forth. I am the only person who can delete records at all but especially from Table1, which removes the record from every table in the Database. None of the TO have the ability to create or delete.
      What could my issue be? I checked relationships, scripts and fields. Could it be the Filemaker Go app?
       
      Thanks folks!
    • By Sterling6of9
      HELP    How can I Export using a $variable as my File Name
      I am a new User with Filemaker 12 on a PC.   I need to export to a file and have the field "Report Id" be the file name I Exported.
       
      Sample " Field Report Id = "Mik01122015"   I need to export mt data to "Mik01122015.txt"
       
      How can I Export using a $variable as my File Name  "$variable= Field "Report#" Export to "Report#123.txt"
       
      I am using this script
       

    • By Gurratheboy
      Hi!
      I have this persistant problem when I try to import my XLM data into filemaker.
      I use various XML inportations in my filemaker database and they all import perfect with the msdso_elem.xslt file, but not this xml type!
      I don't know what I'm doing wrong... I made this XSLT document,  but when I try to import it, the actual record fields are empty!!!
       
      This is the XML document I would like to import:
      <Order url="https://api.fortnox.se/3/orders/3" urlTaxReductionList="https://api.fortnox.se/3/taxreductions?filter=orders&referencenumber=3"> <AdministrationFee>0</AdministrationFee> <AdministrationFeeVAT>0</AdministrationFeeVAT> <Address1>gurratheboy</Address1> <Address2>gurratheboy</Address2> <BasisTaxReduction>0</BasisTaxReduction> <Cancelled>false</Cancelled> <City>gurratheboy</City> <Comments/> <ContributionPercent>0</ContributionPercent> <ContributionValue>0</ContributionValue> <CopyRemarks>false</CopyRemarks> <Country>France</Country> <CostCenter/> <Currency>SEK</Currency> <CurrencyRate>1</CurrencyRate> <CurrencyUnit>1</CurrencyUnit> <CustomerName>gurratheboy</CustomerName> <CustomerNumber>2</CustomerNumber> <DeliveryAddress1/> <DeliveryAddress2/> <DeliveryCity/> <DeliveryCountry/> <DeliveryDate>2015-01-17</DeliveryDate> <DeliveryName/> <DeliveryZipCode/> <DocumentNumber>3</DocumentNumber> <EmailInformation>...</EmailInformation> <ExternalInvoiceReference1/> <ExternalInvoiceReference2/> <Freight>0</Freight> <FreightVAT>0</FreightVAT> <Gross>200</Gross> <HouseWork>false</HouseWork> <InvoiceReference>3</InvoiceReference> <Language>SV</Language> <Net>200</Net> <NotCompleted>false</NotCompleted> <OfferReference>0</OfferReference> <OrderDate>2015-01-17</OrderDate> <OrderRows> <OrderRow> <AccountNumber>3016</AccountNumber> <ArticleNumber>1</ArticleNumber> <ContributionPercent>0</ContributionPercent> <ContributionValue>0</ContributionValue> <CostCenter/> <DeliveredQuantity>1.00</DeliveredQuantity> <Description>Fortnox Bokföring</Description> <Discount>0</Discount> <DiscountType>PERCENT</DiscountType> <HouseWork>false</HouseWork> <OrderedQuantity>1.00</OrderedQuantity> <Price>100</Price> <Project/> <Total>100</Total> <Unit/> <VAT>25</VAT> </OrderRow> <OrderRow> <AccountNumber>3016</AccountNumber> <ArticleNumber>1</ArticleNumber> <ContributionPercent>0</ContributionPercent> <ContributionValue>0</ContributionValue> <CostCenter/> <DeliveredQuantity>1.00</DeliveredQuantity> <Description>Fortnox Bokföring</Description> <Discount>0</Discount> <DiscountType>PERCENT</DiscountType> <HouseWork>false</HouseWork> <OrderedQuantity>1.00</OrderedQuantity> <Price>100</Price> <Project/> <Total>100</Total> <Unit/> <VAT>25</VAT> </OrderRow> </OrderRows> <OrganisationNumber>gurratheboy</OrganisationNumber> <OurReference>API User</OurReference> <Phone1>gurratheboy</Phone1> <Phone2>gurratheboy</Phone2> <PriceList>A</PriceList> <PrintTemplate>oc</PrintTemplate> <Project>0</Project> <Remarks/> <RoundOff>0</RoundOff> <Sent>false</Sent> <TaxReduction/> <TermsOfDelivery/> <TermsOfPayment/> <Total>250</Total> <TotalToPay>250</TotalToPay> <TotalVAT>50</TotalVAT> <VATIncluded>false</VATIncluded> <WayOfDelivery/> <YourReference/> <YourOrderNumber/> <ZipCode>gurrathebo</ZipCode> </Order> This Is my XSLT document:
      <?xml version='1.0' encoding='UTF-8'?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <METADATA> <FIELD NAME="AccountNumber" TYPE="NUMBER"/> <FIELD NAME="Address1" TYPE="TEXT"/> <FIELD NAME="Address2" TYPE="TEXT"/> <FIELD NAME="AdministrationFee" TYPE="NUMBER"/> <FIELD NAME="AdministrationFeeVAT" TYPE="NUMBER"/> <FIELD NAME="BasisTaxReduction" TYPE="NUMBER"/> <FIELD NAME="Cancelled" TYPE="TEXT"/> <FIELD NAME="City" TYPE="TEXT"/> <FIELD NAME="Comments" TYPE="TEXT"/> <FIELD NAME="ContributionPercent" TYPE="NUMBER"/> <FIELD NAME="ContributionPercent1" TYPE="NUMBER"/> <FIELD NAME="ContributionValue" TYPE="NUMBER"/> <FIELD NAME="ContributionValue1" TYPE="NUMBER"/> <FIELD NAME="CopyRemarks" TYPE="TEXT"/> <FIELD NAME="CostCenter" TYPE="TEXT"/> <FIELD NAME="CostCenter1" TYPE="NUMBER"/> <FIELD NAME="Country" TYPE="NUMBER"/> <FIELD NAME="Currency" TYPE="TEXT"/> <FIELD NAME="CurrencyRate" TYPE="NUMBER"/> <FIELD NAME="CurrencyUnit" TYPE="NUMBER"/> <FIELD NAME="CustomerName" TYPE="TEXT"/> <FIELD NAME="CustomerNumber" TYPE="NUMBER"/> <FIELD NAME="DeliveredQuantity" TYPE="NUMBER"/> <FIELD NAME="DeliveryAddress1" TYPE="TEXT"/> <FIELD NAME="DeliveryAddress2" TYPE="TEXT"/> <FIELD NAME="DeliveryCity" TYPE="TEXT"/> <FIELD NAME="DeliveryCountry" TYPE="TEXT"/> <FIELD NAME="DeliveryDate" TYPE="TIME"/> <FIELD NAME="DeliveryName" TYPE="TEXT"/> <FIELD NAME="Description" TYPE="TEXT"/> <FIELD NAME="DiscountType" TYPE="TEXT"/> <FIELD NAME="DocumentNumber" TYPE="NUMBER"/> <FIELD NAME="EmailAddressBCC" TYPE="TEXT"/> <FIELD NAME="EmailAddressCC" TYPE="TEXT"/> <FIELD NAME="EmailAddressFrom" TYPE="TEXT"/> <FIELD NAME="EmailAddressTo" TYPE="TEXT"/> <FIELD NAME="EmailSubject" TYPE="TEXT"/> <FIELD NAME="ExternalInvoiceReference1" TYPE="TEXT"/> <FIELD NAME="ExternalInvoiceReference2" TYPE="TEXT"/> <FIELD NAME="Freight" TYPE="NUMBER"/> <FIELD NAME="FreightVAT" TYPE="NUMBER"/> <FIELD NAME="Gross" TYPE="NUMBER"/> <FIELD NAME="HouseWork" TYPE="TEXT"/> <FIELD NAME="HouseWork1" TYPE="TEXT"/> <FIELD NAME="InvoiceReference" TYPE="NUMBER"/> <FIELD NAME="Language" TYPE="TEXT"/> <FIELD NAME="Net" TYPE="NUMBER"/> <FIELD NAME="NotCompleted" TYPE="TEXT"/> <FIELD NAME="OfferReference" TYPE="NUMBER"/> <FIELD NAME="OrderDate" TYPE="DATE"/> <FIELD NAME="OrderedQuantity" TYPE="NUMBER"/> <FIELD NAME="OrderRow" TYPE="TEXT"/> <FIELD NAME="OrderRows" TYPE="TEXT"/> <FIELD NAME="OrganisationNumber" TYPE="NUMBER"/> <FIELD NAME="OurReference" TYPE="NUMBER"/> <FIELD NAME="Phone1" TYPE="TEXT"/> <FIELD NAME="Phone2" TYPE="TEXT"/> <FIELD NAME="Price" TYPE="NUMBER"/> <FIELD NAME="PriceList" TYPE="TEXT"/> <FIELD NAME="PrintTemplate" TYPE="TEXT"/> <FIELD NAME="Project" TYPE="NUMBER"/> <FIELD NAME="Project1" TYPE="TEXT"/> <FIELD NAME="Remarks" TYPE="TEXT"/> <FIELD NAME="RoundOff" TYPE="NUMBER"/> <FIELD NAME="Sent" TYPE="TEXT"/> <FIELD NAME="TaxReduction" TYPE="TEXT"/> <FIELD NAME="TermsOfDelivery" TYPE="TEXT"/> <FIELD NAME="TermsOfPayment" TYPE="NUMBER"/> <FIELD NAME="Total" TYPE="NUMBER"/> <FIELD NAME="Total1" TYPE="NUMBER"/> <FIELD NAME="TotalToPay" TYPE="NUMBER"/> <FIELD NAME="TotalVAT" TYPE="NUMBER"/> <FIELD NAME="Unit" TYPE="TEXT"/> <FIELD NAME="VAT" TYPE="NUMBER"/> <FIELD NAME="VATIncluded" TYPE="TEXT"/> <FIELD NAME="WayOfDelivery" TYPE="TEXT"/> <FIELD NAME="YourOrderNumber" TYPE="TEXT"/> <FIELD NAME="YourReference" TYPE="TEXT"/> <FIELD NAME="ZipCode" TYPE="TEXT"/> </METADATA> <RESULTSET> <ROW> <COL> <DATA><xsl:value-of select="Order/AdministrationFee/@value"/></DATA> </COL> <COL> <DATA><xsl:value-of select="order/AdministrationFeeVAT/@value"/></DATA> </COL> <COL> <DATA><xsl:value-of select="order/Address1/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="order/Adress2/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="order/BasisTaxReduction/@value"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> <COL> <DATA><xsl:value-of select="current/clouds/@name"/></DATA> </COL> </ROW> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet> This is only one record, and my XSLT won't work!
      Can someone please help me and point out what I'm doing wrong? 
      If you have a working XSLT document please share!!
       
      Thanks!
×

Important Information

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