Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Featured Replies

I am exporting via xsl style sheet with the following code:

<?xml version='1.0' encoding='utf-8'?>



exclude-result-prefixes="fmp" version="1.0"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform">





	

	

	seller-id	gtin	isbn	mfg-name	mfg-part-number	asin	seller-sku	title	description	main-image	additional-images	weight	features	listing-price	msrp	keywords	product-set-id	store-code	category-id



		

		

			

			

			

					

						

							

						

						

							



						

						

						

					

				

		

		

	

Fields I chose for the export are all calculation fields, they are not on the layout from which I do the export (only one is, they are all from same table though, if that matters).

When I export I get an empty file, no data exported from the fields. The only data that shows is the column headers I hard-coded into xsl.

Cannot figure out why nothing is being exported.

Do I need to put all of the calc fields on the layout? I put one to test that and no data from that field got exported as well?

Script.gif

Edited by Guest
Empty fields in XSL are & # 09 for tab and & # xD for CR.

I don't see an instruction to output field data.

  • Author

In the script or in the xsl - this question is getting to me...?

In the xsl - I can't even read your script, but that doesn't matter.

  • Author

Hm, I can see it ok in my code window (xsl), as far as fully understanding it, not quite there but hoping to be shortly.

This script (the xsl) is actually one, I believe, you recommended in a previous post of mine. I do not know much about xsl, even less when it comes to it in FM so I do not know what command I need to add to it to export the data from the fields.

I am using it to generate a tab delimited file with headers.

Basically I am creating a simple form which will generate a file which can then be used to update online data via import / export but it has to be in certain format...

  • Author

I got the xsl code from here:

http://fmforums.com/forum/showtopic.php?tid/183442...

You pointed me to it in this post

http://fmforums.com/forum/showtopic.php?tid/209686/fromactivity/mytopics/

I had it working but obviously I messed somewhere along the line and now cannot figure out what I did wrong.

Thank you.

Well, I am not sure what exactly you are trying to do, but in the original stylesheet there is a line that says:

which means 'take the value of the current node and put it in the result tree'.

Hint:

XSL is pretty hard to get right even when you know what you're doing. The probability of stumbling upon the correct code by trial-and-error is very low.

  • Author

Here is the file and the xsl I am using. Note the file is desgined for Buy.com and the export it creates has to conform to their feed specs. IE. No carriage returns in data, extra tabs and so on so basically I created one calc field for every input field -> the calc will hopefully filter out all error input from users...

Buy.zip

  • Author

HM, I added that line to the xsl and now the data is coming.

Was this all that had to be added? (not really getting it but am trying to...)

I believe those calculations could be done in the stylesheet - but I am afraid a discussion of that would exceed the scope of what's possible in a forum. There are many XSLT tutorials and books out there, if you want to delve deeper.

  • Author

Thanks., I will check. I selected to do them in FM as I do not know enough of XSLT to do it in there.

Now that data is coming I will hopefully finish this project soon.

Thanks for the advice. :D

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.