This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
For the past 8 years, we had 2 separate Concur instances/systems. One for the Americas and one shared by EMEAI & APAC. We have recently merged all countries into 1 global system; whereby EMEAI & APAC were merged into the Americas system which we now call our "global" system. Here is the BIG issue: We want our historical data from the EMEAI&APAC Concur system. Concur said they would provide the data via .dat files whihc we can retrieve via MS Access. MY IT team is not confidant that all of the data will come across successfully and has concerns. Has anyone gone thru this process? Does it work? Are there things we shoud be aware of?
Thanks in advance for your responses!
Natalie
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
The final Data Dump Extract will be a single zip file that is made up of the following:
* Stable.zip: contains reports and corresponding entries and data that go along with approved and paid reports. Note: not all deliveries will contain this file, it is based on client configuration
* Recent.zip: contains all other data and records that were not provided by extract or not approved for payment.
* DDL.zip: contains schema definitions (SQL scripts) for the tables in the Recent & Stable files to enable the client to create these tables easily in a local database. Note: In the examples below we will use an Access Database so the script in the ddl.zip file will not be used directly.
* Each zip file will contain .txt files, one for each table in the entity database in the stable.zip or recent.zip. The DDL.zip will contain one schema definition.
Image Archives:
* Extract_images_*.exe: contains the receipt image pdf files that accompany the data dump extract. There could range between one and many of these files depending on the number of reports.
Kind regards,
Wendy Mos
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
What format are the reports within Stable.zip and Recent.zip comprised of? Also, is there a fee for the final data dump?
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
Hi Wendy,
Is there an technical document for Data Dump Extract File?
Also, I have an additional query
Thank You.
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
Dear Mohaahme,
Yes we have a manual how you can retrieve the files and comprise both extracts etc. All data will be provided including who approved the expense reports etc. I'm not technical etc, but if you want more information than you can create a support ticket.
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
I have done this once, and am preparing to do it again in the near future for companies we have acquired.
The one I have completed only had about 1.5 years of data, but everything worked very smoothly. All files were downloaded, quality-checked, and loaded into a database without any issues.
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
Was there a cost for the data dump extraction? We need to extract all images for last 5 years from Concur Expense, Purchase Request & Invoice. Please advise how to proceed. Thanks so much.
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
Hi,
Was there a cost for the data dump extraction? We need to extract all images for last 5 years from Concur Expense, Purchase Request & Invoice. Please advise how to proceed. Thanks so much.