Jump to content

Devin

Members
  • Content count

    124
  • Joined

  • Last visited

Community Reputation

1 Neutral

About Devin

  • Rank
    member

Profile Information

  • Gender
    Not Telling
  1. docasar, That can be done by using the EmailReadMessageValue... The Doc describe this and even give an example for what your asking.. Set Variable [ $result = EmailReadMessages( "viewed=false" ; "readonly=false" ) ] If [$result = "ERROR"] # Handle Error Here... End If Loop Exit Loop If [not EmailGetNextMessage] Set Variable[$result ; EmailMessageSetFlag("viewed") If [EmailReadMessageValue("from") = "deleteme@example.com"] Set Variable[$result ; EmailMessageSetFlag("deleted") End If End Loop In this case they are deleting the message from deleteme@example.com..
  2. Docasar, 360works email plugin does just what your wanting to do.. Have you looked at it.. They offer a free demo version that works for 2hours before you need to relaunch Filemaker.
  3. I was just thinking about trying pattern count for ¶. From what I can tell based on my scan of emails they have 4 different ways they are suppling the address. 1 - 7line version, 2 - 6 line version and 1 -5 line version. By doing an if statement for them based on the pattern count.. For the 2 - 6 lines version will need to see if only numbers are the last line. then based on that I would know what version of the 6 line it is. Just me thinking out loud..
  4. I can capture the address as a single text field by using one of the techniques above.. So yes that is my dilemma in breaking them up in to individual elements... from what I can tell their is not away to capture number of Lines? Was thinking if their was then it might be possible.
  5. I do not need to loop between the each SKU for the shipping address. They will always be the same.. I'm told. My issue is trying to figure out how to take an address info and split it as it varies order to order with the amount of data they supply.
  6. sorry. should have explained that part more...The shipping address it the part below the Shipping Method for each SKU (Line Item) Example 1 Shipping Method Fedex 2nd DayShipping Address Companystore XYZATTN : MEBigstreetSmalltown , CA - 22112US Example 2 Shipping Method Fedex 2nd DayShipping Address Companystore XYZATTN : MEBigstreetSmalltown , CA - 22112US 333-111-8888 Example 3 Shipping Method Fedex 2nd DayShipping Address Companystore XYZATTN : ME Bigstreet Suite 1A Smalltown , CA - 22112US 333-111-8888 Example 4 Shipping Method Fedex 2nd DayShipping Address Companystore XYZATTN : ME Bigstreet Suite 1A Smalltown , CA - 22112US
  7. OK.. another issue is parsing out the shipping address info. In the example it's 5 lines. But looking thru orders I see that they may include 2 street lines for a suite or something.They also provide a phone number under the Country at times. Is there away to script this when it's not the same?
  8. Thanks Bruce.. I should have played around with the reasoning for the 10.. I was just assuming that it was starting at the end of the search string. Good info. Thanks for your mod.. Did not know I could use Char(9) to replace the hidden tab. Makes is much simpler to debug for visual. Diving deeper into your mod. I like the + Length( $startString) Trim( Middle ( $e_mail ; $start ; $end - $start )) Very cool way of cleaning up the text just incase.
  9. Found the issue.. The end position was my problem.. Let ( [ start = Position ( $e_mail ; "¶File URL" ; 1 ; $n ) + 10 ; end = Position ( $e_mail ; "¶Shipping Method " ; 1 ; $n ) ] ; Middle ( $e_mail ; start ; end - start ) ) What is the need for putting a length value? Just trying to better understand the logic.
  10. I have no issues grabbing the first when I keep $n = 1.. But if I want the 2nd one.. $n = 2 it fails to work. Here is my test fmp file that I'm playing with. Testemailparse.fmp12.zip
  11. Thanks Comment.. I was able to extract SKU info after making sure that Return Characters, Tabs and Spacing were correct. But I've been unable to grab anything else. I'm supplying a screen shot to show returns and tabs. Let ( [ start = Position ( $e_mail ; "¶File URL " ; 1 ; $n ) + 6 ; end = Position ( $e_mail ; "¶Shipping " ; 1 ; $n ) ] ; Middle ( $e_mail ; start ; end - start ) )
  12. I'm in the process of seeing if it's posable to parse emails orders? We get the emails that are very standard format. Getting them into filemaker was simple with 360works. Parsing the text above "1 SKU....." is simple. My issue is I need to create a loop and be able to break out each Line Number for it's own record.. In this example text there are two line numbers. Trying to grab SKU #, Item Name, Item Description, Item Cost, File URL Any help would be greatly appreciated!! PURCHASE ORDER PO # : 2974822-1 Date : 2017-06-09 From: Company 1111 SomeWhere Middletown, IL 11121 Ship Account Number : 3333329 1 SKU # CC-34QA-78489 Item Name Large Poster Item Description 3'x4' Poster Item Cost $18.75 File URL https://somewhere.com/poster_large.pdf Shipping Method Fedex 2nd Day Shipping Address Companystore XYZ ATTN : ME Bigstreet Smalltown , CA - 22112 US 2 SKU # CD-88KS-457894 Item Name Small Poster Item Description 1'x2' Poster Qty 1 Item Cost $18.75 File URL https://somewhere.com/poster_small.pdf Shipping Method Fedex 2nd Day Shipping Address Companystore XYZ ATTN : ME Bigstreet Smalltown , CA - 22112 US
  13. ODBC

    I'm not familiar sage, Your going to need to know what DB it's running and version so that you can have the correct version of driver installed on the Filemaker side. You also may want to look and see if they have an API for integrating. Using the API can be a safer way to integrate.
  14. That Worked.. I have no idea what that does.. But it works. Thanks once again Comment..
  15. Thisbeing used when I'm exporting XML so currently it's a set field calc that is Global.. Not being used for any layout. The issue with having a field to hold the offset is that would need to be changed based on the Daylight saving. The Get ( CurrentTimeUTCMilliseconds ) knows this info.. Just trying to get this info into a Time format.
×

Important Information

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