VB.net Addins for Ms Project 32 bits Corrupt data when paste from - Microsoft Community


hi,

i have vb.net 2010 addins application ms project 2010.

the objective of addins connect sap pm sap.net connector 3.0 bring work orders (and operations) , paste ms project task table.

development machine:

- windows 7 pro, spanish language, 64 bits

- vs.net 2010 pro, english language

- ms project 2010, english language, 64 bits

target machine:

- windows 7 pro, spanish language, 64 bits

- ms project 2010, spanish language, 32 bits

i generate 2 installer: 1 64 bits, , other 32 bits. both version have same lines of code.

running  addins in 64 bits version of ms project 2010 works fine, in 32 bits version, corrupt data when paste large values number custom fields (ex.: 94137750 corrupted 94137752, 94048923 corrupted 94048920, etc.). failure doesn't occurs when paste small values "10" or "44502".

the steps put records clipboard , paste values ms project task table following:

- step 1: add records string variable. "vbtab" delimiter between fields , "vbnewline" delimiter between records.

- step 2: put de string variable clipboard , paste ms project task table.

lines of code:

step 1:

mystring = mystring & tabla.getstring("pltxt").tostring.replace(chr(34), "´´") & vbtab & "op" & vbtab & tabla.getstring("eqktx").tostring.replace(chr(34), "´´") & vbtab & tabla.getstring("ltxa1").tostring.replace(chr(34), "´´") _
                        & vbtab & tabla.getstring("arbpl").tostring.replace(chr(34), "´´") & vbtab & tabla.getstring("steus").tostring.replace(chr(34), "´´") & vbtab & vbtab & tabla.getstring("eqfnr").tostring.replace(chr(34), "´´") & vbtab & tabla.getstring("eqfnr1").tostring.replace(chr(34), "´´") & vbtab & tabla.getstring("equipo").tostring.replace(chr(34), "´´") _
                        & vbtab & tabla.getstring("revision").tostring.replace(chr(34), "´´") & vbtab & tabla.getstring("nomarea").tostring.replace(chr(34), "´´") & vbtab & tabla.getstring("tplnr").tostring.replace(chr(34), "´´") & vbtab & tabla.getstring("prioridad").tostring.replace(chr(34), "´´") & vbtab & tabla.getstring("claseo").tostring.replace(chr(34), "´´") & vbtab & tabla.getstring("centroe").replace(chr(34), "´´") _
                        & vbtab & tabla.getstring("nomemplaza").tostring.replace(chr(34), "´´") & vbtab & tabla.getstring("local").tostring.replace(chr(34), "´´") & vbtab & tabla.getstring("area").tostring.replace(chr(34), "´´") _
                        & vbtab & tabla.getstring("responsable").tostring.replace(chr(34), "´´") & vbtab & tabla.getstring("grupop").tostring.replace(chr(34), "´´") & vbtab & tabla.getstring("centrop").tostring.replace(chr(34), "´´") _
                        & vbtab & tabla.getstring("proveedor").tostring.replace(chr(34), "´´") _
                        & vbtab & tabla.getstring("claseaop").tostring.replace(chr(34), "´´") & vbtab & vbtab & tabla.getstring("destinatario").tostring.replace(chr(34), "´´") & vbtab & tabla.getstring("puestodescarga") & vbtab & vbtab & tabla.getstring("nomfantasiaprov").tostring.replace(chr(34), "´´") & vbtab & vbtab & scontrato & vbtab & dtrabajor1 _
                        & vbtab & tabla.getstring("aufnr") & vbtab & tabla.getstring("vornr") & vbtab & tabla.getstring("maufnr") & vbtab & srecurso & vbtab & sfiniaux & vbtab & sfiniraux & vbtab & sfinraux & vbtab & sduracion & vbtab & strabajor & vbtab & vbnewline

step 2:

                my.computer.clipboard.clear()
                my.computer.clipboard.settext(mystring)
                globals.thisaddin.application.editpaste()
                my.computer.clipboard.clear()

table.getstring("aufnr") contains value sap paste ms project number custom field, 1 corrupted.

when run application in debugging mode, can check that table.getstring("aufnr") has right value, however, changes value when paste ms project table. tried write value directly number custom field

 and works fine.

i had test replacing table.getstring("aufnr") constant (example: "94137750") , pasted successfully.

the size of table.getstring("aufnr") char(12) redundant zeros "000094137750". tried removing zeros before passing value string variable, however, have same result. 

thanks in advance,

manuel.


hi manuel,

to better support visual basic , programming concerns, recommend post inquiry microsoft developer network forum advanced troubleshooting.

regards.



Office / Project / Other/unknown / Office 2010



Comments

Post a Comment

Popular posts from this blog

Outlook Rules not Running Automatically - Microsoft Community

i have 3 rules in outlook 2013 installation set when email arrives check words in body, subject or header.  the rules not seem run automatically.  when run rules manually seem work fine.  i've had problem quite while.  recently, created new outlook profile did not fix issue.  i went , changed srs file srs.old did not fix either. please provide me suggestions fix. hi neil, in order isolate issue, we'd following information: have made recent changes or applied update device prior issue? which email account using? personal email account or work email account? for initial troubleshooting, suggest deleting rules , create again. this, may refer article below: manage email messages using rules looking forward response. Office / Outlook / Windows 10 / ...
Read more

message deleted by transport agent, event: LED=550 4.3.2 - Microsoft Community

i waiting email verification code *** email address removed privacy *** after signing visual studios account. have run message trace see why email not being delivered , given following message: led=550 4.3.2 queue.transportagent; message deleted transport agent i have looked error , saying message being stuck in queue, resolve unfreeze queue. however, in order need exchange toolbox or exchange management, no longer exists office 365 since eac came about. yet haven't found queue viewers in eac can manage , unfreeze queue.   my spam filter set @ 'bypass spam filters'. have whitelisted domain, , have set connection filter allows ip address domain come through. however, after running message trace, email still being dropped. any insight on why happening?  thanks hi suean-work, according description, have try many settings on side. confirm again ‘bypass spam filters’ settings. did mean have c...
Read more

Microsoft Office Exchange Error message - Microsoft Community

Image
received message when trying send email few users outlook desktop client  i checked of users , of them received emails others did not  working within wireless environment in office  any great thank in advance  your message did not reach or of intended recipients.         subject:  fw: panther: hold working sessions gt/rightpont       sent:     6/9/2017 11:26 am   the following recipient(s) cannot reached:         dax scott on 6/9/2017 11:26 am       giulia sergi on 6/9/2017 11:26 am       kia horton on 6/9/2017 11:26 am       micah swigert on 6/9/2017 11:26 am       rob hendricks on 6/9/2017 11:26 am       sarah wallace on 6/9/2017 11:26 am    ...
Read more