Steven1337

Hello, I am importing orders from my online cart solution into filemaker. There are two fields that come from my online cart solution called comment and internalcomment. I wish for both of these fields to be imported into the same filemaker field. Is this possible in some way? Creating a filemaker field for both is not an option since I need both of these values to appear in the same field. I have not been able to think of a way to make this work.

The left menu on my website is dynamic and it is based off a recordset from my filemaker database. My left menu is included on every page of my website and I do not want the find of the recordset to occur every time a user browses to a different page. I am looking for a way to store the results in a session so that it only has to look for them once per session. The code that creates my leftbar menu looks like this: <?php // FMStudio v1.0 - do not remove comment, needed for DreamWeaver support ?> <?php $categories_find = $Rackspace->newFindCommand('vehiclesearchsmall'); $categories_findCriterions = array('VehicleCategory'=>'=='.$_SESSION['make'],'VehicleId'=>$_SESSION['model'],'year'=>$_SESSION['year'],); foreach($categories_findCriterions as $key=>$value) { $categories_find->AddFindCriterion($key,$value); } fmsSetPage($categories_find,'categories',10000); $categories_find->addSortRule('SubCategory2',1,FILEMAKER_SORT_ASCEND); $categories_result = $categories_find->execute(); if(FileMaker::isError($categories_result)) {$error = 'yes';} else { fmsSetLastPage($categories_result,'categories',10000); $categories_row = current($categories_result->getRecords()); } ?> <?php $lis = array(); foreach ($categories_result->getRecords() as $cer) { $tac = $cer->getField('SubCategory2'); $lis[$tac] = (!isset($lis[$tac])) ? 1 : $lis[$tac] +1 ; } foreach ($lis as $nam => $valu) { echo '<dd class="categories" style="border-bottom:1px dotted #999;"><a href="cilist.php?VehicleCategory='. $_SESSION['make'] .'&SubCategory2=' . $nam . '&VehicleId=' .$_SESSION['model'] . '&year=' . $_SESSION['year'] . '" >' . $nam .'</a> '. '(' . $valu . ')' . '</dd>'; } ?> I tried storing the $categories_row in a session variable but it would only give me one result. I am stuck here any help would be greatly appreciated.

Hello, I have written a lot of scripts in filemaker that use the Show Custom Dialog option. Is there a way to change the position of these dialog boxes? instead of them popping up in the middle I want them to appear on the left. Or is there a way to make that a default setting for ALL dialog boxes? Thanks for your help.

I began to split the items and export them in smaller chunks. The second set of items i was exporting gave me the same invalid character error and it is only 3k of them. It sucks because even though it gives me the line and column in which its in it creates it in a temp file. Then a blank file is created. So I think you're right it might not have exported all the records because of the same error. The challenge now is to find these illegal characters with in the thousands of records and their many fields. But that is my problem to solve your style sheet works perfectly I uploaded successfully to Google with the first set of items that worked fine. I'm going to try to browse to the temp file that was created and track all the characters from there.

I don't. It creates the file but i read this comment at the top: I dont know if that is normal. Also I scrolled down to the end to see if it did all the records and it does not. I exported 20k items and there are only 13k lines of code. Plus the ending line is a description which is cut off. Maybe the problem is the size of the file? I can probably try to see what the limit is and split my items once again.

I get the attached error when doing the export. It works fine when i do a found set of other items. So maybe it could be that I have illegal characters in one of items when i try to export the whole database. I'm actually pretty sure that's what that is. Unless you specify something different. Its going to be hard hunting down these illegal characters.

Thanks a lot once I try this out I'll let you know how it works.

Here it is. xml.zip

This is the php code i use to create the pages. It should give you an idea of the format and fields. <?php require_once('../Connections/Rackspace.php'); ?> <?php header('content-type: text/xml'); echo '<?xml version="1.0"?>' . "n"; echo '' . "n"; echo '' . "n"; echo 'Discount Truck Accessories' . "n"; echo 'http://www.discounttruckaccessories.com' . "n"; echo 'Truck accessory products updated daily' . "n"; ?> <?php $items_find = $Rackspace->newFindCommand('googlefeed'); $items_findCriterions = array('xml'=>'=='.fmsEscape('g'),); foreach($items_findCriterions as $key=>$value) { $items_find->AddFindCriterion($key,$value); } fmsSetPage($items_find,'items',3000); $items_result = $items_find->execute(); if(FileMaker::isError($items_result)) fmsTrapError($items_result,"error.php"); fmsSetLastPage($items_result,'items',3000); $items_row = current($items_result->getRecords()); $items_row = current($items_result->getRecords()); foreach($items_result->getRecords() as $items_row){ echo '' . "n"; echo ''. htmlspecialchars($items_row->getField('ProductManufacturer')). " " . htmlspecialchars($items_row->getField('_kp_PartNumber')) . " ".htmlspecialchars($items_row->getField('DescriptionShort')) . " " . htmlspecialchars($items_row->getField('VehicleId')) . '' . "n"; echo '' . htmlspecialchars($items_row->getField('ProductPrice')) . '' . "n"; echo 'http://www.discounttruckaccessories.com/details.php?ProductID=' . htmlspecialchars($items_row->getField('ProductID')) . '' . "n"; echo '' . htmlspecialchars($items_row->getField('ProductID')) . '' . "n"; echo '' . htmlspecialchars($items_row->getField('VehicleCategory')) . " " . htmlspecialchars($items_row->getField('VehicleId')) . " " . htmlspecialchars($items_row->getField('VehicleDetail')) . " " . htmlspecialchars($items_row->getField('year')) . " " . htmlspecialchars($items_row->getField('BedSize')) . htmlspecialchars($items_row->getField('Cab')) . " " . htmlspecialchars($items_row->getField('DescriptionLong')) . '' . "n"; echo 'new' . "n"; echo '' . htmlspecialchars($items_row->getField('VehicleCategory')) . '' . "n"; echo 'http://72.32.124.231:8020/SuperContainer/RawData/Images/Inventory/' . htmlspecialchars($items_row->getField('ProductID')) . '' . "n"; echo '' . htmlspecialchars($items_row->getField('_kp_PartNumber')) . '' . "n"; echo '' . htmlspecialchars($items_row->getField('MainCategory')) . '>' . htmlspecialchars($items_row->getField('SubCategory1')) . '>' . htmlspecialchars($items_row->getField('SubCategory2')) . '' . "n"; echo '' . htmlspecialchars($items_row->getField('Weight')) . '' . "n"; echo '' . "n"; } echo '' . "n"; echo '' . "n"; // FMStudio v1.0 - do not remove comment, needed for DreamWeaver support ?> The resulting page should look like this: <?xml version="1.0"?> Discount Truck Accessories http://www.discounttruckaccessories.com Truck accessory products updated daily Truxedo 888601 Truck Roll Up Tonneau Cover Titan 368.1 http://www.discounttruckaccessories.com/details.php?ProductID=108220 108220 Nissan Titan w/ or w/out Track System 2004, 2005, 2006, 2007, 2008, 2009, 2010 6.5' Bed TruXedo used the latest cutting edge technology to bring you a truck bed cover that not only looks great, but is extremely functional at a great price. The TruXedo Edge mounts between your bed rails allowing you to utilize your stake pockets for racks and tie down points. Installing a Truxedo Edge tonneau cover with it's clamp-on design is simple and easy without doing any drilling or cutting. TruXedo has added a tension control system that allows you to keep your truck bed cover tight with no tools required and the velcro closures along the sides are among the widest in the industry. Opening and closing the Edge is a breeze with TruXedo's one finger quick release mechanism. The Edge truck bed cover is backed by TruXedo with a full 5 year warranty new Nissan http://72.32.124.231:8020/SuperContainer/RawData/Images/Inventory/108220 888601 Tonneau Covers>Soft Tonneau Covers>TruXedo Edge Tonneau Cover 40 XML works perfectly for what I am trying to do since I can combine different fields into one mark up tag. This helps for SEO purposes.

Ok that's what I thought. So I just need to format this XSLT style sheet so that the fields in the database go in between the marks up I set up on it. Is there an example of this being done anywhere? My knowledge of XML and XSLT is very limited.

Hello, My truck accessory company uses Google's Merchant Center to put our items in their google product search. One way to upload your items is using XML (which is what I use). To put all the items from my filemaker database into an XML format I use a PHP page which disguises itself as an xml page. And just basically echos the xml in the google format. I have over 20k items and my method is time consuming. One because the php times out since I have so many tiems so I have to break down the database into bits. I've been looking into exporting the database and all the fields that I need in XML straight from the database. But how would I place the fields within the mark up tags that I specify? Does an XSL stylesheet do this for you? I'm new to XSL I just need a step in the right direction.

That's exactly what I am trying to do right now. The only problem I am having right now is relating the second import of the items back to the invoices. When I export the items from the website they have an invoice number but it is different from the field InvoiceID which we use in our filemaker. The InvoiceID is an auto created serial which keeps each invoice unique. The portal field is set related to the InvoiceID field not the one that comes off the cart. So for the second import I would need all the InvoiceID's that were just created from the first import to relate the items and have them show up on the portal fields. But anyways I am trying a couple of different solutions thanks for your help. I'll probably be back if I get stuck.

Here is my scenario: My business gets it its orders from our online shopping cart website. The orders get stored in the control panel of our shopping cart solution. These orders have to then be taken out and put into filemaker where we process the orders. When there are a lot of orders this becomes a very tedious process, but I noticed that the shopping cart solution allows you to export all the orders. The only issue is that in my filemaker invoice solution all the items for the order are stored in a portal field. Whenever I export the records as a csv file from the website, and a order has more than 1 item the second item is made into a completely new record with the rest of the fields repeated. Is there any possible way to export the orders and import them into filemaker while adding these items to the portal field so that this whole process is automatic and I don't have a bunch of repeated records?

getascss was messing it up thanks alot!

yes it looks like this EmailCreate( "orders@pickupspecialties.com" ; PICKUP SPECIALTIES::EMAIL ; PICKUP SPECIALTIES::emailSubject ) and EmailSetBody( GetAsCSS( PICKUP SPECIALTIES::emailBody ); "html" ) and EmailSend which is set in a variable $result the emailbody field looks like this: Dear Steven: We are sending you this email to let you know that we have processed your order 137470. Many customers that purchased part # LRV6928 have also purchased these items: the email is sent fine but it comes in with the html tags showing. I need them to be actual html.

I've successfully added the plug in and I am able to send emails using the email 360 plug in. I have not been able to send an html email though. I read the documentation and apparently the only way to send an email with html is if that field is formatted in filemaker. This does not work for me since the body of my email comes from one field. The field is just a calculation field which is basically a string of text and fields to write a simple letter to my customers. I implemented the html in the calculation but when the email is sent all the tags are visible and it is not html. Is there any possible way to make this work?

Thanks a lot that works great. I just need to get more familiar with the way filemaker "language" works.

I basically need an address label. I have the fields: firstName, lastName, address, city, state, zip Instead of individually copying each field to an email i want to create a field that has all those fields already in it combined. Is this possible through a calculation? i tried a merge field but for some horrible reason you cannot select its contents. This would be of great help.

im using FMSA9 is that still possible?

Hello, I have a database. I made that database accessible to a lot of different people through IWP. I need to know when one of those people have added/edited a record through some sort of email notification. Is this possible if people are adding items through IWP?

no no image or graphics on it. I do have alot of different fonts but I'll change them all to one to see if that helps. I also have 3 supercontainer fields on there..and a portal field. It's just hard to track down the issue because I do have so many things on this layout.

Everytime I close my database on my inventory layout it crashes filemkaer completely closing all my other databases. This layout has alot of fields and I dont know if there is a limit as to how many fields you can have in a layout? Or any ideas of what else causes filemaker to crash from closing a certain layout?

That works perfect! thanks to both of you lovely ladies :)

Im setting it up now but where you have Result: False it keeps telling me it does not recognize the table. I am not sure how you want me to put that in there. I left that empty and the pop comes up fine but the issue is that no matter what button I click everything still closes.

I need to make a script for the people in my office that will ask if they are sure they want to close filemaker 10 when they hit the X at the top right. They keep complaining that somtimes they close it by mistake and it closes down everything without asking them. I tried looking to see if filemaker had a built in option like this but I was not able to find one. So i figured the next best thing would be to create a script.