Jump to content

Steven1337

Members
  • Content count

    48
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Steven1337

  • Rank
    member
  1. 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.
  2. 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.
  3. Steven1337

    Position Of Dialog Boxes

    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.
  4. Steven1337

    Exporting XML for Google Merchant Center

    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.
  5. Steven1337

    Exporting XML for Google Merchant Center

    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.
  6. Steven1337

    Exporting XML for Google Merchant Center

    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.
  7. Steven1337

    Exporting XML for Google Merchant Center

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

    Exporting XML for Google Merchant Center

    Here it is. xml.zip
  9. Steven1337

    Exporting XML for Google Merchant Center

    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.
  10. Steven1337

    Exporting XML for Google Merchant Center

    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.
  11. 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.
  12. Steven1337

    Importing into portal

    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.
  13. Steven1337

    Importing into portal

    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?
  14. Steven1337

    Send HTML email

    getascss was messing it up thanks alot!
  15. Steven1337

    Send HTML email

    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.
×

Important Information

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