ProFox

profox@leafe.com

2704 discussions

Conversion job from VFP -> C# MVC
by Stephen Russell 28 Sep '16

28 Sep '16

Came in an old email address I look at every once in a while. Greetings!! This is Arif from Softpath System LLC. Softpath is a preferred nationwide staffing vendor to Fortune 500 companies in the US. We have an immediate opportunity with one of our clients. Please find the job description below and if you are interested, please forward your resume to arif(a)softpath.net. You can also reach me at 404 - 315 –1555 ext- 699 *Job Details:* *Title : .Net with Visual FoxPro applications* *Location : Durham, NC* *Duration : 12 Months Contract* The NC Department of Health and Human Services is seeking a short term (approx. 12 months) contractor. This position is responsible to lead functional and detailed requirement development, code development, Joint Application Development (JAD) sessions, functional and detailed design, business and workflow process modelling and business re engineering. This position is responsible for data analysis, data modelling and data conversion from Visual FoxPro to SQL Server. This position is also responsible for developing complex database stored procedures, peer reviews and scrum management practices. This position will be reporting to DHHS IT Manager and also working in conjunction with assigned Project Manager. *Expected Skills:* Able to work without assistance; can provide leadership to others; able to manage complex work efforts; may have advanced education; may have deep industry experience. *Description *(including, but not limited to): 1. Guidance and leadership in the usage and support of a collection of development platforms, technical architectures, or business applications and products that run on those platforms, beyond that of a Developer / Programmer 2. Understanding and knowledge of application development and architecture that serves as a strong base for technical expertise in a specific product or program 3. Analysis, visual design, development, data analysis, testing and implementation, technical and user documentation, software conversions, maintenance (including production support), etc. Skill Matrix: *Skill* *Required / Desired* *Years of Experience* Extremely strong in analyzing Visual FoxPro applications and develop the requirements for the migration Required 7 Years Experience in planning and estimating a technology migration project Required 7 Years Minimum of (7) seven years of experience in Applications Development, Database design and Support with Visual FoxPro Required 7 Years Minimum of (7) seven years of experience in n-tier client/server systems Required 7 Years Minimum of (5) Five years of experience in handling IT Agile Project Management activities using JIRA Required 5 Years In-depth knowledge and understanding of Web Service standards (SOAP, UDDI, and WSDL), graphical UI development experience, network operating system Required 7 Years Thorough knowledge of the principles of application systems development and its associated lifecycle Required 7 Years Expertise with web architecture and structured design Required 7 Years Demonstrated Ability to work independently and in a team setting to meet tight deadlines Required 7 Years Advanced technical skills and significant experience in enhancing client/server and web sites using programming techniques and languages Required 7 Years Experience with applying C#, ASP.NET, MVC architecture, Angular, Visual Studio .NET, ASP, Visual Studio v6.0 and above, VB, SQL, ODBC/OLE DB Required 7 Years Experience with data access to MS SQL Server, Visual FoxPro tables etc., Required 7 Years Experience using web-related technologies (including XML, HTML, CSS, VBScript, JavaScript, IIS) Required 7 Years Experience in writing complex stored procedures in SQL Server Required 7 Years Advanced experience with data analysis and data conversion from Visual FoxPro to SQL Server Required 7 Years Experience in developing complex SSRS reports Required 7 Years Experience integrating SAML with Identity services (such as NCID) for application authentication Desired 3 Years Demonstrated Ability to guide and mentor team members and build good working relationships Required 5 Years Knowledge and experience in Subversion Required 5 Years Experience in the field of accounting Highly desired 5 Years Excellent written and verbal communication skills Required Contractor should be able to join before the end of August 2016 Required *Thanks & Regards,* *Abdul Arif |Recruiter*| Email: *arif(a)softpath.net* <s.jagadeesh(a)softpath.net> Work: (404) 315-1555 Ext. 699 | Fax: (404) 315-1558 *Softpath System LLC* | 3985 Steve Reynolds Blvd | Bldg C| Norcross GA 30093 *www.softpath.net* *Disclaimer:* *We respect your online privacy. You received this message because either you have provided our recruiters with your information in the past, or you have posted your resume to one of many online job posting agencies (CareerBuilder, Monster etc.) to which we subscribe. If you have received this email in error, please accept our apologies and reply with "unsubscribe" in the subject line or click on following link to be removed from our mailing list: **unsubscribe(a)softpath.net* <unsubscribe(a)softpath.net>*. Softpath System cannot guarantee that e-mails are secure or error-free, as information could be intercepted, corrupted, lost, destroyed, and or contain viruses.* -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 9

VFP7 SP1, InstallShield MSMs, etc.
by Ted Roche 28 Sep '16

28 Sep '16

Hi, folks: I find myself in the funny position of having to recreate a VFP7 development environment, and having some trouble locating all the pieces. My VFP7 DVD (and serial number!) were in the proper place in the archives, but I wasn't as careful about archiving the SP1 patch nor the matching patches for the installshield MSMs that install updated runtimes. The MSFT site has a link for VFP7SP1, but it errors out. Google points out InstallShield updates, but it too 404's. I do have the vRunFox7 executable, of course (thanks, Ed!) and the runtime installer from dfPUG, so I can cobble something together. I'm digging through the dusty archives, but if anyone can point our a reliable, non-malware-laced, place to get these online, I'd be grateful. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

7 19

Error 1001
by Paul Newton 26 Sep '16

26 Sep '16

Can anybody think of any reasons for this error to occur running an executable other than: Set Step On Suspend Using the wrong runtime DLLs Thanks Paul Newton

3 7

M$ giving more support to dbf?
by Stephen Russell 23 Sep '16

23 Sep '16

Drivers for Access to use should help you with your foxpro files I am guessing. http://www.winbeta.org/news/dbase-file-support-comes-back-microsoft-access -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

13 38

Trying to write Excel automation code in VFP9SP2 from Excel 2013 VBA macro code
by mbsoftwaresolutions＠mbsoftwaresolutions.com 23 Sep '16

23 Sep '16

VFP9SP2. Data is in MySQL (MariaDB) database on a different machine (at 10.8.20.109). Trying to use VFP to generate Excel files for 55 different outputs (providers), with each workbook/file having a tab for each record type (which is usually 3 types: 1, 2, and 3). My initial concern is how to deal with the named parameters in the first ListObjects.Add line, as VFP doesn't work like that. Note that the _ is a continuation character for VBA code (like the semi-colon is for VFP code), so that first WITH line goes to the QueryTable word. I used VFP to dynamically create the views for each of the 55 providers, so there's about 165 views. Trying to do all this via automation for ease and accuracy. Nobody wants to create 165 imports and 55 saves manually!!! I already created a ODBC connection called tim_dsh to connect to the remote database. (Yes, using the root user remotely isn't good practice. Move on from that. This is internal!) For this example, provider is 210001 and views are v_op_<provnum>_<rectype>. VBA code: With ActiveSheet.ListObjects.Add(SourceType:=0, Source:= _ "ODBC;DATABASE=tim_dsh;DESCRIPTION=Tim's DSH data;DSN=Tim_DSH;OPTION=69533696;PORT=3306;SERVER=10.8.20.109;UID=root;" _ , Destination:=Range("$A$1")).QueryTable .CommandType = 0 .CommandText = Array("SELECT * FROM `tim_dsh`.`v_op_210001_1`") .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .PreserveColumnInfo = True .SourceConnectionFile = _ "C:\Users\mbabcock\Documents\My Data Sources\tim_dsh v_op_210001_1.odc" .ListObject.DisplayName = "Table_tim_dsh_v_op_210001_1" .Refresh BackgroundQuery:=False End With Sheets("Sheet1").Select Sheets("Sheet1").Name = "Record Type 1" Sheets.Add After:=ActiveSheet With ActiveSheet.ListObjects.Add(SourceType:=0, Source:= _ "ODBC;DATABASE=tim_dsh;DESCRIPTION=Tim Forry's DSH data;DSN=Tim_DSH;OPTION=69533696;PORT=3306;SERVER=10.8.20.109;UID=root;" _ , Destination:=Range("$A$1")).QueryTable .CommandType = 0 .CommandText = Array("SELECT * FROM `tim_dsh`.`v_op_210001_2`") .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .PreserveColumnInfo = True .SourceConnectionFile = _ "C:\Users\mbabcock\Documents\My Data Sources\tim_dsh v_op_210001_2.odc" .ListObject.DisplayName = "Table_tim_dsh_v_op_210001_2" .Refresh BackgroundQuery:=False End With Sheets("Sheet2").Select Sheets("Sheet2").Name = "Record Type 2" Sheets.Add After:=ActiveSheet With ActiveSheet.ListObjects.Add(SourceType:=0, Source:= _ "ODBC;DATABASE=tim_dsh;DESCRIPTION=Tim Forry's DSH data;DSN=Tim_DSH;OPTION=69533696;PORT=3306;SERVER=10.8.20.109;UID=root;" _ , Destination:=Range("$A$1")).QueryTable .CommandType = 0 .CommandText = Array("SELECT * FROM `tim_dsh`.`v_op_210001_3`") .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .PreserveColumnInfo = True .SourceConnectionFile = _ "C:\Users\mbabcock\Documents\My Data Sources\tim_dsh v_op_210001_3.odc" .ListObject.DisplayName = "Table_tim_dsh_v_op_210001_3" .Refresh BackgroundQuery:=False End With Sheets("Sheet3").Select Sheets("Sheet3").Name = "Record Type 3" ChDir "G:\somepath" ActiveWorkbook.SaveAs Filename:= _ "G:\somepath\21001_outpatient.xlsx", _ FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False Tips/ideas appreciated. Thanks!!! --Mike

4 8

RE: [NF] Looking for Alpha 5 (Alpha Anywhere) users
by Gene Wirchenko 23 Sep '16

23 Sep '16

At 07:34 2016-09-08, Kevin J Cully <kjcully(a)cherokeega.com> wrote: >When I walk into a store, and prices aren't listed on the products >... I know I'm out of my comfort zone. I think that it is a cheap way to convert curiosity to prospects. I also think it is not that workable. I usually walk from such a situation. I want to do some basic checking before I talk to salespeople. I think that forcing someone into a sales situation prematurely is not a good idea. They can say that the walkers were not good prospects, but they do not actually know. Sincerely, Gene Wirchenko

2 1

[ADMIN] Help me raise money for MS Research
by Ed Leafe 22 Sep '16

22 Sep '16

Hey all, It’s that time of year - the Valero Ride to the River 2016, which is a distance bike ride to raise money to fund research into a cure for Multiple Sclerosis. I missed the ride last year as I was in the middle of moving to a new house, and didn’t have time to train. I almost missed it this year, due to a minor surgery on one of my toes, but it’s healed enough for me to get back to training. The ride is a two-day event, with a choice of 100 or 71 miles on the first day, and a choice of 61 or 38 on the second. I’m going to be conservative and just go for the shorter ride each day, since I’ll have had less than a month to get into shape. And since I did the full century in my ride in May, I don’t have anything left to prove ;-) The ride is on October 1-2, and I need your help! I have a goal of $300 to raise, and based on past experience, that should be no problem for this generous community! If you find ProFox to be a valuable resource, I ask that you donate whatever you’re comfortable giving. To donate, please go to: https://goo.gl/4Wuo4i Thanks once again! -- Ed Leafe

7 11

VFP9 on Windows 10
by Allen Pollard 17 Sep '16

17 Sep '16

Hi gang I seem to be having an annoying failure in VFP9 on windows 10. After running the program in dev I call the taskpane. The taskpane is closed at the start of the prog and called on close. But, it stays blank and what's worse it locks up VFP. Anyone else having this. Never happened in Windows 7 or 8 so this is new and seems to be just the taskpane in environment manager. As far as I know. Al

5 17

Oracle question
by Matt Wiedeman 15 Sep '16

15 Sep '16

Hi everyone, I have a task to sync two tables in Oracle. There are two sets of tables. One is the set used by the application. The other set of tables are identical but each has an action field that is used do show if the row should be an add, update, or delete. An interface tool is populating these. I must take these interface tables and update the originals. I hope that makes sense. Anyway, in FoxPro, I could just loop through each row, run "scatter memvar", locate/seek for the matching row in the original table, and run "gather memvar". Does anyone know of an approach in Oracle like that or perhaps have some advice on doing this?

6 9

[NF] Android learning apps
by Garrett Fitzgerald 14 Sep '16

14 Sep '16

I've gotten interested in Android's potential to teach me programming instead of just games and social media. I enjoyed the SoloLearn LearnPython app. Their PHP one wasn't as good, but i felt I got something out of it. I'm currently using Enki, but I'm not sure i like their 5-a-day workout style. What have other people enjoyed? Or not? Thanks. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox