Search results by user ID 4202

Re: Transferring Data into QuickBooks TAKES FOREVER

WynneCrest — Thu, 05 Nov 2009 14:35:52 GMT

We have a high speed connection. We also have a small amount of network traffic, We run three computers on QuickBooks, but the system that hosts the company files is the one that downloads the method data and sends it to QuickBooks.The method engine is running. We checked that a couple times. We have had two issues with the method engine stopping randoming -- going into a "not responding" mode and quitting. That has only happened twice and we weren't even downloading any data at the time, so it is probably not related. It's just strange that the data transfer is taking over an hour when it used to take a minute when we first started. Let me know what I should try and I'll try it.

Also, it might be important to note that our QuickBooks file is very very large. QuickBooks has encouraged us to upgrade to Enterprise because of the size of our company file. We haven't seen any lag time on our end, but QuickBooks says we're getting too large.

Transferring Data into QuickBooks TAKES FOREVER

WynneCrest — Wed, 04 Nov 2009 17:11:51 GMT

I don't know if anyone else has had a problem with data lag but this is what's happening.

Once I hit "SEND ALL TO QUICKBOOKS," it processes immediately and says "89 records sent to quickbooks."

Then I go to QuickBooks and NOTHING IS THERE. I set a timer....20, 30, 40, 50 minutes pass....

About 2 hours later, the data appears in the timesheets. WHAT'S TAKING SO LONG?

Someone please help. This is very annoying.

Re: Xora to Method FlexField Mapping NIGHTMARE

WynneCrest — Wed, 07 Oct 2009 16:17:14 GMT

Is there a way we can get this done today? It would save me HOURS of work tomorrow fixing all of these mapping problems.

Also, I am not looking to upgrade to Full Blown right now.

Thanks.

Re: Xora to Method FlexField Mapping NIGHTMARE

WynneCrest — Tue, 06 Oct 2009 14:24:46 GMT

Val, has any progress been made on adding a "TRIM" function to my account? I am going to be doing payroll tomorrow and really really really really need my XORA data to map.

I was thinking that if you wanted to deactivate my account and let me just start over with a fresh method account, maybe that would be better and faster than trying to fix this awful problem. I can just download all of my customer mappings and flex field value mappings to excel and transfer them over to a different account. Just let me know if we should do this so I can download my data. I don't want to lose it.

Also, if I upgraded to the FULL BLOWN EDITION, would I get a new account?---I wouldn't want any of these problems transferring over to my new account. I would want a fresh account with nothing transferring over either automatically or residually (being left on a server attached to my account in any way). I would just transfer my data manually.

Re: What does this mean?

WynneCrest — Fri, 02 Oct 2009 23:50:01 GMT

Ok, here's a play by play for what I did:

I created the dropdown field "PayrollItem" for the Employee Screen. That one worked fine.

I then tried to create a Class dropdown field for the Employee Screen. I selected the dropdown value in the wizard and then got to the end and it gave me an error.

I tried to create it again using the same name for the field. I think I used "EmployeeClass" or something like that. This time I got an error that this field already existed....? I went back to see if it was there and it wasn't. I refreshed the page a couple of times and it wasn't there.

Next, I tried to create the same dropdown box with a different name. This time I called it "EmpClass" or something like that. It appeared to work. I believe this one appeared in the list. However, when I clicked the button "Finished editing Fields" I got another error and it wouldn't let me out of that screen.

I refreshed Method (the whole site) to get back to the beginning and then went back to check to see if the field was there. It was and so I went on to my Employee List Customized screen and added both fields to the screen. I tested it out and both seemed to be working.

That is all I did.

When I realized my Employee grid was not appearing in the "GET XORA TIME" screen, I deleted my Employee Customized screen to see if that would help. It didn't so I put it back.

I hope this helps.

SIDE NOTE: Honestly, this is not a big deal compared to my spacing problem on the other post. I would much rather you spend time helping me resolve the spacing issue. That is costing me a lot of money in man hours because I or someone else must correct all the data manually that is supposed to be mapping automatically....

Re: Xora to Method FlexField Mapping NIGHTMARE

WynneCrest — Fri, 02 Oct 2009 23:41:28 GMT

To attack this space problem, I tried a new approach:

I tried to create a whole new set of FlexField Values to see if the problem was with my "Item Listing" FlexField.

Therefore, I created a FlexField named "Service Item" and hand typed all of the values and then used the Excel API to upload the Mapping to the table--GREAT FEATURE!!

I used the new values in XORA with my phone for about 30 minutes and entered 5 or 6 different values. Then I uploaded the data to Method and guess what?

SPACES APPEARED IN FRONT OF ALL OF MY DATA......!!!!!????!!!!! NOTHING MAPPED AT ALL.

WHAT IS THE DEAL??

Re: Xora to Method FlexField Mapping NIGHTMARE

WynneCrest — Fri, 02 Oct 2009 03:55:56 GMT

I HAVE NEVER HAD SO MANY PROBLEMS WITH SOMETHING IN MY ENTIRE LIFE.

Ok, so I was trying a work around by creating a new flexfield list and remapping everything for "Service Item" instead of "Item Listing." (Which I used the API Excel sheet to upload and it worked great) Finally,I got all of my data changed in Xora, test data recorded, and was ready to import it into Method and guess what?

HALF OF MY "CONNECT WITH XORA: STEP 1" SCREEN IS MISSING!!!!!!!!

My entire employee list is GONE. I have not customized it or messed with anything (since it's a locked page) and it's just gone.

WHAT IS UP WITH THAT?????? HERE is the ERROR message I receive when trying to "Get Xora Time":

Action Sequence:2

There has been an error during the action process.

What does this mean?

WynneCrest — Thu, 01 Oct 2009 19:31:01 GMT

An error has occurred. An email has been sent to Method staff. If this problem persists, please contact the Method Team at method@methodintegration.com.

I receive this error only when adding dropdown fields to a table, but I get this message often.

Xora to Method FlexField Mapping NIGHTMARE

WynneCrest — Thu, 01 Oct 2009 17:01:04 GMT

Hello everyone! There is a lot of detail in this post, so thank you for reading and offering any advice.

First, I am a XORA user. I rely exclusives on the FlexField Value mapping to transfer my Xora data from Method into QuickBooks. Here is the history of my problem before we get into the new details.

I originally created a list of FlexField Values in WORD and pasted them into Xora. When the data was being transferred into Method, TWO spaces were appearing in front of all of my Values causing NONE of them to map. After copying the entire value list into Notepad, I found a single (ONE) space in front of my values.

I went through and deleted all of the spaces and re-uploaded the values to XORA and had my users re-download the new lists to their phones. This was 10 days ago........

Val,

I am having severe difficulties with the FlexField Value Mapping. After we discovered (10 days ago through the Notepad process) that there was one space in front of each of my field values, I removed them. This was a week and a half ago. Here's the problem. The spaces ARE NOT gone and I'm almost certain that Method is inserting these TWO spaces into my data as it retrieves it from Xora.

SIDE NOTE: On top of that, occasionally Method will not map a FlexField Value that is properly mapped and properly retrieved from Xora. It shows up without any spaces in "Custom 1" (I use the Custom 1 map field to see the original flexfield value) and then doesn't map?? ----UPDATE: What I have discovered is that while it appears that these values are coming through without spaces, they are NOT. When I close and re-open the Job Details, the SPACES APPEAR! (see steps 5-7 below)------

Some of the flexfield values are coming through CORRECTLY without spaces (about 15% of my data) and random ones still have the spaces (85% of the data---I say "random" because it is not always the same FlexField Values that have the spaces). It is very inconsistent. Different users have different values showing up with spaces and some users will have a value map correctly and then have that same value show up with spaces!!??!!

It is very annoying. I have recreated the lists multiple times in Xora and I know for 100% that there are NO spaces at all in any of my values. In order to test to see if Method was adding the spaces, I performed the following sequence:

1. I created a brand new profile in Xora and created a brand new FlexField Value list for this profile. I checked it in Notepad to ensure that there were no spaces in any of the values.

2. I uploaded the new settings to my test phone and recorded a shift with three jobs using these new FlexField Values. These test times occured on 9-30-09 between 7:00pm and 8:25pm.

3. I logged into Method and connected with Xora to transfer the new times.

4. After the new times transferred, I opened the entry to view the details. THIS IS WHERE IT GETS WEIRD

5. The first time I opened the job info, the value in "Custom 1" was correct with No Spaces. BUT IT WASN'T MAPPING!!

6. BECAUSE IT DIDN'T MAP, I went to the Value Mapping screen to double check that I had it mapped. It was correct.

7. When I went back to the job info to look at the value again, IT HAD SPACES. -----So the first time I viewed the details, there were no spaces, then there were spaces. -----After that point, every single VALUE that I imported from XORA with this new profile had TWO SPACES in front of it.

8. Then I went back and deleted the FlexField completely and made a new Field and hand-typed all of the values into the field. I tested it again and it didn't work. Spaces are still appearing in front of all of my data.

9. ANOTHER WEIRD ANOMALY: Because of the SPACING problems, I have been correcting hundreds of these entries by hand. I simply adjust the data in each job entry to reflect what the Value Mapping should have done automatically. After II click "SAVE AND CLOSE", I reopen the same job data and the SPACES DISAPPEAR FROM THE FLEXFIELD VALUES!!!!! So the spaces are there when I correct the data manually, but when I save my changes and reopen the data, they are gone.

This is very frustrating, but it seems like somewhere in the transfer period, spaces are being added to my flexfield values. See the copied data below.

I have spent that last two and half hours trying to fix this issue. Like I said, I am 100% positive that there are NO spaces in any
of my flexfield values.

However, none of my other FlexField Values are having spaces added to them. I am also not importing them through to Method either.

I would appreciate any help ANYONE can offer.

--------UPDATE: After speaking with Val on the phone, he is going to suggest to Engineering that they add a "TRIM" function to remove any spaces on the FlexField Values. I think that might solve the problem. However, since it is a Method problem at the core, it seems like something internally is adding the spaces to begin with. If the spaces were begin transferred into Method from XORA, then the TRIM function would work, but like I said, I know there are no spaces in my Xora data.

MORE DETAILS: Here is a portion of the XORA DATA that was imported. I don't know if this is possible, but it seems like the spaces are being added as the data is imported----------SEE BELOW:

ExternalTimesID: 73783211X
InternalJobID: 129851975
EventID: 11985868
EventName: Job Start
FieldName: Item Listing
FieldValue:   NB:Travel Time                   TWO SPACES ADDED TO THIS VALUE
**************************************************************
ExternalTimesID: 73966911X
InternalJobID: 129852199
EventID: 11985868
EventName: Job Start
FieldName: Item Listing
FieldValue: Aeration                                  NO SPACES ADDED---THIS ONE WORKED
**************************************************************
ExternalTimesID: 73784232X
InternalJobID: 129852226
EventID: 11769830
EventName: Job Start
FieldName: Item Listing
FieldValue:   NB:Travel Time                       TWO SPACES ADDED
**************************************************************
ExternalTimesID: 73825626X
InternalJobID: 129852258
EventID: 11853822
EventName: Job Start
FieldName: Item Listing
FieldValue:   NB:Property Checks                TWO SPACES ADDED
**************************************************************
ExternalTimesID: 73966903X
InternalJobID: 129853186
EventID: 11985868
EventName: Job Start
FieldName: Item Listing
FieldValue: Aeration                                   NO SPACES ADDED--THIS ONE WORKED
**************************************************************
ExternalTimesID: 73784235X
InternalJobID: 129853905
EventID: 11887822
EventName: Job Start
FieldName: Item Listing
FieldValue:   NB:Travel Time                     TWO SPACES ADDED
**************************************************************
ExternalTimesID: 73783211X
InternalJobID: 129854155
EventID: 11985868
EventName: Job Start
FieldName: Item Listing
FieldValue:   NB:Travel Time                      TWO SPACES ADDED
**************************************************************
ExternalTimesID: 73783211X
InternalJobID: 129854155
EventID: 11985863
EventName: Job End
FieldName: Work Completed?
FieldValue: Yes                                           EXAMPLE OF ANOTHER FLEXFIELD---This one is not being mapped.
**************************************************************
ExternalTimesID: 73784234X
InternalJobID: 129854236
EventID: 11853817
EventName: Job End
FieldName: Work Completed?
FieldValue: Yes
**************************************************************
ExternalTimesID: 73784234X
InternalJobID: 129854236
EventID: 11853822
EventName: Job Start
FieldName: Item Listing
FieldValue:   NB:Misc                                  TWO SPACES ADDED
**************************************************************
ExternalTimesID: 73784230X
InternalJobID: 129807838
EventID: 11843822
EventName: Job Start
FieldName: Item Listing
FieldValue: NB:Truck Load                            NO SPACES ADDED
**************************************************************
ExternalTimesID: 73784230X
InternalJobID: 129807838
EventID: 11843817
EventName: Job End
FieldName: Work Completed?
FieldValue: Yes
**************************************************************