ViarexJonas's Content

#2822 Find Products Associated With Catalog Code

Posted by ViarexJonas on 04 November 2010 - 06:48 AM in General Sitelink Discussion

Does anyone know of any sitelink method/function that I can call to get a list of all products associated with a given catalog code?

#2763 Select certain fields on CUST table using dbuwin

Posted by ViarexJonas on 03 June 2010 - 12:57 PM in MOM & FOX Database Issues

Appreciate the help David! Thanks again!

#2761 Select certain fields on CUST table using dbuwin

Posted by ViarexJonas on 03 June 2010 - 08:50 AM in MOM & FOX Database Issues

I'm currently running v6.2 and using DBUWin.exe to query the CUST table. I would like to export all the email suppressions. Here's the query statement I use to gather all the email suppressions: LIKE("*@*.*",Cust.email) AND Cust.noemail = .T.

The problem is that it is pulling all the fields.

#2759 Select certain fields on CUST table using dbuwin

Posted by ViarexJonas on 03 June 2010 - 08:34 AM in MOM & FOX Database Issues

Hoping to bump this and get an answer to this question please.

#2754 Sitelink. Methods/Functions

Posted by ViarexJonas on 24 May 2010 - 09:59 AM in General Sitelink Discussion

Hi Guys,

I was wondering if anyone had a comprehensive list of all the methods/functions used by sitelink (e.g. sitelink.itemadd, sitelink.verifysourcekey, etc) along with what each parameter placeholder is meant to hold)? I don't want the actual code for each routine but would rather just like a cheatsheet that has all of the methods listed out for reference.

TIA!

#2739 Select certain fields on CUST table using dbuwin

Posted by ViarexJonas on 14 April 2010 - 11:14 AM in MOM & FOX Database Issues

Actually what I'm trying to do is just get the email field instead of all the fields from the Cust table.

#2737 Select certain fields on CUST table using dbuwin

Posted by ViarexJonas on 14 April 2010 - 08:39 AM in MOM & FOX Database Issues

Is it possible to select only the email field in the CUST table when using dbuwin and filtering the records?

#2735 Export Suppression Emails

Posted by ViarexJonas on 13 April 2010 - 06:54 AM in Email Issues & List Management

Unfortunately LMM doesn't have the option to exclude based on the NoEmail Field. What are you using on MOM 7i XL?

#2731 Export Suppression Emails

Posted by ViarexJonas on 12 April 2010 - 12:07 PM in Email Issues & List Management

I'm not on MOM 6.2 but it should work the same way..

You might be able to try making a list of everyone with an email address (click Include/Names/Customer Attribute/E-Mail Address), then clicking File/Export Defined List. If you click the Select Fields button you can select the "No E-Mail" field which'll export if the customer has do not email enabled or not.

In this way you can create a list of all emails & then maybe sort it in Excel by the "No E-Mail" column or however you want to do it.

Thanks for the response Larsm but I'd really like to find a way to do this without having to sort with Excel.

#2728 Export Suppression Emails

Posted by ViarexJonas on 12 April 2010 - 11:09 AM in Email Issues & List Management

Hi,

We are currently v6.2 of M.O.M. with the List Management Module. I am trying to figure out how to create a query to only export the emails of customers who do not wish to be emailed. The reason for this is so I can upload these names to our suppression list for affiliates.

TIA