Jump to content


Photo

mailing list


  • Please log in to reply
7 replies to this topic

#1 ypf1258

ypf1258

    Advanced Member

  • Moderators
  • PipPipPip
  • 101 posts
  • Gender:Male
  • Location:ny

Posted 06 September 2004 - 09:55 PM

Does anybody know how to export customer list from mom without the lmm
The way we did it till now is we went in dbuwin.exe did open we selected cust dbf
And the did browse - table � copy to � selected excel worksheet and did copy just this year we have 23,000 customers and it only copy�s 19,000
I tried doing it with RR but did not help
[email protected] :(

#2 ufsimatt

ufsimatt

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 07 September 2004 - 09:15 AM

If by RR you are referring to Report Writer, then you should easily be able to do it with that program, by selecting the CUST.dbf and then putting the fields you want on the report. Then do a file export to a worksheet format or some other format and you should be good to go. Alternatively you could accomplish the same thing using MS Access. If you have any other questions or would like some help feel free to email me, [email protected].

#3 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 29 September 2004 - 09:03 AM

Hey,

If you provide a layout of the type of info you want to pull from your tables I can send you a similar report I have designed.

Cheers,

David

[email protected]
David Narciso
Ecommerce Operations Manager CVS Inc

[email protected]

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.

#4 ypf1258

ypf1258

    Advanced Member

  • Moderators
  • PipPipPip
  • 101 posts
  • Gender:Male
  • Location:ny

Posted 10 October 2004 - 09:15 PM

Hey,

If you provide a layout of the type of info you want to pull from your tables I can send you a similar report I have designed. 

Cheers,

David

[email protected]

hi David
the problem is that it get exported in 95 workbook xl5 that has limitation to 19000 rows while we need 25000
in the end I did it with ms excel>data>get external data>new database query >visual fox pro database> free table directory>so on

#5 Guest_Guest_*

Guest_Guest_*
  • Guests

Posted 11 October 2004 - 08:54 AM

I tried doing the same thing as you. Your better off just spending the $700 on the LMM to get the job done correctly without problems.

#6 ypf1258

ypf1258

    Advanced Member

  • Moderators
  • PipPipPip
  • 101 posts
  • Gender:Male
  • Location:ny

Posted 11 October 2004 - 03:59 PM

I tried doing the same thing as you. Your better off just spending the $700 on the LMM to get the job done correctly without problems.

IT WORKED PERFECTLY FINE THIS WAY SO Y SPEND $700

#7 beccalori

beccalori

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 31 August 2007 - 07:13 AM

Does anybody know how to export customer list from mom without the lmm
The way we did it till now is we went in dbuwin.exe did open we selected cust dbf
And the did browse - table � copy to � selected excel worksheet and did copy just this year we have 23,000 customers and it only copy�s 19,000
I tried doing it with RR but did not help
[email protected] :(


Since DBF files are essentially compatible as Microsoft Fox Pro, I was able to link to a copy of the file using Microsoft Access, and the MSFOX Pro ODBC Driver.
I set this up as a recurring task to sync MOM customer data to other data warehouses and to sync monthly with my Email Service Provider for sending bulk customer mailings and announcements to my opt-in lists. The data is updateable, but I would suggest only pointing to Live data in single-user mode for bulk SQL update Queries, and of course ALWAYS make sure you have completed your daily backup in case things go awry in your script.

Best,
Joe Beccalori
MOM User

P.S. - I also use SiteLink, and I am working on modifying some of the core files to make the shopping cart pages more Search Engine Friendly. If anyone cares to share thoughts on this let me know.

SEO Consultant

#8 fanlin

fanlin

    Newbie

  • Members
  • Pip
  • 4 posts

Posted 11 May 2009 - 12:33 AM

I am honored to address you tonight. On behalf of the graduating masters and doctoral students of Washington University's School of Engineering and Applied Science, I would like to thank all the parents, spouses, families, and friends who encouraged and supported us as we worked towards our graduate degrees. I would especially like to thank my own family, eight members of which are in the audience today. I would also like to thank all of the department secretaries and other engineering school staff members who always seemed to be there when confused graduate students needed help. And finally I would like to thank the Washington University faculty members who served as our instructors, mentors, and friends.wow gold

As I think back on the seven-and-a-half years I spent at Washington University, my mind is filled with memories, happy, sad, frustrating, and even humorous. World of warcraft Power Leveling

Tonight I would like to share with you some of the memories that I take with me as I leave Washington University.

I take with me the memory of my office on the fourth floor of Lopata Hall - the room at the end of the hallway that was too hot in summer, too cold in winter, and always too far away from the women's restroom. The window was my office's best feature. Were it not for the physics building across the way, it would have afforded me a clear view of the arch. But instead I got a view of the roof of the physics building. I also had a view of one corner of the roof of Urbauer Hall, which seemed to be a favorite perch for various species of birds who alternately won perching rights for several weeks at a time. And I had a nice view of the physics courtyard, noteworthy as a good place for watching people run their dogs. It's amazing how fascinating these views became the longer I worked on my dissertation.wow power leveling, But my favorite view was of a nearby oak tree. From my fourth-floor vantage point I had a rather intimate view of the tree and the various birds and squirrels that inhabit it. Occasionally a bird would land on my window sill, which usually had the effect of startling both of us.

I take with me the memory of two young professors who passed away while I was a graduate student. Anne Johnstone, the only female professor from whom I took a course in the engineering school, and Bob Durr, a political science professor and a member of my dissertation committee, both lost brave battles with cancer. I remember them fondly.

I take with me the memory of failing the first exam in one of the first engineering courses I took as an undergraduate. I remember thinking the course was just too hard for me and that I would never be able to pass it. So I went to talk to the professor, ready to drop the class. And he told me not to give up, he told me I could succeed in his class. For reasons that seemed completely ludicrous at the time, he said he had faith in me. And after that my grades in the class slowly improved, and I ended the semester with an A on the final exam. I remember how motivational it was to know that someone believed in me.

I take with me memories of the midwestern friendliness that so surprised me when I arrived in St. Louis 8 years ago. Since moving to New Jersey, I am sad to say, wow power levelingnobody has asked me where I went to high school.

I take with me the memory of the short-lived computer science graduate student social committee lunches. The idea was that groups of CS grad students were supposed to take turns cooking a monthly lunch. But after one grad student prepared a pot of chicken that poisoned almost the entire CS grad student population and one unlucky faculty member in one fell swoop, there wasn't much enthusiasm for having more lunches.
world of warcraft power leveling,
I take with me the memory of a more successful graduate student effort, the establishment of the Association of Graduate Engineering Students, known as AGES. Started by a handful of engineering graduate students because we needed a way to elect representatives to a campus-wide graduate student government, AGES soon grew into an organization that now sponsors a wide variety of activities and has been instrumental in addressing a number of engineering graduate student concerns.

the memory




2 user(s) are reading this topic

0 members, 2 guests, 0 anonymous users